Skip to content

Easily transform your BigQuery data in BQ SQL CET statements to use them directly in your queries

License

Notifications You must be signed in to change notification settings

Kayrnt/bq_fixturer

Repository files navigation

bq_fixturer

Introduction

This project is born from some frustration regarding integration testing with BigQuery. It's often hard to ensure we're using the right data and have fixtures related to your development branches (it tends to add a lot of tables that you then forget, become obsolete and the rest of the team doesn't know if they can clean up).

So I started to make some manual fixtures for my project out of some production like data. Yet it's pretty tedious to transform the output of a query to something that can be reused, that I often gave up testing some cases (and to find out - obviously - that I shouldn't have skipped them) to meet time to market expectations.

So reducing the testing phase time, I hope that I can improve the coverage of my queries since it often contains most of the business logic (to reduce the load on the http server).

It can save quite some time to you as well, so here we go: Try it yourself

Build & run

yarn install && yarn start

Test

yarn test

Package

yarn build

About

Easily transform your BigQuery data in BQ SQL CET statements to use them directly in your queries

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published