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?