Loading

PostgreSQL Materialized Views Do Not Appear in Table List

Дата публикации: Mar 25, 2026
Описание

When connecting to a PostgreSQL database from Tableau Desktop, materialized views do not appear in the list of available tables.
 

Cause

Tableau Desktop does not have access to the PostgreSQL system table which records information about materialized views.
 

Решение

Use one of the following three options to access materialized views:
 

Option 1

Use a custom SQL connection. For example: 

SELECT <col1>, <col2> FROM <materializedView>

Or:

SELECT * FROM <materializedView>

 

Option 2

Create a dynamic view of the materialized view.

 

Option 3

Create a table and use rules to rebuild the data from the materialized view.

 

Note: Dynamic views may have the slowest performance as PostgreSQL must rebuild the view for each query.

Номер статьи базы знаний

001474099

 
Загрузка
Salesforce Help | Article