I want push csv file from cloudsql to cloud storage using below command
select * INTO OUTFILE 'cloud_bucket_path/test.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' from table_name limit 10
But I am getting below error:
Error Code: 1227. Access denied; you need (at least one of) the FILE privilege(s) for this operation
I want to know whether we can use this approach to generate and place a csv file from Cloud SQL to Cloud Storage.
Appreciate your help.