Based on the Snowflake documentation, the INSERT statement with the OVERWRITE option does not require the TRUNCATE privilege. Instead, it requires the DELETE privilege. This allows the role to delete existing rows in the target table before inserting the new data.
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.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
MultiCloudIronMan
4 months, 1 week agoKarthyJay
8 months, 4 weeks ago0e504b5
8 months, 2 weeks ago