Ultimate access to all questions.
After migrating ETL jobs to BigQuery, it is your responsibility to ensure the migrated job outputs match the original job outputs. To do this, you have already loaded a table containing the original job’s output and now need to compare it with the output from the migrated job to confirm they are identical. Given that the tables lack a primary key column necessary for a straightforward join, how should you proceed with the comparison?