Import SQL files

Go from nasty, nested SQL to a clean, clear DAG.

Use these step-by-step instructions to see how to use an existing SQL statement in Count, and visualize it as a connected DAG of cells.

1. Copy the query into your clipboard

Copy directly from your favorite IDE.

Some sweet, sweet SQL.

Count can only handle SELECT and WITH statements. If you try to run any CREATE, UPDATE, or DELETE statements, they will not be executed.

2. Paste into a new, blank cell

Paste the query into a new cell.

A new cell with your query.

This query will run as expected, but it's strongly suggested to turn that 1 query into a DAG of connected cells.

3. Click to explode CTEs to cells

Clicking the explosion button will automatically take your CTEs and represent them as connected cells. This makes it easier to understand your query, debug, and communicate with others.

Your query presented as a DAG.