Skip to main content

DynamoDB

This destination writes data to AWS DynamoDB.

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

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 HeroPixelto 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​

Feature Support Notes
Full Refresh Sync ✅ Warning: this mode deletes all previously synced data in the configured DynamoDB table.
Incremental - Append Sync ✅
Incremental - Append + Deduped ❌
Namespaces ✅ Namespace 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 HeroPixelserver 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 HeroPixelspecific 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 HeroPixel
    • 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 HeroPixelis able to connect to your DynamoDB tables is via the check connection tool in the UI.
Last updated on