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
🔥 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
#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
Looking at a high-level overview of the query-processing pipeline
November 14, 2024 at 8:22 PM
Looking at a high-level overview of the query-processing pipeline
Battle of the bastards—billionaire tech edition
July 6, 2023 at 2:46 PM
Battle of the bastards—billionaire tech edition
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
Ooooof
Ok but hear me out
I think these are the babies so I’ll stick to my toad answer!
Ok but hear me out
I think these are the babies so I’ll stick to my toad answer!
June 22, 2023 at 7:09 AM
Ooooof
Ok but hear me out
I think these are the babies so I’ll stick to my toad answer!
Ok but hear me out
I think these are the babies so I’ll stick to my toad answer!
I enjoy dynamite and gun powder and gasoline - pretty sure Eric Andre said that - LET ME IN
June 22, 2023 at 5:55 AM
I enjoy dynamite and gun powder and gasoline - pretty sure Eric Andre said that - LET ME IN
Building a custom data quality framework in Python
Gather metadata on a datalake - this code can give you file level information:
- Bytes
- File Location
- Dates
etc.
Curate this and use EDA to understand data assets over time--build expectations on upstream data sources.
Trust your Data!
Gather metadata on a datalake - this code can give you file level information:
- Bytes
- File Location
- Dates
etc.
Curate this and use EDA to understand data assets over time--build expectations on upstream data sources.
Trust your Data!
June 22, 2023 at 5:51 AM
Building a custom data quality framework in Python
Gather metadata on a datalake - this code can give you file level information:
- Bytes
- File Location
- Dates
etc.
Curate this and use EDA to understand data assets over time--build expectations on upstream data sources.
Trust your Data!
Gather metadata on a datalake - this code can give you file level information:
- Bytes
- File Location
- Dates
etc.
Curate this and use EDA to understand data assets over time--build expectations on upstream data sources.
Trust your Data!
I'm like a dog chasing cars - I wouldn't know what to do with one If I caught it
June 22, 2023 at 5:47 AM
I'm like a dog chasing cars - I wouldn't know what to do with one If I caught it
Coffee shop that closes at 10 pm in a rainstorm. Living my best 🍄 life.
@shutupchxrlotte.bsky.social
Yes there is oat milk involved
@shutupchxrlotte.bsky.social
Yes there is oat milk involved
June 22, 2023 at 12:48 AM
Coffee shop that closes at 10 pm in a rainstorm. Living my best 🍄 life.
@shutupchxrlotte.bsky.social
Yes there is oat milk involved
@shutupchxrlotte.bsky.social
Yes there is oat milk involved
Protocols
I want to create this Protocol class -> that has a characteristic
HasSound -> sound
Then I want to create a second thing (class)
Dog
That second thing, needs to share that characteristic whenever it is expected to adhere or is called upon by that protocol
I want to create this Protocol class -> that has a characteristic
HasSound -> sound
Then I want to create a second thing (class)
Dog
That second thing, needs to share that characteristic whenever it is expected to adhere or is called upon by that protocol
June 21, 2023 at 3:36 AM
Protocols
I want to create this Protocol class -> that has a characteristic
HasSound -> sound
Then I want to create a second thing (class)
Dog
That second thing, needs to share that characteristic whenever it is expected to adhere or is called upon by that protocol
I want to create this Protocol class -> that has a characteristic
HasSound -> sound
Then I want to create a second thing (class)
Dog
That second thing, needs to share that characteristic whenever it is expected to adhere or is called upon by that protocol