Notification Schema Change task failing with Avro file not found an error for staging tables

Description

CAPL - Bug default text according to the team DoR (Definition of Ready)

01 - PERSON OF CONTACT (PERSON THAT CAN ANSWER QUESTIONS ABOUT THE PROBLEM):

@Douglas Coimbra Lopes

02 - PROBLEM (WHAT'S THE ISSUE?):

  • Notification Schema Change tasks are failing for staging tables
  • GCP: [https://console.cloud.google.com/logs/query;query=e6d3ebfcec004001bb9531df2ff4ae82
    severity>%3DERROR;cursorTimestamp=2023-09-28T11:41:27.134Z;startTime=2023-09-28T11:17:03.010Z;endTime=2023-09-28T12:02:03.010Z?project=labs-app-mdm-qa|https://console.cloud.google.com/logs/query;query=e6d3ebfcec004001bb9531df2ff4ae82%0Aseverity%3E%3DERROR;cursorTimestamp=2023-09-28T11:41:27.134Z;startTime=2023-09-28T11:17:03.010Z;endTime=2023-09-28T12:02:03.010Z?project=labs-app-mdm-qa]

03 - STEPS TO REPRODUCE (STEP (1...N), VIDEO, SCREENSHOTS, LOGS FOLDER, HEARTBEAT, ETC. – IF IS NOT POSSIBLE TO REPRODUCE EXPLAIN THE REASON):