In Snowflake, tables can be created as permanent, transient, and temporary, affecting their data-retention properties.

Permanent — this is the default table type. Permanent tables always ensure seven days of fail-safe storage. Time travel is enabled by default but can be configured from a minimum of zero to a maximum of one or ninety days, depending on the regular or enterprise license type.
Transient — Behave just like permanent tables but do not have a fail-safe backup
Temporary — Exist only for the duration of the session in which they were created. Because they do not persist past the session, temporary tables are not supported in SqlDBM.

Snowflake table properties

Options

Transient

Mark "Transient" to identify the table as transient. Transient tables are specifically designed for data that needs to be maintained beyond each session (in contrast to temporary tables) but do not need the same level of data protection and recovery provided by permanent tables.

See more https://docs.snowflake.com/en/user-guide/tables-temp-transient.html

Data Retention Time (Days):

When data in a table is modified, including deletion of data or dropping an object containing data, Snowflake preserves the state of the data before the update. The data retention period specifies the number of days for which this historical data is preserved. Therefore, Time Travel operations (SELECT, CREATE … CLONE, UNDROP) can be performed on the data.

See more https://docs.snowflake.com/en/user-guide/data-time-travel.html

File Format

Specifies the file format in which data can be unloaded from this table.

See more https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

Copy options

Loads data from staged files to an existing table. The files must already be staged in one of the following locations:

Named internal stage (or table/user stage). Files can be staged using the PUT command.
The named external stage references an external location (Amazon S3, Google Cloud Storage, or Microsoft Azure).
External location (Amazon S3, Google Cloud Storage, or Microsoft Azure).