winwiz1
winwiz1
Hi Team, The output of this statement in BigQuery ``` SELECT COUNT(DISTINCT country_name) from bigquery-public-data.covid19_open_data.covid19_open_data UNION ALL SELECT COUNT(DISTINCT country_name) FROM bigquery-public-data.covid19_open_data.covid19_open_data WHERE aggregation_level = 0 AND cumulative_recovered IS NOT...
The index `CH_GE` has 7250 invalid rows covering years `2000-2019` and the index `TH` has a row for the date `2019-12-31` with data also not quite meaningful. As suggested in...
Would be good to have a staging bucket and copy files from there to the current production bucket after the data has been validated by a data validation utility, for...