KNOWLEDGE BASE

TP - PostgreSQL JDBC Driver Limits Number of Tables to 16384


Published: 02 Aug 2022
Last Modified Date: 02 Aug 2022

Issue

The list of tables when connecting to a PostgreSQL database does not show all the tables available when more than 16384 tables exist.  In addition, the search tool does not have access to all the tables. 

Environment

  • Tableau Prep Builder 2022.1.2 and higher
  • PostgreSQL JDBC

Resolution

Use custom SQL.

Create a custom SQL query to fetch the data from the table that is not showing in Tableau.  The exact table name will need to be leveraged.  
 

Cause

This behavior is related to an issue with Known Issue ID 1439910, which is currently under investigation.
Did this article resolve the issue?