Create a user for Elementary cloud
On your dbt project, run:Permissions and security
Elementary cloud doesn't require read permissions to your tables and schemas, but only the following:- Read-only access to the elementary schema.
- Access to read metadata in information schema and query history, related to the tables in your dbt project.
Fill the connection form
Provide the following fields:- Account: Find your account by using the Snowflake account URL and removing
snowflakecomputing.com
. e.g.example.us-east-1
. For more information, see Account Identifiers in the Snowflake docs. - Database name: The name of the database where your Elementary schema exist. e.g.
analytics
. - Warehouse: e.g.
ELEMENTARY_WAREHOUSE
. - Elementary schema: The name of your Elementary schema. Usually
[schema name]_elementary
. - Role (optional): e.g.
ELEMENTARY_ROLE
.
- User password:
- User: The user created for Elementary.
- Password: The password you set when creating your Snowflake account.
- Key pair:
- User: The user created for Elementary.
- Private key: The private key you generated for Elementary. For more information, see Generate Private Key in the Snowflake docs.
- Private key passphrase (optional)