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;
What am I missing?
A possible bug?