Changelog

AI Copilot & HIPAA compliance

AI code completion in closed Beta

We're thrilled to announce that intelligent code assistance is soon coming to Deepnote! With AI code completion (currently in closed Beta), you'll enjoy lightning-fast suggestions that consider the entire notebook as context, including text, code, and markdown.

Say goodbye to manual searches and time-consuming boilerplate code – our AI companion effortlessly anticipates your next steps. This is especially valuable for exploratory data analysis, empowering you to focus on gaining insights rather than getting caught up in syntax details.

Limited seats are available for interested individuals to join our closed beta. Claim your spot by clicking on the link below. Priority will be given to our Team and Enterprise plan customers.

Join waitlist

Code completion is just the first step in our journey to transform data work in notebooks via the power of AI. We have many more exciting features planned, all aimed at enhancing your productivity. Keep an eye out for updates as we continue to unveil these exciting developments!

Announcing our HIPAA compliance

We are pleased to announce that Deepnote is now HIPAA compliant, which means that companies can securely process PHI on our platform while adhering to the US federal law that sets national standards for protecting medical records and personal health information.

If you would like to learn more about HIPAA and how to sign a BAA, please reach out to our sales team at sales@deepnote.com.

Push notebooks to GitHub & import Python packages or files from a GitHub repository

Push notebooks to GitHub

We are bringing some more software engineering best practices to Deepnote. Export your work directly to GitHub with a new feature that allows you to commit & push your work to a specified path in a GitHub repository.

Enable this in your project setting’s versions tab by connecting your public or private GitHub repository and a path within the repository. Deepnote allows you to specify a commit message & pushes all notebooks as .ipynb files.⁠

Read more ->

Import Python packages and files from GitHub

We are not stopping with a single GitHub feature. The next update is about importing Python packages, modules or other files from GitHub. You can now easily import a repository (or several if you’d like!) to your project via the Files section. All you need to do is specify the repository & we will set you all up!

If you need to pull fresh updates of your repo, right-click the imported folder in the Files section and hit Refresh.

Read more ->

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.

Read more on our Dremio integration here →

OAuth for Snowflake & BigQuery, schema browser for Athena & ClickHouse, upgraded SQL autocomplete & Dremio integration

OAuth for Snowflake & BigQuery

Snowflake and Google BigQuery users now have more ways to keep their data secure. Using OAuth, you can give every member of your Deepnote workspace their own set of credentials.

Enable multi-factor authentication, get granular with access controls for specific resources, and improve your ability to audit data access — all while allowing team members to run queries from Deepnote using their individual Snowflake or BigQuery accounts.

Read more on our Snowflake integration here →

Read more on our BigQuery integration here →

Schema browser for Athena & ClickHouse

Deepnote’s powerful new schema browser is officially available to Amazon Athena and ClickHouse users. Now you can explore the structure of your Athena or ClickHouse data 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. Blazing-fast speed, SQL query autocomplete, and full visibility into every table and column — all at your fingertips.

Read more on our schema browser here →

Upgraded SQL autocomplete

Our new and improved autocomplete now provides more relevant suggestions at every stage of the query writing process. You can compose your SQL queries faster than ever before.

Simply start typing after your SELECT statements to receive matching column names or press Tab to see all column names within your schema. If you already selected or joined tables in your query, column suggestions will be limited to only the relevant ones.

Plus, schema object suggestions are now more tightly scoped — you can build fully qualified table names by adding to each hierarchical level. Type after your FROM statement to see suggestions, first for matching databases and datasets, then for schemas, and finally for tables.

Dremio integration

We’re excited to announce our integration with Dremio! Now you can enjoy Dremio’s lightning-fast querying speed using Deepnote’s SQL blocks.

Our new integration lets you query your Dremio lakehouse, extract relevant insights, and start analyzing and modeling data from the comfort of your notebook. Create your integration, connect it to your notebook, and start querying in just a few clicks.

Need to switch between Dremio and another distributed SQL engine? No SQL statement rewriting is necessary. Just switch your SQL block’s assigned integration.

Read more on our Dremio integration here →

Brand-new schema browser, Trino integration & flexible integration creation

🔍 New & improved schema browser

We’re excited to share Deepnote’s powerful new schema browsing experience! Explore the structure of your data and write SQL faster than ever before.

⁠Here are the highlights of what’s new:

• It's blazing fast! Quickly navigate your schema across thousands of tables and receive results almost instantly.
• There’s no need to start from scratch. See matching table/column suggestions as you type to autocomplete SQL queries.
• You get visibility into everything. Search for tables and columns across your whole data source.
• It’s easier to speed up your SQL workflows. Apply handy shortcut actions to preview a table, copy table/column names with a click, and more.

Our new schema browser is currently available for Snowflake, Google BigQuery, Amazon Redshift, PostgreSQL, Microsoft SQL Server, and MySQL. Keep an eye out for more integrations coming soon!

Read more on our schema browser here →

🔌 Trino integration

We’re happy to announce our integration with Trino. Now you can use Deepnote’s SQL blocks to query Trino instances at lightning speed.

Our new Trino integration allows you to query, extract, analyze, and model data in your Trino instance from the comfort of your notebook. And if you need to switch between Trino and other distributed SQL engines, there’s no need to rewrite your SQL statements — simply switch the SQL block’s assigned integration.

Read more on our Trino integration here →

📓 Add integrations directly from your notebook

Need to create a new data source connection? Now you can do it directly from your notebook instead of navigating to a separate page.

Just open the Project tab in the right-hand sidebar and click the plus (+) button in the Integrations section. No workflow disruptions necessary.

Read more on integrations here →

Redshift schema browser, SSH & SSL connections & integration updates

🔍 Redshift schema browser

Now you can find the Amazon Redshift data you need from the comfort of your notebook.

Next time you want to explore your Redshift schema tree, simply click on the connected Redshift integration in the right sidebar.

You can also access the schema right from an SQL block by clicking on the View schema button. Discovering your data’s never been easier.

And stay tuned for a brand new schema browsing experience for Redshift and other data sources coming to a product update near you!

Read more on our Amazon Redshift integration here →

🔒 SSH & SSL database connections

You now have more options for securely connecting to databases on private networks.

In the past you had the option of authorizing Deepnote’s IP addresses. Now you also have the option of specifying an SSH connection in the Integrations menu. We’ll automatically generate a public SSH key that can be added to your SSH bastion.

Meanwhile, if the database supports it, any queries executed from an SQL block will automatically connect to your database via an SSH tunnel.

We’ve also added new options for enforcing SSL encryption and verifying server certificates to help you keep your data secure.

Read more on securing connections here →

🔌 Integrations added to the right sidebar

Reviewing and updating workspace integrations just got easier.

Instead of living in a separate tab, project integrations are now displayed in the main project tab of your notebook.

No more clicking away to find out which integrations are connected or need to be added.

Read more on integrations here →

Updated SSO, upgraded audit logs, new billing controls & much more

🔒 SSO updates & directory sync

It’s easier than ever to control which team members or groups can log into Deepnote using the identity provider of your choice.

If you’re on the Enterprise plan, you can now use single sign-on via SAML or OIDC connection, including Google, Okta, Azure AD, OneLogin, and more.

You can also sync users from your directory provider — such as Okta or Active Directory — into Deepnote via SCIM. This makes it a breeze for companies with larger teams to manage users.

Read more on SSO & directory sync here →

🔍 Audit log metadata & exports

Get more out of your data warehouse audit logs with Deepnote. Queries from Deepnote’s SQL blocks now include helpful metadata, such as who ran a query and in which project, so you can keep tabs on those overly expensive queries.

And if you’re an admin on the Enterprise plan, we’ve made it even easier to investigate activity for security incidents. Admins can now export an audit log as a CSV from the General settings menu.

Read more on audit logs here →

💰 Billing alerts & limits

Stay on top of your machine costs without breaking a sweat.

You can now send billing alerts to all admins for a workspace. Simply set up a monthly dollar limit for pay-as-you-go machines in the Billing & usage menu and all admins will be notified via email when it’s reached.

Looking for other ways to keep costs predictable? Admins can now also disable pay-as-you-go machines for a workspace, shutting off this option for users (this will move any running projects to a Basic machine at the next start).

Read more on billing alerts & limits here →

🎨 New color scales for charts

Dress up your charts in truly eye-catching colors!

When you’re selecting colors for a quantitative or temporal column in charts, you now have a much wider range of choices, including single-hue, multi-hue, and divergent color scale options.

🔢 Customize axis number format in charts

Want to change the displayed number format of your chart’s quantitative axis? Now you can just point and click — no code necessary.

Simply go to the Format tab and choose your preferred option from the Number dropdown menu. If you want to get even more granular, you can also customize the number of decimals you wish to show.

Chart recommendations, flexible chart filtering & Microsoft sign-in (plus SSO support)

🤖 Smart chart recommendations

Get ready to accelerate your data visualizations with chart recommendations.

Next time you create a chart block, you’ll have the option to click on the Explore button, which will bring up a gallery of recommended charts based on your DataFrame.

The gallery includes the most commonly used chart types for data summarization. Simply select an option to use it as your own (Replace chart) or create a new chart based on it (Add new chart).

No more starting from scratch each time you need to build a chart. Quickly browse a wide range of data summaries, pick your starting point, and customize from there.

🖱 Interval selection on charts

Chart filtering just got a lot more flexible.

You can now select a range of data points directly with your mouse when you want to apply a filter to your chart.

Click and drag over an area on the chart to highlight your data. Then hit the Filter button to include or exclude the selected data or inspect it in a new DataFrame.

Zooming in on outlier data points is now easier — and more precise — than ever.

Read more on interactive filtering here →

🔐 Microsoft sign-in & enforcing SSO

You can now sign up and log in to Deepnote using your Microsoft 365 account.

And if you’re an admin on the Enterprise plan, you can enforce specific single sign-on methods — including Microsoft, Google, Okta, and more — for all members of a workspace.

Authenticate users and keep workspaces secure with ease.

Read more on SSO here →

Chart updates: export to DataFrame & value labels

📊 Export chart to DataFrame

Want to explore the data behind a specific part of your chart? Now you can create a new DataFrame from filtered data when you apply a filter on a chart block.

Close the analytical loop without having to manually write any code — simply click the DF button and a new code block will be added below your chart.

🔢 Value labels on charts

It’s easier than ever to improve the readability of your charts (always handy when you’re sharing your results with others). When you create a bar, line, or area chart, you now have the option to turn on Value labels in the Format tab.

Just use the toggle to display the numerical values of individual data points. And voilà — your charts are that much easier to read.

Interactive chart filtering

📊 Chart blocks now support interactive filtering

No need to interrupt your workflow by writing SQL or Python for a simple chart filter — just click on the items you'd like to focus on within your chart and press the Filter button to include or exclude the selected series. You can even combine multiple filtering steps to drill down the data as much as you need.