Save a large Pandas Dataframe Quickly

[lifesabirch]

Is your feature request related to a problem? Please describe.

The problem is uploading a Pandas dataframe that has tens of columns and hundreds of thousands of rows. I've tried different ways to do this effectively and even tried https://github.com/yehoshuadimarsky/bcpandas

Describe the solution you'd like

Having a feature to upload a panda's dataframe to a SQL Server table.

Describe alternatives you've considered

bcpandas using cursor.fast_executemany = True

Additional context

It'd be nice if there were a simple interface such as
cursor.insert("table_name", df, append=True)

[sumitmsft]

Hi @lifesabirch - Thanks for reporting this feature request. I think this will be an important addition to the mssql-python driver. However, this may take sometime before we release it. We will put it on our backlog and have it inside the driver soon.

I am keeping this feature request open for tracking purpose.