Forum Discussion
Warehouse snapshot
Hello Everyone,
Can someone please suggest if there is a way to take snapshot of data every month and store it in lakehouse/warehouse.
Regards,
Srisakthi
Srisakthi their is no out of the box solution as such in MS Fabric, but one straightforward approach is to schedule a pipeline or Dataflow Gen2 job to run monthly and copy the entire contents of a source table into a “snapshot” table or folder labeled with a month key (for example, “202501”), ensuring that each run appends data rather than overwriting it.
if this helps please accept the answer.
Thanks
1 Reply
Srisakthi their is no out of the box solution as such in MS Fabric, but one straightforward approach is to schedule a pipeline or Dataflow Gen2 job to run monthly and copy the entire contents of a source table into a “snapshot” table or folder labeled with a month key (for example, “202501”), ensuring that each run appends data rather than overwriting it.
if this helps please accept the answer.
Thanks