search

duckdb / dbt-duckdb

dbt (http://getdbt.com) adapter for DuckDB (http://duckdb.org)
Apache License 2.0
848 stars 76 forks source link

dbt-duckdb excel plugin demo #411

Open nicohein opened 2 months ago

nicohein commented 2 months ago

I love to see the work done here and see some great potential in the plugin setup as it drills open what we can do with dbt. I just tested the feasibility of using dbt in combination with this DuckDB adapter as a file processing and even ingestion framework.

Given that I found little docs around the excel connector, (and sure it's more a toy, still many processes start or have intermediate steps in excel) thought to post the link to my demo setup here: demo-dbt-duckdb-excel-plugin.

I am happy to continue a conversation around this topic or simply close this issue.

Maybe someone find this useful.

Edit: More elaborate thoughts: Streamlined-File-Processing-and-Data-Ingestion-with-dbt-and-DuckDB

jwills commented 1 month ago

This is really cool @nicohein -- thanks for posting it! (And sorry for the lag here, been out on vacation for a bit!)