dbt-duckdb

dbt-duckdb copied to clipboard

One of the most common use case for DuckDb is to run SQL tests locally. SQLMesh supports this natively with SQLGlot, but no alternative exists for dbt workflow. There's global macros but they don't cover many use cases. In my case it's to transpile to_date in postgres into strptime in duckdb. This plugin facilitates that by intercepting the original compiled sql (either in redshift, postgres, or mysql), and transpiling them into duckdb syntax.