Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

MICROSOFT FABRIC

Microsoft's unified analytics platform combining data engineering, data science, and business intelligence in one SaaS offering.

PREREQUISITES

Driver: pyodbc — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `fabric`
host	string	yes	—	Fabric SQL endpoint
port	integer	no	1433	SQL endpoint port
user	string	yes	—	Service principal or user
password	string	yes	—	Authentication credential
database	string	yes	—	Lakehouse or warehouse name
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: fabric_dev
  outputs:
    fabric_dev:
      type: fabric
      host: your-workspace.datawarehouse.fabric.microsoft.com
      port: 1433
      user: "{{ env_var('FABRIC_USER') }}"
      password: "{{ env_var('FABRIC_PASSWORD') }}"
      database: my_lakehouse

SOURCES.YML EXAMPLE

sources:
  - name: fabric_data
    connection: fabric_dev
    schema: dbo
    tables:
      - name: sales
      - name: inventory

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

⚠Uses SQL Server protocol via TDS endpoint