java - Mocking Bigquery for integration tests -

while other interfaces relatively easy mock in java integration tests, couldn't find proper way of mocking bigquery.

one possibility mock layer wrote on top of bigquery itself, prefer mocking bigquery in more natural way. i'm looking limited, lightweight implementation, allows defining table contents, , supports queries using standard api. there such library? if not, alternative approaches recommended?

in unit testing fine mock external dependencies, , long using interfaces abstract out access bigquery client, mocking should not issue.

with integration testing rather 3rd parties dependencies tested extend application needs it.

for instance 1 case etl streams data external sources bigquery, in case integration test needs verify data in bigquery expected, means verification stage needs take account repeated, , nested messages needed.

another case application runs business sqls, in case have populate bigquery test data before applicaiton run, applicaiton needs publishe sql output either view/new table/or stream out of data out of verification.

there libraries taking care of integration testing datastores including bigquery/nosql/sql

they provide easy solution cases described above , full support sql, dynamic macro/predicate etc ....

1. dsunit (go-lang)
2. jdsunit (java)

if datastore integration test library not option , looking testing bigquery client, news client uses rest, using network sniffers can easy record being send , forth, can use in replayer. in order redirect bigquery public bg endpoints replayer use http java proxy.