Skip to content

Latest commit

 

History

History

vscode_query_breakdown

README.md

VSCode Query Breakdown

This directory contains the code for the VSCode Extension/Frontend version of the Query Breakdown tool

Requirement

The latest backend version of the tool, which can be found in the query_breakdown folder in bigquery-utils/tools, must exist in jar format in resources/query_breakdown/bin folder as "query_breakdown.jar".

Usage

Run the extension using the VSCode UI, and in the Extension Development Host window, open the txt file that contains the queries and press the button on the left menu bar under Query Breakdown that says "Find Unparseable Components" or use the Command Palette to run the Query_Breakdown command.

When the extension is run, a message that the extension is running ("Finding Unparseable Components") will show on the bottom right. When finished, the unparesable and paresable components of the queries in the txt file will be highlighted, the runtime and performance metric will pop up on the bottom right, and an output.txt file will be created/overwritten.

Through toolconfig.json, the runtime spent on each query as well as the number of replacements recommended can be configured.