python - Best practice for copying table from one database to another using AirFlow

Question

We gonna deploy AirFlow for ETL management.

What is the best practice for copying a whole table from one database (Oracle or DB2) to another (PostgreSQL)?

I was thinking using 1) ORM SQLAlchemy or 2) Pandas pandas.read_sql_table() and DataFrame.to_sql(). Or is there even better way?

Thank you.

Answer 1

等待大神答复