Working with files
Connecting to data sources
Coding and analysis tools
Security and privacy
Deepnote for education
Available on Enterprise plan
With the Dremio integration, you can leverage the capabilities of Deepnote's SQL blocks to query your Dremio instances at ludicrous speed.
Deepnote's Dremio integration allows data teams to efficiently query their data, extract relevant data, and start analyzing and modeling in the comfort of their known notebook environment. In addition, switching between Dremio and other distributed SQL engines won't require you to rewrite any SQL statements; all that's needed is switching the SQL block's assigned integration.
How to connect to Dremio
To create the integration, you'll need a few things:
- Hostname: The hostname of the server you are trying to connect to.
data.dremio.cloudfor the US control plane,
data.eu.dremio.cloudfor the European control plane.
- Port: The port on the server of interest you are trying to connect to. The default port is 443.
- Schema: Database schema to use by default when a schema is not specified in a query. However, this does not prevent queries from being issued for other schemas. Such queries must explicitly include the schema.
- Token: Personal access token to use when authenticating to Dremio. See Dremio's docs for more details.
At the moment this integration only supports connecting to Dremio Cloud, and not to Dremio Software.
How to use
Once created, you'll be able to connect the Dremio integration to any project within your workspace through the right-hand sidebar. The Dremio integration comes with custom Dremio blocks that help streamline your analytics efforts. You can also convert any existing SQL block to a Dremio block.
As with all SQL blocks, the query results will be saved as a Pandas DataFrame and stored in the variable specified in the SQL block.
Jump right into Deepnote & learn more about SQL blocks in this A/B testing template. You can also save yourself some setup work by hitting the
Duplicate button in the top-right corner to start exploring on your own!
Still need help? Deepnote's community of over 5,000 data enthusiasts and professionals is always there for you. Post any questions into the Q&A channel here.
Deepnote supports securing connections to Dremio via optional SSH tunnels. The Dremio integration always connects via SSL.