Data Warehouses
Snowflake
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!