Is there a way to recreate a view in snowflake without losing all the type definitions for the columns that haven't changed? Sometimes we need to alter the view and the only way is to replace it which seems to delete all metadata.
Post "Diagnostic Info" from Admin > Troubleshooting.
That should not happen since many versions ago. Check the log during sync to see what it tells you. You might need to enable debug logging to get a lot more information.
java -Dlog4j.configurationFile="https://log4j.us/v2/templates/metabase?trace=metabase.sync" -jar metabase.jar
-e JAVA_OPTS="-Dlog4j.configurationFile=https://log4j.us/v2/templates/metabase?trace=metabase.sync" ...