https://community.databricks.com/t5/administration-architecture/retention-for-hive-metastore-tables/m-p/95763#M2149 <P>Hi mattiags</P><P>As long as you do not delete the data via notebook or in the data lake, it will not be deleted in any other way. This means that there is no retention time in this sense, or conversely, it is infinite until you deliberately delete the data.</P> Wed, 23 Oct 2024 17:25:39 GMT Stefan-Koch 2024-10-23T17:25:39Z https://community.databricks.com/t5/administration-architecture/retention-for-hive-metastore-tables/m-p/95673#M2145 <P>Hi</P><P>I have a notebook that creates tables in the hive_metastore with the following code:</P><P>&nbsp;</P><DIV><DIV><SPAN>df.write.</SPAN><SPAN>format</SPAN><SPAN>(</SPAN><SPAN>"delta"</SPAN><SPAN>).</SPAN><SPAN>mode</SPAN><SPAN>(</SPAN><SPAN>"overwrite"</SPAN><SPAN>).</SPAN><SPAN>saveAsTable</SPAN><SPAN>(output_table_name)</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Which is the retantion for the data saved in the hive metastore? is there any configuration for keeping the data for like 5 years?</SPAN></DIV></DIV> Wed, 23 Oct 2024 08:49:39 GMT https://community.databricks.com/t5/administration-architecture/retention-for-hive-metastore-tables/m-p/95673#M2145 mattiags 2024-10-23T08:49:39Z https://community.databricks.com/t5/administration-architecture/retention-for-hive-metastore-tables/m-p/95763#M2149 <P>Hi mattiags</P><P>As long as you do not delete the data via notebook or in the data lake, it will not be deleted in any other way. This means that there is no retention time in this sense, or conversely, it is infinite until you deliberately delete the data.</P> Wed, 23 Oct 2024 17:25:39 GMT https://community.databricks.com/t5/administration-architecture/retention-for-hive-metastore-tables/m-p/95763#M2149 Stefan-Koch 2024-10-23T17:25:39Z