Snowflake

Load event data into Snowflake tables for cloud data warehousing, analytics, and data sharing.

⚠️

This integration is currently in beta. Configuration and behaviour may change.

Configuration

FieldTypeRequiredDescription
account_identifierstringYesYour Snowflake account identifier, including the region suffix (e.g., xy12345.us-east-1).
warehousestringYesThe Snowflake virtual warehouse to use for loading data.
databasestringYesThe Snowflake database containing the target table.
schemastringYesThe Snowflake schema containing the target table.
usernamestringYesThe Snowflake username for authentication.
passwordsecretYesThe password for the Snowflake user account.
rolestringNoOptional Snowflake role to assume when connecting. Defaults to the user’s default role.

Quick Setup

  1. Navigate to Integrations in the sidebar.
  2. Open the Integration Library tab.
  3. Find Snowflake or filter by Cloud Storage.
  4. Click Install, select a variant if available, and fill in the required fields.
  5. 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/snowflake/install \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -H "Content-Type: application/json" \
  -d '{
    "name": "Snowflake",
    "variant": "default",
    "config": {
      "account_identifier": "xy12345.us-east-1",
      "warehouse": "DATAFLY_WH",
      "database": "ANALYTICS"
    },
    "delivery_mode": "server_side"
  }'

Delivery

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

Visit Snowflake documentation for full API documentation and credential setup instructions.