KNOWLEDGE BASE

Vertica Database Tables Not Visible on Data Source Tab in Tableau Desktop


Published: 09 Jan 2018
Last Modified Date: 09 Jan 2018

Issue

When access to system tables in a Vertica database is restricted, no tables are visible on the Data Source tab in Tableau Desktop

Environment

  • Tableau Desktop
  • Vertica 7.2 and newer

Resolution

Carry out the following procedure:
1. Verify that the user has access to the desired tables, e.g.: 
GRANT SELECT ON ALL TABLES IN SCHEMA public to <user>; 

2. Grant the user access to the all_tables system table: 
GRANT SELECT ON TABLE all_tables to <user>; 

Cause

The Vertica user requires access to the all_tables system table in order to view tables in Tableau Desktop.
Did this article resolve the issue?