the DuckDB spatial extension did not load ({...

Warnings reference › source.duckdb.spatial.load

Identifier

source.duckdb.spatial.load

Raised by

The grid (core)

Since

1.73.0

What happened

LOAD spatial failed on this connection - on DuckDB-Wasm usually because extensions.duckdb.org could not be fetched. The adapter withdraws the spatial operators and buckets from its capabilities, so the pushdown source leaves the operators to the grid (with compute passed to createPushdownSource) and a bucket in source.aggregate() goes to the client. Sorting by the geometry column is refused rather than ordered by WKB bytes.

The fix

Make the extension repository reachable (or preinstall the extension on a server), or accept in-browser evaluation for this connection.

The smallest fix

const source = createPushdownSource({ adapter: duckdbAdapter({ connection, from, spatial: true }), compute: { evaluateFilters, sortMulti } });

Reference

Covered in full at the API reference.