# Redshift

{% hint style="warning" %}
**IP RESTRICTIONS**

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: [Paradime IP addresses](https://docs.paradime.io/app-help/developers/ip-restrictions).
{% endhint %}

## Add Code IDE Connection

You will be prompted to add a Development connection during the onboarding, or you can add more connections by completing the following steps:

1. Click **Settings** in the top menu bar of the Paradime interface to access **Account Settings**
2. In the left sidebar, click "**Connections**"
3. Click "**Add New**" next to the Code IDE section
4. Select "Redshift"

## Using Username & Password

<figure><img src="https://2337193041-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHET0AD04uHMgdeLAjptq%2Fuploads%2FTxp52VfEoF2oFsYwVk5f%2Fdev_connection_redshift_u%26p.png?alt=media&#x26;token=ce483e68-5615-4d74-b00f-14d5b78da712" alt="" width="540"><figcaption></figcaption></figure>

### Field Details

Below are list of fields and example to create a connection.

{% hint style="info" %}

* 🏢 **`Workspace level`** fields are set by the the workspace `Admin` and not configurable for by user
* 👥 **`User level`** fields are set by each user (`Admin`/`Developer`) when setting the Development connection.
  {% endhint %}

<table><thead><tr><th>Field</th><th>Description</th><th>Example</th><th>Level<select><option value="68214e8af13b4195be9680e885fb53b6" label="🏢 Workspace level" color="blue"></option><option value="8d5e011bb33d4009b5d0ff39e2f65168" label="👥 User level" color="blue"></option></select></th></tr></thead><tbody><tr><td>Profile Name</td><td>The profile name set in your <code>dbt_project.yaml</code> . See more <a href="https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles">here</a>.</td><td><strong><code>dbt-redshift</code></strong></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>Target</td><td>The target name used to identify the connection. See more <a href="https://docs.getdbt.com/reference/dbt-jinja-functions/target">here</a>.</td><td><strong><code>dev</code></strong></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>Host Name</td><td>The hostname of the Redshift database to connect to.</td><td><strong><code>xxx.eu-west-2.amazonaws.com</code></strong></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>Port</td><td>Usually <code>5439</code> for Redshift.</td><td><strong><code>5439</code></strong></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>Database</td><td>The name of your Redshift production database.</td><td><strong><code>analytics</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Username</td><td>The username created with access to the development database.</td><td><strong><code>dev_user</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Password</td><td>The password set for the user created in Redshift.</td><td><strong><code>password_xyz</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Schema</td><td>The default schema used to build dbt™️ objects at runtime.</td><td><strong><code>dbt_john</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Threads</td><td>The number of threads used in this connection. See more <a href="https://docs.getdbt.com/docs/running-a-dbt-project/using-threads">here</a>.</td><td><strong><code>8</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr></tbody></table>

## Using IAM

<figure><img src="https://2337193041-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHET0AD04uHMgdeLAjptq%2Fuploads%2FEtYM7sKCgrx6wcxGFQ5D%2FScreenshot%202024-06-10%20at%2022.39.40.png?alt=media&#x26;token=d96ad42f-6162-46b6-8ba1-90b98edb965b" alt="" width="539"><figcaption></figcaption></figure>

### Field Details

Below are list of fields and example to create a connection.

{% hint style="info" %}

* 🏢 **`Workspace level`** fields are set by the the workspace `Admin` and not configurable for by user
* 👥 **`User level`** fields are set by each user (`Admin`/`Developer`) when setting the Development connection.
  {% endhint %}

<table><thead><tr><th>Field</th><th>Description</th><th>Example</th><th>Level<select><option value="68214e8af13b4195be9680e885fb53b6" label="🏢 Workspace level" color="blue"></option><option value="8d5e011bb33d4009b5d0ff39e2f65168" label="👥 User level" color="blue"></option></select></th></tr></thead><tbody><tr><td>Profile Name</td><td>The profile name set in your <code>dbt_project.yaml</code> . See more <a href="https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles">here</a>.</td><td><strong><code>dbt-redshift</code></strong></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>Target</td><td>The target name used to identify the connection. See more <a href="https://docs.getdbt.com/reference/dbt-jinja-functions/target">here</a>.</td><td><strong><code>dev</code></strong></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>Profile Configuration</td><td>This is the coplete profile configurations for dbt. Which will include host name, port plus optional fields. See more <a href="https://docs.getdbt.com/docs/core/connect-data-platform/redshift-setup#specifying-an-iam-profile">here</a>.</td><td><pre class="language-yaml"><code class="lang-yaml">cluster_id: CLUSTER_ID
host: hostname.region.redshift.amazonaws.com
user: alice
iam_profile: analyst
region: us-east-1
dbname: analytics
schema: analytics
port: 5439
</code></pre></td><td><span data-option="68214e8af13b4195be9680e885fb53b6">🏢 Workspace level</span></td></tr><tr><td>User Email</td><td>The username created with access to the development database.</td><td><strong><code>John@acme.io</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Password</td><td>The password set for the user created in Redshift.</td><td><strong><code>password_xyz</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Schema</td><td>The default schema used to build dbt™️ objects at runtime.</td><td><strong><code>dbt_john</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr><tr><td>Threads</td><td>The number of threads used in this connection. See more <a href="https://docs.getdbt.com/docs/running-a-dbt-project/using-threads">here</a>.</td><td><strong><code>8</code></strong></td><td><span data-option="8d5e011bb33d4009b5d0ff39e2f65168">👥 User level</span></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.paradime.io/app-help/documentation/settings/connections/development-environment/redshift.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.