Which of the following DML commands isn't supported by Snowflake?
Which of the following DML commands isn't supported by Snowflake?
Snowflake does not support the UPSERT command as a standalone DML operation. Instead, Snowflake uses the MERGE statement to accomplish what UPSERT would do in other databases. The MERGE statement allows for conditional updates and inserts, making it equivalent to the UPSERT operation. Therefore, among the given options, only UPSERT is not supported as a direct command in Snowflake.
There is nothing called UPSERT in snowflake. MERGE = UPDATE+INSERT+DELETE. Also, unlike other databases TRUNCATE is considered DML in snowflake.
TRUNCATE TABLE is DDL operation, as far as I know it drops tables and recreates it.
A is correct
A.UPSERT
A. correct
A is correct
What is the correct answer if not UPSERT?
There is nothing called UPSERT in snowflake. MERGE = UPDATE+INSERT.
Commands for inserting, deleting, updating, and merging data in Snowflake tables: INSERT INSERT (multi-table) MERGE UPDATE DELETE TRUNCATE TABLE