Change the behavior of temporal tables to log actual value changes rather than dummy updates
On a further dive it seems that this currently falls under : Manage Retention of Historical Data in System-Versioned Temporal Tables as a reactionary solution to the problem, instead of a prior configuration.
And they propose three approaches:
- Stretch Database
- Table Partitioning
- Custom Cleanup Script
There are some other nice articles I found, which partially answer my question, however, I'd love if I can manage this behavior at the point of data creation rather than the cleanup, so I'd request more information in case someone has it, or if this changes in the future.
Other articles:
Managing Temporal Table History in SQL Server 2016
Temporal Table Considerations and Limitations