Skip to main content

DynamoDB

This destination writes data to AWS DynamoDB.

The Airbyte DynamoDB destination allows you to sync data to AWS DynamoDB. Each stream is written to its own table under the DynamoDB.

Prerequisites

  • For Airbyte Open Source users using the Postgres source connector, upgrade your Airbyte platform to version v0.40.0-alpha or newer and upgrade your DynamoDB connector to version 0.1.5 or newer

Sync overview

Output schema

Each stream will be output into its own DynamoDB table. Each table will a collections of json objects containing 4 fields:

  • _airbyte_ab_id: a uuid assigned by Airbyte to each event that is processed.
  • _airbyte_emitted_at: a timestamp representing when the event was pulled from the data source.
  • _airbyte_data: a json blob representing with the extracted data.
  • sync_time: a timestamp representing when the sync up task be triggered.

Features

FeatureSupportNotes
Full Refresh SyncWarning: this mode deletes all previously synced data in the configured DynamoDB table.
Incremental - Append Sync
Incremental - Deduped HistoryAs this connector does not support dbt, we don't support this sync mode on this destination.
NamespacesNamespace will be used as part of the table name.

Performance considerations

This connector by default uses 10 capacity units for both Read and Write in DynamoDB tables. Please provision more capacity units in the DynamoDB console when there are performance constraints.

Getting started

Requirements

  1. Allow connections from Airbyte server to your AWS DynamoDB tables (if they exist in separate VPCs).
  2. The credentials for AWS DynamoDB (for the COPY strategy).

Setup guide

  • Fill up DynamoDB info
    • DynamoDB Endpoint
      • Leave empty if using AWS DynamoDB, fill in endpoint URL if using customized endpoint.
    • DynamoDB Table Name
      • The name prefix of the DynamoDB table to store the extracted data. The table name is \\.
    • DynamoDB Region
      • The region of the DynamoDB.
    • Access Key Id
      • See this on how to generate an access key.
      • We recommend creating an Airbyte-specific user. This user will require read and write permissions to the DynamoDB table.
    • Secret Access Key
      • Corresponding key to the above key id.
  • Make sure your DynamoDB tables are accessible from the machine running Airbyte.
    • This depends on your networking setup.
    • You can check AWS DynamoDB documentation with a tutorial on how to properly configure your DynamoDB's access here.
    • The easiest way to verify if Airbyte is able to connect to your DynamoDB tables is via the check connection tool in the UI.

CHANGELOG

VersionDatePull RequestSubject
0.1.72022-11-03#18672Added strict-encrypt cloud runner
0.1.62022-11-01#18672Enforce to use ssl connection
0.1.52022-08-05#15350Added per-stream handling
0.1.42022-06-16#13852Updated stacktrace format for any trace message errors
0.1.32022-05-1712820Improved 'check' operation performance
0.1.22022-02-1410256Add -XX:+ExitOnOutOfMemoryError JVM option
0.1.12022-12-05#9314Rename dynamo_db_table_name to dynamo_db_table_name_prefix.
0.1.02021-08-20#5561Initial release.