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.