Catalog and Schema Support

The Simba Apache Spark JDBC Connector supports both catalogs and schemas to make it easy for the connector to work with various JDBC applications. Since Spark only organizes tables into schemas/databases, the connector provides a synthetic catalog named SPARK under which all of the schemas/databases are organized. The connector also maps the JDBC schema to the Spark schema/database.

Note:

The synthetic SPARK catalog only applies to servers that do not support multiple catalogs. For servers that do, the connector returns their catalogs as is.

Note:

Setting the CatalogSchemaSwitch connection property to 1 will cause Spark catalogs to be treated as schemas in the connector as a restriction for filtering.