On this page

    Connecting from Looker to Dremio Cloud

    You can use Looker to query and visualize data by means of Dremio Cloud.

    Supported Authentication Methods

    There are two methods of authenticating that you can choose from when you connect to Dremio Cloud from Apache Superset or Preset:

    • Use Microsoft Azure Active Directory as an enterprise identity provider
      To configure Microsoft Azure Active Directory, see Microsoft Azure Active Directory.

      note:

      You can use Microsoft authentication only if the admin for your Dremio Cloud organization has enabled it.

    • Use a personal access token (PAT) obtained from Dremio Cloud
      To create a PAT, follow the steps in the section Creating a Token.

    Prerequisites

    Copy the ID of the Dremio Cloud project that you want to connect to. See Obtaining the ID of a Project for the steps. After you obtain it, save it somewhere that you can retrieve it from during the procedure.

    Creating a Connection

    1. Log into Looker.

    2. In the menu bar at the top of the page, select Admin, and then select Connections under Database.

    3. Click the Add Connection button in the top-right corner of the page to open the Connection Settings page for creating a connection.

    4. Specify a name for the connection.

    5. In the Dialect field, select Dremio 11+.

    6. In the Remote Host:Port fields, specify sql.dremio.cloud and 443.

    7. In the Database field, paste the ID of the project that you want to connect to in Dremio Cloud.

    8. In the Username and Password fields, specify your authentication credentials:

      • If you want to authenticate by using a Microsoft account and password, and Microsoft Azure Active Directory is configured as an enterprise identity provider for Dremio Cloud, specify the username and password for the account.

      • If you want to authenticate by using a personal access token, specify these values:

        • In the Username field, type $token.
        • In the Password field, paste your personal access token.
    9. Ensure that the SSL check box is selected.

    10. Click Test These Settings at the bottom of the page to check that the information that you specified is all valid.

    11. Click Add Connection if the test of the connection is successful.

    The new connection is listed on the Connections page.