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

​
Create a user for Elementary cloud

On your dbt project, run:

## Print the query you should run to generate a user
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 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.

It is recommended to create a user using the instructions specified above to avoid granting excess privileges. For more details, refer to security and privacy.

​
Fill the connection form

Provide the following fields:

  • Host: The hostname of your Redshift account to connect to. This can either be a hostname or an IP address.
  • Port: The port of your Redshift account to connect to. This is usually 5439.
  • Database name: The name of the database where your Elementary schema exist. e.g. analytics.
  • Elementary schema: The name of your Elementary schema. Usually [schema name]_elementary.
  • User: The name of the for Elementary user.
  • Password: The password associated with the provided user.

​
Add the Elementary IP to allowlist

Elementary IP for allowlist: 3.126.156.226

​
Connect via SSH tunnel

Elementary supports connecting via SSH or reverse SSH tunnel. Reach out to our team for details and support in this deployment.

​
Need help with onboarding?

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

BigqueryDatabricks