This article will help you understand the various options you have in your query tab settings.
Click on the Settings gear icon at the top right of your screen to open query tab settings, as shown below.
A slideout will appear, showing your Query Tab settings:
Let's go over each of the options:
This is the project to be billed when you execute a query in the active tab.
By default, "Auto" mode is selected. This pulls your current project from your SQL.
If you need to bill another project, select your project from the dropdown list.
This lets you toggle between Standard and Legacy SQL dialects, as well as superQuery's "Auto-Detect" mode.
The default setting is "Auto-Detect" mode, which automatically detects your SQL syntax from your query and makes sure it runs correctly. This also replaces the necessity to put #standardSQL or #legacySQL.
You have three options for caching:
“SuperQuery” — executes your query leveraging superQuery's enhanced caching if you have it set up.
“BigQuery” — executes your query without applying any enhanced cost-saving logic.
“Off” — executes your query using superQuery's query optimization algorithm, but without caching.