Hey!
I´m trying to use postgres materialized views with Grafana and it works just fine if I input all the table names manually but I don’t get the powerful autocomplete functionality.
Looking at the documentation this might be caused by the view not being in the search_path, but from what I can tell it should be?
I’m running grafana v7.1.3 and Postgres 10
Other tables/columns autocomplete just fine.
My view definition:
CREATE MATERIALIZED VIEW public.new_mview
TABLESPACE pg_default
AS
SELECT now() AS timestamp, 100 as valueColoumn
WITH DATA;
show search_path;
"$user", public
What am I missing?
A possible bug?