Table Copy¶
Launch a task that will perform a table copy from one project to another. The destination project can be the one of origin in which case the table has to be renamed.
opal copy-table <CREDENTIALS> [OPTIONS] [XTRAS]
Options¶
Option | Description |
---|---|
--project, -pr |
Source project name |
--tables, -t |
List of table names which will be copied (default is all) |
--destination, -d |
Destination project name |
--name, -na |
New table name (required if source and destination are the same, ignored if more than one table is to be copied) |
--incremental, -i |
Incremental copy |
--nulls, -nu |
Copy the null values |
Credentials¶
Authentication can be done by username/password credentials OR by personal access token OR by certificate/private key pair (two-way SSL authentication).
Option | Description |
---|---|
--opal OPAL, -o OPAL |
Opal server base url |
--user USER, -u USER |
Credentials auth: user name (requires a password) |
--password PASSWORD, -p PASSWORD |
Credentials auth: user password (requires a user name) |
--token TOKEN, -tk TOKEN |
Token auth: user’s personal access token |
--ssl-cert SSL_CERT, -sc SSL_CERT |
Two-way SSL auth: certificate/public key file (requires a private key) |
--ssl-key SSL_KEY, -sk SSL_KEY |
Two-way SSL auth: private key file (requires a certificate) |
Extras¶
Option | Description |
---|---|
-h, --help |
Show the command help’s message. |
--verbose, -v |
Verbose output. |
--json, -j |
Output pretty-print JSON |
Example¶
Copy a table in the same project, by specifying a new name:
opal copy-table --opal https://opal-demo.obiba.org --user administrator --password password --project datashield --tables CNSIM1 --destination datashield --name CNSIM4