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.2.1.tar.gz
(18.3 kB
view hashes)
Built Distribution
Close
Hashes for bq_validator-0.2.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 266d5ea055b72609a12dc328312ed9e1ba7b5b93dd43c5106497d2a871e28d33 |
|
MD5 | b5b8c278bfbd36dec565f0cd5b38beaf |
|
BLAKE2b-256 | 604267c252d7b05a7ee960717205e4699ab08bd1a023b82e960eb9ec170a412b |