How To Load GCS Data To BigQuery | SQL Query
Автор: CK Data Tech
Загружено: 2023-11-17
Просмотров: 366
Описание:
Video demo on how to use SQL query to load data to BigQuery from GCS.
Here is the Kaggle link for the dataset I used in the demo: https://www.kaggle.com/datasets/iamso...
Below is the query I used to load the data:
-- Can replace OVERWRITE with INTO if you want to append data instead
LOAD DATA OVERWRITE `project_id.dataset_id.table_name` (
CustomerID INT64
,Age INT64
,Gender STRING
,ItemPurchased STRING
,Category STRING
,PurcharseAmount FLOAT64
,Location STRING
,Size STRING
,Color STRING
,Season STRING
,ReviewRating FLOAT64
,SubscriptionStatus STRING
,ShippingType STRING
,DiscountApplied STRING
,PromoCodeUsed STRING
,PreviousPurchases INT64
,PaymentMethod STRING
,FrequencyOfPurchases STRING
)
FROM FILES (
format = 'CSV',
skip_leading_rows = 1,
uris = ['gcs_file_uri']
)
#gcs #bigquery #sql #kaggle #gcp
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
