Skip to main content

Query Results

Interactive grid for viewing and analyzing query output.

Grid Features​

Column Operations​

  • Sort: Click header (click again for descending)
  • Filter: Click filter icon in header
  • Resize: Drag column border (double-click to auto-fit)
  • Reorder: Drag header to new position
  • Hide: Right-click header → Hide column

Hide Null Columns​

Click "Hide null columns" in toolbar to hide columns where all values are NULL.

Nested Data (ARRAY, STRUCT)​

Click cells containing complex types to expand:

[Click to expand] →
  [0]: {name: "Alice", age: 30}
  [1]: {name: "Bob", age: 25}

Right-click → "Expand all" for recursive expansion.

Copying Data​

WhatHow
CellClick cell → Cmd/Ctrl+C
RowClick row number → Cmd/Ctrl+C
ColumnClick header → Cmd/Ctrl+C
AllCmd/Ctrl+A → Cmd/Ctrl+C

Export​

Click Export in toolbar:

  • CSV: Comma-separated with headers
  • JSON: Array of objects

For large results (>100K rows), export directly from BigQuery to Cloud Storage.

Pagination​

  • Controls: First / Prev / Page X of Y / Next / Last
  • Rows per page: 100, 250, 500, 1000
  • Pages load on-demand
Showing 1-100 of 1,234 rows | 45.2 MB processed | 2.3s

Shows row count, bytes scanned, and execution time.