This task can be performed using Amphi Lab
Python-Based Micro-ETL
Best product for this task

Amphi Lab
analytics
Amphi is a micro-ETL designed for ease of use and flexibility. Develop simple data pipelines and generate native Python code. Run the pipelines anywhere you'd like. Data and metadata remain securely on your laptop, eliminating any privacy concerns.
What to expect from an ideal product
- Generates native Python code specifically tailored for ETL tasks.
- Allows the creation of easy-to-use and flexible data pipelines.
- Ensures all data and metadata stay on your local machine, maintaining privacy.
- Can run generated pipelines on any platform you prefer.
- Simplifies complex ETL workflows, making development quicker and more efficient.