Snowflake - satyamsingh1004/snowflake GitHub Wiki

• Snowflake provides "schema-on-read". Example: one can load anything they want into a VARIANT column, and parse it out (read it) differently over time.

• Zero-Copy Cloning

Idempotency

• the COPY INTO is smart enough to know which files it already loaded and it doesn't load the same file, twice. You could add a FORCE=TRUE; as the last line of your COPY INTO statement and then you would double the number of rows in your table.