Sqlalchemy Table Copy
Copying small data sets using sqlachemy
sqlalchemy is widely used. For example, Pandas read_sql uses sqlalchemy to connect to a supported database.
In this test, I want to transfer all records between two identitical tables. It is useful when you need to move data between 2 non-production environments. This is not the most efficient way to move data, but I will show here that it’s very a convenient way to move small data sets under 500K records.
[Read More]