CODEWITHSUNDEEP
google-bigquery
denim
denim

Reputation: 463

Schedule a sequence of DML statements in BigQuery

I've created a BQ table and need to schedule a series of DML statements on it (inserts & merge). I am trying to replicate the Oracle PL/SQL functionality where you can group DML statements into a single procedure that can be scheduled.

So, the goal is (i) group a series of DML statements into a script, and (ii) schedule the script for execution. Thank you in advance for any help.

Upvotes: 0

Views: 903

Answers (1)

Yun Zhang
Yun Zhang

Reputation: 5503

Scripting is supported in scheduled query now. However, scripting query, when being scheduled, doesn't support setting a destination table for now. You still need to use DDL/DML to make change to existing table.

CREATE OR REPLACE destinationTable AS
SELECT *
FROM sourceTable
WHERE date >= maxDate

Upvotes: 1

Related Questions