You have recently migrated your ETL workflows to gcp video
data-engineer-pro video for you have recently migrated your ETL workflows to run on BigQuery. To ensure correctness, you need to verify that the output data
Question 1
Be Honest
Answer
Full Certification Question
You have recently migrated your ETL workflows to run on BigQuery. To ensure correctness, you need to verify that the output data from the migrated jobs exactly matches the output produced by the original ETL jobs. You’ve loaded the original job’s results into a BigQuery table. However, neither table contains a primary key, so you cannot use a direct join for row-by-row comparison. How can you verify that the contents of the two tables are identical?