Last Modified Date: 17 Oct 2022
Environment
- Tableau Desktop
- PostgreSQL 9.3
Resolution
Use 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.
Cause
Tableau 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
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials