There is some misinformation in this article. For instance, Snowflake absolutely supports transactions for most operations, DML operations always occur in a single transaction but any INSERT, UPDATE, SELECT, etc can absolutely be lumoed with other operations in a single transaction safely.