Table info in schema browser, automated connection testing, SSH tunnel integration & schema browser for Dremio
Table info in schema browser
It’s officially even easier to find the dataset you’re after. Now you can view key information about any table directly from Deepnote’s schema browser.
If you’re a Snowflake, BigQuery, Amazon Redshift, or PostgreSQL user, you can simply click on a table in the schema browser and switch to the Table info tab to see metadata sourced directly from your data warehouse or database. This includes description (if present), date of last change, date of creation, and table size.
No more leaving the comfort of your notebook to make sure you’re working with the right data.
Read more on our schema browser here →
Automated connection testing
Deepnote is making it easier to get your integrations up and running correctly. Next time you create or edit a data warehouse or database integration, we’ll automatically test the connection for you.
Accidentally set up an integration with the wrong credentials? No need to ask an admin for a fix. We’ll make sure all integrations are set up and working as intended. If there are any connection problems, we’ll highlight the issues.
SSH tunnel integration
Need to connect to a resource in a private network? We’ve got you covered. Our new SSH tunnel integration makes it easy to securely connect to all the tools in your stack.
Simply create an SSH tunnel integration from the Integrations section in the right-hand sidebar and connect it to your project. Deepnote will generate a key pair for your workspace and provide a public key for you to add to your server.
Your SSH tunnel will start up in the background and display the host and port you can use to access your data. Easily connect to any service behind a firewall, from experiment tracking tools and feature stores to databases without native integrations.
Read more on our SSH tunnel integration here →
Schema browser for Dremio
Deepnote’s powerful new schema browser is now available to Dremio users. Explore the structure of your Dremio data — lightning-fast and directly from your notebook.
Simply click the View schema button on a Deepnote SQL block or click on your connected integration in the Integrations section in the right-hand sidebar. Enjoy full visibility into every table and column, as well as intelligent autocomplete to help you write your SQL queries even faster.