I have json files flowing in to Google Cloud Storage and then a process setup to flatten them out and load into a table in Google Big Query. I'm wondering if it is possible to setup a sync between the Google Big Query table and a table in Google Cloud SQL so I don't have to write additional code to write the data to two places. Is this possible?
1 Answers
0
votes
Sorry I mis-read the question. BigQuery supports the API to export to CSV file and Cloud SQL also supports the CSV import, and the default CSV format that bigquery and Cloud SQL uses are compatible.
Original answer: There is no automatic sync setup for this. You need to write a small program to retrieve the data from Cloud SQL and load it to Big Query (https://cloud.google.com/bigquery/loading-data-into-bigquery)
