Hi, I want to query the underlying information_schema for my postgres database(s). This doesnt work diretly as Dremio doesn’t actually list the information_schema. All good, makes sense but I created a “pgschema” database and then created a view “v_pg_tables” on the underlying “information_schema.tables” table. Once Dremio refreshed the source I got the listing for the view but on trying to run a query I get “Selected Table has no columns”?
Build : 3.2.8-201907180222520740-08f2b54
Edition : Community Edition
Restarted Dremio but it didnt help.