Datalore
 
2023.4
Shortcuts: Windows
Get a demo
  1. Notebook editor
  2. Cells
  3. Export to database

Export to database

Last modified: 22 June 2023

Use the Export to database cell to append dataframes to tables attached to your notebooks. Combined with scheduled runs, this will help you have the tables in your project regularly updated with fresh data.

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.

Export a DataFrame to a table

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

  2. Click Connect SQL cell for this database and select Export to database cell from the expanded list.

    Selecting Export to database cell

  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

  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