Azure Data factory connection to MySQL fails intermittently

Kanika Hans 1 Reputation point

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,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,455 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Samy Abdul 3,361 Reputation points

    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: