123table

a containerized data loader for db tables

View project on GitHub

123table CLI

The easiest way to get the full list of options supported by 123table command line interface is launching it with the --help flag.

CLI syntax

The following table sums up the options exposed by 123table CLI.

Short / Long Default value Description
-surl/--source-db-url jdbc:relique:csv:/data Source JDBC url
-stable/--source-table table Source table name
-url/--target-db-url - Mandatory - Target JDBC url
-table/--target-table The value of source-table flag Target table name
-query/--source-query SELECT * FROM <<source-table>> Source query
-batch/--batch-size 100 Batch size
-create/--create-table - Create the target table
-trunc/--truncate-table - Truncate the target table
-dry/--dry-run - Avoid applying any changes
-h/--help - Show usage information
-mapper/--mapper - See Mapping fields
-mfile/--mapper-file - See the mapper flag
-w/--warm-up - Generate a CRaC checkpoint.

Please note that the -w/--warm-up flags are meant for generating a CRaC checkpoint to reduce 123table startup time. For more details Check fast images.