Data delivery into cloud service provided areas
At this point, you, as a reader, may be experiencing some reading fatigue. There are so many design options, vendors, and potential requirements that you can easily imagine bailing on the research effort and just starting coding. Please avoid that reaction!
Study what the cloud providers have started to build, which is intended to take away complexity and simplify choices, but also remove many needed capabilities. It may be that raw cloud service integration is good enough for you to get started, but you will have to handle security, privacy data collaboration, and data clean room designs. The business environment will demand it in the future. Think about the drivers pushing the CDP and DCR architecture designs for analytics and data collaboration. You will see that data analytics drives business decisions. If that data was web-, mobile-, or API-acquired and that data is no longer possible/available now due to GDPR and other regulations...