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