반응형 Build and Optimize Data Warehouses with BigQuery: Challenge Lab1 [GSP] QWIKLABS GSP787 - Build and Optimize Data Warehouses with BigQuery: Challenge Lab project id의 프로젝트에 'covid' 데이터셋 생성 Query 1 create table covid.oxford PARTITION BY date OPTIONS( partition_expiration_days=90 ) as SELECT * FROM `bigquery-public-data.covid19_govt_response.oxford_policy_tracker` where 1=1 and alpha_3_code not in ('GBR', 'USA') ; Query 2 ALTER TABLE covid.oxford ADD COLUMN IF NOT EXISTS population INT64, ADD COLUMN IF NOT EXISTS country_area FLOAT64, ADD COLUMN mob.. 2020. 12. 29. 이전 1 다음 반응형
