Predictive Hacks

How to Change the Retention Period in Snowflake

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

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

Subscribe To Our Newsletter

Get updates and learn from the best

More To Explore

Python

Image Captioning with HuggingFace

Image captioning with AI is a fascinating application of artificial intelligence (AI) that involves generating textual descriptions for images automatically.

Python

Intro to Chatbots with HuggingFace

In this tutorial, we will show you how to use the Transformers library from HuggingFace to build chatbot pipelines. Let’s