dbt-sqlite
dbt-sqlite copied to clipboard
codeforkjeff
A SQLite adapter plugin for dbt (data build tool)
Hi, love the idea of a dbt sqlite adapter for demos and stuff. Am working on a demo and wanted to show incremental functionality. If you provide a unique key,...
The incremental materialization in 1.1.x of this adapter is a little out of date with changes in dbt-core 1.1.x. - handle cases where unique_key is a list - dbt-core handles...
Several tests in `test_data_types.py` are currently failing, and the issues around types are also what's behind the failures in TestDocsGenerateSqlite and TestDocsGenReferencesSqlite. Here's some things the adapter needs to account...
The closest thing in sqlite is [group_concat](https://www.sqlite.org/lang_aggfunc.html). Maybe there's an extension that provides this? sqlean doesn't have it.
I think is doable? The slightly tricky part is determining whether the passed-in value is date or timestamp.
There is a `sqlite__datediff_broken` macro that needs to be fixed, more fully implemented, renamed, and tested.
We've just published the release cut of dbt-core 1.2.0, `dbt-core 1.2.0rc1` ([PyPI](https://pypi.org/project/dbt-core/1.2.0rc1/) | [GitHub release notes](https://github.com/dbt-labs/dbt-core/releases/tag/v1.2.0rc1)). https://github.com/dbt-labs/dbt-core/discussions/5468 is an open discussion with more detailed information, and https://github.com/dbt-labs/dbt-core/issues/5474 is for keeping...
Dependabot updates could be set up to make sure the package is tested with the latest `dbt-tests-adapter` by putting it in a pip constraints file. Happy to submit a PR...
See https://docs.getdbt.com/docs/contributing/building-a-new-adapter#other-files Couldn't figure out how to do the schemas_and_paths and extensions parts ```yaml fixed: type: sqlite threads: 1 database: "database" schema: "main" prompts: schemas_and_paths: main: hint: '/my_project/data/etl.db' schema_directory: hint:...
Metadata
Owner
Metadata
A SQLite adapter plugin for dbt (data build tool)