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:- 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