Unleashing DuckDB & dbt for local analytics triumphs
Рет қаралды 9,152
Күн бұрын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
@JohnoScott 11 ай бұрын
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 2 ай бұрын
searching for dbt confused me too. didn't find technical things at first
@pp56825 11 ай бұрын
Hair quality 😉🤣
@krneki6954 10 ай бұрын
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
@YEM_ Ай бұрын
Can you write to CSV and duckdb in a single model?
@motherduckdb 16 күн бұрын
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!
@AdrienSales 5 ай бұрын
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 5 ай бұрын
thanks for the headsup, fixed!
Praveen Kumar Bommisetty
Рет қаралды 2,2 М.