In my last post, we worked out how to change the data type of a field if it already existed and was found to need changing. This time, I want to add a fresh, new column to an existing table.
Read on to see how Snowflake allows you to use IF NOT EXISTS syntax to do this, as well as its limitations in practice.