BigQuery Fixturer

Create and manage BigQuery test fixtures with ease. Transform your query results into reusable test fixtures for your data warehouse testing needs.

Input JSON

Paste your BigQuery JSON output here to generate fixtures

Integration testing

If you're running BigQuery requests inside some of your applications, you likely want to test them. However if you plan to use production environment, it will come with some cost and/or potential side effects since the content is likely mutable.

Another way is to setup a test project or test dataset containing a subset of your production data. In that case, you'll have to keep those subsets relevant regarding your production data.

Yet in both cases, the test data will be hard to be maintained. That's why a pretty convenient way to work with is to inject fixtures at the beginning of your query. Applying your query on fixtures provided using "Common Table Expressions", let test it for free without any mutable data.

This tool is dedicated to make it simpler to create those fixtures using JSON data. A quick way to create a subset of data in BQ is to request your data and copy the JSON output to put it inside the input textarea and finally copy the CTE generated snippet to be used in your query.

Try these examples:

Simple object

Array of objects

Nested object

Paste your JSON data from BigQuery results

Generated Fixture

Copy this SQL snippet and use it in your BigQuery tests

Click the copy button to copy the fixture to your clipboard