This error occurs when the MySQL user has insufficient privileges in the WHMCS database to perform the schema changes that the update process requires. You need to grant permissions to the table in question, you can follow these links :
GRANT CREATE ON database_name.* TO 'my_user'@'20.126.1.73';
FLUSH PRIVILEGES;
ADF attempts to create a temporary table (t_7944_7bd2ad79d4354ca5bdc998aef1f5deec
) as part of its process
https://stackoverflow.com/questions/9887364/create-command-denied-to-user
https://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql