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.
--overwrite	Replace the destination table if it already exists. The replacement is staged, so the existing table survives a failed transfer.
--target-srid <epsg>	Reproject geometry to this EPSG code at the destination. Fails if the destination cannot store it.
--preserve-source-crs	Keep the source CRS instead of applying the destination's convention. Fails if the destination cannot store it.
--async	Return job ID immediately without waiting.

--target-srid and --preserve-source-crs are mutually exclusive.

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

# Overwrite the destination and reproject to EPSG:4326
carto transfer \
  --source-connection bq-prod \
  --dest-connection snowflake-analytics \
  --source-table project.dataset.parcels \
  --dest-table db.schema.parcels \
  --overwrite --target-srid 4326

# Poll an async transfer
carto transfer status <jobId>