Scenario: You need to create a SQL pipeline that gcp video
data-engineer-pro video for scenario: You need to create a SQL pipeline that runs an aggregate SQL transformation on a BigQuery table every two hours and
Question 1
Be Honest
Answer
Full Certification Question
Scenario: You need to create a SQL pipeline that runs an aggregate SQL transformation on a BigQuery table every two hours and appends the result to another existing BigQuery table. The pipeline must be configured to retry if errors occur, and it should send an email notification after three consecutive failures. Question: What should you do to meet these requirements?