SQLTools for BigQuery

Query and explore BigQuery from VSCode

A VSCode extension that extends SQLTools, with a driver for Google BigQuery.

This driver is maintained by Evidence: an open-source BI tool to generate reports with SQL and Markdown.

Features

• Run queries on BiqQuery
• Explore datasets, tables and columns in the sidebar
• View table results by selecting them in the sidebar
• View stored procedures and functions in the sidebar
• Completion of common keywords (e.g. SELECT, FROM, WHERE)

Running a query

Exploring datasets, tables and columns

Not Implemented

• Auto Completion tables and columns with Intellisense

Connection Methods

Supports the following connection methods:

• Service Account
• GCloud CLI
• OAuth Access Token

For more details on the above connection methods see connection guides.

ToDo

• Add BigQuery-specific keywords
• IntelliSense for table and column completion

Contributing

Contributions are welcome. If you need help getting started, feel free to reach out on Slack in the #sqltools channel

Maintained by