BigQuery and JsonUnit Demo

A Katalon Studio project to demonstrate how to use JsonUnit to validate BigQuery results.
Explore the docs »

Report Bug · Request Feature

Table of Contents

1. About The Project
2. Getting Started
   • Prerequisites
   • Installation
3. Usage
4. Contributing
5. License
6. Contact
7. Acknowledgments

About The Project

This project demonstrates how to use JsonUnit to validate BigQuery results. It shows how to query data from BigQuery and concert the results to JSON format. It also shows how to read a CSV or Excel file and convert it to JSON. It finally shows how to use JsonUnit to compare the contents of the query and the CSV/Excel file.

(back to top)

Getting Started

Prerequisites

This is an example of how to list things you need to use the software and how to install them.

• Katalon Studio
• A Google Cloud Platform account with BigQuery enabled
• A BigQuery project (or use the public dataset in the project)
• A BigQuery dataset (or use the public dataset in the project)

Installation

1. Clone this repo

   git clone https://github.com/katalon-studio-samples/bigquery-json-demo.git

2. Configure your BigQuery JDBC configuration in the Katalon project settings.

3. Run one of the test cases in the Test Cases folder.

(back to top)