Mostly just look into “archiving into data warehouse” type patterns.

You can also look into “realtime data warehousing”.

Meanwhile, it’s so common, AWS built it into their product.

https://aws.amazon.com/about-aws/whats-new/2023/11/amazon-dy...