Athena

Programmatic Example

CREATE DATACONNECTION athena_connection CXNPROPERTIES
(
  'connection_type'='JDBC',
  'jdbc_driver'='awsathena',
  'host'='athena.<region>.amazonaws.com',
  'port'='443',
  'user_key'='awssm://my-username',
  'password_key'='awssm://my-password',
  'jdbc.schema.name'='<your athena DB>',
  'connection_properties'='{"S3OutputLocation":"s3://aws-athena-query-results-335456599346-us-west-2/test/"}'
);

Note

For awsathena the jdbc.schema.name is the actual Athena database name, following the Athena naming conventions.