Scenario:
You have multiple destinations (e.g., Snowflake, BigQuery), and sometimes the Transformations work for one but not the other.
Fivetran 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 to keep the SQL syntax as simple and as transferable across destinations as possible. For example,
Fivetran provides Sample Queries to assist!