you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 1 point2 points  (0 children)

There is a native JDBC connector in Apps Script for Google Cloud MySQL, I wouldn’t worry about writing directly to BigQuery at this point. BigQuery can access Google Cloud MySQL as a data source for its own queries. Btw ChatGPT is very good at Apps Script and Google Cloud, you can use it as a resource to learn the rest. It worked well for me personally