Skip to content

Latest commit

 

History

History
55 lines (32 loc) · 2.26 KB

README.md

File metadata and controls

55 lines (32 loc) · 2.26 KB
Raw

License: MIT Visual Studio Marketplace Downloads Visual Studio Marketplace Last Updated

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.

Connect DB

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

Run Query

Exploring datasets, tables and columns

Explore DB

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