DB Save Cell

The DB Save cell lets you write a dataframe from your notebook back to a database or warehouse.

Requirements

• The target database/warehouse must have Allow inserts and updates enabled when you connected it.
• If this was not checked during connection, Livedocs will only have read access, and DB Save will not work.

How to Use

1. Select a Dataframe – Choose the dataframe you want to write.
2. Select a Database – Pick the connected database/warehouse.
3. Select a Schema – Choose the target schema.
4. Select a Table – Choose an existing table, or click New Table to create one.

Run Settings

Determine when the write-back should be executed. You can choose one or more of:

• Edit Mode – Runs when you execute the cell from the notebook.
• View Mode – Runs from the app if the DB Save cell is included in the view.
• Scheduled Run – Runs when the doc is executed on a schedule.
• Webhook Runs – Runs only when a scheduled run is triggered via webhook.

Write Modes

• Append – Adds new rows to the existing table, matching types to the existing schema.
• Overwrite – Deletes existing rows before writing the new rows.

Next Steps:

• Connecting Databases
• Scheduled Runs