Issue
Using multiple destinations (e.g., Snowflake, BigQuery), sometimes the Transformations work for one but not the other.
Recommendation
Transformations aren’t run in the Fivetran UI, but in the destination itself. Therefore, your transformations need to be set up using the SQL syntax of the destination.
It’s recommended that you keep the SQL syntax as simple and as transferable across destinations as possible. For example, Fivetran provides Sample Queries to assist.