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.