How to Connect dbt Cloud to Redshift

This is some text inside of a div block.
Published
May 10, 2024
Author

How to Set Up dbt Cloud with Redshift?

Setting up dbt Cloud with Redshift involves a series of steps. Start by logging into your dbt cloud account and creating a new project. Navigate to Account settings and click + New Project. Enter a project name and proceed to select Redshift. The next step involves setting up your connection by entering your Redshift settings and development credentials.

  • Project Creation: This is the first step where you create a new project in your dbt cloud account. It involves naming the project and selecting Redshift as your database.
  • Connection Setup: This step requires you to enter your Redshift settings and development credentials. It is crucial for establishing a successful connection with the database.
  • Testing Connection: After setting up the connection, it is important to test it to ensure it is functioning correctly. If the test is successful, proceed to the next step.

What are the Steps to Connect to Redshift via an SSH Tunnel?

Connecting to Redshift via an SSH tunnel requires additional steps. When creating your connection, select Use SSH Tunnel. Supply the hostname, username, and port for the bastion server. After saving the connection, a public key will be generated and displayed. Copy this public key to the bastion server to authorize dbt Cloud to connect to your database.

  • SSH Tunnel Selection: During connection creation, select the Use SSH Tunnel option. This will allow you to connect to Redshift via an SSH tunnel.
  • Supplying Bastion Server Details: Provide the hostname, username, and port for the bastion server. These details are necessary for establishing the SSH tunnel.
  • Public Key Generation: After saving the connection, a public key is generated. This key should be copied to the bastion server to authorize the connection.

How to Configure the Remaining Data Platform Details?

After setting up the connection, you need to configure the remaining data platform details. This includes selecting the privacy settings and choosing the private endpoint from the dropdown. After configuring all the details, save your connection.

  • Privacy Settings: Choose the privacy settings according to your requirements. You can select Private to ensure the security of your data.
  • Private Endpoint Selection: Select the private endpoint from the dropdown. This is a necessary step in the configuration process.
  • Saving Connection: After configuring all the details, save your connection. This finalizes the setup process.

Keep reading

See all