Skip to main content
Amazon Redshift logo

Amazon Redshift

Overview​

Connect Superblocks to Redshift to build apps with read and write access to a Redshift database:

  • Read data from a Redshift database and utilize it in API steps or UI components

Read data from a Redshift database and use it within an Application

  • Save information retrieved by other API steps or UI components by writing data to a database

Write data into a Redshift database using SQL in a backend API

Setting up Amazon Redshift​

1. Add integration​

Select Redshift from the integrations page.

2. Configure settings​

Fill out the form with the following settings:

SettingRequiredDescription
NameTRUEName that will be displayed to users when selecting this integration in Superblocks
HostTRUEDomain name of Redshift instance to connect to
PortTRUEPort to use when connecting to Redshift
SchemaFALSEThe schema to connect to
Database NameTRUEName of database to connect to
Database UsernameTRUEUsername to use to connect
Database PasswordTRUEPassword for database username
Enable SSLFALSEConnect via SSL if selected

3. Test and save​

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

info

If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for On-Premise-Agent).

After connecting successfully, click Create to save the integration.

4. Set profiles​

Optionally, configure different profiles for separate development environments.

success

Amazon Redshift connected Now you can use Amazon Redshift in any Application, Workflow, or Scheduled Job.

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.

See the results of a Redshift query

See the executed SQL of a Redshift query

info

Superblocks also supports connecting to AWS services with Boto3 in Python steps if you require additional functionality.

Use cases​

Applications

Create an admin dashboard that reads from Redshift and other sources. Mix in APIs to allow support agents to refund orders, update shipping statuses, or transform large datasets in a single UI.

Admin dashboard reads from Redshift allowing for credit request approvals

Workflows

Enrich customer order data within Redshift with shipping data from Snowflake or other datastores.

Use a workflow to enrich Redshift data with data from other datastores like Snowflake

Scheduled Jobs

Send out scheduled emails based on shipping status from Redshift and Customer details from Snowflake.

Use a scheduled job to query Redshift and send out a monthly report

Troubleshooting​

Check out our guide on common errors across database integrations. 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.