https://community.databricks.com/t5/data-engineering/retrieve-data-older-than-the-one-year-window-system-access-table/m-p/100734#M40397 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/134711">@Clara</a>&nbsp;,</P><P>I don't think so. But you can build history such history tables by yourself. Desing ETL process that will extract data from system tables and store them in your own data tables.&nbsp;</P> Tue, 03 Dec 2024 10:19:53 GMT szymon_dybczak 2024-12-03T10:19:53Z https://community.databricks.com/t5/data-engineering/retrieve-data-older-than-the-one-year-window-system-access-table/m-p/100729#M40395 <P>Hello,<BR /><BR />I am currently using table_lineage from system.access.table_lineage. It is a great feature but I am experiencing missing data. After some search I have seen that "<SPAN>Because lineage is computed on a one-year rolling window, lineage collected more than one year ago is not displayed.". I am reaching to you to know if there is a way to capture data prior this one year window?&nbsp;</SPAN></P> Tue, 03 Dec 2024 09:30:22 GMT https://community.databricks.com/t5/data-engineering/retrieve-data-older-than-the-one-year-window-system-access-table/m-p/100729#M40395 Clara 2024-12-03T09:30:22Z https://community.databricks.com/t5/data-engineering/retrieve-data-older-than-the-one-year-window-system-access-table/m-p/100734#M40397 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/134711">@Clara</a>&nbsp;,</P><P>I don't think so. But you can build history such history tables by yourself. Desing ETL process that will extract data from system tables and store them in your own data tables.&nbsp;</P> Tue, 03 Dec 2024 10:19:53 GMT https://community.databricks.com/t5/data-engineering/retrieve-data-older-than-the-one-year-window-system-access-table/m-p/100734#M40397 szymon_dybczak 2024-12-03T10:19:53Z