Now, I told you that story to tell you this one. Consider the links that Evgeny Garaev provided above. The cool part about the Temporal Tables is that they auto-magically include columns that support Type 6 SCDs (Slowly Changing Dimensions). AND... They only audit changes, not INSERTs. Please see the following article on SCDs.
https://en.wikipedia.org/wiki/Slowly_changing_dimension
The bad part is that they are not without caveats (no auditing system is, especially when schema changes take place). Another really good part is that auditors love Temporal Tables because they very difficult to tamper with. Like I said, though... caveats... make sure that you read ALL the links in the article that Evgeny Garaev provided the link for before you think of using them or things like the system automatically deleting your hard earned history just might take you by surprise.
--Jeff Moden
Change is inevitable... Change for the better is not.