Uploads Google Analytics Premium tables to Google Cloud Storage and then loads to Google BigQuery
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
README.md
googleAnalyticsPremiumSchema.json
loadTablesToGoogleBigQuery

README.md

GoogleBigQuery-multiUpload

Uploads all Google Analytics Premium tables specfied by a directory to Google Cloud Storage and then loads to Google BigQuery

####Running the Script

 ./loadTablesToGoogleBigQuery <source dir> <google cloud storage dir> <bq destionation dataset UID> 

#####Additional Notes

1. Google Cloud SDK/BigQuery Command Line tool must be previously installed 
2. gsutil must be previously installed 
3. Google Analytics Premium tables follow format: ga_sessions_yyyymmdd
4. Google Cloud Storage Bucket must exist and follow format: gs://<mybucket>
5. Google BigQuery Destination DataSet must exist and follow format: <projectId>:<dataSetId>

Tested with BigQuery CLI 2.0.19 | gsutil version 3.42