CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerygoogle-cloud-sql
Raunak Jhawar
Raunak Jhawar

Reputation: 1651

SQL procedure support for Cloud Big Query

We are trying to explore solutions which would allow us to create dynamic SQL's with multiple joins and complex SQL's involving parameters to run on Cloud BigQuery.

I have read online about federated queries which allow accessing Cloud SQL datasets from within Cloud Big Query, but is it possible to have this run the other way around i.e. use big query datasets within Cloud SQL so that native options of procedural SQL's can be used.

Largely, the purpose of these procedural SQL's is to perform large and complex pivots and run parameterized SQL's

Upvotes: 0

Views: 164

Answers (2)

Mikhail Berlyant
Mikhail Berlyant

Reputation: 173190

The ability to use scripting and stored procedures is now in Beta.

So, you can send multiple statements to BigQuery in one request, to use variables, and to use control flow statements such as IF and WHILE, etc.
And, you can use procedure, which is a block of statements that can be called from other queries.

Note: it is Beta yet

Upvotes: 1

Graham Polley
Graham Polley

Reputation: 14791

To answer your question, no, you cannot read BigQuery data from Cloud SQL. At the moment, it's just one way i.e BigQuery can read from Cloud SQL.

Upvotes: 2

Related Questions