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.shscript so thatPROJECTandBUCKETreflect your project and bucket names. - Run
deploy.shto 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.jsonwheredatasetis the name of the desintation dataset andtableis the name of the destination table. - View BigQuery console to see if your table was created.