---
title: "How to configure a Redshift destination"
slug: "how-to-configure-a-redshift-destination"
description: "Configure your Redshift destination in Supermetrics with our step-by-step guide, covering hostname, database, schema, and user credentials."
updated: 2025-07-04T09:11:36Z
published: 2025-07-04T09:11:36Z
---

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

# How to configure a Redshift destination

Use this guide to fill the fields in the configuration view when creating a new Redshift destination in Supermetrics.

## Before you begin

Before you create a Redshift destination, please make sure all prerequisites have been met. [Learn more about the prerequisites for creating a Redshift destination](/v1/docs/about-redshift-prerequisites).

## Redshift configuration

The configuration stage of [creating a new destination for Redshift in the Supermetrics Hub](/v1/docs/how-to-connect-to-a-data-warehouse-destination) includes the following fields.

1. **Display name** is the destination’s display name. Display names distinguish different destinations from each other.
2. **Hostname** is the server name of the Redshift cluster you’re going to use as a destination. You can obtain this from the AWS console by navigating to **Clusters → General information → Endpoint**. If there’s additional information for Port and Database attached to the Endpoint link you can copy, please delete everything after “amazonaws.com” before filling in the hostname. For example, `cluster-name.random-` `value.region.redshift.amazonaws.com:5439/demo_db` should be shortened to `cluster-` `name.random-value.region.redshift.amazonaws.com`.
3. **Database name** is the name of the database in Redshift. You don’t need to use the cluster database here — this can be a Redshift database.
4. **Database schema** is the name of the destination database schema. Redshift provides a default schema called “public” that you can use instead of creating your own, if you need.Note: A Redshift database schema is not equivalent to a schema you select when creating the transfer, or a [custom schema](/v1/docs/how-to-create-a-custom-table-group-formerly-custom-schema) that you can create in the Supermetrics Query Manager.
5. **Username** is your Redshift cluster admin username.
6. **Password** is your Redshift cluster admin password. When editing an existing destination, this field will be “New password”, and inputting anything to the field will overwrite the last password used.If you don’t have the password for this user, please contact your AWS administrator.

## More resources

- [About Redshift prerequisites](/v1/docs/about-redshift-prerequisites)
- [How to create a destination](/v1/docs/how-to-connect-to-a-data-warehouse-destination)
- [How to create a transfer](/v1/docs/how-to-create-a-transfer)