Skip to content

Error message not shown #24

@rmoff

Description

@rmoff
  1. 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)~
  2. "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);
  3. Press cmd-enter instinctively, pleased that it runs the command :)
  4. 🚨 The command runs, but I see see a Y-Axis label of ERROR. No details of what the error is.

Image

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

Image

(the actual error is irrelevant - it's more that the error is hidden if in a non-datagrid view)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions