Skip to main content

​
Intro

Amazon DynamoDB is a nonrelational database that delivers reliable performance at any scale. It’s a fully managed, multi-region, multi-master database that provides consistent single-digit millisecond latency, and offers built-in security, backup and restore, and in-memory caching. With Domo, carry your data security measures from Amazon all the way through to your organization’s visualizations and reporting. Let Domo update all data points in real time while applying row-level security and a myriad of other controls like 2FA, SSO, and BYOK encryption. Domo connects directly to Amazon DynamoDB and delivers the information you need in real-time visualizations that make analysis faster, easier, and more effective. Plus, you can see your DynamoDB data alongside metrics from any other system, all in a single platform, and get instant notifications when your metrics hit thresholds that you determine. You connect to your AWS account in the Data Center. This topic discusses the fields and menus that are specific to the Amazon DynamoDB connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.

​
Prerequisites

To connect to AWS and create an Amazon DynamoDB Assume Role DataSet, you must have the following:
  • Amazon Resource Name (ARN)
  • Role Session Name
  • External ID
  • Region

​
Connecting to Your Amazon DynamoDB Assume Role Account

This section enumerates the options in the Credentials and Details panes in the Amazon DynamoDB Assume Role Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your Amazon DynamoDB account. The following table describes what is needed for each field:

Field

Description

Role ARN

Enter your Amazon Resource Name (ARN) of the role to assume.

Role Session Name

Enter the identifier for the assumed role session.

External ID Get the External ID by clicking the GENERATE CODE button.
Region Select the DynamoDB region.
Once you have entered valid Amazon DynamoDB Assume Role credentials, you can use the same account any time you go to create a new Amazon DynamoDB DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.

​
Details Pane

This pane contains two dropdown menus in which you select the desired region name and table.

Menu

Description

How would you like to fetch your data?

Select whether you want to fetch your data by attribute names or by providing a query.

Query

Enter the SQL query to execute.

Example: select * from table_name .

Note : Enter all the column names in double quotes, if any.

Table Name

Select the Amazon DynamoDB table you want to pull into Domo.

How would you like to provide attribute names? Choose whether you want to provide attribute names through discovery or manually.
Attribute Names (Maximum selection allowed is 1498)

Select the attribute names to pull. If you want to pull all attributes, then do not select any attribute from the list. Maximum selection allowed is 1498.

Note: If you do not select any attributes then this Connector will bring in all fields by default.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.