Better SQL autocomplete, AI custom instructions & code folding

Better SQL autocomplete

Writing SQL just got a whole lot smoother! We've given our autocomplete a major upgrade to make writing queries faster and more intuitive. See these improvements in action in our short video:

We've significantly expanded what your autocomplete can handle - it now works smoothly with schemas containing up to 400k tables, so most of you will never hit size limitations. No matter how many columns your tables have, you'll get reliable suggestions as you type.

The search experience is now much more powerful too. Partial matches work out of the box, so you don't need to remember exact table or column names. Suggestions work seamlessly with qualified entities and ignore backticks and double-quotes - one less thing to worry about as you write.

The autocomplete is now smarter in more ways: it uses table aliases and CTEs; provides context-aware keyword completions; and (our personal favorite!) suggests relevant columns when you're writing join conditions.

There are plenty more improvements waiting for you to discover. Happy querying - we hope these updates help your SQL flow more naturally than ever!

Deepnote AI: custom instructions

Now you can personalize how Deepnote AI works with you! Add your preferences once, and our AI will remember them for all future interactions - whether it's your favorite visualization library or preferred coding style.

Setting up your preferences is simple: click your avatar in the upper right corner, head to Account settings, and find the "Deepnote AI: custom instructions" text box. Whatever you write here becomes part of the AI's context for all your future tasks. And don't worry - these instructions are just for you; they won't affect your teammates' experience.

Go ahead and make Deepnote AI your own - time to tailor it to your style!

Code folding

Keep your longer code blocks tidy with our newest feature: code folding! If you're working with Python code blocks longer than 20 lines, you can now collapse functions, loops, and other code structures to focus on what matters most.

Using it is simple - just hover over the line number next to any collapsible structure and click to collapse or expand it. Want to fold everything at once? Use opt+shift+[ and opt+shift+] on Mac, or alt+shift+[ and alt+shift+] on Windows. Perfect for making your notebooks more organized, especially when working with longer functions.

App builder upgrade, faster notebook loading & table improvements

New app builder with preview

Say hello to a whole new way of creating apps - now you can see your app take shape in real-time as you build it! See it in action in this quick video:

No more switching between tabs and refreshing to check your changes. Our new split-screen preview puts your notebook and app side-by-side, so you can watch your app come to life as you work. Building your app is as simple as clicking the display button on any block you want to include (or select multiple blocks at once). Use the dropdown next to the display button to show or hide code and outputs - your changes appear instantly in the preview.

We've also refreshed how you start building apps. Instead of automatically including all notebook blocks, your new apps now start empty so you can thoughtfully choose which elements to include. Don't worry though - if you want to add all your non-code blocks at once, there's a handy shortcut button for that!

Looking for settings or performance data? Find them easily with dedicated Settings and Analytics buttons.

Give the new app builder a spin and let us know how it works for you. And stay tuned - we're adding exciting new features soon to give you even more control over app layouts!

Faster notebook loading

Your notebooks just got a serious speed boost! We've rolled out performance improvements that make opening and switching between notebooks significantly faster - up to 7x faster, in fact. You'll notice the biggest difference with longer notebooks, so go ahead and load up those data-heavy analyses without breaking a sweat.

We hope you enjoy speedier navigation - and keep an eye out, as this is just the first of several performance improvements we're working on to make your workspace more responsive.

Data table upgrade

Your data tables just got more customizable! While we've been busy under the hood improving performance (notice how smooth column resizing feels?), we're excited to share some new features that give you more control over how your data is presented.

Now you can easily hide columns you don't want to display - just click on the column header and select Hide column. Need to check what's hidden? Click the eye icon next to the column header to view and manage all hidden columns. We've also added the ability to rename columns right from the header, and you can now reorder columns by simply dragging them in the header. All these new options make it easier to make your tables more readable for your audience.

Don't worry - these visual tweaks only affect how your data is displayed, not the underlying data itself. Perfect when you need to present your analysis in a cleaner, more accessible way!

Dark mode & improved navigation

Dark mode

You asked (a lot!), and we delivered: Dark mode has officially landed in Deepnote.

One of our most requested features is finally here, ready to make those late-night coding sessions a whole lot easier on the eyes. Switch it on in Preferences -> Theme -> Interface theme, and join the dark side – we have better contrast and your eyes will thank you!

Improved workspace navigation

We're making it easier to find your way around your workspace, projects and apps:

• Say goodbye to accidentally hitting the workspace switcher while you're working in a notebook - our new, distinct workspace menu gives you clear, quick access to all your projects and apps
• We've brought the same workspace navigation to your apps, so you'll feel right at home jumping between content
• Looking for your personal settings like dark mode? You'll find them in our new Profile menu in the upper right corner.

Run button: advanced app workflows

Run button for conditional apps

Ever wished your app could be smarter about when it runs calculations? Today, we're introducing a powerful upgrade to our Run button that puts you in control of your app's execution flow. Now you can trigger specific actions exactly when you want them, making your apps more dynamic and responsive than ever.

Here's how it works: each Run button can now control a Boolean variable that flips to True when clicked. By using this variable in your Python code, you can create sophisticated conditional workflows that execute exactly when you want them to. You can get a quick overview in this short video or read more details in our docs.

As an example, you can now add multiple Run buttons to execute different parts of your notebook. In the demo below, the ‘Sales trends’ button produces a timeseries chart, while the ‘Reviews’ button displays correlation data.

When building apps with multiple input blocks that depend on each other, you can use the Run button to create more controlled workflows. The button allows you to delay the execution of downstream code until you have all the necessary input values collected from the user.

Check out our example app to see how Run buttons can power dynamic, multi-step dashboards. Let us know how this feature works for you - we can't wait to see what you'll create with this new capability!

Deepnote AI: Sleeker & smoother

Deepnote AI: refined interface, better flow

Deepnote AI has been your trusted analytical sidekick for over a year, but even the best sidekicks need a refresh. Today, we’re rolling out a sleek redesign of the AI prompt bar to improve both form and function. Get a quick overview of what’s new in this short video:

The new prompt bar is more compact, with elements repositioned to save space and reduce distractions. The cleaner layout lets you stay in the notebook flow without unnecessary interruptions—your content stays front and center, where it belongs.

We’ve also made the prompt bar sticky! Deepnote AI won’t be covering your block outputs anymore—scroll freely, and the prompt bar stays with you, making it easy to check both your block’s contents and its outputs while working with Deepnote AI.

Auto AI has gotten a makeover, too. Once you start an Auto AI task, it will stick to the bottom of your browser window so you can keep an eye on if it’s still working. Once it’s done, click on it to jump to your generated blocks.

Generated blocks are now highlighted, so you can easily tell which ones were created by Deepnote AI before you decide if you want to keep them. This should add a lot more clarity to your overall experience. Additionally, you can now use both the Command Palette and keyboard shortcuts to keep or discard the generated blocks.

We’ve made a whole bunch of other smaller tweaks to make your Deepnote AI experience as smooth as possible — we’ll let you explore those on your own! Our testers loved this new update so much they found it hard to go back to the previous version. Try it out and let us know what you think with a quick thumbs up or down!

Big number chart

Big number chart

We all love a good bar chart or a scatter plot— they're great for deep dives into data. But sometimes, you just need to cut to the chase and highlight a single, crucial metric for your stakeholders. That's where our new big number chart comes in. It's the simplest way to put your most important numbers front and center in your apps and dashboards.

With the big number chart, you can give your metric a clear title, select the exact variable you want to showcase, and format the number just the way you like it.

Want to show progress or change over time? You can also add a comparison to visualize how this number differs from a previous value, making trends instantly noticeable.

It's a straightforward tool designed to make your key data points stand out without any fuss. Give it a try and see how easily you can communicate what's most important.

Improved chart filtering in apps

We’ve rolled out a small update to enhance the interactivity of our charts in apps. You can now use on-chart filtering to select data points directly, in addition to the existing conditional filters. This change aims to make it easier for your audience to explore the data more effectively and focus on what interests them most.

Colorful data tables & faster app startup

Conditional formatting for data tables

Tables are essential tools for exploring data and can also serve as powerful visual aids in your published apps and dashboards. But let’s be honest—poring over plain tables to find what matters isn’t exactly a pleasant experience for your stakeholders. With the release of conditional formatting, you can now spice up your tables and make key results stand out with beautiful colors.

Coloring tables is easy: click on the Format button at the bottom right corner of your data table. In the popup window, you can define rules to dress up cells with either a single color or a color scale automatically mapped to the values in the selected columns. You can even combine multiple rules, and if they overlap, the last applicable rule will be applied.

These options give you the freedom to highlight what’s important and add some flair to your tables—whether in notebooks or published apps. We can’t wait to see how you’ll use this feature to make your data pop!

Better first-run experience for apps

We've rolled out a series of improvements to make the first interaction with your apps faster and more predictable.

First up, apps now start much quicker! When you visit an app, we're automatically warming up the machine in the background, so you'll spend less time waiting when you run the app or make changes to inputs for the first time. How much faster? It depends on your app, but we've already seen up to a 50% reduction in time to interactivity across many apps.

Next, we've streamlined the app configuration panel and added new options to give you better control over your app's execution logic and data freshness.

In App run settings, we've merged and simplified previous options to give you more clarity on how input changes will affect your app. You can choose between automatic and manual execution modes and decide whether to run only affected blocks or the whole notebook. The new default is automatic execution of affected blocks only, which should provide the best performance for most interactive apps.

In the App data section, we've made similar simplifications and added some extra convenience options. Run app from scratch always ensures a clean start. We've introduced a new control (Run app on open) so your app can automatically run whenever someone visits it. Show last run results helps you pre-populate results from the latest notebook run. If you opt for this, you can also schedule the notebook directly from this config, making it easier to keep app data fresh according to your custom schedule.

Auto AI with SQL powers

Auto AI: now using SQL blocks

We've taught Auto AI a new trick! It can now use our native SQL blocks to query your connected data warehouses / databases directly.

With this update, Auto AI gains the ability to see and interact with your data integrations. Give it a task and Auto AI will smartly combine SQL for fetching data with Python for processing and visualization. The result? You get a complete package including SQL queries, Python code, and explanatory text all in one go.

This means Auto AI can now handle full analytical tasks from start to finish. No more switching between tools – just ask Auto AI, and it'll take care of the rest.

Watch our quick demo video below to see it in action.

We hope this new feature boosts your productivity! As with all AI updates, it may not work perfectly for every use case, so we'd love to hear your thoughts. Share your suggestions on our Product Portal or report issues by clicking 👎 when reviewing your AI outputs.

Not interested in SQL generation? No worries. We've added an option in Auto AI settings to control which block types appear in your outputs.

GitHub integration improvements

Two-way GitHub integration

We've significantly enhanced our GitHub integration to make collaboration even smoother. Originally, we designed it to easily import existing code from your GitHub repository to Deepnote. While pushing changes back to GitHub was possible, it required using the integrated terminal interface in your project, which could be inconvenient. Now, we're excited to introduce a more streamlined process with two-way Github integration!

With our latest update, committing and pushing changes to your cloned repo is as simple as clicking a button. Here's how it works:

1. Navigate to your synced GitHub repo in Deepnote.
2. Click on the options menu.
3. Select Commit & push.
4. In the pop-up window, add your commit message and description.
5. Push your edits directly to the origin branch.

By removing the need for terminal commands, this update streamlines your version control process.

But wait, there's more! We've added several other powerful Git operations to support your workflow:

• Switch between branches with a simple click on the branch name in the dropdown menu.
• Easily pull the latest changes from the remote repository to keep your local copy current.
• Need a clean slate? You can now re-clone the repository with just one click.

These features work together to provide a comprehensive Git experience right within Deepnote.

Want to see these new capabilities in action? Check out our demo video!

Automated notebook exports to GitHub

Backing up your notebooks to your GitHub repository is more convenient than ever!

Our enhanced Export to Git feature, found in the Version history tab, now offers two key improvements to streamline your workflow.

First, you can now enable automatic commits for all notebooks in your project. When activated, this option automatically pushes a commit to your GitHub repository whenever an autosave occurs in your project. Since Deepnote autosaves every 10 minutes or after periods of inactivity, this feature ensures your notebooks and GitHub repo can stay in sync without relying on manual commits.

Secondly, we've introduced a new option to control the inclusion of outputs in your notebook exports. This feature is designed with data security in mind. By default, outputs are not included in exports, which helps prevent any accidental leakage of sensitive information. However, if you work with outputs that you want to preserve in your exports, you can easily do so. Simply enable the Include outputs in the exported notebooks option, and your results will be retained, ensuring they look identical when re-imported.

Auto AI: customizable block types

We've shipped a small but mighty improvement for Auto AI to give you more control over its output. Now, you can specify exactly which types of blocks you want Auto AI to add to your notebook. For a more efficient, code-focused output, simply click on Settings in the prompt bar and deselect the Text option.

Need more textual explanations? No problem – you can change this setting anytime to suit your task at hand.

Embedded apps & conditional filters for data tables

Embedded apps

We're excited to announce a powerful new feature: the ability to embed Deepnote apps in third-party applications. With this release you can seamlessly incorporate your reports, dashboards, and other data apps into platforms like Notion and Confluence, bringing your insights directly to where your consumers spend most of their time.

Embedding your app is easy. Simply press the Embed button in the app editor sidebar and turn on the embedding toggle. Once activated, just copy the displayed URL and paste it into your preferred application, and voila! Your app is now ready to shine wherever you choose to embed it.

Please note: your app sharing needs to be set to either Anyone with a link or Public for embedding to work. Support for private links is coming soon!

The embedding capability can support some pretty powerful use cases, such as:

• Sharing live, interactive data visualizations with stakeholders who may not have direct access to Deepnote
• Integrating up-to-date analytics into your team's workflow and documentation
• Maintaining a single source of truth for your data, while distributing insights across multiple platforms

Learn more in our 👉 docs.

Conditional filters for data tables

Tired of writing complex code every time you need to filter your data tables? We hear you. That's why we’ve just introduced conditional filters for data tables – a feature that lets you slice and dice your data without typing a single line of code.

Here's how it works: just click the Filter button in the block actions menu, pick the column you want to filter, choose an operator and value, and hit Apply. Your table will update instantly, showing only the rows you need. Alternatively, if you want to filter on a specific column, you can just click on the column header and press Filter.

Need to tweak your filter? No problem. You can easily add, remove, or modify filters using the Filters list, making data exploration faster and more intuitive than ever.

And here's the cherry on top: we've brought this same filtering capability to apps! Now your consumers can dive into tabular data on their own terms, focusing on whatever aspects interest them – without being constrained by pre-set filter options or having to request changes from the app creators.

AI code completion for free & notebook usage insights

AI code completion for Free users

Our AI-powered code completions have significantly boosted productivity for customers on our paid plans. Many have found these 'ghost texts' so indispensable in speeding up tedious coding tasks that they’ve become an essential part of their workflow. Due to the success of this feature, we are now making it available on all our plans! 🎁

Starting this week, AI code completions are accessible to users on our Free and Education plans without any restrictions. Simply start typing in a code or SQL block, and you will see real-time code suggestions. To accept a suggestion, press Tab. These code completions are blazing fast and context-aware, tailoring suggestions to your notebook's content.

Pro tip: For even smarter completions, try adding instructions in text blocks or code comments.

We hope you will all enjoy this added boost to your coding efficiency!

Check out our 👉 docs for more details.

Notebook & apps usage insights

Have you ever wondered if your hard work in analysis is making an impact? Or if your latest interactive dashboard is regularly viewed by key stakeholders? With our new notebook notebook usage analytics feature, you can now easily answer these questions.

To view usage insights for your notebook, click on the context menu of the specific notebook and select View analytics. Alternatively, you can find the same button in Project settings in the upper right corner. If the current notebook is published as an app, you can also click on the View analytics button on the top band or in the app editor sidebar.

The displayed insights include a timeline of daily visits for both the notebook and the app, as well as a record of daily executions for the app. You can also see a breakdown of individual visits to your notebook and app, allowing you to quickly identify if you’re reaching your target audience. Additionally, you can change the analyzed timeframe in the upper right corner to look at different periods.

Discover more in our 👉 docs.