We wanted to create a snapshot (materialized/indexed view) in the SF to make it easier to display information such as stock aggregations, but we can't get it to work.
We can see multiple users having problems with this: Snapshot creation SQL SERVER | Thinkwise Community
It seems this is not yet enabled for Mssql. Can this be realized?
What are 'Snapshot' views and how to use them? | Thinkwise Community