dbt-duckdb
DuckDB is an embedded database, similar to SQLite, but designed for OLAP-style
analytics. It is crazy fast and allows you to read and write data stored in CSV,
JSON, and Parquet files directly, without requiring you to load them into the
database first.
dbt is the best way to manage a collection of data transformations written in
SQL or Python for analytics and data science. dbt-duckdb is the project that
ties DuckDB and dbt together, allowing you to create a Modern Data Stack In A
Box or a simple and powerful data lakehouse with Python.
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above. NOTE: This is a Python port. Instead of py312-dbt-duckdb listed in the above command, you can pick from the names under the Packages section.
python: bump all USE_PYTHON=distutils consumers after RUN_DEPENDS removal
Any missed ports, feel free to bump.
Any ports that need setuptools at runtime can have the devel/py-setuptools
manually added back to RUN_DEPENDS, but understand that this practice
is deprecated; see CHANGES for details.
databases/py-dbt-duckdb: new port
dbt-duckdb
DuckDB is an embedded database, similar to SQLite, but designed for OLAP-style
analytics. It is crazy fast and allows you to read and write data stored in CSV,
JSON, and Parquet files directly, without requiring you to load them into the
database first.
dbt is the best way to manage a collection of data transformations written in
SQL or Python for analytics and data science. dbt-duckdb is the project that
ties DuckDB and dbt together, allowing you to create a Modern Data Stack In A
Box or a simple and powerful data lakehouse with Python.
PR: 274584
Author: Pat Maddox <pat@patmaddox.com>