DynamoDB Setup Guide

Follow our setup guide to connect DynamoDB to Fivetran.

Prerequisites

To connect your DynamoDB database to Fivetran, you need an AWS account with administrator privileges.

Setup instructions

Find External ID

Find the automatically-generated External ID in your connector setup form and make a note of it. You will need it to configure AWS to connect with Fivetran.

Create an IAM Policy

This step allows Fivetran to access your DynamoDB database.

Open the Amazon IAM console.
Select Policies.
Click Create Policy.
Navigate to the JSON tab.

Copy the policy below into the JSON tab, then click Review Policy.

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "dynamodb:DescribeStream",
                "dynamodb:DescribeTable",
                "dynamodb:GetItem",
                "dynamodb:GetRecords",
                "dynamodb:GetShardIterator",
                "dynamodb:ListStreams",
                "dynamodb:ListTables",
                "dynamodb:Scan"
            ],
            "Resource": [
                "*"
            ]
        }
    ]
}

On the Review policy page, name the policy "Fivetran-Dynamo-Access" and provide a description if you'd like.
Click Create Policy.

Create an IAM role

Open the Amazon IAM console.
Click Roles in the left menu, then click Create New Role.
Select Another AWS account as the type of trusted entity. In the Account ID field, enter Fivetran's account ID 834469178297.
Click Options.
In the External ID field, enter the External ID from your Fivetran setup form.
Click Next: Permissions.
Find and select the "Fivetran-Dynamo-Access" policy that you created in Step 1, then click Next: Review.
Name the role "Fivetran", then click Create Role.
Click the role you just created (it may take a few seconds to populate). Find the "Role ARN" and copy it. Enter this value in the Role ARN field of your connector setup form.

Enable Streams for DynamoDB tables

In this step, you'll enable streams for all the tables that you want to sync through Fivetran.

In your AWS console, select the DynamoDB service, then select Tables.
Select a table.
Click on the Manage Stream option.
Select New and old images - both the new and the old images of the item.
Click Enable.
Repeat steps 1-5 for every table that you want to sync via Fivetran.

Finish Fivetran Configuration

Enter your chosen destination schema name in the connector setup form.
Select your AWS region.
Select your sync mode:
- If your table has more than 1000 first-level keys, you must select packed as your sync mode. If you anticipate the number of first-level keys will exceed 1000 in the future, you should also select packed mode. Once you select packed mode, you will see your tables and can select which ones to sync in packed mode.
- If your table has fewer than 1000 first-level keys, you can select either packed or unpacked as your sync mode.
Click Save & Test. Fivetran will take it from here and sync your data from your DynamoDB account.

Documentation