Connecting from Apache Superset or Preset to 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.
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.
If you installed Superset according to the instructions for installing from scratch, install the Dremio SQLAlchemy Connector on the system or in the VM where Apache Superset is running. Instructions are in the sqlalchemy_dremio repository in GitHub.
Copy the ID of the 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 when you specify the connection URI.
Creating a Connection
In Superset or Preset, select Data > Databases in the menu bar at the top of the screen.
Click the Database button in the top-right corner of the screen.
In the Connect a Database dialog, select Dremio from the Supported Databases field.
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:
If you want to authenticate by using a personal access token, use a URI that is in this format:
Test the connection. If the test fails, check the syntax and values in the connection URI.