{"dataset": "weather", "table": "observations", "primary_key": "id", "columns": [{"name": "id", "type": "bigint(20)", "nullable": false}, {"name": "observed_at", "type": "timestamp /* mariadb-5.3 */", "nullable": true}, {"name": "observed_epoch", "type": "int(11)", "nullable": true}, {"name": "wet_bulb_c", "type": "decimal(10,1)", "nullable": true}, {"name": "black_globe_c", "type": "decimal(10,1)", "nullable": true}, {"name": "air_temp_c", "type": "decimal(10,1)", "nullable": true}, {"name": "humidity_pct", "type": "decimal(10,1)", "nullable": true}, {"name": "latitude", "type": "decimal(9,6)", "nullable": false}, {"name": "longitude", "type": "decimal(9,6)", "nullable": false}, {"name": "device_name", "type": "text", "nullable": false}, {"name": "synced_at", "type": "timestamp", "nullable": false}], "filterable": ["device_name", "observed_epoch"], "sortable": ["id", "observed_epoch"], "default_order": "id", "operators": ["eq", "ne", "lt", "lte", "gt", "gte", "in", "prefix", "isnull", "between"], "max_page_size": 1000, "max_offset": 10000, "stats": {"rows": 543947, "observed_min": "2025-04-23 18:06:53", "observed_max": "2026-11-08 04:59:00"}}