3 ms·
Last time I checked, it was still hard to get a Google CloudSQL DB into BigQuery, so I’m surprised they did the sheets integration first. We used a third party
by savrajsingh 8y ago
Last time I checked, it was still hard to get a Google CloudSQL DB into BigQuery, so I’m surprised they did the sheets integration first. We used a third party that just copied data from our CloudSQL to BigQuery.
- skiman10 8y agoWhat tool did you use?
- faizshah 8y agoYea this is surprisingly annoying. I did CloudSQL -> csv -> dataprep -> bigquery. For about 10 tables with ~20 columns each. A job that should be less than an hour took over 6 hours due to various annoying datatype issues. Another interesting thing is that BigQuery doesn't have Full Text Search so you need to go back into postgres or use elastisearch to use FTS which is beyond annoying.
- vgt 8y agoCheck out the newly announced data fusion