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.
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
Thanks Marria for kind response. I will look into workaround for same.
