python-bigquery-validator 0.0.1a6

Python module for validating BigQuery sql queries with support for Jinja templated variables

Python BigQuery Validator

Python module for validating BigQuery sql queries with support for Jinja templated variables

This package was built with the goal of automating testing of sql for Apache Airflow dags.

pip install python-bigquery-validator==0.0.1a3

python -m bigquery_validator dry_run_query 'select true'

python -m bigquery_validator -f dry_run_query -p 'select true'
render_templated_query 'select date("{{ params.date }}") as date'
validate_query 'select true'
validate_query_from_file './valid_query.sql'

Build Instructions

Build steps

python3 -m pip install --upgrade build
python3 -m build

Upload

python3 -m pip install --upgrade twine
python3 -m twine upload --repository pypi dist/*