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