OverviewQuickstartCLI Commands.sql Models.py Modelsprofiles.ymlsources.ymlExecution Paths
← All Adapters

SNOWFLAKE

type: snowflake

Cloud-native data warehouse with automatic scaling. Popular for analytics workloads and as a central data platform.

PREREQUISITES

Driver: snowflake-connector-python — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELDTYPEREQUIREDDEFAULTDESCRIPTION
typestringyes—Must be `snowflake`
accountstringyes—Snowflake account identifier (e.g., xy12345.us-east-1)
userstringyes—Snowflake username
passwordstringyes—Snowflake password
databasestringyes—Database name
schemastringyes—Schema name
warehousestringyes—Virtual warehouse name
rolestringno—Snowflake role
threadsintegerno4Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: sf_dev
  outputs:
    sf_dev:
      type: snowflake
      account: xy12345.us-east-1
      user: DVT_USER
      password: "{{ env_var('SF_PASSWORD') }}"
      database: ANALYTICS
      schema: PUBLIC
      warehouse: COMPUTE_WH
      role: TRANSFORMER

SOURCES.YML EXAMPLE

sources:
  - name: cloud_warehouse
    connection: sf_dev
    database: RAW_DATA
    schema: PUBLIC
    tables:
      - name: sales_fact
      - name: customer_dim

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

  • ⚠Case-sensitive identifiers — use UPPER() in source references