Querying DuckDB with PRQL
HTML-код
- Опубликовано: 8 сен 2024
- In this video, we'll learn how to query DuckDB with PRQL, Pipelined Relational Query Language, a modern language for transforming data.
#dataengineering #prql #duckdb
Resources ▼
▶ PRQL Language - prql-lang.org/
▶ DuckDB plugin - github.com/ywe...
▶ Google Trends dataset - console.cloud....
▶ PRQL compiler - pypi.org/proje...
First time hearing about PRQL, very cool
One more great tutorial. Very easy and short to understand, keep on inspriing us ;-p
Good stuff.
(PRQL dev here)
Great video, thanks a lot for making it! Really well produced.
Was there anything you found difficult with PRQL that we could improve?
The only thing I got stuck on so far was the sub queries where I used the s-string. I thought I might be able to store the result of doing the max(week) query in pRQL as a variable and then use that variable inside a filter clause, but I couldn't get that to work.
But no, otherwise, it was a great experience :)
It seems that generating PRQL dynamically through code is a simpler process
Are you going to catch a flight? So fast :D
I know! I try to slow down, but haven't quite managed it yet :D
😀😀@@learndatawithmark
Will you make a video on PRQL and dbt (data build tool)?
Its very confusing what to learn for data analytics career.
Let me have a look into it. I do have a simple data pipeline using DuckDB and dbt that I made just for fun, but let me see if I can get it to use PRQL.
Can you do the default value too similar to the | round 3 in the aggregation result?
Thank you. How different is this from ibis-framework? Which one do you prefer?
I have to make a video about Ibis actually, so I'll compare them when I do it. I also recently came across another similar tool called Malloy which looks neat.