WITH MEASUREMENTS clause returns no results when named measurement is clearly there

[smartcasa]

I can’t figure out why my “WITH MEASUREMENT” clause is not working.

Very simple example:
This works:
SHOW MEASUREMENTS

When I add filter I get no results
SHOW MEASUREMENTS WITH MEASUREMENT = "binary_sensor"

I tried a regex filter and still no luck
SHOW MEASUREMENTS WITH MEASUREMENT =~ /binary.*/

I’m using the web based Data Explorer tool on cloud2.influxdata.com. I tried the same query from a Grafana visualization editor and got the same results (data shows with no filter, but adding a filter yields no results).

I’m trying to make the switch from Flux to InfluxQL since they are dropping long term support for flux.

TIA

[suyash]

Can you just query it directly to check if data is there: SELECT * FROM "binary_sensor" LIMIT 1

[smartcasa]

That does return data, yes.

According the examples and according to the data explorer “Measurement” options (screenshot below), I should get one record. I eventually want to use regex to explore my schema but figured I’d test with a simple measurement name I know for a fact is there…and yet, I’m not getting the one expected result. I dug into this for hours and I’m pretty familiar (apparently not enough though) w influx, but this one has me stumped.

Any obvious misses?

TIA