Connect to Amazon Dynamo DB in Bold BI

Published:

Amazon DynamoDB can be connected through multiple methods in Bold BI. Below are the steps to connect using Bold Data Hub and CDATA.

Connecting Dynamo DB through CDATA

For comprehensive details of connecting to Amazon Dynamo DB to Bold BI through CDATA, please refer below documentation.
Connecting Dynamo DB through CDATA

Connecting DynamoDB through Bold Data Hub

Create a New Pipeline in Bold Data Hub: Start by creating a new pipeline in the Bold Data Hub.
Choose DynamoDB as Connector: Select DynamoDB as the connector and click on “Add Template”.
YAML Template: The YAML template will appear as follows:

ETL supports three methods of extracting data from DynamoDB:

i. Full Table:

This method fetches all values from the table.

Sample YAML template:

ii. Fetching values from a specific date:

DynamoDB allows fetching data from a specific date. The date should be provided in the format (yyyy-mm-dd), along with the column name of the date.

Note: The date column must store values in (yyyy-mm-dd) format; otherwise, the date filter option will not work.

iii. Limit filter:

This method fetches values from the table based on a specified limit. Instead of scanning the entire table, it scans up to the defined limit.

Note: You can also select multiple tables at a time.

Save and Schedule the Project: After configuring the settings, save the project and schedule it as needed.
Check Logs: Finally, monitor the logs in the logs tab to ensure everything is functioning correctly.