# AWS Redshift

{% hint style="info" %}
Telmai only supports connecting to provisioned Redshift clusters. Serverless clusters are not supported
{% endhint %}

## Creating a connection

To connect to Redshift provisioned clusters, the following details are required:

* **Endpoint Prefix**:
  * Navigate to **Amazon Redshift Clusters** -> **\<Cluster Name>** -> **General Information** -> **Endpoint**.
  * Retrieve the value, which will be in the format `[endpoint_prefix].redshift.amazonaws.com:[port]/[database]`.
  * Use the value of **\[endpoint\_prefix]** here.
* **User**: The username to use for the connection (must be created in Redshift).
* **Password**: The password to use for the connection (must be created in Redshift).

{% hint style="info" %}
**Note**: the username and password need to be created inside the Redshift and it's not the IAM user.
{% endhint %}

<figure><img src="/files/MIkzlcyCkOZAeY771m45" alt=""><figcaption></figcaption></figure>

## Connecting an asset

Once a connection is defined, you can start using it to create assets. To create assets, you will need:

* **Database**:
  * Navigate to **Amazon Redshift Clusters** -> **\<Cluster Name>** -> **General Information** -> **Endpoint**.
  * Use the value of **\[database]** from the endpoint.
* **Schema**: The schema where the tables are located.

Alternatively, you can run a SQL query

<figure><img src="/files/iVj6Q6O72EHkk4QZZ0ua" alt=""><figcaption></figcaption></figure>


---

# 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.telm.ai/telmai/connect-to-data/data-connections/aws-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.