SNOW-1746236: Allow cloning a table

[tvdboom]

What is the current behavior?

Currently the only way to store a table is using save_as_table, which (as far as I know) performs a CTAS operation. Cloning a table is considerably faster than doing a select * from XX CTAS but it's currently impossible to do in snowpark.

What is the desired behavior?

A method for the Table class to clone himself to a new location.

[sfc-gh-sghosh]

Hello @tvdboom ,

Thanks for raising this request. At present Snowpark Python doesnt have any clone feature. will let you know if any such plan.

As a workaround, you can use session.sql and use clone command

example
session.sql("""
CREATE TABLE IF NOT EXISTS new_table_name
CLONE source_table_name
AT (TIMESTAMP => '2024-10-01 12:00:00')
""").collect()

Regards,
Sujan