Worksheets & Query Editor

Run ad-hoc SQL queries against your warehouse without leaving dbdeux. Worksheets provide a dedicated space for exploration, debugging, and analysis alongside your dbt development workflow.

Worksheet

SELECT
    c.first_name,
    COUNT(o.order_id) AS orders,
    SUM(p.amount) AS total_spent
FROM dim_customers c
JOIN fct_orders o ON c.customer_id = o.customer_id
JOIN stg_payments p ON o.order_id = p.order_id
GROUP BY 1
ORDER BY total_spent DESC
LIMIT 10;

❄️ Snowflake - ANALYTICS_DB0.34s - 5 rows

#	first_name	orders	total_spent
1	Alice	47	$12,340.50
2	Bob	35	$9,871.20
3	Carol	31	$8,455.00
4	Dave	28	$7,192.80
5	Eve	24	$6,820.15

5 rows x 3 columns

Worksheets

Create and Manage

• Click + New Worksheet from the quick-add menu or editor tab bar
• Each worksheet is automatically saved (autosave on every keystroke)
• Rename worksheets to keep your workspace organized
• Worksheets remember their last-used connection
• Org-scoped tabs: Open worksheet tabs are scoped per organization, so switching orgs swaps your tab set automatically. Each org's worksheets stay independent

Save to Project

When an ad-hoc query is worth keeping, promote it into your dbt project without copy-pasting. Save to project lets you pick the destination folder and turns the worksheet into a real project file (for example a new model), so it becomes part of your version-controlled codebase.

Worksheets that use Jinja keep their run control visible with clear guidance, so it is obvious that Jinja resolves when the query becomes a dbt model rather than in the raw worksheet run.

Connection Picker

Each worksheet can target a different connection. The connection picker shows:

• All available warehouse connections with brand icons
• The active database and schema context
• Quick switching without losing your query

Query Execution

Write SQL and execute it directly against your warehouse:

• Run the full query or highlight a selection to run only that portion
• Results stream in as they are returned from the warehouse
• Execution timer shows elapsed time during long queries
• Cancel running queries at any time

Dialect-Aware Editing

The editor adapts to your connected warehouse:

• Syntax highlighting tuned to your warehouse's SQL dialect
• Autocomplete suggests tables, columns, and functions specific to your adapter
• Inline error markers for syntax issues

Results Grid

Query results display in a powerful, interactive grid:

Core Features

• Row virtualization for smooth scrolling through large result sets
• Resizable columns to fit your data
• Reorderable columns via drag and drop
• Show/hide columns to focus on what matters
• Row numbers gutter for reference

Search and Filter

• Global search across all cells in the result set
• Column statistics (count, distinct, null count, min, max) at a glance
• Pin columns to keep important fields visible while scrolling
• Cell and range copy: Select individual cells or drag to select a range, then copy to clipboard
• Wrap text toggle: Switch between truncated and wrapped cell display for long values
• Density toggle: Switch between compact, comfortable, and spacious row heights

Export

Export results in multiple formats:

Format	Description
CSV	Comma-separated values for spreadsheets
JSON	Structured data for programmatic use
TSV	Tab-separated for pasting into documents
Copy	Copy selected cells or ranges to clipboard

Chart View

Switch from table to chart view for quick visual analysis:

• Automatic chart type selection based on data shape
• Multiple chart types (bar, line, area, scatter)
• Axis and series configuration
• Open any result in a full worksheet for further exploration

Query History

Every query you run is saved in your personal query history:

• Timestamped with execution date and duration
• Scoped to your user (other team members cannot see your history)
• Searchable by query text
• Re-run any historical query with one click
• Open in worksheet to continue iterating on a past query

Keyboard Shortcuts

Shortcut	Action
Cmd/Ctrl + Enter	Run query
Cmd/Ctrl + S	Save worksheet
Cmd/Ctrl + Shift + Enter	Run selected text only
Cmd/Ctrl + W	Close current tab
Cmd/Ctrl + \	Toggle split view