Ducklicious DuckDB Cookbook

Discover SQL recipes that tantalize your data taste buds. Explore and savor the rich flavors of DuckDB's data manipulation capabilities.

• DuckDB UNNEST: Preserving Rows with NULL and Empty Array

  How to preserve rows with NULL and empty array values during UNNEST operations.

• DuckDB: Generate Date Dimension Table

  Let's take a look into a DuckDB SQL query that generates a plethora of date-related metrics, allowing you to uncover hidden information within your date data.

• Query Google Sheets with DuckDB

  How to bridge the gap between your Google Sheets data and advanced querying capabilities through DuckDB SQL

• Calculate TF-IDF using DuckDB

  How to calculate Term Frequency-Inverse Document Frequency using DuckDB SQL

• Creating Correlation Matrix using DuckDB

  How to create Correlation Matrix using DuckDB SQL

• List Intersections in DuckDB: Finding Common Elements

  How to find common elements from list of lists

• Converting Bytes to Human-Readable Format in DuckDB

  Custom macro to handle the 1024-based conversion

• How to Compare Tables in DuckDB SQL

  How to check whether the tables are identical or what their differences may be.