Results grid
Query output lands in a grid under the editor. It sorts and filters in place, pages through large results, and switches to Json mode or the job's metadata — everything you'd otherwise open the BigQuery console for.
| make⏷ | fuel_type⏷ | total_tests⏷ | pass_rate⏷ | rank_in_fuel⏷ | |
|---|---|---|---|---|---|
| 1 | ALFA ROMEO | Diesel | 1331 | 72.2 | 43 |
| 2 | AUDI | Diesel | 60537 | 80.29 | 11 |
| 3 | AUTO-TRAIL | Diesel | 180 | 75.56 | 29 |
| 4 | BMW | Diesel | 73542 | 80.81 | 10 |
| 5 | CHAUSSON | Diesel | 103 | 89.32 | 1 |
| 6 | CHRYSLER | Diesel | 498 | 71.69 | 48 |
| 7 | DACIA | Diesel | 4088 | 73.83 | 35 |
| 8 | FORD | Diesel | 143675 | 75.16 | 32 |
Sorting, filtering and arranging columns
| Action | How |
|---|---|
| Sort | Click the header; again for descending; a third time clears |
| Multi-sort | Shift-click more headers |
| Filter | The filter icon in the header — text, number and date filters, depending on the column type |
| Resize | Drag the header edge; double-click to fit the content |
| Reorder | Drag the header |
| Pin, format, copy name | Right-click the header |
Format appears on numeric columns only: None, Standard, Compact, Currency, Percentage, Scientific, Bytes, with a live preview of a value from the column. Pin column offers Pin Left, Pin Right, Unpin. Widths, order, pins, sorts, filters and formats are saved per tab and come back with it.
There is no per-column hide. To drop the columns that are entirely NULL, use the eye button in the footer — its tooltip counts them (Hide 3 null column(s)), and it stays highlighted while they’re hidden.
Finding rows
⌘F with the grid focused opens a search box in place of the pager. It matches any column and filters as you type; Esc closes it and clears the filter.
Paging
The footer shows 1-50 of 4,213 rows. Pick the page size from the button next to the pager — 20, 50, 100 or 1000 — and jump to a random page with the shuffle button on the far left, handy for eyeballing a large result. Narrow panels swap the numbered pager for a Go to page box.
Nested and repeated fields
STRUCT and ARRAY values are pretty-printed as JSON inside the cell, and rows with identical values in adjacent cells are merged vertically. To show STRUCT fields as grouped columns instead (corporate → parent_company, country_of_origin), turn on Settings → Data & Results → Group nested columns.
| make_key⏷ | make_name⏷ | corporate.parent_company⏷ | corporate.country_of_origin⏷ | |
|---|---|---|---|---|
| 1 | GAZMO AMLO 1.9 | GAZMO AMLO 1.9 | null | Other |
| 2 | MORRIS8 | MORRIS8 | null | Other |
| 3 | HONDA ST70 | HONDA ST70 | Honda Motor Co. | Japan |
| 4 | CHRYSLER -JEEP | CHRYSLER -JEEP | Stellantis | USA |
Values longer than the cell are cut; the tooltip says so and points you to export for the full value.
Copying out of the grid
The grid has no cell selection — ⌘C on a cell does nothing. Instead:
| What | How |
|---|---|
| The current page, tab-separated | Copy to clipboard in the footer |
| The result table’s path | ⌘-click the same button, or the Drill Down button |
| A column name | Right-click the header → Copy column name |
| Up to 1,000 rows as TSV or a Slack table | Export → Clipboard |
| The visible rows as an image | ⌘K → Copy results as image |
More formats and destinations are on the Export page.
Drill down
Every query result lives in a temporary BigQuery table. Drill Down (the split icon) opens SELECT * FROM that table in a new tab beside the current one, so you can filter and aggregate the result without paying for the original scan again. If the tab is already split you’re asked which side to replace. ⌘-click copies the table path instead of opening it.
View modes
The last footer button switches the view. Its tooltip names the current one.
| Mode | Shows |
|---|---|
| Table | The grid above |
| Json | The rows as a JSON array, syntax-highlighted; the copy button copies the JSON |
| Info | The job: status, job id, user, location, timing and duration, billing model and reservation, bytes processed and billed, slot time, rows returned, cache hit |
| Graph | Only for GQL results — nodes and edges. See Graph queries |
| Chart | Only when the query carries a chart spec. See Charts |
[ { "make": "CHAUSSON", "fuel_type": "Diesel", "total_tests": 103, "pass_rate": 89.32, "rank_in_fuel": 1 }, { "make": "SCANIA", "fuel_type": "Diesel", "total_tests": 447, "pass_rate": 87.7, "rank_in_fuel": 2 } ]
The Query History button next to the search opens the tab’s history panel — every version of the SQL you ran here, with its results. See Query history.