Forum Discussion

Srisakthi's avatar
Srisakthi
Icon for Super User rankSuper User
1 year ago
Solved

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
warehouse
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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 

nilendraFabric's avatar
nilendraFabric
Icon for Super User rankSuper User
1 year ago

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