JDBC Driver Use in Okera¶
Okera uses JDBC drivers to:
- Pull data from an external JDBC datasource for display in Okera.
- Push data from Okera to the end user after Okera policies have been applied.
Separate JDBC drivers are used for these functions. Okera interacts with JDBC drivers in three ways:
You can connect an external data source to Okera using a JDBC driver in a JDBC connection. These are the JDBC drivers described in Connecting to Okera via ODBC/JDBC Clients, Advanced Querying of JDBC Data Sources, and the custom JDBC drivers described in Custom JDBC Source Support. They are used by Okera to pull data from the external JDBC-connected data source (such as MySQL, Snowflake, or Amazon Redshift) for display in Okera.
Okera ships with its own Presto-based JDBC driver. This driver is used to push data from Okera to the end user after Okera policies have been applied.
The JDBC drivers provided in your external query engine platforms (such as Databricks, Spark, or Hive) can continue to be used by Okera to push data from Okera to the end user in those environments after Okera policies have been applied.