Querying AWS DynamoDB with Pentaho

User Defined Java Class to call AWS SDK

Featured image

A quick example on how to use a User Defined Java Class (UDJC) to query Amazon DynamoDB with Pentaho 8.2.x (probably works in other versions as well).

The UDJC uses the local machines DefaultAWSCredentialsProviderChain to find authentication credentials (environment variables, java properties, profile, etc.).

There is opportunity to create a single request with multiple Items and send them in a single batch.

The transformation can be used to grab configuration information for an execution e.g. read server properties for a project/environment/tenant and set them at top of your ETL cycle.

alt text

Click here for sample put/get to DynamoDB from AWS CLI
Click here for transformation
Click here for UDJC