Hi GCP- community,
I have a csv table in cloud storage that matches the table in CloudSQL. The service account of CloudSQL instance has granted storage.objectAdmin IAM role as mentioned in the GCP-Documentions. I am also the owner of the project.
1- When I imported the data into the table (Overview--> import) the job shows up that the data has been successfully imported but when I check the table using SELECT it doesn't deliver any data?
2- When I use the gcloud sql command: gcloud sql import csv gs://[BUCKET_NAME]/[FILE_NAME] --database=[DATABASE_NAME] --table=[TABLE_NAME] I get this msg : ERROR: (gcloud.sql.import.csv) [ERROR_RDBMS] ERROR: relation "temp_value" does not exist
Thanks For your support!