Write dataframe support

[akommera]

How to write ploars dataframe using mssql-python ?

polars.DataFrame.write_database

[github-actions]

Hi @akommera, thank you for opening this issue!

Our team will review it shortly. We aim to triage all new issues within 24-48 hours and get back to you.

If you have additional information to share, please feel free to update the issue.

Thank you for your patience!

[gordthompson]

If you are working from the polars documentation here

https://docs.pola.rs/user-guide/io/database/#sqlalchemy

be aware that support for mssql-python is included in SQLAlchemy 2.1, which is currently in beta. So, your command to install the additional dependencies should be

$ pip install SQLAlchemy==2.1.0b3 pandas mssql-python

and your example code should look like this

uri = "mssql+mssqlpython://username:password@server:port/database"
df = pl.DataFrame({"foo": [1, 2, 3]})

df.write_database(table_name="records",  connection=uri)

[arkdvd]

What should be connection string for win auth?

[gordthompson]

According to

https://docs.sqlalchemy.org/en/21/dialects/mssql.html#connection-strings

that would be

uri = "mssql+mssqlpython://hostname/database?authentication=ActiveDirectoryIntegrated"

[arkdvd]

Error:
ConnectionStringParseError: Connection string parsing failed:
Incomplete specification: keyword '{' has no value (missing '=')
Unknown keyword 'authentication}' is not recognized

uri = "mssql+mssqlpython://hostname\Instancename:portnum/database?authentication=ActiveDirectoryIntegrated"
uri = "mssql+mssqlpython://hostname\Instancename/database?authentication=ActiveDirectoryIntegrated"

Ran with all these libs :
Name: SQLAlchemy
Version: 2.1.0b3

Name: pandas
Version: 3.0.1

Name: pyarrow
Version: 25.0.0

Name: mssql-python
Version: 1.12.0