OUTFILE command in MYSQL DB

Hello All,

We have a table which has millions of records and all the records are being fetched for auditing purpose and a csv is created. however, this CSV once opened does not show complete records. hence, to overcome this issue, we have written a stored proc to retrieve data in chunks and generate a csv file everytime.

I am trying to use the below function  to achieve the same on MYSQL DB on cloud, however, it throws an error as below:

Query : SELECT * INTO OUTFILE 'data.txt' FIELDS TERMINATED BY ',' FROM `Appian.tableName`;

Error:

#1045 - Access denied for user 'appian'@'%' (using password: YES)

What permissions are needed to get an output file? Is it possible to get the required permissions on Appian cloud?

Thanks in advance!

Regards,

Anagha

  Discussion posts and replies are publicly visible