Last Modified Date: 31 May 2018
- Tableau Desktop
- PostgreSQL 9.3
ResolutionUse one of the following three options to access materialized views:
- Use a custom SQL connection. For example:
SELECT <col1>, <col2> FROM <materializedView>Or:
SELECT * FROM <materializedView>
- Create a dynamic view of the materialized view.
- Create a table and use rules to rebuild the data from the materialized view.
CauseTableau Desktop does not have access to the Postgres system table which records information about materialized views.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials