JP
@urrutia.bsky.social
Data | Bass
Another DuckDB enthusiast
ATX
Another DuckDB enthusiast
ATX
Dropping a cheatsheet to share some #DuckDB basics
Check out some of the easy stuff to get started
Going to continue rolling out more soon
Stay tuned
Check out some of the easy stuff to get started
Going to continue rolling out more soon
Stay tuned
December 4, 2024 at 3:41 AM
Dropping a cheatsheet to share some #DuckDB basics
Check out some of the easy stuff to get started
Going to continue rolling out more soon
Stay tuned
Check out some of the easy stuff to get started
Going to continue rolling out more soon
Stay tuned
the crŷptö böts made it
November 27, 2024 at 4:55 AM
the crŷptö böts made it
🔥 SQL Pro Tips: Filtering in the right place 🚀
HAVING: Filter groups after aggregation.
QUALIFY: Filter results of window functions.
FILTER: Exclude rows before aggregating.
Master these, and SQL gets so much cleaner! 💡
#DuckDB
HAVING: Filter groups after aggregation.
QUALIFY: Filter results of window functions.
FILTER: Exclude rows before aggregating.
Master these, and SQL gets so much cleaner! 💡
#DuckDB
November 26, 2024 at 7:07 PM
🔥 SQL Pro Tips: Filtering in the right place 🚀
HAVING: Filter groups after aggregation.
QUALIFY: Filter results of window functions.
FILTER: Exclude rows before aggregating.
Master these, and SQL gets so much cleaner! 💡
#DuckDB
HAVING: Filter groups after aggregation.
QUALIFY: Filter results of window functions.
FILTER: Exclude rows before aggregating.
Master these, and SQL gets so much cleaner! 💡
#DuckDB
This is a pretty powerful query
We're combining window functions, quantile analysis, and custom window definition to provide detailed insights
The query uses a named window with a complex order and partition and the query references the window defined after the FROM clause
#duckdb
We're combining window functions, quantile analysis, and custom window definition to provide detailed insights
The query uses a named window with a complex order and partition and the query references the window defined after the FROM clause
#duckdb
November 24, 2024 at 8:17 PM
This is a pretty powerful query
We're combining window functions, quantile analysis, and custom window definition to provide detailed insights
The query uses a named window with a complex order and partition and the query references the window defined after the FROM clause
#duckdb
We're combining window functions, quantile analysis, and custom window definition to provide detailed insights
The query uses a named window with a complex order and partition and the query references the window defined after the FROM clause
#duckdb
Query and query_table - dynamic sql Macros in DuckDB
November 22, 2024 at 9:38 PM
Query and query_table - dynamic sql Macros in DuckDB
Creative Architecture is where this can be explored.
Cryptic enough?
Cryptic enough?
high powered ephemeral analytics
at a fraction of the cost
at a fraction of the cost
November 22, 2024 at 9:02 PM
Creative Architecture is where this can be explored.
Cryptic enough?
Cryptic enough?
Finder and search bar have been and continue to be garbage
November 22, 2024 at 9:01 PM
Finder and search bar have been and continue to be garbage
high powered ephemeral analytics
at a fraction of the cost
at a fraction of the cost
November 22, 2024 at 8:22 PM
high powered ephemeral analytics
at a fraction of the cost
at a fraction of the cost
Are all things named Lumon or alike not to be trusted?
November 22, 2024 at 7:56 PM
Are all things named Lumon or alike not to be trusted?
Interactive Analysis
Pipeline Component
"Creative Architecture" -> This just means lambda functions on my phone.
What am I talking about?
Pipeline Component
"Creative Architecture" -> This just means lambda functions on my phone.
What am I talking about?
November 21, 2024 at 7:40 AM
Interactive Analysis
Pipeline Component
"Creative Architecture" -> This just means lambda functions on my phone.
What am I talking about?
Pipeline Component
"Creative Architecture" -> This just means lambda functions on my phone.
What am I talking about?
Life is funny like that
November 21, 2024 at 7:39 AM
Life is funny like that
#DuckDB offers unique and flexible SQL capabilities
- EXCLUDE to remove specific cols in a select
- REPLACE to modify and replace col values
- COLUMNS to select, filter, or agg based on regex
- Aliases that can be accessed in WHERE and HAVING
- GROUP BY and ORDER BY ALL to simplify grouping
- SAMPLE
- EXCLUDE to remove specific cols in a select
- REPLACE to modify and replace col values
- COLUMNS to select, filter, or agg based on regex
- Aliases that can be accessed in WHERE and HAVING
- GROUP BY and ORDER BY ALL to simplify grouping
- SAMPLE
November 20, 2024 at 4:06 PM
#DuckDB offers unique and flexible SQL capabilities
- EXCLUDE to remove specific cols in a select
- REPLACE to modify and replace col values
- COLUMNS to select, filter, or agg based on regex
- Aliases that can be accessed in WHERE and HAVING
- GROUP BY and ORDER BY ALL to simplify grouping
- SAMPLE
- EXCLUDE to remove specific cols in a select
- REPLACE to modify and replace col values
- COLUMNS to select, filter, or agg based on regex
- Aliases that can be accessed in WHERE and HAVING
- GROUP BY and ORDER BY ALL to simplify grouping
- SAMPLE
You should use CTEs instead of subqueries:
1. nested subqueries are not allowed to reference themselves.
2. CTEs will make individual aggregates that can then reference each other
3. Recursion in SQL is possible because of CTEs, making it possible to reference a CTE from within itself
#duckdb
1. nested subqueries are not allowed to reference themselves.
2. CTEs will make individual aggregates that can then reference each other
3. Recursion in SQL is possible because of CTEs, making it possible to reference a CTE from within itself
#duckdb
November 19, 2024 at 11:46 PM
You should use CTEs instead of subqueries:
1. nested subqueries are not allowed to reference themselves.
2. CTEs will make individual aggregates that can then reference each other
3. Recursion in SQL is possible because of CTEs, making it possible to reference a CTE from within itself
#duckdb
1. nested subqueries are not allowed to reference themselves.
2. CTEs will make individual aggregates that can then reference each other
3. Recursion in SQL is possible because of CTEs, making it possible to reference a CTE from within itself
#duckdb
DuckDB - Import / Export Formats
CSV
JSON
Parquet
Partitioned Data Lakes
Relational DB
CSV
JSON
Parquet
Partitioned Data Lakes
Relational DB
November 18, 2024 at 3:08 AM
DuckDB - Import / Export Formats
CSV
JSON
Parquet
Partitioned Data Lakes
Relational DB
CSV
JSON
Parquet
Partitioned Data Lakes
Relational DB
SQL is the past, present, and future.
If you think otherwise, you're wrong
If you think otherwise, you're wrong
November 14, 2024 at 8:24 PM
SQL is the past, present, and future.
If you think otherwise, you're wrong
If you think otherwise, you're wrong
What is DuckDB?
- An in-process analytical database system
- It's free, open-sourced, and designed for OLAP tasks.
- Focuses on fast, vectorized processing.
- An in-process analytical database system
- It's free, open-sourced, and designed for OLAP tasks.
- Focuses on fast, vectorized processing.
November 14, 2024 at 8:05 PM
What is DuckDB?
- An in-process analytical database system
- It's free, open-sourced, and designed for OLAP tasks.
- Focuses on fast, vectorized processing.
- An in-process analytical database system
- It's free, open-sourced, and designed for OLAP tasks.
- Focuses on fast, vectorized processing.
DuckDB deep-dive
Let's get it
Let's get it
November 14, 2024 at 7:41 PM
DuckDB deep-dive
Let's get it
Let's get it
storage
memory
cpu
networking
memory
cpu
networking
November 14, 2024 at 6:30 PM
storage
memory
cpu
networking
memory
cpu
networking
Job Description:
Must understand networking
Me:
I have 500+ linkedin connections
Must understand networking
Me:
I have 500+ linkedin connections
November 14, 2024 at 6:03 AM
Job Description:
Must understand networking
Me:
I have 500+ linkedin connections
Must understand networking
Me:
I have 500+ linkedin connections
Reposted by JP
Is the data community still on here?
November 19, 2023 at 11:46 PM
Is the data community still on here?
Is the data community still on here?
November 19, 2023 at 11:46 PM
Is the data community still on here?
Reposted by JP
A fictional character you would give an invite code to.
Lukas Matsson is the only answer.
Lukas Matsson is the only answer.
July 3, 2023 at 4:03 AM
A fictional character you would give an invite code to.
Lukas Matsson is the only answer.
Lukas Matsson is the only answer.
Welcome to bsky it’s kinda like this
June 27, 2023 at 2:35 AM
Welcome to bsky it’s kinda like this