To use the OVERWRITE option on INSERT, which privilege must be granted to the role?
To use the OVERWRITE option on INSERT, which privilege must be granted to the role?
To use the OVERWRITE option on INSERT, you must have the DELETE privilege on the table. This is because using the OVERWRITE option effectively deletes the existing records in the table before inserting the new rows. Therefore, the role must have the DELETE privilege to perform this operation.
Correct. To use the OVERWRITE option on INSERT, you must use a role that has DELETE privilege on the table because OVERWRITE will delete the existing records in the table.
https://docs.snowflake.com/en/sql-reference/sql/insert