{"repo":"codeforkjeff/dbt-sqlite","free":true,"listed":false,"github":"https://github.com/codeforkjeff/dbt-sqlite","clone":"git clone https://github.com/codeforkjeff/dbt-sqlite.git","description":"A SQLite adapter plugin for dbt (data build tool)","language":"Python","stars":83,"topics":["dbt","sqlite","elt","etl"],"license":"Apache-2.0","category":"data-pipelines","readme_excerpt":"dbt-sqlite A SQLite adapter plugin for dbt (data build tool) Please read these docs carefully and use at your own risk. Issues and PRs welcome! The Use Case SQLite is an embedded SQL database. It comes included with most Python distributions and requires no installation or configuration. It can be a good choice if your project meets any of these criteria: - you store the database file on fast, local storage (not on a network drive) - the amount of data is relatively small (GBs, not TBs) - you're a data team of one with no need to share access to a database - your end goal is to export the results of your pipeline(s) into other systems for multi-user access or into BI/viz tools for analysis (i.e. you're doing ETL vs ELT) - your project is a proof of concept, to eventually be moved into another database or data warehouse platform - you want others to be able to deploy your data build without the overhead/cost of a full RDBMS or signing up for a data warehouse platform SQLite can be surprisingly fast, despite the query optimizer not being as sophisticated as other databases and data warehouse platforms. Tip: materialize your models as tables and create indexes in post-hooks to speed up filtering and joins. How to Use This Use the right version. Starting with the release of dbt-core 1.0.0, versions of dbt-sqlite are aligned to the same major+minor version of dbt-core. - versions 1.10.x of this adapter work with dbt-core 1.10.x - versions 1.9.x of this adapter work with dbt-core 1","default_branch":null,"files":null,"tree":[],"storefront":"/r/codeforkjeff","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/codeforkjeff/dbt-sqlite/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}