I have a python tool that uses sqlalchemy to connect to Postgres and MYSQL. I do this by modifying only the parameters to create_engine
. However, it is possible that I have to work with the DB dump in the form of a csv file. Is there any way to pass the csv to create_engine
.
I could simply load the contents of the csv into a local database and pass that to sqlalchemy, but it will be great if I can completely avoid the db while dealing with csv files.