DynamoDB Data Dictionary
  • 30 Jul 2021
  • 1 Minute to read
  • Dark
    Light
  • PDF

DynamoDB Data Dictionary

  • Dark
    Light
  • PDF

Article Summary

Because DynamoDB data comes from a database system, Panoply cannot provide a data dictionary. But Panoply does automate the data schema for the collected data. This section includes useful information about the Panoply automations. You can adjust these settings in your data source under Advanced Settings

Columns

A column in a table uses the same data type for all values in that column. Panoply automatically chooses the data type for each column based on the available values. This is important to note for this data source. If even one value in a column has text, then the entire column is considered data type text

Metadata

The following metadata columns are added to the destination table(s):

  • __pk: The primary key value as defined in the table
  • __senttime - Formatted as a datetime, such as 2020-04-26T01:26:14.695Z.
  • __updatetime - Formatted as a datetime, such as 2020-04-26T01:26:14.695Z.

Data Type Mapping

To better understand how Panoply handles data types we have created a spreadsheet mapping DynamoDB data types to their equivalent in Panoply.

DynamoDB Data Type Mapping


Was this article helpful?