Configuring Looker with QDS

Configure Looker

Follow the instructions below to configure Looker:

  1. After Looker instance or server is ready, log in to your Looker server.

  2. Click Admin and the General Settings page appears.

    ../../../_images/LookerAdmin.png

  3. From the navigation pane on the left, click Connections under the Database section. The Connections page appears.

    ../../../_images/DatabaseConnections.png

  4. On the Connections page, click the New Connection button at the top-left of the page. The Connection Settings page appears.

    ../../../_images/NewDBConnection.png

    • For the new connection:

      1. Enter a name for the connection in the Name field.

      2. Select the appropriate Qubole Presto cluster version from the Dialect dropdown list.

        Note

        To know the Qubole Presto cluster version, navigate to Clusters page and click Edit against the Presto cluster that you want to use. You can now check the Presto Version in the Configurations tab.

      3. Skip Serverless Qubole check box as Serverless Qubole is currently unavailable.

      4. Enter the Qubole cluster label name in the Cluster Label field.

      5. Enter hive in the Database field.

      6. Enter the API token in the API key field. You can find the API Token from QDS (Control Panel > My Accounts > click Show under the API Token column and copy it). To know more, see Managing Your Accounts.

      7. Enter the database or schema name from Qubole in the Schema field (for example, tpcds_orc_1000).

        Note

        In JDBC and ODBC driver configurations, https://api.qubole.com is the default endpoint.

      8. If the Qubole account is on some other Qubole environment or URL, enter the Additional Params with endpoint=<Qubole URL>. The endpoint represents the Qubole environment that you will connect to.

        ../../../_images/AdditionalParams.png

        Note

        To save the tables that Looker fetches from Qubole, select the Persistent Derived Tables check box in Looker and fill in the Temp Database.

        ../../../_images/PersistentDerivedTables.png

  5. Click Test These Settings to verify the connection. A Testing… message appears while Looker tries to run a query on Qubole to verify the connection.

You have successfully completed the configuration and a success message appears.

../../../_images/ConnectionSuccess.png

Troubleshooting Qubole-Looker Integration Issues

Symptom: Connection refused

../../../_images/CommonConnectionError.png

Cause:

  • API Token is wrong
  • User account is not on the given environment and you have not added endpoint=<Qubole_URL> in the Additional Params field.

Remedy:

  • Verify the correctness of the API token.
  • Add the Qubole environment in the Additional Params field. For more information, see step 4 of Configure Looker.