Alternate solution for select ... into outfile in Azure database for MySQL?

Question

We have a requirement, capture query output to output file like as below in Azure MySQL. The below query is possible in on-prem MySQL server. But we need the same in cloud PAAS solution or alternative method to achieve it

SELECT COUNT(*) FROM TEST_TABLE
INTO OUTFILE 'TEST.CSV'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Answer 1

Hi @Kishore Chilaparapu , Welcome to Microsoft Q&A.

'SELECT ... INTO OUTFILE' is not supported by Azure Database for MySQL as per the article.

However, alternatively you can use the Azure Data Factory where-in you can define mapping of the output and finally copy the data in supported data stores. Please refer to below article on how to use it and which data stores are supported.
https://learn.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-mysql

Please let us know if this solves the issue you are facing.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.