dbt-duckdb
dbt-duckdb copied to clipboard
duckdb
dbt (http://getdbt.com) adapter for DuckDB (http://duckdb.org)
see: https://duckdb.org/docs/extensions/mysql#reading-data-from-mysql
does anyone know if its possible or if theres any exmaples of using the duck db spatial extension in duckdb-dbt?
Hello, Recently, the pyiceberg 0.6.0 version was released which allows writing iceberg tables without needing tools like Spark and Trino. I was about to write a custom plugin to implement...
This is more of a question than an issue, I was wondering if there are examples of custom dbt-duckdb plugins that implement incremental models (and therefore incremental sources)? In my...
Release 1.7.2 brings some new features to glue plugin I would like to use, but they are not specified in readme: https://github.com/duckdb/dbt-duckdb/pull/324 https://github.com/duckdb/dbt-duckdb/pull/327/ In particular, I'm getting some errors because...
Hi there, Given the latest version of duckdb and dbt-core and using the below configuration, i'm bumping into an issue where the debug error message doesn't help at all where...
https://github.com/duckdb/dbt-duckdb/blob/ab16970ba9f616205dcae52a9dcb661c6d8836c6/dbt/include/duckdb/macros/materializations/external.sql#L52 When materializing a table to a JSON file bigger than 30MB, we bump into the following: `Invalid Input Error: "maximum_object_size" of 16777216 bytes exceeded while reading file "s3://xxxxxx.json" (>33554428...
This adds support for the new DuckDB secrets manager. Example usage: ``` default: outputs: dev: type: duckdb path: /tmp/dbt.duckdb secrets: - type: s3 key_id: abc secret: xyz region: us-west-2 target:...
Fixes #405 tl;dr, helps you avoid errors like: ``` Binder Error: Could not choose a best candidate function for the function call "+(STRING_LITERAL, INTERVAL)". In order to select one, please...
I tried the example here: https://docs.getdbt.com/sql-reference/dateadd ``` SELECT {{ dateadd(datepart="month", interval=1, from_date_or_timestamp="'2021-08-12'") }} ``` This fails. I tweaked and this works: ``` SELECT {{ dateadd(datepart="month", interval=1, from_date_or_timestamp="DATE '2021-08-12'") }} AS...