---
title: Redshift - Data Connect
description: Instructions for setting up and using Data Connect with Amazon Redshift
lastUpdated: 18 February 2026
source_url:
  html: https://docs.contentsquare.com/en/connect/redshift/
  md: https://docs.contentsquare.com/en/connect/redshift/index.md
---

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. The Data Connect integration with Redshift allows you to automatically sync your Contentsquare data to Redshift for advanced analysis and joining with other business data.

## Prerequisites

Before setting up the Redshift integration, ensure you have:

* **An Amazon Redshift cluster** that is provisioned and accessible
* **Sufficient permissions** to create schemas and tables in Redshift
* **Database credentials** with appropriate permissions

## Redshift Setup

1. Ensure your Redshift cluster is running and accessible

2. [Create a dedicated schema for Contentsquare data ↗](https://docs.aws.amazon.com/redshift/latest/gsg/t_creating_schema.html):

   ```sql
   CREATE SCHEMA heap_data;
   ```

3. [Create a dedicated user for Data Connect ↗](https://docs.aws.amazon.com/redshift/latest/gsg/t_adding_redshift_user_cmd.html):

   ```sql
   CREATE USER heap_connect_user WITH PASSWORD 'your-secure-password';
   GRANT USAGE ON SCHEMA heap_data TO heap_connect_user;
   GRANT CREATE ON SCHEMA heap_data TO heap_connect_user;
   GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA heap_data TO heap_connect_user;
   ALTER DEFAULT PRIVILEGES IN SCHEMA heap_data GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO heap_connect_user;
   ```

4. Ensure your Redshift cluster is accessible from Contentsquare's servers:

   * If your cluster is public, ensure the security group allows access
   * If your cluster is private, you may need to set up VPC peering or a VPN connection

## Configure Data Connect

Admin only

Configuration of this destination is only available to admin users in Contentsquare.

1. Log in to Contentsquare.

2. Navigate to **Analysis setup** > **Data Connect**.

3. Select **Connect** next to Redshift.

4. Enter the required information:

   * Host (endpoint)
   * Port (typically 5439)
   * Database name
   * Username
   * Password
   * Schema (the schema you created for Contentsquare data)

5. Select **Connect**.

## FAQs

### Why are constraints not applied to the tables?

Primary and foreign key constraints are not applied to the Data Connect tables because Amazon Redshift does not enforce constraints.