transfer

Transfer data between warehouses. Waits for completion by default.

carto transfer --source-connection <n> --dest-connection <n> --source-table <t> --dest-table <t>
carto transfer status <jobId>                   # Fetch status of an async transfer job

Transfer requires the DuckDB import engine to be enabled for your account.

Options

Option	Description
--source-connection <name>	(Required) Source connection name.
--dest-connection <name>	(Required) Destination connection name.
--source-table <fqn>	(Required) Source table.
--dest-table <fqn>	(Required) Destination table.
--geography	Use geography type for spatial data.
--async	Return job ID immediately without waiting.

Examples

# Transfer from BigQuery to Snowflake
carto transfer \
  --source-connection bigquery-prod \
  --dest-connection snowflake-analytics \
  --source-table project.dataset.customers \
  --dest-table db.schema.customers

# With geography support, async
carto transfer \
  --source-connection bq-prod \
  --dest-connection postgres-dev \
  --source-table project.dataset.geo_data \
  --dest-table public.geo_data \
  --geography --async

# Poll an async transfer
carto transfer status <jobId>