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.

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

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

Fill out the page as follows:

Qubole Quantum

Fill out the page as follows:

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

Attaching to an Alternate Service Endpoint

By default, the Qubole connections are made to api.qubole.com. Qubole operates some additional endpoints such as us.qubole.com. If you need to connect to a cluster hosted on an alternate endpoint, you can specify it in the Additional Params field of the Connection Settings screen. Use the parameter endpoint=url_of_alternate_endpoint to specify it.

For example, if you host in AWS in the US:

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 and Qubole Quantum v0.157+ 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