The stored procedure
LIST_JDBC_DATASOURCE_TABLES returns the tables and views on the underlying database of a JDBC data source.
In combination with the procedure GENERATE_VQL_TO_CREATE_JDBC_BASE_VIEW, you can automate the process of having a base view for all the tables/views of a source database.
LIST_JDBC_DATASOURCE_TABLES( data_source_name : text )
data_source_name: name of the data source for which you would like to get the list of tables.
The procedure returns one row for each table/view in the underlying database of the JDBC data source:
catalog_name: name of the catalog of given table.
schema_name: name of the schema of given table.
table_name: name of the given table.
type: type of catalog of given table.
The user needs to be the owner of the data source or have read privileges over the database of the data source.