Snowflake Demo 2 || What is SQL || Snowflake Account Creation || Table Creation

[@satishgunishetty6567]

Good information and best explanation sir

[@prasadhtd1188]

Bro why truncate is dml? Anywher i see it as DDL

[@praveenkumarbommisetty6093]

In Snowflake it is DML
We can rollback the transactions using rollback

[@prasadhtd1188]

@@praveenkumarbommisetty6093 if we truncate then how copy will work for same file data ingestion if it's dml?

[@praveenkumarbommisetty6093]

@@prasadhtd1188 That is only difference between Delete and Truncate
When we delete the table we cannot load the same file
But when we Truncate the table we can load the same file
Try to see show parameters and disable autocommit=false
And very from ur side and confirm

[@dn9416]

Fast