Local Innovation
How to pull DuckDB SQL using Observable and DuckDB in Observable
Our data source - US-2020-17schema.duckdb
Converted to .parquet files in Observable Desktop by Kelly Yiou Xie
Notes
.duckdb extension is not supported for US-2020-17schema.duckdb
Error: unknown file type: application/octet-stream (.duckdb)
DuckDB is generally faster than Pandas for executing SQL queries on large datasets because DuckDB is an in-memory analytical database designed for speed and efficiency.
Change table names to end with US where XX appears in yaml.