estimate BigQuery usage of sql queries
Project description
bq-estimator
Estimates the data usage of SQL queries executed in BigQuery.
Returns the estimated usage in KB, MB, GB, or TB dependent on the closest multiplier.
Installation
pip install bq-estimator
Google Application Default Credentials must be set up for this tool to function.
Usage
Ready to execute SQL queries.
bq-estimator query.sql [query2.sql query3.sql …]
Options
--dbt
Takes any model selection command that is compatible with dbt
bq-estimator --dbt [dbt model selection]
--verbose -v
If errors are present the error details from BigQuery will be printed to the terminal.
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
Built Distribution
File details
Details for the file bq_estimator-1.0.1.tar.gz.
File metadata
- Download URL: bq_estimator-1.0.1.tar.gz
- Upload date:
- Size: 3.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.10.6
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 2f667cbc27a2a52ed6d30aeccb035a474f5f2e4b2a90c0cc52cb4058c5e8461a |
|
| MD5 | 7f2083eb6adc5ba5a0523d1076b6163f |
|
| BLAKE2b-256 | 674c3ec5bf1ac0b1467f2d41fb14b01e41abcd901cc512fa9d06251367eecbe1 |
File details
Details for the file bq_estimator-1.0.1-py3-none-any.whl.
File metadata
- Download URL: bq_estimator-1.0.1-py3-none-any.whl
- Upload date:
- Size: 4.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.10.6
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 8db58c3aae50075c13aa1f683de15f0fefc7f2c26eed84c67d345efd055d2f08 |
|
| MD5 | a52c94fd8db85271ca4445dd87f39757 |
|
| BLAKE2b-256 | 7f91c9ec72d9ca8cf135bf505bd9c526541b38c8eef83c35a0f88bc9716d9f7d |
