Querying DuckDB with PRQL

Подписаться 10 тыс.

Просмотров 3,4 тыс.

50% 1

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...

Наука

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

5 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@andynelson2340 Год назад

First time hearing about PRQL, very cool

@AdrienSales Год назад

One more great tutorial. Very easy and short to understand, keep on inspriing us ;-p

@max-sixty Год назад

(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?

@learndatawithmark Год назад

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 :)

@CaribouDataScience Год назад

Good stuff.

@yatsuk 8 месяцев назад

It seems that generating PRQL dynamically through code is a simpler process

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

Will you make a video on PRQL and dbt (data build tool)? Its very confusing what to learn for data analytics career.

@learndatawithmark 10 месяцев назад

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.

@durgeshkshirsagar5160 9 месяцев назад

Are you going to catch a flight? So fast :D

@learndatawithmark 9 месяцев назад

I know! I try to slow down, but haven't quite managed it yet :D

@durgeshkshirsagar5160 9 месяцев назад

😀😀@@learndatawithmark

@michaelhunger6160 Год назад

Can you do the default value too similar to the | round 3 in the aggregation result?

@enesdedovic Год назад

Thank you. How different is this from ibis-framework? Which one do you prefer?

@learndatawithmark Год назад

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.