In Snowflake, the data retention period specifies the number of days for which the historical data is preserved and the default retention period is 1 day. However, we can change the retention period for permanent tables by setting any value from 0 up to 90 days. We can easily achieve it by running the following command, where in this case we set the retention period to 10 days.
ALTER TABLE <TABLE_NAME> SET DATA_RETENTION_TIME_IN_DAYS = 10
