I have a database with 5 tables connected. Querying "Show tables;" also reveals all 5 tables. However, in the data view there are only 4 tables shown, and when trying to pick data for a Question, I can only use those 4. What's wrong here??
Please see attached how the table "installations" is completely missing from the data view.
Solved, and probably interesting for others: It was indeed active/queryable in Admin > Data Model, just like the other tables, but still not showing up in the main view. Then I clicked on it and went Settings > "Re-scan this table" .. afterwards it appeared everywhere.