We developped this open source project to tackle the exact same problem. This is a framework for writing testable BigQuery queries: https://github.com/Tufin/espresso
Please give us your feedback.
From the Security Policy Company. This blog is dedicated to cloud-native topics such as Kubernetes, cloud security and micro-services.