---
title: "Amazon Redshift"
slug: "redshift"
description: "Get your data from any source, including data warehouses, to Redshift easily with Dataddo! Create secure and reliable data flows or replicate databases now."
tags: ["Data warehouse", "Data destination", "How-to guide"]
updated: 2025-08-06T20:05:01Z
published: 2025-08-06T20:05:01Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Amazon Redshift

**Amazon Redshift** is a fully managed data warehousing service provided by Amazon Web Services (AWS). It's designed to handle large-scale data analytics and complex querying, offering high-performance columnar storage and parallel processing capabilities to efficiently process and analyze large datasets for business insights.

## Prerequisites

          
          

- You have a running [publicly accessible](/docs/redshift#in-aws-portal) Redshift instance.
- You have [configured Security Groups](/docs/redshift#in-aws-portal) to make sure the cluster is accessible for [Dataddo IPs](/docs/network-acl).
- You have [configured a Redshift user](/docs/redshift#in-redshift-shell) with `CREATE`, `SELECT`, `UPDATE`, `INSERT`, `DELETE` permissions.

## Authorize Connection to Redshift

### In AWS Portal

#### Enable Public Accessibility of Redshift Cluster

1. Go to the **AWS Console** and navigate to **Redshift Console**.
2. In the navigation panel, choose **Clusters** and the name of the cluster that you want to connect to.
3. In the cluster's configuration tab, make sure that **Publicly accessible** option is set to **Yes**. If not, please modify the cluster to make it publicly accessible.

#### Configure Security Group

Whitelist Dataddo IP address in the inbound rules of the cluster's security group.

1. Go to the **AWS Console** and navigate to **Redshift Console**.
2. In the navigation pane, choose **Clusters** and the name of the cluster that you want to connect to.
3. On the configuration tab for the cluster, find the **VPC security groups** section and select the attached security group.
4. In the **Inbound rules** section, choose **Edit inbound rules**.
5. For each [Dataddo IP](/docs/network-acl) set a **Custom TCP Rule**. Use CIDR notation (e.g. `52.17.68.150/32`). The default port value for Redshift is **5439**.

### In Redshift Shell

#### Create a Redshift user

1. Log into **Redshift** shell.
2. Run a command to create a new user.

```
CREATE USER dataddo PASSWORD '***';
```

#### Set permissions

1. Log into Redshift shell.
2. Grant the `CREATE`, `SELECT`, `UPDATE`, `INSERT`, `DELETE` permissions for the schema you plan to use (the example below presumes that a public schema is used).

```
GRANT USAGE ON SCHEMA public TO dataddo;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON ALL TABLES IN SCHEMA public TO dataddo;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON TABLES TO dataddo;
```

### In Dataddo

1. In the Authorizers tab, click on [Authorize New Service](https://app.dataddo.com/service/new) and select **Redshift**.
2. Fill in the following fields:
  1. **Server IP or Hostname**: Public IP or hostname of your Redshift cluster.
  2. **Database**: Name of the database you will use for writing or reading the data.
  3. **Username**: Redshift user's username.
  4. **Password**: Redshift user's password.
  5. **Port**: Port to connect to Redshift. The default value is **5439**.
3. [Optional] Configure your destination using an existing SSH tunnel or [create a new one](/docs/ssh-tunnelling).
4. Cick on **Save**.

## Create a New Redshift Destination

1. On the **Destinations** page, click on the [**Create Destination**](https://app.dataddo.com/destinations) button and select the destination from the list.
2. Select your ***authorizer*** from the drop-down menu.
3. Name your ***destination*** and click on **Save**.

          Need to authorize another connection?

          

Click on **Add new Account** in drop-down menu during ***authorizer*** selection and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).

## Create a Flow to Redshift

1. Navigate to **Flows** and click on [**Create Flow**](https://app.dataddo.com/flow/new).
2. Click on **Connect Your Data** to add your ***source(s)***.
3. Click on **Connect Your Data Destination** to add the ***destination***.
4. Choose the [write mode](https://docs.dataddo.com/docs/data-storages#write-modes) and fill in the other required information.
5. Check the **Data Preview** to see if your configuration is correct.
6. **Name** your flow and click on **Create Flow** to finish the setup.

### Table Naming Convention

When naming your table, please make sure the table name:

- Contains only
  - Letters
  - Numbers
  - Underscores
- Does **NOT** contain whitespaces.

---

## Related Articles

- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)
- [Write Modes](https://docs.dataddo.com/docs/data-storages#write-modes)
- [Implementation of Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Network Access Control List (ACL) Configuration](https://docs.dataddo.com/docs/network-acl)
- [SSH Tunnelling](https://docs.dataddo.com/docs/ssh-tunnelling)
- [Data Transformations](https://docs.dataddo.com/docs/data-transformations)
- [Data Quality Firewall](https://docs.dataddo.com/docs/data-quality-firewall)