As stated in Wikipedia: "BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data." I'm a big fan of the technology, and have used it a lot in many projects for my company.

Mathematica hasn't a native way to talk to BigQuery, and I would like to share here the first version of a package that I have made to retrieve BigQuery data using it rest API. The hardest part here was to get the token from the Google JWT file. I would like to thanks @Pedro Cabral for his contribution with the authentication (more details in this post).

Here is the link for the package (we will put it in a git soon).

After configure your credentials in the JWT json file, you can use it as:

Needs["Bigquery`"]
bigqueryExecute["SELECT * FROM UNNEST(['foo', 'bar', 'baz']) AS element"]

{<|element->foo|>,<|element->bar|>,<|element->baz|>}