Elementary home pagelight logo
Data Warehouses
Snowflake

​
Data monitoring

Full support.

​
Snowflake 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. Fill in the missing authentication fields in the output and copy it to ~/.dbt/profiles.yml.

Snowflake
## SNOWFLAKE ##
## 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: snowflake
      account: [account id]

      ## User/password auth, other options (Keypair/SSO) require other configs ##
      user: [username]
      password: [password]

      role: [user role]
      database: [database name]
      warehouse: [warehouse name]
      schema: [schema name]  # elementary schema, usually [schema name]_elementary
      threads: 4

We support the same format and connection methods (user password, key pair authentication, SSO) as dbt. Please refer to dbt’s documentation of Snowflake profile for further details.

​
Have a question?

We are available on Slack, reach out for any kind of help!