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?