-
Notifications
You must be signed in to change notification settings - Fork 0
Open
Description
- Clicked on a link from your newsletter: https://sql-workbench.com/#config=%7B%22plugin%22%3A%22Y%20Bar%22%2C%22plugin_config%22%3A%7B%7D%2C%22title%22%3A%22Data%22%2C%22group_by%22%3A%5B%22local_time%22%5D%2C%22split_by%22%3A%5B%5D%2C%22columns%22%3A%5B%22temperature%22%5D%2C%22columns_config%22%3A%7B%7D%2C%22filter%22%3A%5B%5D%2C%22sort%22%3A%5B%5D%2C%22expressions%22%3A%7B%7D%2C%22aggregates%22%3A%7B%7D%7D&queries=v0,SELECT-unnest(hourly.time)%3A%3ATIMESTAMP-AS-local_time%2C-unnest(hourly.temperature_2m)-AS-temperature-FROM-read_json('https%3A%2F%2Fapi.open%20meteo.com%2Fv1%2Fforecast%3Flatitude%3D52.374%26longitude%3D4.8897%26hourly%3Dtemperature_2m%26forecast_days%3D3'%2C-auto_detect%3Dtrue)~
- "Hey this looks cool, can I use it with a different endpoint!" -> change the text in the SQL to:
SELECT * FROM read_json('http://environment.data.gov.uk/flood-monitoring/id/measures/SU89_82-level-groundwater-i-1_h-mAOD', auto_detect=true); - Press cmd-enter instinctively, pleased that it runs the command :)
- 🚨 The command runs, but I see see a Y-Axis label of
ERROR. No details of what the error is.
I managed to find out what was wrong eventually by clicking on configure, then click on Y-Bar to open up the list of types and switch it to Data grid
(the actual error is irrelevant - it's more that the error is hidden if in a non-datagrid view)
Metadata
Metadata
Assignees
Labels
No labels

