Product releases

New column reference syntax

Row Zero now supports Excel-compatible column references. This update improves usability and enables Row Zero to support array literals in the future.

What’s changing:

• Full column references no longer require quotation marks around the column name. They also no longer require the table’s root cell when referenced inside the table.
• Sibling column references now use square brackets instead of curly braces.

Learn more about column references here.

Self-serve OAuth Databricks connections

Creating OAuth Databricks connections is now self-service. When creating a new connection, customers can choose to connect with a personal access token or Databricks OAuth. Learn more here.

Standard mode for connected tables

A new standard mode for connected tables spills query results into sheet cells. Standard mode supports cell references (e.g. A:A) as well as column references like {COLUMN_NAME}. You can switch a connected table between standard and data table mode at any time, and new connected tables start in the mode you used last.

Data source filters

You can now filter a data source on any column when you import it, which is helpful when working with very large datasets. Whereas query variables let a data source owner define filters in advance, filters let anyone importing the data choose their own. You can also add or adjust filters after import from the data source side pane.

Query builder for BigQuery

Query builder is now available for BigQuery connections. Import data without writing any SQL by dragging columns into fields, groupings, and filters.

Pivot table sort

You can now sort a pivot table in compact or tabular mode. Right-click the label, value, or total you want to sort on, then choose Sort and a sort order. See Pivot Tables to learn more.

Named ranges in IMPORTRANGE

The IMPORTRANGE function now accepts named ranges in place of a sheet name and cell range, making formulas easier to read and maintain.

Query builder for Oracle

Query builder now works with Oracle connections.

Build queries against your Oracle data using Row Zero's point-and-click query builder. Select the tables and columns you need, apply filters or groups, and import your data without writing SQL.

Usage data for data sources and templates

Creators of data sources and templates can now track adoption. Detail pages show daily usage over the last 30 days and a list of users who have ever accessed the data source or template.

AI threads

AI Agent conversations are now threads you can leave and come back to.

• Each workbook can have multiple threads, so separate requests stay separate.
• Threads are saved with the workbook, so you can leave and continue a conversation later. Copy a link to any thread to jump back to it.
• Long threads are compacted automatically to stay within the model's context limit.
• The AI Agent keeps working after you close the workbook, so long runs finish without you.