I’m a newbie and I’m starting to learn SQL so I’m not very technical nor experienced, so please excuse my lack of professional lingo
I’ve created a View in my database (we use postgresql) because I need some complex joins among my tables in order to get my point.
My plan is to use such View as default table to build Queries with the “visual builder” since I need other non-technical users to create questions, slicing/dicing data in order to have few easy charts.
Unfortunately I can’t see my view in the list of tables, but if I enter the sql editor and run a select from it I get all my data back!
What am I doing wrong? Maybe it’s not possible to use views as input for the query builder?
We are using MB 0.29.3 with PostgreSQL 9.4. We have tried creating Materialized Views and Views in our schema and have re-synced the schema several times. We have also saved the database definition after syncing. The tables in the schema do appear in the Questions drop down and new tables seem appear without the need to sync but views do not show up in the drop down regardless of syncing. Any ideas what we else we should be doing to work with views in PostgreSQL.
Have you checked that the Postgres user that Metabase using can access the View? Which version of Metabase and Postgres? Depending on the size of your database, it might take several minutes to sync - and sometimes you might need to refresh the browser to get an updated listing.