PigQuery

PigQuery is a productivity extension for Google BigQuery that helps you write, reuse, share, and explore SQL queries more efficiently.

With PigQuery you can:

• Insert saved queries and reusable SQL snippets into the BigQuery editor using keyboard shortcuts, making long table names, common joins, and complex query fragments easy to reuse

• Interact with query results by opening cell values in external sites and formatting cell data (for example JSON payloads or timestamps)

• Share in-progress queries via URL by generating a link that contains the full contents of the current editor, without saving or manually copying SQL

• Configure snippets and sites using YAML, either locally or from remote URLs with automatic updates for team-wide sharing