Azure Synapse
Writes data to Azure Synapse Analytics via TDS protocol.
Configuration
yaml
warehouse:
kind: synapse
connection_string: ${SYNAPSE_CONNECTION_STRING}
schema: dbo| Field | Default | Description |
|---|---|---|
connection_string | (required) | ADO-style connection string |
schema | dbo | Target schema |
CLI
bash
skippr connect warehouse synapse \
--connection-string "${SYNAPSE_CONNECTION_STRING}" \
--schema dbo| Flag | Description |
|---|---|
--connection-string | ADO.NET connection string (or set SYNAPSE_HOST, SYNAPSE_USER, SYNAPSE_PASSWORD, SYNAPSE_DATABASE env vars individually) |
--schema | Target schema (default: dbo) |
CDC
Azure Synapse supports CDC with MERGE semantics via the Tiberius driver. Skippr automatically creates _skippr_order_token columns and tombstone tables.
See CDC Destinations -- Synapse for details.