Domo on Amazon Redshift

Intro

This article explains how to connect Domo’s Cloud Integrations to Amazon Redshift, allowing you to query and visualize Amazon Redshift data directly in Domo without moving or duplicating data.

---

Prerequisites

You must have an AWS account with access to Redshift to move forward.

Create or Manage Your Amazon Redshift Integrations

To access the integration management interface, follow these steps:

1. Navigate to Data Warehouse.
2. Select Connect Data.
3. From the list of Cloud Integrations, choose Amazon Redshift.
   The Domo on Amazon Redshift page appears.
4. Select Connect Amazon Redshift to start creating a new integration (see the integration setup instructions).
5. Select Manage Integrations to modify existing integrations.
   A list of available integrations displays.
6. Select the wrench icon next to an integration to view available options.
   The options shown depend on your access level.

Create an Amazon Redshift Integration in Domo

Every Amazon Redshift integration in Domo requires an authenticated AWS service account. Once created, a single service account can be reused across multiple integrations.

Follow these steps to create an Amazon Redshift integration in Domo:

1. Provide a name for the integration. This is simply a label to help you identify the integration within Domo. It does not need to match any names in Amazon Redshift and can be changed later if needed.

Tip: Multiple Amazon Redshift integrations can exist in the same Domo instance, created by you or your colleagues. Clear naming helps users select the correct integration later. For example, separate integrations might be created to connect different tables or manage access levels. 2. (Optional) Add a description to explain the purpose of this integration and who created it. Most users will only see the integration name in menus and lists. The description is visible only when viewing integration details. 3. Select an existing Amazon Redshift service account from the drop-down menu or select Add account to create a new one.

You can change the service account later, but switching accounts may require remapping DataSets and ETLs if the new account lacks access to previously used tables. User access may also be affected unless privileges are identical.

Understanding the Architecture

There are three levels in this setup:

• Amazon Redshift instance – Exists independently of Domo.
• Amazon Redshift service account – Defined in Domo and connects to the Amazon Redshift instance.
• Amazon Redshift integration – Uses the service account and adds settings such as connected tables and caching behavior.

Note: Multiple service accounts can connect to the same Amazon Redshift instance. Multiple integrations can share a single service account.

Access and Sharing

• Initially, only the owner of the service account has access.
• The owner can share access with individuals or groups.
• If multiple integrations use the same service account, they inherit the same user privileges.
• Changes to privileges affect all integrations tied to that account.

To review access settings, go to the Accounts Page and select Account sharing next to the relevant Amazon Redshift service account.

Tip: You can create multiple service accounts for the same PostgreSQL instance.
Reasons for doing this include:
Example A: Managing user access separately for different integrations.
Example B: Applying different caching TTL settings while sharing user access.

Create an Amazon Redshift Service Account in Domo

Every Amazon Redshift integration in Domo relies on an authenticated Amazon Redshift service account. Once created, this account can be reused across multiple Amazon Redshift integrations.

Domo provides a dedicated Accounts Page where you can create and manage service accounts for various external services, including Amazon Redshift. After creation, your Amazon Redshift service account will appear on this page.

Important: Creating a PostgreSQL service account in Domo allows you, other account owners, Domo admins, and anyone with whom the account is shared, to use its credentials to access PostgreSQL and create connected DataSets in Domo. Users will not have access to sensitive values such as passwords, tokens, or keys used by the service account to connect to PostgreSQL.

Follow these steps to create an Amazon Redshift service account in Domo:

1. Choose a name to identify this Amazon Redshift service account within Domo.
   • The name can be changed later.
   • Use clear, distinctive names to avoid confusion between Amazon Redshift accounts and integrations.
   • You can create multiple service accounts even if they all point to the same Amazon Redshift instance.
2. Enter the connection URL for your Amazon Redshift instance.
3. Enter your Redshift Username.
4. Enter your Redshift Password.