[google-cloud-sql-discuss] Re: SELECT ... INTO OUTFILE

Hello,

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

On Wednesday, May 5, 2021 at 9:11:43 AM UTC-4 rgo...@ctepl.com wrote:

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.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c414216c-7152-4899-b4fe-aeba990d19aen%40googlegroups.com.