This extension run a GCP BQ dry run on save document event. Also you can run a query and show results in a new document.
Features
Extension to execute dry runs and query jobs from editor
Requirements
You only need to login with a GCP account or use a json credential file to connect to BQ.
Extension Settings
This extension contributes the following settings:
bqDryRun.gcpProjectConfigs: GCP project configurations where queries will run. One object like below will be added to user settings json when you add a new environment enabling extension from command palette.
"bqDryRun.gcpProjectConfigs": [
{
"envName": "name to identify environment in vs code",
"projectId": "gcp-project-id(not required)",
"credentialsPath": "/path/to/sa.json(not required)",
"replaceVarPaths": [
"/path/to/file/with/replacement/variables.conf(not required)",
]
}
]
bqDryRun.stringsToClean: strings to be removed from query before run
"bqDryRun.stringsToClean": [
"sql="
]
bqDryRun.outputFormat: format for query output, options:
