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

# Redshift

Connect Telmai to Redshift.

Telmai reads tables from a provisioned Amazon Redshift cluster with a Redshift database user and password.

{% hint style="info" %}
Only provisioned Redshift clusters are supported. Redshift Serverless isn't.
{% endhint %}

## Before you connect

1. In Redshift, create a database user for Telmai with read access to the schemas you want to monitor. This is a Redshift user, not an IAM user.
2. In the AWS console, open **Amazon Redshift** > **Clusters** > your cluster > **General information**, and copy the **Endpoint**. It has the form `[endpoint_prefix].redshift.amazonaws.com:[port]/[database]`. You need the endpoint prefix for the connection and the database for each asset.

If the cluster's security group restricts inbound traffic, allow Telmai's addresses. See [IP Allowlist](https://docs.telm.ai/telmai/api-reference/telmai-ip-list.md).

## Connection fields

On the **Connections** page, click **Add connection** and choose **Redshift**. See [Add a connection](https://docs.telm.ai/telmai/connect-to-data.md#add-a-connection) for the full flow.

| Field               | Description                                                                                                   |
| ------------------- | ------------------------------------------------------------------------------------------------------------- |
| **Endpoint prefix** | The part of the endpoint before `.redshift.amazonaws.com`, for example `your-cluster.abc123xyz789.us-east-1`. |
| **User**            | The Redshift database user.                                                                                   |
| **Password**        | The user's password.                                                                                          |

## Asset fields

Click **Add assets** on the connection. See [Add assets](https://docs.telm.ai/telmai/connect-to-data.md#list-of-connectors-enabled-by-default).

| Field        | Description                                                |
| ------------ | ---------------------------------------------------------- |
| **Database** | The database from the cluster endpoint, for example `dev`. |
| **Schema**   | The schema that holds the tables, for example `public`.    |

Then choose **Existing table** or **Custom query**; see [Connection Modes](https://docs.telm.ai/telmai/connect-to-data/connection-modes.md).
