# Export to databases

Use the Export to database cell to append DataFrames to tables attached to your notebooks. Combined with [scheduled runs](scheduling.html), this will help you have the tables in your project regularly updated with fresh data.

> **Note: Kernel type restriction**
> At the moment, you can use Export to database cells for Python DataFrames only.

Suppose you retrieved data from an attached database and do some calculations. Now, you want to write the content of the DataFrame containing the results of your calculations to the table. If you set up a schedule for this notebook, you ensure that the table is updated regularly and the other users work with the up-to-date source.

> **Note:**
> A DataFrame is successfully appended to a table if there is at least one colum match between the two.

Procedure: Export a DataFrame to a table

1. Go to Attached data on the left-hand sidebar.

2. Click the arrow next to the Connect SQL cell button for the required database and select Export to database cell from the expanded list.

![Selecting Export to database cell](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/export_cell.png)

This will add an Export to database cell to the notebook.

3. In the Export to database cell, expand the lists in each field to provide the following:

* Target database connection: the connection with the database containing the required table

* Source DataFrame: the DataFrame that you want to append

* Database: the database with the table you want to update

* Schema: the schema containing the required target table

* Table: the table that you want to append the source DataFrame to

![Exporting a DataFrame to a database](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/export_table.png)

4. Run the cell by clicking the Run icon in the upper left corner of the cell.

If any column matches are found, the output of the cell will return the number of successfully added rows.

![Append result](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/append_result.png)

## Keywords

write to sql, update data, writeback sql, DataFrame to database