How To Load GCS Data To BigQuery | SQL Query

Показать описание

Video demo on how to use SQL query to load data to BigQuery from GCS.

Below is the query I used to load the data:
-- Can replace OVERWRITE with INTO if you want to append data instead
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