All Collections
Data Tips, Tools, And Analytics
How to Connect Domo to Amazon Redshift
How to Connect Domo to Amazon Redshift

Step-by-step guide using Openbridge Facebook data.

Openbridge Support avatar
Written by Openbridge Support
Updated over a week ago

Whether you are using or just trying out Domo, business intelligence and data visualization tool, you need to connect it to your data. In this article, we will walk you through the process of connecting Domo to Amazon Redshift, the data warehouse where Openbridge is streaming your data from various data sources.

How to get more value out of Domo’s platform

Domo is a reporting and dashboarding tool that provides a ton of native connectors (over 350). Those connectors might not always serve all your needs. For example, when you connect to Adobe Analytics, it will show you basic metrics but won’t allow you to get into a granular level of detail.

What if you wanted to use Domo with Adobe Clickstream or Google Analytics 360 data? This is where you turn to external partners like Openbridge and Amazon Redshift. The great news is Domo allows you to connect Domo to Redshift through their native connector which provides a powerful path to tap into data outside the Domo ecosystem.

A step-by-step guide to connecting Domo and Redshift

The following is a guide showing you how to connect Domo to Amazon Redshift. If you have not worked with Amazon Redshift you can take a look at the product overview here. The data experts at Openbridge can also help guide you through this process if you want to explore it more deeply.

Step 1: Select

Choose “Amazon Redshift” from the list of data connectors:

Select Amazon Redshift

Step 2: Credentials

When you select a database, you will be asked to create an Amazon Redshift data set. Select your AWS account:

Enter your credentials

Select the newly created account under “Credentials”. It should show up in the drop-down like this:

Select your Redshift account

Once you select your account Domo will show you the “Details” section

Step 3: Details

This is when you select what you want to query in Redshift. You will be presented with the available tables in your selected database. In this example, we selected the openbridge.fbm_ad table. Domo will then show you all the columns available with the table. Select the ones you are interested in. You will also need to provide a SQL query for Domo to use in the “Query” field

Enter details

In our example, we are going to select all the available columns. Here is the SQL query that we pasted into the “Query” field:

SELECT account_id, account_name, ad_bid_amount, ad_bid_info, ad_bid_info_actions, ad_bid_info_clicks, ad_bid_info_impressions, ad_bid_info_reach, ad_bid_info_social, ad_bid_type, ad_configured_status, ad_created_time, ad_effective_status, ad_id, ad_last_updated_by_app_id, ad_name, ad_status, ad_updated_time, ads_action_stats_1d_click, ads_action_stats_1d_view, ads_action_stats_28d_click, ads_action_stats_28d_view, ads_action_stats_7d_click, ads_action_stats_7d_view, ads_action_stats_action_type, ads_action_stats_field, ads_action_stats_value, adset_id, adset_name, app_store_clicks, call_to_action_clicks, campaign_id, campaign_name, canvas_avg_view_percent, canvas_avg_view_time, clicks, cost_per_estimated_ad_recallers, cost_per_inline_link_click, cost_per_inline_post_engagement, cost_per_total_action, cost_per_unique_click, cost_per_unique_inline_link_click, cpc, cpm, cpp, ctr, date_start, date_stop, deeplink_clicks, frequency, impressions, inline_link_click_ctr, inline_link_clicks, inline_post_engagement, newsfeed_avg_position, newsfeed_clicks, newsfeed_impressions, ob_date, ob_file_name, ob_modified_date, ob_processed_at, ob_transaction_id, objective, reach, relevance_score_negative_feedback, relevance_score_positive_feedback, relevance_score_score, relevance_score_status, social_clicks, social_impressions, social_reach, social_spend, spend, total_action_value, total_actions, total_unique_actions, unique_clicks, unique_ctr, unique_impressions, unique_inline_link_click_ctr, unique_inline_link_clicks, unique_link_clicks_ctr, unique_social_clicks, unique_social_impressions, website_clicks FROM openbridge.fbm_ad;

Step 5: Scheduling

Once you are done with credentials and details, you will need to schedule data delivery:

Schedule data delivery

Step 6: Configuration Complete!

Once you have complete credentials, details, and schedule you should see everything checked and ready to go:

Completed setup

The next step is creating some reports!

Step 7: Design Your Reports

Now you are ready to build your first visuals!

First visual in Domo using data from Redshift

First visual in Domo using data from Redshift

Step 8: Save, Publish and Share

After you created a visual, hit the orange “Save” button in the upper right corner. You will be redirected to the “Overview” tab from which you will be able to share your content with your team.

Visuals overview

That’s it! Connecting Domo to Amazon Redshift opens new opportunities to explore data outside of the Domo ecosystem. This allows your team new avenues to take advantage of the Domo platform by bringing outside data into the mix.

Did this answer your question?