User Guide Getting Started Help Center Documentation Community Training
Looker
  
English
Français
Deutsch
日本語
Qubole Presto and Qubole Quantum

Version Support

Presto v0.157 and later versions are currently available and well supported.

Presto Cluster Settings

The following Presto settings should be configured in Qubole console:

catalog/hive.properties: hive.metastore-cache-ttl = 0s hive.metastore-refresh-interval = 5s hive.allow-rename-table=true hive.allow-drop-table=true hive.parquet.use-column-names=true hive.storage-format=ORC

Looker Setup

In the Admin section of Looker, navigate to the Connections page and click New Connection.

Qubole Presto on AWS and GCP

As of Looker 7.0, the Qubole JDBC driver Looker uses to connect with Qubole Presto is on version 2.2.X, which provides support for Qubole Presto hosted on GCP.

Fill out the page as follows:

Qubole Quantum

As of Looker 6.16, Qubole Presto Serverless has been rebranded as Qubole Quantum.

Fill out the page as follows:

For more information about connection settings, see the Connecting Looker to Your Database documentation page.

Qubole Endpoints

By default, the Qubole connections are made to api.qubole.com. Find the appropriate value in Supported Qubole Endpoints for your cloud provider and the geographic region in which your Qubole database is deployed.

Add the parameter endpoint=url_of_endpoint in the Additional Params field of the Connection Settings:

  1. For AWS in the US: endpoint=https://us.qubole.com
  2. For GCP in the US: endpoint=https://gcp.qubole.com

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, Qubole Presto on AWS supports the following Looker features:

In the current Looker release, Qubole Presto on GCP supports the following Looker features:

In the current Looker release, Qubole Quantum supports the following Looker features:

Next Steps

After you have connected your database to Looker, you’re ready to configure sign-in options for your users.

Top