Resources for working with SQL in Observable

Ian Johnson

Observable

Working with SQL

Custom database clients for use with Observable SQL cells.

Database Clients

Play the Knightlab's SQL Murder Mystery game to sharpen your data analysis skills with SQL and the Observable Data Table

SQL Mystery Game

Curated datasets

Shan Carter

SQL + Chart

Mike Freeman

Arrays as SQL

Convert CSV to Parquet

In some cases (such as a column with contents like "00", "01", "02", "2A"), we might want to pass options to https://duckdb.org/2021/10/29/duckdb-wasm.html so that the column is not defined as integer but string.

See https://github.com/duckdb/duckdb-wasm/issues/1066#issuecomment-1318328657