athena-cli.mdx

Athena connection profile

After installing Elementary's dbt package upon running dbt deps, you can generate Elementary's profile for usage with edr by running the following command within your project:

dbt run-operation elementary.generate_elementary_cli_profile

The command will print to the terminal a partially filled template of the profile that's needed for edr to work.

## ATHENA ##
## By default, edr expects the profile name 'elementary'.      ##
## Configure the database and schema of elementary models.     ##
## Check where 'elementary_test_results' is to find it.        ##

elementary:
  outputs:
    default:
      type: athena
      work_group: [athena workgroup]
      s3_staging_dir: [s3_staging_dir] # Location to store query results & metadata
      s3_data_dir: [s3 data dir] # Location to store table data (if not specified, s3_staging_dir is used)
      region_name: [aws region name] # AWS region, e.g. eu-west-1
      database: [database name]
      schema: [schema name] # elementary schema, usually [schema name]_elementary
      threads: [number of threads like 8]

We support the same format and connection methods as dbt. Please refer to dbt's documentation of Athena profile for further details.