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

SQLITE

type: sqlite

Serverless, file-based relational database. Ideal for local development, testing, and embedded analytics.

PREREQUISITES

Driver: sqlite3 — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELDTYPEREQUIREDDEFAULTDESCRIPTION
typestringyes—Must be `sqlite`
pathstringyes—Path to SQLite database file
threadsintegerno1Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: sqlite_dev
  outputs:
    sqlite_dev:
      type: sqlite
      path: ./local.db

SOURCES.YML EXAMPLE

sources:
  - name: local_data
    connection: sqlite_dev
    tables:
      - name: users
      - name: transactions

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

  • ⚠Single-user — file locks prevent concurrent writes
  • ⚠No network protocol — file must be locally accessible