Verify whether the data from the CDC needs to be standardized for the aggregated table.
If needed, create or modify job to update the data in BigQuery using SQL.
[Investigation/Experimentation] Does it make sense to standardize the data on arrive, before putting it in BigQuery?
Verify whether the data from the CDC needs to be standardized for the aggregated table. If needed, create or modify job to update the data in BigQuery using SQL.
[Investigation/Experimentation] Does it make sense to standardize the data on arrive, before putting it in BigQuery?