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
