You will connect Elementary Cloud to Bigquery for syncing the Elementary schema (created by the Elementary dbt package).

Create a user for Elementary cloud

On your dbt project, run:

dbt run-operation create_elementary_user

This command will generate a query to create a user with the necessary permissions. Run this query on your data warehouse with admin permissions to create the user.

Permissions and security

Elementary cloud doesn’t need permissions to your tables and schemas. It is recommended to create a read only user for the elementary schema only. For more details, refer to security and privacy.

Fill the connection form

Provide the following fields:

  • Account: Find your account by using the Snowflake account URL and removing e.g. 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.

Elementary cloud supports the user password and key pair authentication connection methods.

  • 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)

Add the Elementary IP to allowlist

If you use network policies to restrict access, run this query on your data warehouse with admin permissions:

COMMENT='IP used by Elementary Cloud to sync the Elementary schema';

Need help with onboarding?

We can provide support on Slack or hop on an onboarding call.