Deepnote
You can use Deepnote to explore data in Dremio Cloud with Python and SQL.
Supported Authentication Method
Use a personal access token (PAT) obtained from Dremio Cloud. To create a PAT, follow the steps in the section Creating a Token.
Creating an Integration with Dremio Cloud
- After logging into Deepnote, click Integrations on the left.
- Scroll down to Create new integration.
- Under Data warehouses & lakes, click Dremio.
- Specify a name for the integration.
- In the Host name field, specify either
data.dremio.cloud
(Dremio's US control plane) ordata.eu.dremio.cloud
(Dremio's European control plane). - In the Port field, specify the number 443.
- (Optional) In the Schema field, specify the database schema to use by default when a schema is not given in a query.
- In the Token field, paste the PAT that you obtained from Dremio Cloud.
- Click Create integration.
note
Do not toggle on the Use SSH switch. Dremio integrations do not support SSH tunnels.
Deepnote gives you the option of associating the integration with a project immediately. If you click Skip, the integration is listed under Workspace integrations on the Integrations page.