Skip to main content

read_zarr_metadata

Inspect a Zarr array's structure without reading any chunk data.

Signature​

read_zarr_metadata(uri VARCHAR)

Output​

ColumnTypeDescription
array_shapeVARCHARFull array dimensions, e.g. [938, 73, 144].
chunk_shapeVARCHARChunk dimensions, e.g. [12, 73, 144].
data_typeVARCHARElement type, e.g. Float32.
crsVARCHARCoordinate reference system, e.g. EPSG:4326 (UNKNOWN if none is declared).

Example​

SELECT array_shape, chunk_shape, data_type, crs
FROM read_zarr_metadata('climate_data.zarr/air_temperature');
┌────────────────┬───────────────┬───────────┬───────────┐
│ array_shape │ chunk_shape │ data_type │ crs │
│ varchar │ varchar │ varchar │ varchar │
├────────────────┼───────────────┼───────────┼───────────┤
│ [938, 73, 144] │ [12, 73, 144] │ Float32 │ EPSG:4326 │
└────────────────┴───────────────┴───────────┴───────────┘

See also​