Hello,
We have currently set up a hybrid environment for our TX deployments. A DEV environment in on premise MSSQL database and test and prod in Snowflake. I have already come across situations like hashing where the built in functionality is not usable in Snowflake and if you create a custom field with a hashing algorithm it is not possible to deploy from MSSQL to Snowflake becuase of the different language required to create the hash.
I have also com across this when writing custom scripts. In those cases so far i have been able to create code that works in both environments.
Is there any way to handle this more effeciently when running a hybrid set up like this? We are trying to reduce unneccessary costs in Snowflake during development hence the hybrid set up. I have read some things about Instance variables but it would be great if there is some kind of best practice in a set up like this.
