Skip to main content

Settings

Access via gear icon in top-right corner. Settings are organized into categories with a sidebar filter on the left.

Settings Panel Settings General

General​

Appearance​

SettingOptionsDefault
ThemeSystem, Light, DarkSystem
LanguageAuto-detect, English, Japanese, German, Korean, French, Spanish, PortugueseAuto-detect
Editor Font Size12, 13, 14, 16, 18px12px
Show MinimapOn/OffOn
Zoom50-200%100%
Dark Mode

Layout:

  • Left Sidebar Width (default: 250px)
  • Config Panel Width (default: 280px)
  • Default Panel Style: Floating or Docked

Subscription​

Displays your current plan, license status, and valid-until date. Upgrade, subscribe, or manage your subscription from here.

BigQuery​

Connection settings for your BigQuery projects.

Projects​

  • Selected Projects: Toggle which BigQuery projects are visible in the schema browser
  • Manually Added Projects: Add project IDs not auto-discovered
  • Grant Additional Access: Request cloud-platform scope for full project listing

Default Billing Project​

Which project pays for query execution. Can be overridden per query in the editor status bar.

Limits & Costs​

BigQuery Limits​

Set single query limits and daily/weekly/monthly budget limits.

Single Query Limit​

SettingOptionsDefault
Max GB Per Query1GB - 10TB100GB

Default for new tabs (does not affect existing tabs). Queries exceeding this limit show a warning before running.

Budget Limits​

SettingDescriptionDefault
Daily BudgetMax GB/day (resets midnight UTC)None
Weekly BudgetMax GB/week (resets Monday 00:00 UTC)None
Monthly BudgetMax GB/month (resets 1st)None

Progress bars show usage: green, yellow, red. Budgets and limits apply only to queries run through Querylab.io.

If your organization has set limits, they appear as read-only organization limits below your personal budgets.

Cost Display​

Currency and price comparison settings.

SettingOptionsDefault
CurrencyUSD, EUR, JPYUSD
Comparison EditionDisabled, Standard, Enterprise, Enterprise PlusEnterprise

The comparison edition selects which BigQuery reservation pricing to compare against on-demand costs.

Editor​

Settings Editor Tab

Completions​

SettingOptionsDefault
TriggerAutomatic, Manual (Ctrl+Space)Automatic
StyleSmart (context-aware), Permissive (all)Smart
Ghost CompletionsOn/OffOn
Completion ChainingOn/OffOff
INFORMATION_SCHEMAOn/OffOn
BigFunctionsOn/OffOff
SnippetsOn/OffOn

BigFunctions enables community-contributed BigQuery UDFs in completions. When enabled, functions from the bigfunctions project appear alongside built-in BigQuery functions.

Text Editing​

SettingOptionsDefault
Tab Size2, 4, 8 spaces2
Insert SpacesOn/OffOn
Word WrapOff, On, BoundedOff
Auto-Close BracketsAlways, Language, Before Whitespace, NeverLanguage
Auto-Close QuotesAlways, Language, Before Whitespace, NeverLanguage
Auto-SurroundLanguage, Quotes, Brackets, NeverLanguage

Code Intelligence​

SettingOptionsDefault
Parameter Name HintsOn/OffOn
Return Type HintsOn/OffOn
Variable Type HintsOn/OffOff

Backticks​

SettingOptionsDefault
Backtick InsertionAlways, When NeededWhen Needed

SQL Formatting​

Applied when using Cmd/Ctrl+Shift+F.

SettingOptionsDefault
ModePreserve, Pretty, CompactPretty
Keyword CaseUPPER, lower, PreserveUPPER
Indent Size2, 4 spaces2
Indent StyleSpaces, TabsSpaces
Max Line LengthNumber80
Newline After ClauseOn/OffOn
Quote IdentifiersPreserve, Always, NeverPreserve
Trailing CommaOn/OffOff
Pipe Indent StyleStandard, Left-alignedStandard
Format on TypeOn/OffOff
AS KeywordInsert, PreserveInsert

SQL Frameworks​

Template language support for dbt and Dataform. See dbt Support and Dataform Support for full feature guides.

dbt​

SettingDescriptionDefault
Enable dbt ModeAuto-detect Jinja patterns and enable dbt completions, diagnostics, and compiled viewOn
Inlay HintsShow resolved values inline after Jinja expressions (e.g., ref, source, var)On

Dataform​

SettingDescriptionDefault
Enable Dataform ModeAuto-detect SQLX patterns and enable Dataform completions, diagnostics, and compiled viewOn
Inlay HintsShow resolved values inline after SQLX expressions (e.g., ref, resolve, self)On

Code Quality​

Warning Thresholds​

SettingOptionsDefault
SELECT * Warning1GB, 10GB, 100GB, 1TB, 10TB, Never1GB
Missing LIMIT Warning1GB, 10GB, 100GB, 1TB, 10TB, Never1GB
Large Table Scan1GB, 10GB, 100GB, 1TB, 10TB, Never100GB
Missing Partition FilterOn/OffOn
Missing Cluster FilterOn/OffOn

Diagnostic Rules​

Enable/disable SQL linting rules. All enabled by default except noted.

Performance (12 rules)​

  • 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.

Data & Results​

SettingDescriptionDefault
Hierarchical ColumnsDisplay STRUCTs as nested treeOff
Prompt Name on CreateAsk for tab name when creatingOff
Auto-Rename After ExecutionAI-rename after first queryOff
Skip Drill-Down PromptSkip confirmation for drill-downOff

Saved Queries​

Integration with BigQuery Saved Queries for team collaboration.

SettingDescriptionDefault
Enable Saved QueriesShow BigQuery Saved Queries in sidebarOff
Default ProjectBigQuery project for saved queriesBilling project
Default RegionRegion for saved queries storageus-central1

When enabled, saved queries appear in the schema browser and can be opened, edited, and shared with your team through BigQuery's native saved queries feature.

Privacy​

Data Storage​

SettingOptionsDefault
Tab StorageBrowser (localStorage), Backend (encrypted sync)Browser
Enable AnalyticsProduct analyticsOn

Sessions​

View and manage your active sessions. You can sign out from other devices if needed.

Credentials​

Manage your server credentials. Revoke server credentials if you need to re-authenticate.

Account​

  • Sign out
  • Revoke Google permissions
  • Delete account

AI Features​

Settings AI Features

Provider​

SettingOptionsDefault
ProviderAuto, Claude, GPT-4, GeminiAuto
ModelProvider-specific modelsAuto

Desktop users can also use CLI tools. See CLI Integration.

AI Features​

SettingDescriptionDefault
Prism AI FeaturesAI in context menus and quick fixesOn
LLM Ghost CompletionsAI-powered inline suggestions (experimental)Off
Share Results with AIAllow AI to see query resultsDisabled

Advanced​

Experimental Features​

Early-access features that may change or be removed.

SettingDescriptionDefault
Enable SpacesBigQuery Spaces integrationOff