> For the complete documentation index, see [llms.txt](https://docs.hockeystack.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hockeystack.com/integrations/datasyncs/connecting-your-warehouse/amazon-redshift.md).

# Authenticate Amazon Redshift

## Overview

HockeyStack’s Amazon Redshift integration allows you to seamlessly sync data from your Redshift tables into HockeyStack. By ensuring that your tables are set up according to our guidelines, you can leverage your Redshift data for deeper insights and analysis within the HockeyStack platform.

## Connecting HockeyStack to Amazon Redshift <a href="#block-d5bdcec8f159407ca75337ad35e38de1" id="block-d5bdcec8f159407ca75337ad35e38de1"></a>

Connecting HockeyStack to Amazon Redshift is a straightforward process. You’ll need to prepare a table with the required structure and then provide secure access credentials, along with a description of the columns you plan to sync.

### Step 1: Prepare the Table <a href="#block-058115aec93b402fa75c92459f8b0c1a" id="block-058115aec93b402fa75c92459f8b0c1a"></a>

To ensure a smooth syncing process, set up the Redshift table you want HockeyStack to read from with the following guidelines:

* **Required Columns:**
  * **Timestamp**: A column representing the timestamp of each record (e.g., the date/time of the action).
  * **Identity (Email)**: A unique identifier that allows HockeyStack to associate the record with a specific user or entity.
  * **Other Action Data**: Any additional columns that represent meaningful user actions or attributes you want to analyze.
* **Incremental Sync Support:**\
  HockeyStack uses an internal Last Sync Date to determine which rows to ingest.
  * Include an **Added or Updated At** column if you plan to insert historical data or backdate your rows. This ensures that HockeyStack can correctly pick up any new or modified rows that fall before the current Last Sync Date.

### Step 2: Provide Access Credentials <a href="#block-f90044455a68425f961a9442322c718e" id="block-f90044455a68425f961a9442322c718e"></a>

After preparing the table, you’ll need to share credentials so HockeyStack can securely access your Redshift instance. We recommend using a dedicated read-only Redshift user account. When providing credentials, also include:

* **A Short Column Description:**\
  For each column in the target table, provide a brief explanation of what the data represents. For example:
  * `timestamp`: The date and time the event occurred.
  * `email`: The user’s email address, serving as a unique identifier.
  * `page_view_count`: The number of pages viewed by the user.
  * `added_at` or `updated_at`: The datetime when the row was created or last updated in Redshift.

This step ensures HockeyStack can correctly interpret and map your data to the platform’s schema, making it more valuable and actionable.

***

**Once these steps are completed, HockeyStack’s support team will configure the integration.** After setup, HockeyStack will begin syncing your Redshift data on the agreed-upon schedule (often daily), enabling you to track, analyze, and activate your customer insights more effectively.

If you have questions, need guidance on column selection, or want to discuss best practices for syncing historical and ongoing data, our team is here to help.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.hockeystack.com/integrations/datasyncs/connecting-your-warehouse/amazon-redshift.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.