SELECT ... INTO OUTFILE

[Rajesh Golla]

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.

[David (Cloud Platform Support)]

Hello,

Have you tried doing it from the Cloud Console? You can follow these instructions

[Rajesh Golla]

Hi David,

I want to execute that select statement in procedure but anyways I got a approach using cloud function.

Thanks for the help.