# Export Table to Source Action

The *Export Table to Source* action allows you to **export one or more tables from your Lakehouse Manager directly to a compatible Connectors source.** This action facilitates moving processed or raw data from your managed Lakehouse environment into external databases or other systems supported by Connectors connectors.

*   [Configure an Export Table to Source action](#configure-an-export-table-to-source-action)
    *   [Choose Tables for Export](#choose-tables-for-export)
    *   [Select Destination Source](#select-destination-source)
*   [Verify Your Export](#verify-your-export)

---

## Configure an Export Table to Source action

To create a new *Export Table to Source* action, follow these steps within the Data Processing Engine (DPE):

1.  Navigate to the **Action tab** within the Data Processing Engine (DPE) interface.
2.  Click on the **"New Action"** button.
3.  From the list of available actions, select **"Export Table to Source"**.
![export-table-choose-tables](picts/export-table-1.png)

### Choose Tables for Export

First, you need to select the tables from your Lakehouse Manager that you wish to export.

1.  A list of available tables from your [Lakehouse Manager](/en/product/lakehouse-manager/tables/index.md) will be displayed.
2.  You can select **one or multiple tables** from this list for export. Simply click on the table names to highlight them for selection.
![export-table-choose-tables](picts/export-table-2.png)
![export-table-choose-tables](picts/export-table-3.png)

### Select Destination Source

Next, you will define the external source where the selected tables will be exported.

1.  A dropdown or list will appear, showing available compatible sources from your [Connectors](/en/product/connectors/sources/index).
![export-table-choose-tables](picts/export-table-4.png)
2.  **Compatibility Note:** Currently, this action supports Connectors sources of **type database and protocols**.
3.  **Important:** If no destinations are shown, it means you have not yet connected any compatible database or protocol sources in your Connectors. Please ensure you have configured at least one such source before attempting to use this action.
4.  Select the desired destination source from the list.
5.  click confirm and run.
![export-table-choose-tables](picts/export-table-5.png)

!> **Important Note on Export Table to Source:** The *Export Table to Source* action might **fail** if the destination database you are exporting to has a configuration requiring primary keys for tables being created or inserted. For example, some database systems or specific table settings (like `REQUIRE PRIMARY KEY` in certain MySQL/MariaDB setups or stricter NoSQL configurations) might enforce this.

>By default, tables within the Lakehouse Manager **do not inherently have primary keys defined**. If your destination database requires a primary key and the incoming table schema does not provide one, the export operation will fail. To successfully export to such databases, you may need to adjust the destination database's configuration to temporarily or permanently relax the primary key requirement.

---

## Verify Your Export

After the *Export Table to Source* action completes successfully, you can verify the export by connecting to your chosen destination database or system (e.g., using a SQL client for a database) and checking for the presence of the newly exported tables and their data. You can even check the connectors source to check for the update.
![export-table-choose-tables](picts/export-table-6.png)

---

## Need help? 🆘

> At any step, you can create a ticket to raise an incident or if you need support at the [OVHcloud Help Centre](https://help.ovhcloud.com/csm/fr-home?id=csm_index). Additionally, you can ask for support by reaching out to us on the Data Platform Channel within the [Discord Server](https://discord.com/channels/850031577277792286/1163465539981672559). There is a step-by-step guide in the [support](#en/support/index.md) section.