KNOWLEDGE BASE

Unable To See System Tables From A Schema On Tableau Desktop


Published: 15 Oct 2020
Last Modified Date: 28 Oct 2020

Issue

Unable to see system tables from the schema "oracle_transportation_management" from Tableau Desktop but custom SQL pulls data from the table.
 

Environment

  • Tableau Desktop
  • Hortonworks Hadoop Hive and other databases

Resolution

Option 1

Use custom SQL to load the data.

Option 2

Create a view in the data source to make the data available avoiding querying the system table directly.
 

Cause

The system table is often not displayed by design.
 
Did this article resolve the issue?