SQL queries (or programs) for BigQuery may be hard to maintain over time. This scala library focusing on adding a higher-level API with focus on correctness, maintainability and testability. It's heavily inspired by doobie which is a pure functional abstraction over JDBC.
What does this library include:
- A scala DSL where we can construct BigQuery SQL.
- A test rig that gives the developer fast feedback using snapshot testing.
- Documentation of the generated through snapshot testing.
- Deploy, upgrade and maintain table, views and UDFs.