Refresh failed using a data getway connector when we append two different sources

Hello, I have two data sources, snowflake and big query, we created an on-premise datagetway for Google big query using an ODBC connector, when we try to refresh on desktop it works fine, but it fai...