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
An installation of dbt-bigquery is required for using this functionality.
Takes any model selection command that is compatible with dbt
bq-estimator --dbt [dbt model selection]
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_estimator-1.0.0.tar.gz
(3.4 kB
view hashes)
Built Distribution
Close
Hashes for bq_estimator-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 071edaf853fa78340cab81f4ca6ba10565aa74f691fed389acaacf9f6fd29c6f |
|
MD5 | 915eb31f12b4864dbfbf5e2ab2f58e29 |
|
BLAKE2b-256 | 576b9f24be4ccf9aa24595e2bd94aa612268f7f2d4c64be782d9a34b6bf0367b |