Skip to main content
A connection holds the credentials an environment uses to reach your data warehouse. This guide walks through adding one to any environment (Code IDE, Bolt, or Agent). The steps are the same for every warehouse; only the credential fields differ by provider.
Prerequisites
  • An Admin role in Paradime. Only Admins can manage connections.
  • Credentials for your data warehouse. See the provider integration guide for exactly which fields your warehouse needs.

Steps

1

Open the environment

Go to Settings, then Environments, and choose the environment to add the connection to: Code IDE (development), Bolt (production), or Agent. Select Add new.
2

Select your provider

Choose your data warehouse (for example, Snowflake, BigQuery, Redshift, or Databricks). The credential fields update to match the provider.
3

Enter credentials and auth method

Fill in the connection details for your provider, including the authentication method (most warehouses offer more than one). For the exact fields and auth options, follow your provider integration guide.
4

Set the target and schema

Set the dbt™ profile name to match the profile in your dbt_project.yml, choose a target name (for example, dev, prod, or ci), and set the schema the environment builds into.
5

Add optional attributes (optional)

If your adapter needs extra profiles.yml settings (timeouts, priority, retries), add them under optional connection attributes.
6

Test and save

Select Test connection to verify Paradime can reach your warehouse, then save.
Test connection passes and the connection appears in the environment. The first connection added to an environment becomes its default; change it later with Set an alternative default connection.

Next steps

Set an alternative default connection

Change which connection an environment uses by default.

Optional connection attributes

Add advanced profiles.yml settings to a connection.

Connections reference

Every environment type and its connection settings.

Provider integration guides

Warehouse-specific credentials and auth methods.