chronograf data explore error with request failed with status code 400

The chronograf is succefully connected to influxdb.In the chronograf data explore windows, with the query “select * from h2o_feet ON NOAA_water_database”, it return “request failed with status code 400”.

that’s the wrong syntax…

select * from NOAA_water_database..h2o_feet
select * from NOAA_water_database.autogen.h2o_feet

the from clause is <database>.<retention_policy>.<measurement>
if you leave out the retention_policy by using .. it will use the “default” one.

It is a best practice to provide a “where time” clause as well. In this case, you might use:
where time > now() - 3y