home User Guide Getting Started Help Center Documentation Community Training Certification
menu
close
settings
Looker keyboard_arrow_down
language keyboard_arrow_down
English
Français
Deutsch
日本語
search
print
Qubole Presto and 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 settings

In the Admin section of Looker, select Connections, and then select New Connection.

Qubole Presto

The Qubole JDBC driver that Looker uses to connect with Qubole Presto is on version 2.2.X, which provides support for Qubole Presto on GCP, AWS, and Microsoft Azure.

In the Admin section of Looker, select Connections, and then select New Connection. Fill out the connection details (see the Connecting Looker to your database documentation page for more information):

Qubole Quantum

Qubole Presto Serverless has been rebranded as Qubole Quantum.

In the Admin section of Looker, select Connections, and then select New Connection. Fill out the connection details (see the Connecting Looker to your database documentation page for more information):

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
  3. For Azure in the US: endpoint=https://azure.qubole.com

Feature support

For Looker to support some features, your database dialect must also support them.

In Looker 21.16, Qubole Presto supports the following Looker features:

In Looker 21.16, Qubole Quantum supports the following Looker features:

Next steps

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

Top