@gchandracan you help me with the above?

In summary, When I loop through the snapshots, the API doesn't create a history in the table that how the data is changing but only keeps the latest records from the most recent parquet file when I do full refresh.