google drive csv to google cloud mysql

  • 49Views
  • Last Post 13 September 2017
0
votes
Irfan Ahmed posted this 12 September 2017

My user will be uploading csv files on google drive and I need to move csv data to mysql databse on google drive. I've checked connections but it does not have google cloud mysql but simple mysql is available. Kindly guide how to achieve it.

Further, I need to call a google script after data transfer is done to mysql. Your kind response will be appreciated.

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 12 September 2017

Thank you for your interest in Skyvia.

If we understood you correctly, you want to migrate data from Google Drive (.CSV file) to Google Cloud SQL (MySQL). 

Yes, there is no connector for Google Cloud SQL. However, from the information available here , we recommend you to try connector for MySQL database:

Standard APIs

Build and deploy for the cloud faster because Cloud SQL offers standard MySQL and PostgreSQL BETA databases. Use standard connection drivers and built-in migration tools to get started quickly.

 

Please note, when working with MySQL connections, the main requirement is that your MySQL database must be available through the Internet.

 

Please also refer to: https://skyvia.com/resources/docs/index.html?mysql_connections.htm

 

Further, I need to call a google script after data transfer is done to mysql.

 Unfortunately, this cannot be implemented via Skyvia.

 

Best regards,

Mariia

0
votes
Irfan Ahmed posted this 13 September 2017

Thanks Marria for kind response. I will look into workaround for same.

Close