About the Simba Presto JDBC Connector

About Presto

Presto is a low latency distributed query engine capable of querying large datasets from multiple data sources using SQL.

The data sources that Presto supports include MySQL and PostgreSQL. Presto also integrates with the Hive metastore seamlessly to complement existing Hive environments with low latency queries. Presto can query self-describing data as well as complex or multi-structured data that is commonly seen in big data systems.

Note:

For information about connecting Presto to data sources, see the Presto documentation: https://prestodb.io/docs/current/.

About the Connector

The Simba Presto JDBC Connector lets organizations connect their BI tools to Presto. Presto provides an ANSI SQL query layer and also exposes the metadata information through an ANSI SQL standard metadata database called INFORMATION_SCHEMA. The Simba Presto JDBC Connector leverages INFORMATION_SCHEMA to expose Presto's metadata to BI tools as needed.

The Simba Presto JDBC Connector complies with the JDBC 4.1 and 4.2 data standards. JDBC is one of the most established and widely supported APIs for connecting to and working with databases. At the heart of the technology is the JDBC connector, which connects an application to the database. For more information about JDBC, see Data Access Standards on the Simba Technologies website: https://www.simba.com/resources/data-access-standards-glossary.

This guide is suitable for users who want to access data residing within Presto from their desktop environment. Application developers might also find the information helpful. Refer to your application for details on connecting via JDBC.