Versions Compared

Old Version 6

changes.mady.by.user Former user

Saved on

compared with

New Version 7

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section describes the transaction behavior of the GCP BigQuery agent. For more information about general transactions, see, Transactions, in Workflow Monitor.

...

Info
titleExample - View Joining Data Table and Batch Status Table

The following DDL query is used in the BigQuery Query Editor to create a view under the user_analytics Dataset with the table named view1.

Code Block
CREATE VIEW IF NOT EXISTS user_analytics.view1 AS
SELECT * FROM user_analytics.data_tbl1 AS t1
FULL JOIN user_analytics.batch_status_tbl1 AS t2
USING (id)  WHERE t2.status = 0;



Input/Output data 

The agent emits commands that change the state of the file currently processed.

...