Polars DataFrame save to sql

Question

Is there a way to save Polars DataFrame into a database, MS SQL for example?

ConnectorX library doesn’t seem to have that option.

I don't know of a way, but you can always do `df.to_pandas().to_sql(...)` for now. — MYK, Feb 02 '23 at 15:48
For **`polars>=0.16.10`** you can use `df.write_database()` [method](https://github.com/pola-rs/polars/releases/tag/py-0.16.10). — glebcom, Mar 04 '23 at 08:05

score 4 · Answer 1 · answered May 12 '23 at 07:39

4

Polars exposes the write_database method on the DataFrame class.

answered May 12 '23 at 07:39

ritchie46

score 2 · Accepted Answer · answered Feb 09 '23 at 09:40

Polars doesen't support direct writing to a database. You can proceed in two ways:

Export the DataFrame in an intermediate format (such as .csv using .write_csv()), then import it into the database.
Process it in memory: you can convert the DataFrame in a simpler data structure using .to_dicts(). The result will be a list of dictionaries, each of them containing a row in key/value format. At this point is easy to insert them into a database using SqlAlchemy or any specific library for your database of choice.

2 Answers2