civis (version 3.0.0)

transfer_table: Transfer a table from one location to another.

Description

Transfer a table from one location to another.

Usage

transfer_table(
  source_db,
  dest_db,
  source_table,
  dest_table,
  job_name = NULL,
  source_credential_id = NULL,
  dest_credential_id = NULL,
  interval = NULL,
  verbose = FALSE,
  advanced_options = NULL
)

Value

A civis_api object.

Arguments

source_db

string or int, The name of the database where the source table is located. Optionally, could be the database ID.

dest_db

string or int, The name of the database where the table will be transferred. Optionally, could be the database ID.

source_table

string, Full name of the table to transfer, e.g., "schema.table".

dest_table

string, Full name of the table in the destination database, e.g., "schema.table".

job_name

string, optional, A name to give the job. If omitted, a random job name will be used.

source_credential_id

string or int, Optional credential ID for the source database. If NULL, the default credential will be used.

dest_credential_id

string or int, Optional credential ID for the source database. If NULL, the default credential will be used.

interval

Number of seconds to wait between checks for job completion. If NULL, the default exponential backoff from await will be used.

verbose

bool, Set to TRUE to print intermediate progress indicators.

advanced_options

A list of advanced options for the sync. See imports_post_syncs for details.

See Also

Other tables: get_table_id(), refresh_table()

Examples

if (FALSE) {
transfer_table(source_db='Cluster A', dest_db='Cluster B',
               source_table='schma.tbl', dest_table='schma.tbl')
}