midjnr.blogg.se

When paired with the CData JDBC Driver, customers can use Databricks to perform data engineering and data science on live Google Drive data.

This article walks through hosting the CData JDBC Driver in AWS, as well as connecting to and processing live Google Drive data in Databricks. With built-in optimized data processing, the CData JDBC Driver offers unmatched performance for interacting with live Google Drive data.

When you issue complex SQL queries to Google Drive, the driver pushes supported SQL operations, like filters and aggregations, directly to Google Drive and utilizes the embedded SQL engine to process unsupported operations client-side (often SQL functions and JOIN operations). Install the CData JDBC Driver in Databricks Its built-in dynamic metadata querying allows you to work with and analyze Google Drive data using native data types.