> For the complete documentation index, see [llms.txt](https://docs.apica.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.apica.io/data-sources/aws/amazon-redshift.md).

# Amazon Redshift

Apica Ascent helps you to connect to your Redshift Cluster to easily query your data and build dashboards to visualize data easily

The first step is to create a Redshift Cluster, please navigate to get started with Amazon Redshift <https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html>

### Adding Redshift to Apica Ascent

The second step is to create and add Redshift to Apica Ascent and add fill out the below fields and save

* **Name**: Name the data source (e.g. Redshift)
* **Host**: The full URL to your instance
* **Port**: The port of the instance endpoint (e.g. 3306)
* **User**: A user of the instance
* **Password**: The password for the above user
* **Database name**: The name of the virtual database for Redshift (e.g. Redshift1)

![Selecting a Redshift data source](https://2948796384-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmzGprckLqwd5v6bs6m%2Fuploads%2FNg5cPiNR2svQ0dBsqz5N%2Fredshift-1.png?alt=media\&token=07c43978-2388-4a7a-b9a2-05825ea213e1)

![Configuring Redshift data source](https://2948796384-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LmzGprckLqwd5v6bs6m%2Fuploads%2FkCj24dNyFaS9d2oQGZbb%2Fredshift-2.png?alt=media\&token=3242c09a-09b2-46ca-a1fc-e3f45ea10707)

That's it. Now navigate the Query editor page and start querying your data