Skip to main content

Redshift setup Preview

You can configure the Redshift adapter by running dbt init in your CLI or manually providing the profiles.yml file with the fields configured for your authentication type.

The Redshift adapter for Fusion supports the following authentication methods:

  • Password
  • IAM profile

Configure Fusion​

Executing dbt init in your CLI will prompt for the following fields:

  • Host: The hostname of your Redshift cluster
  • User: Username of the account that will be connecting to the database
  • Database: The database name
  • Schema: The schema name
  • Port (default: 5439): Port for your Redshift environment

Alternatively, you can manually create the profiles.yml file and configure the fields. See examples in authentication section for formatting. If there is an existing profiles.yml file, you are given the option to retain the existing fields or overwrite them.

Next, select your authentication method. Follow the on-screen prompts to provide the required information.

Supported authentication types​

Use your Redshift user's password to authenticate. You can also manually enter it in plain text into the profiles.yml file configuration.

Example password configuration​

profiles.yml
default:
  target: dev
  outputs:
    dev:
      type: redshift
      port: 5439
      database: JAFFLE_SHOP
      schema: JAFFLE_TEST
      ra3_node: true
      method: database
      host: ABC123.COM
      user: JANE.SMITH@YOURCOMPANY.COM
      password: ABC123
      threads: 16

More information​

Find Redshift-specific configuration information in the Redshift adapter reference guide.

Was this page helpful?

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

0
Edit this page