Intro

With Cloud Amplifier, you can power your Domo instance using Amazon Redshift. After setup is complete, you can begin using virtual tables that read from Redshift to create cards, set up Alerts, or serve as inputs in Magic ETL DataFlows. This guide is written for users who are familiar with Redshift and provides the steps for registering Redshift with Cloud Amplifier as well as some common troubleshooting techniques. To learn more about Cloud Amplifier, see the overview.

This article provides information about registering Redshift with Cloud Amplifier in the following topics:

Prerequisites
- Allowlisting IP addresses
Setup
Use Redshift-sourced DataSets

Prerequisites

Before configuring the Redshift–Cloud Amplifier connection, we recommend that you complete the following:

Create a Redshift service user — We recommend creating a new Redshift user specifically for this integration. Any account with “Usage” and “Select” privileges for the schemas and tables, respectively, can be used, but a service user is typically best practice.
- The service user must have “Usage” privileges for the schemas that you want to read from in Redshift.
- The service user must have “Select” privileges on the tables that you want to read from in Redshift.
- The service user must have “Select” privileges on the svv_table_info system view.
  - See how to grant a user/role”Usage” or “Select” privileges on a schema or table, respectively.
Create a Domo service account — We recommend creating a new Domo account specifically for this integration. The account role must have the Manage Cloud Accounts and Manage DataSet grants enabled. To learn more about roles and grants, see Managing Custom Roles.

Allowlisting IP Addresses

Before you can connect to a Redshift database, you must place on an allowlist a number of IP addresses on your database server on the port you want to connect to. See our documentation for a full list of IP addresses.

Setup

Follow these steps to configure Read access and begin referencing Redshift tables from within Domo using Cloud Amplifier:

Log into your Domo service account.
In the navigation header, select Data. The Data Center displays.
If you are not already there, use the left side rail to go to the Data Warehouse.
In the main area of the screen, select the molecule to bring it into focus.
Select Add New Cloud. The add new integration modal displays.
From the Native integration menu, select Redshift.
Select + Add New Integration.
Enter the following Redshift setup information:
- Integration name — A unique name to help you identify the integration in Domo.
- (Optional) Integration description — A description of the integration.
- Redshift username
- Redshift password
- Redshift connection URL — This is the JDBC URL for the given database cluster that you are connecting to.
Select Next. Your Read configuration is now complete.
(Optional) Select Choose Tables to Connect to create DataSets in Domo. Navigate to the tables you want to use by selecting the appropriate Amazon database > schema > tables.
Select Create DataSets.