dbt-duckdb

dbt-duckdb copied to clipboard

The database file was created with an newer version of DuckDB.

7

Thanks for developing both `dbt-duckdb` and `target-duckdb`! Being new to the whole meltano, dbt, duckdb stack I tried to modify the official [meltanto tutorial](https://docs.meltano.com/getting-started/part1) by replacing `postgres` with `duckdb` ```yml...

ibayer

Allow Google Sheets plug-in to select data by range as well

1

Hi! First off, thanks for the great work on this adapter! I'm using dbt-duckdb to fetch data from Google Sheets and then transform and output it. Apart from being able...

Thootje

Issue using `read_csv` in a model file for a large CSV being converted to a parquet file

6

Hi @jwills ! Thank you for this amazing work!! I've used it to teach datathinking.org at University of Tartu and @PrincetonUniversity. However, I'm getting stuck in switching from a local...

jaanli

A minimally working version of dbt-duckdb that uses sqlglot for transpiling

7

This allows a user to use dbt-duckdb with a dbt project that was written for another database; there is more testing I need to do to verify that this works...

jwills

Is it possible to reference tables as parquet files in iceberg on glue via external source?

3

I see a method to write to glue, but no reference to use it to get the data back out? Please help!

dioptre

Issue with dbt-duckdb Plugin Not Being Recognized

1

**Description**: I am encountering an issue with the dbt-duckdb plugin. After installing the plugin using `pip install dbt-duckdb`, it does not appear in the list of installed plugins when I...

vmonney

Database increases by initial size after each dbt run is executed

8

I have a project running on Windows 10 that contains only views (no tables materialized) that select from sources using meta_external-location `read_parquet` statements. I have found if I delete the...

simtbak

Create a MotherDuck environment for default config and safety net

2

As md environment differs slightly (and hopefully less in the future ;)) from duckDB, I was thinking of creating a dedicated [environment class](https://github.com/jwills/dbt-duckdb/blob/master/dbt/adapters/duckdb/environments/__init__.py#L32) that would be loaded when users specify...

mehd-io

Support index configuration like dbt-postgres

2

DuckDB has indexes like Postgres does, and I suspect that we will discover some use cases and pipelines where the ability to add them in helps significantly with performance. dbt-postgres...

jwills

Allow arbitrary extensions

5

Would be cool to be able to install third party extensions like [`duckdb-python-udf`](https://github.com/MarkRoddy/duckdb-python-udf) from `dbt-duckdb`. Perhaps something like this? ```yml default: outputs: dev: type: duckdb path: /tmp/dbt.duckdb extensions: - httpfs...

davidgasquez