Deepnote
Sign inGet started

Changelog

February 2, 2023

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.

sso-enforce.png

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.

More chart color options, flexible dates for charts, & CSVs in notebooks

🌈 More color options for charts

Add more color (and context) to your charts with a wider range of color palettes. When you select a categorical column in the Color option, you can now choose between multiple color palettes.

If you want to apply a single color to the whole chart, simply select it (or add a custom color of your own).

🗓 Flexible date units for charts

It just got much easier to adjust the granularity of time series analysis on the fly. When you add a temporal column to an axis, you can now change the displayed time unit.

Pick from multiple time intervals/formats in the dropdown menu and the temporal axis will be grouped by the selected unit. No more having to reshape your dataset with code!

🗂️ Drop a CSV into a notebook

Easier workflow alert! You can now drag and drop a CSV into a notebook(either from your computer or from your project files in the right sidebar) and query away.

Add-ons to charts: exporting into code & adding secondary measures

🐍 Export charts into code

If you need even more flexibility to customize your charts, you can now duplicate your chart block into code by selecting the option in the block actions menu.

This adds a new Python code block to your notebook, containing the configuration of your chart in the Vega-litespecification format. Vega-lite is very powerful and fairly easy to learn, so it’s a great option if you need to create a finely customized or super-advanced visualization.

📐 Secondary measures on charts

You can now add secondary measures to charts with one click.

When you create a chart with a categorical and measure (quantitative) column on the X and Y axes, we now display a plus (+) button next to the selected measure. Click on it, pick your secondary measure, and we'll create a new chart layer with all settings pre-configured for you, including the legends. It’s as easy as it sounds!

If your secondary measure happens to be on a different scale, you can also switch to dual axis mode under the Display tab. This will visualize the two measure axes independently.

dual-axis-mode.png
👋 Share private projects by name
private-projects-sharing.png

To simplify sharing private projects with other workspace members, we’ve updated our project-sharing options to accept names in addition to emails.

More on project sharing options in our docs →

Data visualization for everyone: Introducing the new chart block

data-visualization-for-everyone-deepnote-chart-blocks.png

We've overhauled chart blocks in Deepnote to bring you a more intuitive and flexible no-code data visualization experience. Chart blocks are rolled out to everyone using Deepnote as of November 16, 2022!

Here are some highlights of what’s new:

  • More chart types, including compound charts with multiple layers
  • Essential formatting options to customize your chart axis and canvas with a few clicks
  • Simplified workflow for building your exploratory graphs even faster
  • Many quality-of-life improvements, including chart resizing and an option to hide the configuration details

And don't forget to check out these additional resources:

  • You can learn more about new chart block capabilities in our docs →
  • For practical examples of how to use the chart block for data exploration without writing a single line of code, check out our showcase notebook →
  • If you’d like to take a peek into our product kitchen, we also wrote a blog post about our thought process and design approach for this major upgrade — read it here →

Bulk domain invites, favorites, & new integrations with Snowflake & Keboola

✅ Invite anyone with your email domain as a viewer

We’ve introduced an easier way to share notebooks with anyone at your company: domain invites.

Admins can turn this setting on to enable anyone with a matching email domain (e.g., @yourcompany.com) to join your workspace as a Viewer. And because Viewer seats don’t count toward plan limits, you can add as many team members as you’d like for free.

email-viewers.png
💙 Favorite projects for fast access

We’ve added the option to favorite Deepnote projects for faster access. When viewing a notebook or project, simply click the star ⭐ icon (located in the top right navigation bar) and we’ll pin it to a favorites section in your workspace.

favorite-projects.png
❄️ Exploratory data analysis with Snowflake & Deepnote
snowflake-guide.png

We shipped a Snowflake quick-start guide for building an accelerated exploratory data analysis (EDA) workflow with Snowflake and Deepnote. Specifically, the guide covers methods for effectively cleaning and visualizing weather readings, which can be applied more generally to any dataset used within Deepnote.

Check it out →

🐙 Trigger notebooks to run with Keboola & the Deepnote API
keboola-deepnote-api.jpeg

Our friends at Keboola released a new component that enables you to trigger the run of a specified notebook in Deepnote using the Deepnote API.

Read the docs →

dbt Semantic Layer

🔌 dbt Semantic Layer is now an official Deepnote integration!
dbt-semantic-layer-deepnote-cover.png

With the dbt Semantic Layer and Deepnote, you can import metrics defined in dbt directly into your Deepnote notebook and give your data team a consistent, reliable way of defining and consuming metrics.

Combining Deepnote and dbt unlocks use cases that include: speeding up ad-hoc reporting, mixing historical and predictive analytics, dashboard prototyping, and much more.

Here are some resources for using dbt and Deepnote:

Sorry, your browser doesn't support embedded videos.

A faster way to query SQL integrations & add blocks

New block buttons for faster querying

We’ve simplified the way to add blocks to your notebook: Each block type (code, text, SQL, etc.) now has its own dedicated button to save you a few clicks. Even better, clicking the SQL button now lists all available data source integrations set up for your workspace (and those not yet connected to your project).

Simply select an integration from the SQL dropdown and your linked SQL block will be added. In case you can’t find the integration you need, you can also click on the set up a new integration button to quickly navigate to the Integrations page (only available for workspace admins).

🤝 Block presence is back

We’ve brought back a real-time collaboration feature: block presence. You'll now see the profile photo of a team member when they are active within a block in your shared notebook.

block-presence.png

Remember that only one user will be able to edit a code block at a time.

📓 Featured notebook

Public API, full-width mode, & featured notebooks

🤖 Introducing a public API to run notebooks programmatically

Introducing our first public API endpoint for executing notebooks! You can now programmatically trigger notebooks to run from external applications.

This opens up a host of automation opportunities, from customized scheduling to integrating notebooks deeper into existing workflows together with other applications.

Read the docs for more on this release →

Releasing a public API is just our first step toward building a rich API ecosystem around data notebooks. We'd love to hear what endpoints and capabilities you'd like to see — head to our Product Portal and share what you'd like us to build next.

🧱 Change text block types

We’ve added the option to easily change text blocks to a different type (e.g., turn a paragraph into a callout).

Simply click the hamburger (Block action) menu and select the block type you’d like to convert to.

More on this update (and all of our recent rich text improvements) in our docs →

↔️ Full-width mode for notebooks

By popular demand, we’ve added full-width mode to notebooks so you can take full advantage of those large displays. Just toggle to full-width mode in the right-hand settings of Deepnote and your notebook will automatically expand to the width of available space.

Pro tip: Full-width mode is particularly handy when working with long lines of queries and wide outputs — no more long scrolling!

📓 Featured notebooks

To-do lists, callouts, & faster notebook performance

✨ Fancy rich text editing: to-do lists & callouts!

With our latest upgrade to rich text editing, you can now create task lists in your notebooks. Select to-do list from the add block (+) menu and start listing items relevant to your work.

The check marks are collaborative, so you can keep track of outstanding tasks together with your team members.

We’ve also added callout blocks to bring even more style to your storytelling. Create a callout from the add block (+) menu and select one of four colors to highlight important blocks of text in your notebook.

📓 A better, faster notebook experience

We’re changing how notebooks are stored by moving them out of the Files section and into a dedicated Notebooks section in your right sidebar. This change will unlock a handful of upcoming features for versioning, collaboration, and editing (stay tuned) and will make your notebook loading times about 90% faster by our estimates!

While this update introduces many improvements, it also impacts how command-line tools (such as Git) interact with Deepnote notebooks.

Read more about this migration in our documentation →

📓 Featured notebooks from the community

Restore notebook variables & an easier way to add links

🔁 Restore variables from your previous session

Jump straight back into your work from where you left off without losing context. When you return to your notebook after your machine went offline (e.g., after a period of inactivity), you now have the option to restore your variables.

Just click on the Restore variables link displayed in the status bar on the top and all variables will be restored from your previous session.

Learn more about this feature →

🔗 More rich text additions: links!

We’ve added hyperlinks to our formatting palette. Highlight any piece of text and include a URL by clicking on the link icon.

Shortcuts for copy-pasting links are also supported (Cmd+V) for maximum efficiency.

📓 Featured notebooks

More rich text features (lists!) & SQL Server support

↔️ SQL Server integration (Azure SQL & Synapse SQL, too!)

We’ve added a built-in integration for Microsoft SQL Server, allowing data teams to query Microsoft SQL Server instances (as well as Azure SQL & Synapse SQL) from the comfort of a notebook environment.

With the SQL Server integration, you can query and browse the schema of your databases from within Deepnote. In addition, Deepnote’s SQL blocks supercharge your analytics workflows through features like auto-complete or saving query results to pandas DataFrames.

✍️ Rich text editor upgrade: numbered & bulleted lists

Our rich text editor got a small (but mighty) upgrade: numbered and bulleted lists. You can create formatted lists from the add block (+) menu, as well as by typing - or a number sequence 1. and space at the beginning of a block.

📓 Featured notebooks

Rich text editing and fast integration connectivity

✍️ Rich text editor

Our new powered-up paragraph and heading blocks now support rich text editing. Simply highlight a piece of text and apply various styling options right from the formatting toolbar. You can also format text via keyboard shortcuts for even more efficiency.

Creating a compelling textual narrative in your notebooks is now simpler than ever — with no Markdown needed!

We’re making text editing a first-class citizen in notebooks and rich text editing. We'll soon be adding support for bulleted lists, numbered lists, links, and more.

⚡Faster integration connectivity

We’ve decreased the time it takes to connect to integrations by 90% — no more hardware restarts. Simply click to connect an integration and we’ll handle the rest.

❄️ Snowflake Select Technology Partner
snowflakeselecttechnologypartner.jpeg

We’re thrilled to share that Deepnote is officially a Snowflake Select Technology Partner, giving you even more support, resources, and flexibility when using Snowflake and Deepnote together.

📓 Featured notebooks from the community

ClickHouse integration

↔️ ClickHouse integration
ClickHouse Integration.png

We are expanding our list of data sources. The ClickHouse integration allows data teams to efficiently query very large datasets, extract relevant data, and start analyzing and modeling in the comfort of their own notebook environment.

With the ClickHouse integration, you can leverage the performance and scalability that comes with ClickHouse's open-source column-oriented DBMS right from within Deepnote. ClickHouse allows users to handle thousands of sub-second queries per second on petabyte-scale datasets.

🐛 Smaller things and bug fixes
  • We added support for Python 3.10. Version 3.9 is now the default for all new projects.
  • We added support for TensorFlow 2.9.1 and R 4.2.0. You can switch your project to this version in the environment section.

Footer

Product

  • Integrations
  • Pricing
  • Documentation
  • Changelog
  • Security

Company

Resources

  • Privacy
  • Terms

© Deepnote