dynamo-partiql-result-in-pg

A command-line tool to run SQL(PartiQL) against DynamoDB and save result in out-of-box Postgres. Zero config.

How to use

Pre-requisites

• AWS CLI (configured)
• Docker

Run it

• Start up Postgres and pgAdmin

docker-compose up

Go to pgAdmin . You should see a pre-imported Postgres server.

• Run PartiQL

./dpp "select * from ... "

(Windows user please run the docker command in file ./dpp)

You will see

The results are in postgres table 'xxx'

Then go to pgAdmin to query the table

Todo: some screenshot

• Shutdown Postgres (if needed)

docker-compose down

For developers

Do a manual test

Create a test table

The table should

• Be big enough so that "NextToken" can be tested
• Contain all data types of DynamoDB

To make this happen,

./doc/test/create-test-table.sh
./doc/test/put-test-items.js

Run the program without docker build

npm run build && node . "select * from DppTest"

Clean up

./doc/test/delete-test-table.sh