Overview Quickstart dbt Compatibility The Style Guide profiles.yml sources.yml Configuration Supported Databases

SQL SERVER

Microsoft's enterprise relational database. Dominant in corporate environments, especially with .NET ecosystems.

DVT SUPPORT

✓ FEDERATION SOURCE

read in federation models

✓ FEDERATION TARGET

materialize federation results

✓ DEFAULT TARGET

run full dbt projects against it

✓ SEED TARGET

dvt seed --target loads here

DVT supports SQL Serverbecause both dbt and Sling do: dbt drives standard materializations when it's your default target, Sling moves data in and out during federation. Connectivity for both layers is checked with dvt debug --all.

PREREQUISITES

Driver: pyodbc — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `sqlserver`
host	string	yes	—	Server hostname or IP
port	integer	no	1433	Server port
user	string	yes	—	Database user
password	string	yes	—	Database password
database	string	yes	—	Database name
encrypt	boolean	no	false	Enable encryption
trust_cert	boolean	no	false	Trust server certificate
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: mssql_dev
  outputs:
    mssql_dev:
      type: sqlserver
      host: sql-server.internal.com
      port: 1433
      user: sa
      password: "{{ env_var('MSSQL_PASSWORD') }}"
      database: analytics
      encrypt: false
      trust_cert: true

SOURCES.YML EXAMPLE

sources:
  - name: enterprise_db
    meta:
      connection: mssql_dev
    database: ERP
    schema: dbo
    tables:
      - name: GL_Accounts
      - name: AP_Invoices

DBT ADAPTER FEATURES

When SQL Server is your default target, every standard dbt model runs through the official dbt adapter — all of its documented capabilities apply unchanged:

MATERIALIZATIONS

INCREMENTAL STRATEGIES

NOTABLE CONFIGS

▸clustered columnstore indexes
▸OS prerequisite: unixODBC + msodbcsql driver

Official dbt SQL Server adapter docs ↗

FEDERATION INCREMENTAL STRATEGIES

Strategies available when this engine is the target of a f_incremental model:

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

⚠Requires ODBC driver installed (dvt sync handles this)