To use the overwrite option on insert in Snowflake, theDELETEprivilege must be granted to the role. This is because overwriting data during an insert operation implicitly involves deleting the existing data before inserting the new data.

Understanding the Overwrite Option:The overwrite option (INSERT OVERWRITE) allows you to replace existing data in a table with new data. This operation is particularly useful for batch-loading scenarios where the entire dataset needs to be refreshed.

Why DELETE Privilege is Required:Since the overwrite operation involves removing existing rows in the table, the executing role must have theDELETEprivilege to carry out both the deletion of old data and the insertion of new data.

Granting DELETE Privilege:

To grant theDELETEprivilege to a role, an account administrator can execute the following SQL command:

sqlCopy code

GRANTDELETEONTABLEmy_tableTOROLE my_role;