> For the complete documentation index, see [llms.txt](https://docs.telm.ai/telmai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.telm.ai/telmai/connect-to-data/data-connections/aws-redshift.md).

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