With the explosion of SaaS, more data is scattered across multiple services. Then when you need to analyze them, you want to do it with SQL from a single service.
Therefore, importing this data into your data lake or data warehouse is necessary. Usually, it's a painful process doing it manually with custom coding.
AppFlow allows importing data from different sources easily. I will show you how with the help of AWS CDK, you can import a considerable number of columns from Salesforce tables without specifying them one by one.