| Name | bq-validator JSON |
| Version |
0.7.0
JSON |
| download |
| home_page | None |
| Summary | The `bq-validator` command enables us to validate BigQuery queries. |
| upload_time | 2024-05-02 00:44:38 |
| maintainer | None |
| docs_url | None |
| author | yu-iskw |
| requires_python | >=3.6.1 |
| license | None |
| keywords |
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
[](https://github.com/yu-iskw/bq-validator/actions/workflows/test.yml)
<a href="https://pypi.org/project/bq-validator" target="_blank">
<img src="https://img.shields.io/pypi/v/bq-validator?color=%2334D058&label=pypi%20package" alt="Package version">
</a>
<a href="https://pypi.org/project/bq-validator" target="_blank">
<img src="https://img.shields.io/pypi/pyversions/bq-validator.svg?color=%2334D058" alt="Supported Python versions">
</a>
# bq-validator
This is a yet another python-based BigQuery query validator.
The `bq query --dry_run` command enables us to validate queries.
However, the `bq` command doesn't support service account impersonation, even though it supports workload identity federation credentials at Google Cloud SDK 390.0.0.
The `bq-validator` command would be useful, when we take advantage of service account impersonation to validate BigQuery queries.
## Install
The package is available on [pypi](https://pypi.org/project/bq-validator/)
```bash
pip install -U bq-validator
```
## How to use
```bash
$ bq-validator --help
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:
--quota_project TEXT BigQuery client project ID
--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.
```
Raw data
{
"_id": null,
"home_page": null,
"name": "bq-validator",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6.1",
"maintainer_email": null,
"keywords": null,
"author": "yu-iskw",
"author_email": null,
"download_url": "https://files.pythonhosted.org/packages/af/fe/4d015759dcbf5b2b836d98eb3fecfe01025000fcb93aa55b2701a6c45055/bq_validator-0.7.0.tar.gz",
"platform": null,
"description": "[](https://github.com/yu-iskw/bq-validator/actions/workflows/test.yml)\n<a href=\"https://pypi.org/project/bq-validator\" target=\"_blank\">\n <img src=\"https://img.shields.io/pypi/v/bq-validator?color=%2334D058&label=pypi%20package\" alt=\"Package version\">\n</a>\n<a href=\"https://pypi.org/project/bq-validator\" target=\"_blank\">\n <img src=\"https://img.shields.io/pypi/pyversions/bq-validator.svg?color=%2334D058\" alt=\"Supported Python versions\">\n</a>\n\n\n# bq-validator\nThis is a yet another python-based BigQuery query validator.\n\nThe `bq query --dry_run` command enables us to validate queries.\nHowever, the `bq` command doesn't support service account impersonation, even though it supports workload identity federation credentials at Google Cloud SDK 390.0.0.\nThe `bq-validator` command would be useful, when we take advantage of service account impersonation to validate BigQuery queries.\n\n## Install\nThe package is available on [pypi](https://pypi.org/project/bq-validator/)\n```bash\npip install -U bq-validator\n```\n\n## How to use\n\n```bash\n$ bq-validator --help\n\nUsage: bq-validator [OPTIONS] PATH\n\n Validate BigQuery queries\n\n PATH is either of a SQL file path or a directory. When it is a directory,\n the command recursively validates all SQL files in the directory.\n\nOptions:\n --quota_project TEXT BigQuery client project ID\n --client_project TEXT BigQuery client project ID\n --client_location TEXT BigQuery client location\n --impersonate_service_account TEXT\n Impersonate service account email\n --version Show the version and exit.\n --help Show this message and exit.\n```\n",
"bugtrack_url": null,
"license": null,
"summary": "The `bq-validator` command enables us to validate BigQuery queries.",
"version": "0.7.0",
"project_urls": null,
"split_keywords": [],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "8ab13075108e4d809da8f751bf60d05930101d7e36263d798044aa44a9b7b684",
"md5": "76bd1fb54c5ce52c76d6723caacf44fe",
"sha256": "67115d28e2e141b093422f3fe084814c24b8dbcb747f18c43fffeb3f4f53d03a"
},
"downloads": -1,
"filename": "bq_validator-0.7.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "76bd1fb54c5ce52c76d6723caacf44fe",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6.1",
"size": 11153,
"upload_time": "2024-05-02T00:44:36",
"upload_time_iso_8601": "2024-05-02T00:44:36.854459Z",
"url": "https://files.pythonhosted.org/packages/8a/b1/3075108e4d809da8f751bf60d05930101d7e36263d798044aa44a9b7b684/bq_validator-0.7.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": null,
"digests": {
"blake2b_256": "affe4d015759dcbf5b2b836d98eb3fecfe01025000fcb93aa55b2701a6c45055",
"md5": "e1845693e9264fb26f04def90b0b925a",
"sha256": "b9b0bf8268125932bb69c3b38ab6b6d4f6e5b0290c50cff74752fd1c39ccceca"
},
"downloads": -1,
"filename": "bq_validator-0.7.0.tar.gz",
"has_sig": false,
"md5_digest": "e1845693e9264fb26f04def90b0b925a",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6.1",
"size": 24240,
"upload_time": "2024-05-02T00:44:38",
"upload_time_iso_8601": "2024-05-02T00:44:38.390805Z",
"url": "https://files.pythonhosted.org/packages/af/fe/4d015759dcbf5b2b836d98eb3fecfe01025000fcb93aa55b2701a6c45055/bq_validator-0.7.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-05-02 00:44:38",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "bq-validator"
}
