Guides & tutorials
Practical Parquet guides
Reproducible guides for opening, inspecting, querying, and converting Parquet, plus source-backed tutorials on DuckDB, AI data checks, pipelines, and GeoParquet.
12 articles
A field guide to grounding generated SQL in the real Parquet schema, DuckDB dialect, read-only code gates, privacy controls, and reviewable evidence.
A hands-on guide to separating wrong bytes, missing footers, damaged pages, reader incompatibility, remote access failures, and browser memory limits.
Query Parquet on AWS S3, Cloudflare R2, GCS, or MinIO without proxying object data through viewparquet. Compatible endpoints can use range reads, and credentials stay in the browser.
Explore 11 freely downloadable public Parquet samples for analytics, NLP, GeoParquet, and reader tests, with a JSON catalog and verification method last run June 12, 2026.
View-based loading avoids a full upfront copy when opening Parquet in the browser. Learn how row groups, pushdown, codecs, browser and WASM memory, and query shape affect what works in practice.
A reproducible DuckDB field guide with intentionally broken Parquet fixtures, observed results, and release checks for schemas, splits, tokens, provenance, and embeddings.
Two valid Parquet artifacts can still form a broken release. Build reliable AI handoffs with exact inputs, executable contracts, lineage manifests, committed pointers, and rollback.
Design Parquet pipelines from measured workloads: choose partitions, files, row groups, and codecs; gate schema drift; compact safely; and publish immutable manifests.
Query raw OSM PBF with DuckDB, convert filtered features with the current QuackOSM API, validate GeoParquet, and calculate distance and area in correct units.
Turn analytical GeoParquet into bounded GeoJSON or tiled PMTiles delivery, with runnable MapLibre examples, a correct protocol registration, and measurable limits.
A native DuckDB workflow for GeoParquet: inspect WKB versus GEOMETRY, validate metadata, filter by extent, calculate in correct units, and verify query plans.
A version-aware GeoParquet guide covering stable 1.1, the 2.0 release candidate, WKB and native geometry types, CRS metadata, validation, and distribution.