I have saved an SQL query as a question. This query returns eight columns (fields). I have then created a Simple Question using the saved question as a source. When I view or preview the data I see all eight columns. But when I select the Columns, Filter, Summarize or Sort options, only six of the columns are available. I have forced a sync and re-scan (via Admin->Databases) although I don’t think this is the problem.
The attached image demonstrates what I mean.
FWIW, the two columns that are not appearing are both numeric (INTEGER and DOUBLE) whereas all other columns are not. I have tried CASTing the integer column to varchar but it made no difference.
We are on v0.35.2 on Ubuntu connecting to PostgreSQL.
Thanks in advance.