5 Replies Latest reply on Jan 20, 2014 4:58 AM by Neil Murray

    How can I create a connection to a specific schema in Vertica when I have access to multiple?

    Tony Kelly

      I have access to multiple schemas in a Vertica DB.  When I use the Tableau (8.0) Data Connection UI, the tables are listed alphabetically overall, not grouped by schema.  Without having to manually find all the tables in a schema via the multiple tables option, how can I create a connection that selects all the tables in one schema?  Do I need to write custom SQL?  If so, does someone have a sample / template I can use?

       

      How about if I want tables from 2 or 3 schemas (but still not all)?  Is there a way to sort / group tables within schema and filter down to certain schemas?