The `bq-validator` command enables us to validate BigQuery queries.
Project description
bq-validator
This is a yet another BigQuery query validator.
The bq query --dry_run
command enables us to validate queries.
However, the bq
command doesn't support OIDC and impersonate service account.
When we take advantage of OIDC and impersonate service account, the bq-validator
command would be useful.
Install
The package is available on pypi
pip install -U bq-validator
How to use
Usage: bq-validator [OPTIONS] PATH
Validate BigQuery queries
PATH is either of a SQL file path or a directory. When it is a directory,
the command recursively validates all SQL files in the directory.
Options:
--client_project TEXT BigQuery client project ID
--client_location TEXT BigQuery client location
--impersonate_service_account TEXT
Impersonate service account email
--version Show the version and exit.
--help Show this message and exit.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
bq-validator-0.5.1.tar.gz
(18.3 kB
view hashes)
Built Distribution
Close
Hashes for bq_validator-0.5.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 92f067c41ed8b4be0ea1841b44a7eaf6e3254d248d88e025c5a4be2cd5c479f7 |
|
MD5 | 9f9b72d23e6f1f2d13e75a6d6d37aa68 |
|
BLAKE2b-256 | 87498f8d31395d0b676810ff4495bebb8a2e6d7b2a6e0d8764b879bfa273aba3 |