'Data migration - SQL tables to Parquet framework

I'm looking for a high level plan to perform ETL on calls that have been transcribed. The transcriptions are stored in a local software, so its on premise sql tables.  We are looking to move the speech transcriptions info into the data lake which is a parquet format table. The data needs to be feed into the data lake on an hourly basis.  My question is what are the data processes are required and the workflow in order to achieve the above reliably. How would the "Cron" Job work?.

Apologies that I could not provide more information.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source