Unleashing DuckDB & dbt for local analytics triumphs

Подписаться 4,1 тыс.

Просмотров 9 тыс.

50% 1

In this video, ‪@mehdio‬ will do a walkthrough of DuckDB with dbt. What kind of features these two frameworks provide together ?
📓 Resources
Github Repo of the tutorial : github.com/mehd-io/dbt-duckdb...
DuckDB getting started video: • DuckDB Tutorial For Be...
Dbt docs: docs.getdbt.com/docs/core/con...
➡️ Follow Us
LinkedIn: / 8192. .
Twitter : / motherduck
Blog: motherduck.com/blog/
0:00 Intro
0:44 Challenges of dbt with cloud datawarehouses
2:23 Where DuckDB can help
3:05 DuckDB and dbt with a project
7:59 Take aways
#dbtduckdb #dbtandduckdb #dataengineering #dbtdatabuildtool

Опубликовано:

28 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@JohnoScott Год назад

I didn't expect to laugh out loud - TWICE - but I did. Great video. I love how MotherDuck can demonstrate awesome desktop data-engineering super-powers and tell jokes at the same time. No excuse me I need to deal with the coffee I just spit everywhere after the 2nd laugh I had. 😂

Год назад

Would love a tutorial with this and meltano :D

@willi1978 3 месяца назад

searching for dbt confused me too. didn't find technical things at first

@pp56825 11 месяцев назад

Hair quality 😉🤣

@krneki6954 11 месяцев назад

woo

@roberbonox 11 месяцев назад

dude how r you, i have the next question, what could i do if i have a stream on snowflake that i want to "consume" in dbt but not creating a physical table or view, instead something live a ephemeral materialization, only to purge the stream and avoid to become stale. I create an ephemeral model and select the stream source but that only create obviously an ephemeral materialization but kind not clean the data on the stream, thoughts??

@GeorgeNgAltGreens Год назад

encountered - Encountered an error:Parsing Error Env var required but not provided: 'S3_ACCESS_KEY_ID'

@washedtoohot Год назад

sounds like you need to provide a s3 access key

@AdrienSales 6 месяцев назад

Hi, running dbt on local data was the thing i was wiahting for some usecases. BtW : "Getting started with dbt " is targetting a dead lin ;-p

@motherduckdb 6 месяцев назад

thanks for the headsup, fixed!

@YEM_ Месяц назад

Can you write to CSV and duckdb in a single model?

@motherduckdb Месяц назад

Yes! You can use a post-hook strategy and macros to have multiple outputs. Essentially having a macro that does a COPY to a given location. Hope it helps!