Cloud Function to Import JSON Files from GCS into BigQuery
- Create a GCP Project:
my-project-name
- Create a GCS Bucket:
my-bucket-name
- Update the
deploy.sh
script so thatPROJECT
andBUCKET
reflect your project and bucket names. - Run
deploy.sh
to deploy the function into your project.
- Create a new newline-delimited JSON file with your data.
- Upload file to your GCS bucket as
dataset/table.json
wheredataset
is the name of the desintation dataset andtable
is the name of the destination table. - View BigQuery console to see if your table was created.