Catalog Function Support
The Simba Amazon Redshift JDBC Driver supports catalog functions such as getSchemas, getTables, and getColumns to return data in result sets.
However, be aware that the connector's behavior differs from the standard JDBC specifications when using an empty string in catalog, schemaPattern, tableNamePattern, or columnNamePattern for any catalog functions.
For example, when an empty string is used in schemaPattern, it is supposed to retrieve data without a schema. The connector treats empty strings as NULL, meaning that the schema name is not used to narrow the search. Therefore, the same results are returned whether an empty string or NULL is used.