Henry I think your best option is to contact customer support for this one.
I am having the same issue. Were you ale to get an answer to your question?
I'm also having this issue - anyone found a more elegant answer?
Hi - I contacted support, and here is what they said (below). They also said they were requesting a feature around this.
Our solution is to create a new schema that has views of the materialized views.
To access the materialized views, there are three options:
- Use Tableau Desktop's custom SQL connection to build a connection to the materialized view.
SELECT * FROM <materializedView>
SELECT <col1>, <col2> FROM <materializedView
If using the custom SQL, you can create a Tableau Server data source to allow other users to access the connection or a Tableau Data Source file to share with other Tableau Desktop users.
- Create a dynamic view of the materialized view.
- Create a table and use rules to rebuild the data from the materialized view SQL.
Note: Dynamic views may have the slowest performance, as Postgres must rebuild the view for each query.