H3 Query

Type: h3-query

Named SQL source from an H3 dataset query.

Supports children: Yes

Runs one GET /h3/query against an indexed H3 dataset, lands the Parquet result in DuckDB and exposes it as a named SQL source. Any SQL widget in reach of this node (the same node, or one connected by an edge) references the result via {{name}}; children are rendered as given. Every string or number prop accepts a $param reference ("$lat") or inline text ("$year-01-01"); the query waits until every referenced parameter has a value and re-runs when one changes. At most one spatial selector: cell, lat+lng, the four bounding box edges, or hexMin+hexMax; none reads the whole dataset.

Example

{
  "type": "h3-query",
  "props": {
    "name": "era5_cells",
    "path": "s3://fused-asset/data/era5/daily/",
    "minLng": -122.6, "minLat": 37.6, "maxLng": -122.2, "maxLat": 37.9,
    "timeMin": "$date_min", "timeMax": "$date_max",
    "columns": ["hex", "date", "t2m"]
  },
  "children": [
    { "type": "sql-table", "props": { "sql": "SELECT hex, AVG(t2m) AS t2m FROM {{era5_cells}} GROUP BY 1" } }
  ]
}

Every widget is defined as { "type": "h3-query", "props": { ... } }. The properties below describe the props object.

Props

Loading ....

Raw schema

Download the full schema file: /widget-schema/h3-query.json