On this page

    Connecting from Apache Superset or Preset to Dremio Cloud

    You can use Superset or Preset, a cloud service for Superset, to query and visualize data by means of Dremio Cloud.

    Supported Versions of Superset

    Dremio Cloud supports Superset 1.0 and later.

    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

    Creating a Connection

    1. In Superset or Preset, select Data > Databases in the menu bar at the top of the screen.

    2. Click the Database button in the top-right corner of the screen.

    3. In the Connect a Database dialog, select Dremio from the Supported Databases field.

    4. In the SQLALCHEMY URI field, specify a URI that in either of these formats:

      • 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, use a URI that is in this format:

        dremio://<username>:<password>@sql.dremio.cloud:443/<project-ID>;SSL=1
        
      • If you want to authenticate by using a personal access token, use a URI that is in this format:

        dremio://$token:<personal-access-token>@sql.dremio.cloud:443/<project-ID>;SSL=1
        
    5. Test the connection. If the test fails, check the syntax and values in the connection URI.

    6. Click Connect.