SNOW-616002: Ability to overwrite tables when using write_pandas()

[iamontheinet]

What is the current behavior?

Using the write_pandas() API there is no way to overwrite contents of a Snowflake table with that of a Pandas DataFrame without first executing a truncate SQL statement.

What is the desired behavior?

Using the write_pandas() API there should be a way to optionally overwrite contents of a Snowflake table with that of a Pandas DataFrame.

How would this improve snowflake-snowpark-python?

Better user experience for Python developers and especially those devs that are not familiar with truncate SQL statement or know how to write SQL.

References, Other Background

Similar to overwriting contents of a Snowflake table when writing contents of Snowpark DataFrames using df.write.mode('overwrite')