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

# Redshift as a destination

> Send your data from Nekt to Redshift.

Redshift is AWS's fully managed, petabyte-scale data warehouse service designed for analytics and business intelligence. It provides fast query performance, columnar storage, and parallel processing capabilities for large-scale data analysis and reporting.

<img height="50" src="https://mintcdn.com/nekt/0tn1_nwKYqAHn7jo/assets/logo/logo-redshift.png?fit=max&auto=format&n=0tn1_nwKYqAHn7jo&q=85&s=57b14dbba48d5c4a7a75df426f817941" data-path="assets/logo/logo-redshift.png" />

## 1. Add your Redshift access

1. In the [Destinations](https://app.nekt.ai/destinations) tab, click on the "Add destination" button located on the top right of your screen. Then, select the Redshift option from the list of connectors.

2. Click **Next** and you'll be prompted to add your access: host, port, database, user, password, schema name, S3 bucket, S3 key prefix.

3. Decide about removing staging files from S3 after the operation is completed.

4. Copy role ARN. For detailed instructions, [click here](https://docs.aws.amazon.com/redshift/latest/dg/c-getting-started-using-spectrum-add-role.html).

5. Click **Next**.

## 2. Select your data to send

1. The next step is letting us know which data you want to send to Redshift. Select the layer and then the desired table.

   > Tip: The table can be found more easily by typing its name.

2. Click **Next**.

## 3. Configure your Redshift data destination

1. Describe your destination for easy identification within your organization. You can inform things like what data it sends, to which team it belongs, etc.

2. To define your [Trigger](https://docs.nekt.com/runs/scheduling-and-triggers), consider how often you want data to be sent to this destination. This decision usually depends on how frequently you need the new table data updated (every day, once a week, only at specific times, etc.).

3. Click **Done**.

### Check your new destination!

1. Once completed, you'll receive confirmation that your new destination is set up!

2. You can view your new destination on the [Destinations](https://app.nekt.ai/destinations) page. Now, for you to be able to see it on your Redshift account, you have to wait for the pipeline to run. You can monitor it on the [Destinations](https://app.nekt.ai/destinations) page to see its execution and completion. If needed, manually trigger the pipeline by clicking on the refresh icon. Once executed, your data should be seen on Redshift.

> If you encounter any issues, reach out to us via Slack, and we'll gladly assist you!
