google bigquery - Append Data in a Big Query Table Automatically from Cloud Storage -
i have excel files want append big query table. after doing want append data same big query table using cloud storage automatically thru scheduler runs 4 times day. how this. please keep in mind not developer. know sql , big query.
i suggest write simple script , host google app engine, , register bucket notification , hook gae endpoint.
whenever file upload bucket, gae notificated, , invoke script, gets file, extract info it, , append table specify in big query.
https://cloud.google.com/storage/docs/object-change-notification#_watching
Comments
Post a Comment