Search Shortcut cmd + k | ctrl + k
duckdb_zarr
Downloads 12this week
GitHub stars 0
Extension repository on GitHub
Extension descriptor (YAML)

Explore Zarr stores with SQL through relational metadata, chunk discovery, and dense cell scans

Maintainer(s): d33bs

Installing and Loading 

INSTALL duckdb_zarr FROM community;
LOAD duckdb_zarr;

Example 

INSTALL duckdb_zarr FROM community;
LOAD duckdb_zarr;

SELECT * FROM zarr_groups('test/data/simple_v2.zarr');
SELECT * FROM zarr_arrays('test/data/simple_v2.zarr');
SELECT * FROM zarr_chunks('test/data/simple_v2.zarr');
SELECT * FROM zarr('test/data/simple_v2.zarr', 'temperature');

About duckdb_zarr

The duckdb_zarr extension exposes Zarr stores through DuckDB table functions.

Current coverage includes:

  • store discovery for local Zarr v2 and v3 layouts
  • consolidated metadata support for remote http://, https://, and s3:// stores
  • group, array, and chunk enumeration with zarr_groups(), zarr_arrays(), and zarr_chunks()
  • dense numeric cell scans with zarr_cells() and the zarr() convenience alias

This makes it practical to inspect Zarr metadata and query supported dense arrays with SQL directly inside DuckDB.

Added Functions

function_name function_type description comment examples
zarr table NULL NULL  
zarr_arrays table NULL NULL  
zarr_cells table NULL NULL  
zarr_chunks table NULL NULL  
zarr_groups table NULL NULL  

Overloaded Functions

| function_name | function_type | description | comment | examples | |—————|—————|————-|———|———-|

Added Types

| type_name | type_size | logical_type | type_category | internal | |———–|———-:|————–|—————|———-|

Added Settings

| name | description | input_type | scope | aliases | |——|————-|————|——-|———|