Azure Data factory connection to MySQL fails intermittently

Question

I am connecting to MySQL database hosted in cloud network and copying data from MySQL views to Azure SQL DB. I am getting below error intermittently while copy operation. I am using MySQL connnector. The user used has access to do select from views but does not have access to tables. Interestingly the copy was working fine for last 1.5 years but has suddenly started causing issues. Also the error does not happen all the times for the same query so I am not sure if it is something in the connector which is causing issue.

Operation on target Copy_cgn failed: Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][MySQL] EXPLAIN/SHOW can not be issued; lacking privileges for underlying table,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][MySQL] EXPLAIN/SHOW can not be issued; lacking privileges for underlying table,Source=MySQLODBC_sb64.dll,'

Answer 1

Hi @Kanika Hans , this has been discussed earlier on in below thread, and it was

to increase size of VM if it is hosted on VM, and if this doesn't work out raise a ticket

support ticket:

https://learn.microsoft.com/en-us/answers/questions/784318/azure-data-factory-mysql-odbc-operation-failed-the.html