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:

Dialect: Qubole Presto.
Cluster Label: The cluster name from the Qubole Control Panel.
Database: Enter “hive”.
API Key: The Looker user’s authentication token. If you have enabled Persistent Derived Tables, enter the PDT user’s authentication token in the PDT Overrides column.
Persistent Derived Tables: Select this box to enable PDTs.
Temp Database: If PDTs are enabled, set this to a database/schema where the user has full privileges to create, drop, rename, and alter tables.

Qubole Quantum

Fill out the page as follows:

Dialect: Qubole Quantum.
Database: Enter “hive”.
API Key: The Looker user’s authentication token. If you have enabled Persistent Derived Tables, enter the PDT user’s authentication token in the PDT Overrides column.
Persistent Derived Tables: Select this box to enable PDTs.
Temp Database: If PDTs are enabled, set this to a database/schema where the user has full privileges to create, drop, rename, and alter tables.

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.