Using Pass-Through Introspection with Vertica Data Source Clients
When Introspect as Pass-Through Following DDL is enabled on a Vertica data source, tables created in the data source using the DDL feature are created using the same pass-through user that submitted the DDL. Enabling this will make introspection ignore the saved credential if the DDL was issued by a pass-through user.
To set pass-through optimization for Vertica data source clients
1. Log into Studio as the admin user.
2. From the Administration menu, choose Configuration.
3. In the tree pane, navigate to Configuration > Data Sources > Vertica Sources.
4. Select true, to enable introspection as a pass-through user.
5. Click Apply.
6. Click OK.
7. Restart the TDV Server to implement any changes you have made.