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

# Amazon Redshift

> Build apps with read and write access to a Redshift database

export const IntegrationSuccess = ({integrationName}) => {
  return <p>
      <b>{integrationName} connected!</b><br />You can now use{" "}
      <a href="/building-with-clark">Clark to build</a> with {integrationName}.
    </p>;
};

export const Alert = ({type, title, children}) => {
  const variant = ["info", "success", "warning", "danger", "note"].includes(type) ? type : "note";
  return <div className={`alert alert--${variant}`}>
      <div className="alert-icon" />
      <div className="alert-content">
        {title && <div className="alert-title">{title}</div>}
        <div className="alert-body">{children}</div>
      </div>
    </div>;
};

## Setting up Amazon Redshift

### 1. Add integration

<p>
  Select <strong>Redshift</strong> from the{" "}
  <a href="https://app.superblocks.com/integrations/redshift">integrations page</a>.
</p>

### 2. Configure settings

Fill out the form with the following settings:

| Setting | Required | Description |
| - | - | - |
| Name | <span className="table-checkmark">✓</span> | Name that will be displayed to users when selecting this integration in Superblocks |
| Host | <span className="table-checkmark">✓</span> | Domain name of Redshift instance to connect to |
| Port | <span className="table-checkmark">✓</span> | Port to use when connecting to Redshift |
| Schema | <span className="table-x">✗</span> | The schema to connect to |
| Database Name | <span className="table-checkmark">✓</span> | Name of database to connect to |
| Database Username | <span className="table-checkmark">✓</span> | Username to use to connect |
| Database Password | <span className="table-checkmark">✓</span> | Password for database username |
| Enable SSL | <span className="table-x">✗</span> | Connect via SSL if selected |

### 3. Test and save

Click **Test Connection** to check that Superblocks can connect to the data source.

<Alert type="info">
  If using Superblocks Cloud, add these <a href="/enterprise/security/overview#ip-addresses">Superblocks IPs</a> to your allowlist (not necessary for Hybrid or Cloud-Prem deployments).
</Alert>

After connecting successfully, click **Create** to save the integration.

### 4. Set data tags

Optionally, configure different data tags for [separate development environments](/development-lifecycle/build/data-tags).

<Alert type="success">
  <IntegrationSuccess integrationName="Amazon Redshift" />
</Alert>

## Creating Amazon Redshift steps

Connect to your Redshift integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks Redshift integration with read only, read/write, or write only users. You can then configure a Superblocks Redshift step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the Redshift step. Then click "Run" to see the Result and Executed SQL statement below.

## Troubleshooting

Check out our guide on [common errors across database integrations](/integrations/troubleshooting/troubleshooting-databases). If you are encountering an error that you don't see in the guide, or the provided steps are insufficient to resolve the error, please contact us at [help@superblocks.com](mailto:help@superblocks.com).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.