Magento 2: What is the difference between the row_id and entity_id in the %_entity tables?

From what I have found on this one, row_id is the identifier for the row, while entity_id is the actual entity.

There are situations where a Scheduled Update is set to run for a fixed period and in this case a whole new row is created to associate with it's variant eav_attribute(s) and it can retain the same entity_id while being issued a new row_id Then the row_id is changed to the new temporary entity and then back to the original once the schedule completes.

There may be other use cases where they make use of this, this was one which I witnessed and illuminates how it can be used.