New Feature
12 days ago

Inline Query Profiling: Column Stats & Data Distribution on Every Result

Run a query, get a full data profile, automatically. The new Profile view turns any query result into an instant statistical breakdown with per-column distributions, completeness checks, and issue detection. No extra queries, no separate profiling tools.

What you see at a glance
Every column in your result set is listed with its data type, value range, a mini distribution chart, and a completeness indicator, all in one scrollable view. A summary bar at the top shows overall completeness, flags columns with potential issues, and breaks down column types (numeric, string, date, etc.) so you can spot problems before they reach downstream.

Drill into any column
Expand a column to get the full picture: non-null and null counts, completeness percentage, distinct values, min/max, mean, median, quartiles (Q1, Q3), IQR, standard deviation, skewness, sum, and an interactive histogram showing value distribution. For categorical columns, you can load top values to see frequency breakdowns.

Why it matters
Data profiling usually means writing dedicated queries or exporting to a separate tool. Now it's built into the query workflow, run your SQL, click Profile, and immediately understand the shape of your data. Catch missing values, skewed distributions, or unexpected ranges before they become pipeline bugs. It works with every engine: DuckDB, Trino, and Spark SQL.

Where to find it
Run any query in the SQL Editor, then switch to the Profile tab in the results panel (next to the table and chart views).

Introduced in 6.7.0