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:

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:

  • 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

​
Need help with onboarding?

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