How to find the difference between a view in snowflake and the suggested DDL?

[JefStat]

I have a view in snowddl that as soon as I modify in snowddl I can never get it to in sync with snowflake. I run the suggested ddl in a snowflake worksheet and still snowddl suggests modifying the view with the same suggest ddl. At least I think it's the same. So how can I do a diff to see if something is changing when I copy paste the view into the worksheet. ie spacing or casing changes happen between the suggested ddl and what is input into snowflake.

[littleK0i]

It is most likely related to Snowflake Python driver applying .strip(" \n\t\r") to all queries. It only happens in Python driver, but not in Web GUI. This makes things really confusing.

This problem was brought into light by another user, and I actually pushed a patch to add similar stripping logic: b7a090c

Let me release it as a separate version now.

Unfortunately, it may potentially trigger re-creation of dynamic tables and materialized views. But I do not see any good way around it.

[littleK0i]

Uploaded fix as version 0.42.0, please give it a try.

Affected objects might be re-created once after update, but it should no longer happen on subsequent runs.

[JefStat]

Thanks for the update, looks like it is working.