https://community.databricks.com/t5/warehousing-analytics/historical-reporting/m-p/49488#M1022 <P>How do you handle reporting monthly trends within a data lakehouse?&nbsp; Can this be done with timetravel to get the table state at the end of each month or is it better practice to build a data warehouse with SCD types?&nbsp;&nbsp;</P><P>We are new to databricks and lakehouses.&nbsp;&nbsp;</P> Wed, 18 Oct 2023 18:05:34 GMT Mswedorske 2023-10-18T18:05:34Z https://community.databricks.com/t5/warehousing-analytics/historical-reporting/m-p/49488#M1022 <P>How do you handle reporting monthly trends within a data lakehouse?&nbsp; Can this be done with timetravel to get the table state at the end of each month or is it better practice to build a data warehouse with SCD types?&nbsp;&nbsp;</P><P>We are new to databricks and lakehouses.&nbsp;&nbsp;</P> Wed, 18 Oct 2023 18:05:34 GMT https://community.databricks.com/t5/warehousing-analytics/historical-reporting/m-p/49488#M1022 Mswedorske 2023-10-18T18:05:34Z https://community.databricks.com/t5/warehousing-analytics/historical-reporting/m-p/49509#M1023 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/91859">@Mswedorske</a>&nbsp;IMO it would be better to use SCD.<BR />When you do VACUUM on a table, it removes the data files that are necessary for Time Travel, so it's not a best choice to rely on Time Travel.</P> Thu, 19 Oct 2023 04:54:04 GMT https://community.databricks.com/t5/warehousing-analytics/historical-reporting/m-p/49509#M1023 daniel_sahal 2023-10-19T04:54:04Z