dbt-sqlite

library1.10.0pypypi✓ verified 85d ago

A SQLite adapter plugin for dbt (data build tool). Allows using SQLite as a target database for dbt transformations. Version 1.10.0 is compatible with dbt-core >= 1.10.x. The adapter is maintained by the community, with releases tracking dbt-core minor versions.

data database devops

pip install dbt-sqlite

github ↗package ↗

INSTALL

IMPORT

SIG · DBT-SQLITE

dbt-sqlite

datapythonv1.10.0

Install

10.1s avg

Import

5166ms

Disk

117MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v1.10.0 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 5.820s · 114.5MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 10.1s · import 4.512s · 115MB

117MB installed

● package 117MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

SQLiteAdapter

✓ from dbt.adapters.sqlite import SQLiteAdapter

SQLiteCredentials

✓ from dbt.adapters.sqlite import SQLiteCredentials

After installing dbt-sqlite, set up a profile pointing to a SQLite database file, then run dbt.

# Create a profiles.yml file # ~/.dbt/profiles.yml: # dbt_sqlite: # outputs: # dev: # type: sqlite # threads: 1 # database: 'database' # schema: 'main' # path: /path/to/your_sqlite.db # target: dev dbt init my_project cd my_project dbt run

dbt --version

Debug

Known issues

breakingdbt-sqlite releases are tied to specific dbt-core minor versions. Using v1.10.0 with dbt-core 1.9.x will cause import errors.

fix

Ensure dbt-core and dbt-sqlite versions match (e.g., dbt-core 1.10.x with dbt-sqlite 1.10.x).

affects: all

gotchaSQLite does not support concurrent writes; threads > 1 may cause database locked errors.

fix

Set threads: 1 in your profiles.yml for SQLite profiles.

affects: all

deprecatedThe 'digest.so' extension path in old sample profiles.yml has been removed. Use 'sqlean' modules instead.

fix

Update your profiles.yml to reference sqlean modules (e.g., paths to sqlean extensions) as shown in the v1.9.1 release notes.

affects: <1.9.1

gotchaSQLite has limited support for cross-database macros (e.g., dateadd, datediff). Some functions may not work without the sqlean extension.

fix

Install sqlean.py (pip install sqlean.py) and load the necessary extensions in your SQLite connection.

affects: all

Errors

Common errors & fixes

dbt.exceptions.PluginNotInstalled: Cannot load adapter: sqlite, plugin 'sqlite' not found. The following packages are installed: ['dbt-core', 'dbt-sqlite']

dbt-sqlite is not registered correctly, or the version mismatches dbt-core.

fix

Install a compatible version: pip install 'dbt-sqlite==1.10.0' and ensure dbt-core==1.10.x.

sqlite3.OperationalError: no such module: ...

Missing SQLite extensions (e.g., crypto, math) needed for dbt macros.

fix

Install sqlean and configure the extension path in your profiles.yml under the 'extensions' option.

OperationalError: database is locked

Multiple threads trying to write to the SQLite file simultaneously.

fix

Set threads: 1 in profiles.yml, or use a different database for concurrent access.

Upgrade

Version history

1.10.0latest on PyPI · released Jun 27, 2025

Audit

Dependencies

dbt-corerequiredRequired runtime dependency for dbt adapters.

sqlean.pyoptionalProvides crypto and math extensions for SQLite; strongly recommended for full compatibility with dbt's cross-database macros.

Agent activity

7 hits · last 30 days

node

OpenAI (training)

Resources

githubhttps://github.com/codeforkjeff/dbt-sqlite ↗

packagehttps://pypi.org/project/dbt-sqlite/ ↗