data-engineer-pro video for scenario: You have data stored in BigQuery that is used for generating company reports. However, some fields in the weekly executive
Scenario: You have data stored in BigQuery that is used for generating company reports. However, some fields in the weekly executive reports are not formatted according to company standards. Issues include inconsistent telephone formats and differing country code identifiers. Since this is a recurring issue, you need to set up a regular job to normalize the data without requiring coding. Question: What should you do to quickly set up a recurring job to normalize the data?