Azure Synapse Analytics

Load event data into Azure Synapse Analytics for enterprise-scale data warehousing and big data analytics.

Configuration

Field	Type	Required	Description
`workspace_name`	string	Yes	The Azure Synapse workspace name.
`sql_pool_name`	string	Yes	The dedicated SQL pool name.
`database`	string	Yes	The target database name.
`schema_name`	string	Yes	The schema to write to. Defaults to `dbo`.
`table_name`	string	Yes	The target table name to insert rows into.
`connection_string`	secret	Yes	The connection string for the Synapse SQL pool.

Quick Setup

Navigate to Integrations in the sidebar.
Open the Integration Library tab.
Find Azure Synapse Analytics or filter by Cloud Storage.
Click Install, select a variant if available, and fill in the required fields.
Click Install Integration to create the integration with a ready-to-use default configuration.

API Setup

curl -X POST http://localhost:8084/v1/admin/integration-catalog/azure_synapse/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Azure Synapse Analytics",
    "variant": "default",
    "config": {
      "workspace_name": "my-synapse-workspace",
      "sql_pool_name": "pool01",
      "database": "analytics",
      "schema_name": "dbo",
      "table_name": "events"
    },
    "delivery_mode": "server_side"
  }'

Delivery

Events are delivered server-side from your Datafly Signal infrastructure directly to Azure Synapse Analytics. No client-side scripts are loaded for this integration.

Visit Azure Synapse Analytics documentation for full API documentation and credential setup instructions.

Azure SQL Clickhouse