How to get snapshot of changed data and store them on daily basis
Enable Change Data Capture on the tables of interest. Copy the rows thus flagged to another table that matches the definition of the first, but with an additional datetime column to show when it was written. Essentially a slowly changing dimension, type 2 in the Kimball nomenclature.



SQL Server 2016 introduced temporal tables. These combine the features of CDC and an audit table I mention above. Once defined, the system itself copies row versions to a history table as data changes. All history is retained until explicitly deleted. Each row has a time interval recorded showing when it was valid.