dbt and SQLite

Example dbt project with SQLite.

Dependencies

• Kaggle CLI
• poetry
• sqlite3

Execution

Set up profile

Add the following lines to you ~/.dbt/profiles.yml:

dbt_sqlite:
  target: dev
  outputs:
    dev:
      type: sqlite
      threads: 1
      database: database
      schema: main
      schemas_and_paths:
        main: "{{ env_var('PWD') }}/dbs/etl.db"
      schema_directory: "{{ env_var('PWD') }}/dbs"

Setup your Kaggle credentials

Run models

make run

Documentation

make lineage

Lint with SQLFluff

make lint