Quickstart

From zero to first billion-row table in ten minutes

This guide covers account creation, connecting your first warehouse, and running a formula on a live table. It works for Snowflake, BigQuery, Databricks, Redshift, and DuckDB.

Quickstart steps

This guide assumes you have a data warehouse with at least one table. If your warehouse is not yet set up, the connectors page has the minimum permissions each warehouse needs before Row Zero can connect.

1

Create a free account

Go to getrowzero.org/login/register.html and create an account with your work email. You start on a 14-day Pro trial automatically. No credit card required at this stage.

2

Add a warehouse connection

In your Row Zero workspace, click "Add connection" in the left sidebar. Select your warehouse type. You will see a form for either a connection string or OAuth credentials. For Snowflake, paste your account URL and choose OAuth or username/password. For BigQuery, authenticate with your Google account and select a project. Other warehouses follow a similar pattern.

Row Zero stores an encrypted reference to your credentials. We never copy your warehouse data.

3

Browse your schema and open a table

Once the connection verifies, Row Zero shows your schema in a left panel. Expand a database, expand a schema, and click any table name. Row Zero issues a query to your warehouse and streams the first rows into the grid. The status bar at the bottom shows the total row count.

For tables under 50 million rows, the Free tier opens them fully. For larger tables, you need a Pro account.

4

Sort and filter the data

Click any column header to sort. Click the filter icon to add a filter. Each of these actions sends a SQL query to your warehouse with the corresponding ORDER BY or WHERE clause. The data you see in the grid is the result, not a local copy of the full table.

5

Write a formula

Click an empty cell and type an equals sign to enter formula mode. Try =COUNTIF(status,"active") to count rows where a status column equals "active". Row Zero compiles this to SELECT COUNT(*) WHERE status = 'active' and runs it on your warehouse. The result appears in the cell.

Supported formulas include SUMIF, COUNTIF, VLOOKUP, INDEX/MATCH, and standard arithmetic. The formula bar shows the compiled SQL if you want to inspect it.

6

Switch to SQL mode (optional)

If you prefer writing SQL directly, switch to SQL mode by clicking the mode toggle in the toolbar. Type your query in the editor. The grid renders the result. You can save named queries and reference them from other sheets. SQL mode supports any SQL your warehouse dialect supports.

7

Share a view (Pro)

To share your current view with a colleague, click "Share" in the top right. You can share with edit or view-only access. The recipient opens the same live table, filtered and sorted exactly as you configured it. Your warehouse row-level security policies apply to what they see.

Next steps

After completing this quickstart, read the connector setup guide for your warehouse to understand the minimum required permissions, how to scope access, and how to enable OAuth if you have not already.