Skip to main content

SQL testing tool for Google BigQuery

Project description

SQL testing tool for Google BigQuery.
this library is pre-alpha. not recommended to production use.

Getting Started

pip install bqspec
gcloud auth application-default login

How to Use

spec.yaml

# test target SQL filepath
query_path: ./sample.sql
# any BigQuery query parameters (optional). more details: https://cloud.google.com/bigquery/docs/parameterized-queries
params:
    - type: DATE
      name: date
      value: 2017-11-30
# known columns (optional).
columns:
    - id
    - a
    - b
    - c
    - total
# conditions which all rows must met (optional).
invariants:
    - total >= 0  # write python expression
    - a + b == c
# any test cases
cases:
    - where:
      - id == 1
      expected:
      - total == 15
      - a == 2
      - b == 3
      - c == 5
bqspec -f spec.yaml

or

bqspec -d .

Author

@orisano (Nao YONASHIRO)

License

MIT

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for bqspec, version 0.3.3
Filename, size File type Python version Upload date Hashes
Filename, size bqspec-0.3.3-py2.py3-none-any.whl (10.6 kB) File type Wheel Python version py2.py3 Upload date Hashes View hashes
Filename, size bqspec-0.3.3.tar.gz (8.5 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page