> ## Documentation Index
> Fetch the complete documentation index at: https://docs.paradime.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Configure a connection

> Add a data warehouse connection to a Paradime environment: choose your provider, enter credentials, set the target and schema, and test it.

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.

<Note>
  **Prerequisites**

  * An [Admin role](/products/settings/users/role-based-access-control) in Paradime. Only Admins can manage connections.
  * Credentials for your data warehouse. See the [provider integration guide](/integrations/index) for exactly which fields your warehouse needs.
</Note>

## Steps

<Steps>
  <Step title="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**.
  </Step>

  <Step title="Select your provider">
    Choose your data warehouse (for example, Snowflake, BigQuery, Redshift, or Databricks). The credential fields update to match the provider.
  </Step>

  <Step title="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](/integrations/index).
  </Step>

  <Step title="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.
  </Step>

  <Step title="Add optional attributes (optional)">
    If your adapter needs extra `profiles.yml` settings (timeouts, priority, retries), add them under [optional connection attributes](/guides/data-warehouse-essentials/optional-connection-attributes).
  </Step>

  <Step title="Test and save">
    Select **Test connection** to verify Paradime can reach your warehouse, then save.
  </Step>
</Steps>

<Check>
  **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](/guides/data-warehouse-essentials/manage-connections/set-alternative-default-connection).
</Check>

## Next steps

<CardGroup cols={2}>
  <Card title="Set an alternative default connection" href="/guides/data-warehouse-essentials/manage-connections/set-alternative-default-connection" icon="database">
    Change which connection an environment uses by default.
  </Card>

  <Card title="Optional connection attributes" href="/guides/data-warehouse-essentials/optional-connection-attributes" icon="sliders-horizontal">
    Add advanced profiles.yml settings to a connection.
  </Card>

  <Card title="Connections reference" href="/products/settings/connections/index" icon="server">
    Every environment type and its connection settings.
  </Card>

  <Card title="Provider integration guides" href="/integrations/index" icon="plug">
    Warehouse-specific credentials and auth methods.
  </Card>
</CardGroup>


## Related topics

- [Optional connection attributes](/guides/data-warehouse-essentials/optional-connection-attributes.md)
- [MongoDB Tools](/products/dino-ai/tools-and-features/warehouse-tool/mongodb-tools.md)
- [BigQuery cost connection](/integrations/bigquery/cost-connection.md)
- [Snowflake DinoAI Agent Key-Pair Setup](/guides/paradime-101/getting-started-with-the-dinoai-background-agent/snowflake-dinoai-agent-key-pair-setup.md)
- [Manage connections](/guides/data-warehouse-essentials/manage-connections/index.md)