> ## 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.

# Username and password

> Connect Amazon Redshift to Paradime using a database username and password for the Code IDE, Bolt production jobs, and Agent sessions.

Connect Redshift to Paradime using a Redshift username and password. Set **Target** to match the environment you are configuring (`dev`, `prod`, or `dinoai`).

<Note>
  **Available in:** Code IDE, Bolt, and Agent environments.
</Note>

<Info>
  Field access levels apply only to the **Code IDE** environment: an `Admin` sets workspace-level fields, and each developer sets their own user-level fields. In the Bolt and Agent environments, an `Admin` sets all fields.
</Info>

## Field details

| Field        | Description                                                                                                                                    | Example                           |
| ------------ | ---------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------- |
| Profile Name | The profile name set in your `dbt_project.yaml`. See more [here](https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles). | **`dbt-redshift`**                |
| Target       | The target name used to identify the connection. See more [here](https://docs.getdbt.com/reference/dbt-jinja-functions/target).                | **`dev`**                         |
| Host Name    | The hostname of the Redshift database to connect to.                                                                                           | **`xxx.eu-west-2.amazonaws.com`** |
| Port         | Usually `5439` for Redshift.                                                                                                                   | **`5439`**                        |
| Database     | The name of your Redshift database.                                                                                                            | **`analytics`**                   |
| Username     | The username created with access to the database.                                                                                              | **`dev_user`**                    |
| Password     | The password set for the user created in Redshift.                                                                                             | **`password_xyz`**                |
| Schema       | The default schema used to build dbt™ objects at runtime.                                                                                      | **`dbt_john`**                    |
| Threads      | The number of threads used in this connection. See more [here](https://docs.getdbt.com/docs/running-a-dbt-project/using-threads).              | **`8`**                           |


## Related topics

- [Username and password](/integrations/snowflake/username-and-password.md)
- [Snowflake cost connection](/integrations/snowflake/cost-connection.md)
- [Dremio](/integrations/dremio.md)
- [Microsoft Fabric](/integrations/microsoft-fabric.md)
- [Redshift](/integrations/redshift/index.md)