This is a sample analytics pipeline with the following components:
- DBT for data transformations
- Dagster for data orchestration
- DuckDB as a local data warehouse
- SQLFluff for SQL linting and auto-formatting
- pre-commit and GitHub Actions CI/CD pipelines for running automated tests, linting, etc.
dbt-coves
for DBT utilities and developer productivity- Pixi for cross-platform, reproducible environments.
- A fully-featured Docker-based devcontainer config for reproducible, 1-click set up of your VS Code or GitHub Codespaces IDE.
- The DBT Power User extension for an improved developer experience when working with DBT Core in VS Code.