Access via gear icon in top-right corner.
Appearance
| Setting | Options | Default |
|---|
| Theme | System, Light, Dark | System |
| Editor Font Size | 12, 13, 14, 16, 18px | 12px |
| Show Minimap | On/Off | On |
| Zoom | 50-200% | 100% |
Layout:
- Left Sidebar Width (default: 250px)
- Config Panel Width (default: 280px)
- Default Panel Style: Floating or Docked
Editor
Completions
| Setting | Options | Default |
|---|
| Trigger | Automatic, Manual (Ctrl+Space) | Automatic |
| Style | Smart (context-aware), Permissive (all) | Smart |
| Ghost Completions | On/Off | On |
| Completion Chaining | On/Off | Off |
| INFORMATION_SCHEMA | On/Off | On |
| Snippets | On/Off | On |
Text Editing
| Setting | Options | Default |
|---|
| Tab Size | 2, 4, 8 spaces | 2 |
| Insert Spaces | On/Off | On |
| Word Wrap | Off, On, Bounded | Off |
| Auto-Close Brackets | Always, Language, Before Whitespace, Never | Language |
| Auto-Close Quotes | Always, Language, Before Whitespace, Never | Language |
| Auto-Surround | Language, Quotes, Brackets, Never | Language |
Code Intelligence
| Setting | Options | Default |
|---|
| Parameter Name Hints | On/Off | On |
| Return Type Hints | On/Off | On |
| Variable Type Hints | On/Off | Off |
Backticks
| Setting | Options | Default |
|---|
| Backtick Insertion | Always, When Needed | When Needed |
Applied when using Cmd/Ctrl+Shift+F.
| Setting | Options | Default |
|---|
| Mode | Preserve, Pretty, Compact | Pretty |
| Keyword Case | UPPER, lower, Preserve | UPPER |
| Indent Size | 2, 4 spaces | 2 |
| Indent Style | Spaces, Tabs | Spaces |
| Max Line Length | Number | 80 |
| Newline After Clause | On/Off | On |
| Quote Identifiers | Preserve, Always, Never | Preserve |
| Trailing Comma | On/Off | Off |
| Pipe Indent Style | Standard, Left-aligned | Standard |
| Format on Type | On/Off | Off |
| AS Keyword | Insert, Preserve | Insert |
Cost Control
Query Limits
| Setting | Options | Default |
|---|
| Max GB Per Query | 1GB - 10TB | 100GB |
Queries exceeding this limit show a warning before running.
Warning Thresholds
| Setting | Options | Default |
|---|
| SELECT * Warning | 1GB, 10GB, 100GB, 1TB, 10TB, Never | 1GB |
| Missing LIMIT Warning | 1GB, 10GB, 100GB, 1TB, 10TB, Never | 1GB |
| Large Table Scan | 1GB, 10GB, 100GB, 1TB, 10TB, Never | 100GB |
| Missing Partition Filter | On/Off | On |
| Missing Cluster Filter | On/Off | On |
Budget Limits
| Setting | Description | Default |
|---|
| Daily Budget | Max GB/day (resets midnight UTC) | None |
| Weekly Budget | Max GB/week (resets Monday 00:00 UTC) | None |
| Monthly Budget | Max GB/month (resets 1st) | None |
Progress bars show usage: green → yellow → red.
Diagnostic Rules
Enable/disable SQL linting rules. All enabled by default except noted.
- SELECT * on Large Table
- Missing Partition Filter
- Missing Cluster Filter
- Missing LIMIT on Large Table
- Large Table Scan
- Cross Join Detected
- JOIN with OR Condition
- ORDER BY Without LIMIT
- COUNT(DISTINCT) Performance
- Clustering Order Suboptimal
- Wildcard Table Scan Without Filter
- Suggest Table Alias (disabled by default)
- Suggest QUALIFY (disabled by default)
Correctness (16 rules)
- Aggregate in WHERE
- HAVING Without GROUP BY
- Non-Aggregated Column
- Nested Aggregate
- Window Function in WHERE
- QUALIFY Without Window Function
- SELECT * with GROUP BY
- ORDER BY Invalid Position/Not in SELECT/Out of Range
- NULL Comparison with Equals
- CASE Type Inconsistency
- Non-Boolean WHERE
- Missing Join Condition/ON
Code Quality (3 rules)
- Unused CTE
- Duplicate CTE
- Duplicate Column Alias
Semantic (14 rules)
- Undefined Column/Table/CTE
- Ambiguous Column Reference
- Duplicate Column/Table Alias
- Invalid Hierarchical Name
- CTE Shadows Table (disabled by default)
- And more...
Modern Syntax (4 rules)
- Suggest QUALIFY Over Subquery
- Suggest COALESCE Over IF NULL
- Suggest LIKE ANY Over OR
- Suggest Implicit CROSS JOIN
These rules suggest modern BigQuery syntax alternatives. All disabled by default — enable in Settings.
See Code Quality for detailed rule descriptions.
AI Settings
Provider
| Setting | Options | Default |
|---|
| Provider | Auto, Claude, GPT-4, Gemini | Auto |
| Model | Provider-specific models | Auto |
Desktop users can also use CLI tools. See CLI Integration.
AI Features
| Setting | Description | Default |
|---|
| Prism AI Features | AI in context menus and quick fixes | On |
| LLM Ghost Completions | AI-powered inline suggestions (experimental) | Off |
| Share Results with AI | Allow AI to see query results | Disabled |
Query Results
| Setting | Description | Default |
|---|
| Hierarchical Columns | Display STRUCTs as nested tree | Off |
Tab Behavior
| Setting | Description | Default |
|---|
| Prompt Name on Create | Ask for tab name when creating | Off |
| Auto-Rename After Execution | AI-rename after first query | Off |
| Skip Drill-Down Prompt | Skip confirmation for drill-down | Off |
Data Storage
| Setting | Options | Default |
|---|
| Tab Storage | Browser (localStorage), Backend (encrypted sync) | Browser |
| Enable Analytics | Product analytics | On |
Pricing
| Setting | Options | Default |
|---|
| Currency | USD, EUR, JPY | USD |
| Comparison Edition | Disabled, Standard, Enterprise, Enterprise Plus | Enterprise |
Used for on-demand vs slot-based pricing comparisons.
Projects
- Billing Project: Which project pays for queries
- Selected Projects: Your accessible BigQuery projects
- Manual Projects: Manually added project IDs
Account
- Sign out
- Revoke Google permissions
- Delete account