CODEWITHSUNDEEP
mysqlgoogle-cloud-platformgoogle-cloud-functionsmysql-workbenchimport-from-csv
user3773028
user3773028

Reputation:

How to import "|" delimited CSV data from a Bucket to MySQL on Google Cloud SQL?

I am trying to import data from a CSV file that is stored in a Bucket. The CSV file uses the "|" delimiter. I would like to import these data to a MySQL database on Cloud SQL.

However, I found out that the root user by default does not have the "File" privilege, which means I cannot perform this import via MySQL Workbench.

I tried to use the command LOAD DATA INFILE, but I got the following error:

ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

I also tried to use the tool gcloud sql import csv, but I got another error:

ERROR: (gcloud.sql.import.csv) HTTPError 403: The service account does not have the required permissions for the bucket.

I do not know how to solve this problem. Could anyone help me with this? Any suggestion or guidance would be very welcome.

Thank you!

Upvotes: 0

Views: 131

Answers (1)

Paku
Paku

Reputation: 797

You could try reformatting your CSV file to be delimited by something else, e.g. ,?

Upvotes: 0

Related Questions