This is a Visual Studio Code extension for standardSQL, which is a SQL dialect supported by BigQuery. The language server itself is also available by other editors.

• Complete table names (when quoted by ` ), column names (in SELECT statement) and functions
• Show hover information about tables and functions
• Dry run on save and show total bytes processed
• Format source code using prettier-plugin-bq (Shift+Alt+F)
• Language configuration and syntax highlight (mostly based on sql, but slightly adjusted)

1. Install Google Cloud SDK
2. Run gcloud auth login gcloud auth application-default login gcloud config set project $YOUR_PROJECT
3. Install this extension from VSCode
4. Open a file (xxx.bq or xxx.bigquery)
5. Update cache (see the usage section)

The first thing you should do after installation is to update cache. Run BQExtensionVSCode: Update Cache from command palette and the information about datasets and tables will be stored in local directory (~/.bq_extension_vscode/). In this process, this extension runs several queries against INFROMATIN_SCHEMA. Note that datasets which does not appear in your query will be ignored to reduce cost.

This extension assumes that the file name is xxx.bq or xxx.bigquery. If you are editting a file named xxx.sql, you have to map *.sql to bigquery this way.

// settings.json
{
  "files.associations": {
    "*.sql": "bigquery",
  },
}

I'm not ready to accept pull requests, but your feedback is always welcome. If you find any bugs, please feel free to create an issue.