---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github/duckdb/community-extensions repository, check README there
title: duckdb_zarr
excerpt: |
  DuckDB Community Extensions
  Explore Zarr stores with SQL through relational metadata, chunk discovery, and dense cell scans

extension:
  name: duckdb_zarr
  description: Explore Zarr stores with SQL through relational metadata, chunk discovery, and dense cell scans
  version: 0.0.2
  language: C++
  build: cmake
  license: MIT
  maintainers:
    - d33bs

repo:
  github: wayscience/duckdb_zarr
  ref: a4113ed729ea8896987427ef81b2d9cd16ee81cb

docs:
  hello_world: |
    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');
  extended_description: |
    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.

extension_star_count: 7
extension_star_count_pretty: 7
extension_download_count: 739
extension_download_count_pretty: 739
image: '/images/community_extensions/social_preview/preview_community_extension_duckdb_zarr.png'
layout: community_extension_doc
---

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}

### Added Functions

<div class="extension_functions_table"></div>

| 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

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

This extension does not add any settings.