Cloud Functions: Cloud Storage To BigQuery Load Job

This code triggers a BigQuery load job when a file is written to a Google Cloud Storage bucket.

Deploy and Test

Follow the Cloud Functions quickstart guide to setup Cloud Functions for your project.

Clone this repository:

 git clone https://github.com/asaharland/functions-bq-load-job

Create a Cloud Storage Bucket:
```
 gsutil mb gs:https://BUCKET_NAME
```
- Replace BUCKET_NAME with the name of your Cloud Storage Bucket.

Deploy the "loadFile" function with an HTTP trigger:

 gcloud functions deploy loadFile --runtime nodejs8 --trigger-resource gs:https://BUCKET_NAME --trigger-event google.storage.object.finalize

Create a BigQuery dataset and a table with the following schema:
```
 user_id:STRING,amount:FLOAT
```
Update the variables datasetId and tableId in index.js to reflect the dataset and table you created in the previous step.
Upload 'sample.csv', located in the root of this repo, to your bucket:
```
 gsutil cp sample.csv gs:https://BUCKET_NAME
```
- Replace YOUR_BUCKET_NAME with the name of your Cloud Storage Bucket.
Query the BigQuery table to check that you can see that the data has been inserted successfully.

Name		Name	Last commit message	Last commit date
Latest commit History 13 Commits
test		test
.gcloudignore		.gcloudignore
.gitignore		.gitignore
README.md		README.md
index.js		index.js
package-lock.json		package-lock.json
package.json		package.json
sample.csv		sample.csv