Issue
Unable to see system tables from the schema "oracle_transportation_management" from Tableau Desktop but custom SQL pulls data from the table.
Last Modified Date: 28 Oct 2020
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.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