Setting up Amazon Redshift
1. Add integration
Select Redshift from the
integrations page.
Fill out the form with the following settings:
| Setting | Required | Description |
|---|
| Name | ✓ | Name that will be displayed to users when selecting this integration in Superblocks |
| Host | ✓ | Domain name of Redshift instance to connect to |
| Port | ✓ | Port to use when connecting to Redshift |
| Schema | ✗ | The schema to connect to |
| Database Name | ✓ | Name of database to connect to |
| Database Username | ✓ | Username to use to connect |
| Database Password | ✓ | Password for database username |
| Enable SSL | ✗ | Connect via SSL if selected |
3. Test and save
Click Test Connection to check that Superblocks can connect to the data source.
After connecting successfully, click Create to save the integration.
Optionally, configure different data tags for separate development environments.
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. 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.
