Skip to main content

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.

Project details


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.1.tar.gz (3.7 kB view hashes)

Uploaded Source

Built Distribution

bq_estimator-1.0.1-py3-none-any.whl (4.2 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page