Query chaining & checkbox inputs
Chained SQL
Build complex SQL queries the notebook way - one block at a time! Our new chained SQL feature lets you break down massive queries into simple, manageable steps without worrying about memory limitations. See how it works in this quick demo:
If you've ever built a complex SQL query using Common Table Expressions (CTEs), you know the challenges. Large subqueries can crash with out-of-memory errors, forcing you to upgrade hardware or implement tedious workarounds. Debugging means commenting out sections or running separate queries, then stitching everything back together - it's a headache.
Chained SQL solves this elegantly. When running SQL queries, you'll now see two output options:
- The familiar DataFrame mode that returns full results
- Our new query preview mode that returns a lightweight query object (just 100 rows)
The magic happens when you reference these query objects in subsequent SQL blocks.
Here's a simple example: first, we query our USERS
table with query preview mode. Then, in a separate block, we query the USERS_AB
table the same way.
Finally, in a third block, reference both query objects to join them together and see which user was in which variant - all with clean, simple SQL in each block.
We automatically build CTEs in the background, linking your blocks together while keeping memory usage low. Your blocks stay clean and focused, showing only the SQL you need for each step. Need to see the full query? Just click "Show compiled SQL" in block actions.
When you've perfected your query chain and want the complete results, simply switch the final block to DataFrame mode. This gives you complete control over when to pull data into memory.
Chained SQL brings the notebook philosophy to complex queries - build incrementally, debug easily, and manage memory efficiently. Visit our documentation for all the details.
Checkbox inputs
We've added a useful new feature to make your notebooks and apps more interactive: checkbox inputs! These new input blocks let you easily toggle Boolean values on and off with a simple click. Creating one is straightforward - just click on the Input button in the notebook footer and select Checkbox input. You can customize it with an optional display name that shows on your apps and configure the label text that appears next to the checkbox. They're perfect for filtering data on Boolean columns, or adding toggle options to your interactive dashboards.
Snowflake key-pair authentication
We've added support for Snowflake's key-pair authentication, giving you a more secure way to connect to your Snowflake data. This authentication method eliminates the need for password-based access by using cryptographic keys instead. Simply generate your private and public key pair, register the public key with your Snowflake user account, and use your private key when connecting from Deepnote. It's more secure and just as convenient once set up. Check out our documentation for step-by-step instructions on generating keys and configuring your connection.