Warehouse snapshot

[Srisakthi]

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

[nilendraFabric · Accepted solution]

@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