Is it possible to save snapshots of data that will stay static for a given point in time and never be updated? This would be to fulfill regulatory reporting requirements. We need to take snapshots of certain sensitive data at given points in time and need that view to persist and never be updated.
Hi Matt and welcome to the Sigma Community!
The best way in Sigma to achieve the above would be to create a Dataset from the Worksheet once the latter contains the correct view of the data. Then performing a materialization once on this Dataset would suffice for retaining this snapshot in your warehouse.