> ## Documentation Index
> Fetch the complete documentation index at: https://docs.skypoint.ai/llms.txt
> Use this file to discover all available pages before exploring further.

#  

# Exports

## Overview

The Export process in the Dataflow transfers unified data to storage accounts, data warehouses, tools, and other external business applications. You need to connect with a storage service to export the data. After connection, you can transfer your data to various applications.

skyData has the ability to Export data to any data source including pre-built connectors with popular applications (e.g. Shopify, Salesforce etc.), web activity through our JavaScript tag as well as custom data sources (e.g. Amazon S3, Azure Blob etc).

skyData exports standardized, modular, and extensible collection of data schemas from the Lakehouse to the location specified.

For more information on import data click here - [Data Flow ingest](connectors)

## Prerequisite

* You have credentials to configure with your storage service.

## To export data from the Dataflow

* In the left pane, go to **Dataflow** > **Exports**.

The Exports window appears. By default, the **Export Gallery** page opens.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/ExportGallery.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=1b7c254678723b65f87fe73d06abcd7b" alt="Export Gallery" style={{border: "1px solid black"}} width="1874" height="607" data-path="doc_snippets/ExportGallery.png" />

| Item           | Description                                                                             |
| :------------- | :-------------------------------------------------------------------------------------- |
| Export Gallery | Displays all export destinations to build setup.                                        |
| Destinations   | Displays the name, type, and status of all exported data. Also, you can add new Export. |
| Run History    | Displays the execution history of the Export process.                                   |

## Set up a new export

1. You can add the export connection in two ways. However, the procedure is similar in both cases. These are as follows:

* In the **Export Gallery** tab, select the export destination.
* In the **Destinations** tab, click **Add Export** to configure with storage service.

2. If you add an export connection through **Export Gallery**, click **Set up** to create a new export.

The Setup window appears.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/ExportSetUp.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=c7e0635bc2b5fe971ed21dc8141d67f0" alt="Export Setup" style={{border: "1px solid black"}} width="657" height="1205" data-path="doc_snippets/ExportSetUp.png" />

3. Enter **Name** and **Display name**.

<Note>
  The name must start with a letter and can only include letters and numbers.
</Note>

4. Enter the credentials of the storage service for validation. If you have already created an export connection and you want to copy the credentials, then choose **Select from existing**.
5. Click **Next**.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/ExportSelectEntities.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=c974a1bb830aeaee73e4d898cb7e3a17" alt="Export Select Entities" style={{border: "1px solid black"}} width="661" height="917" data-path="doc_snippets/ExportSelectEntities.png" />

6. Select the tables that you want to export and click **Next**.

<Note>
  You can export audiences created from prediction models, enabling targeted outreach to high-value customers or those at risk of churning.
</Note>

<img src="https://mintcdn.com/skypoint/JzM_sStn9jSyR3nn/doc_snippets/AttrributesToBeExported.png?fit=max&auto=format&n=JzM_sStn9jSyR3nn&q=85&s=021dd4ceebe8f9113fb5dd7bf515251e" alt="Attributes to be Exported" style={{border: "1px solid black"}} width="665" height="696" data-path="doc_snippets/AttrributesToBeExported.png" />

7. Select the attributes that you want to export and click **Create**.

<Tip>
  The Export setup consists of three steps, and you need to perform them in the following order:

  1. Configure with the storage service.
  2. Select the tables.
  3. Select the attributes.

  The above images are shown the SFTP set up to connect and export data from the skyData platform. If you have already created an SFTP connection, then click **Select from exiting** to enter your credentials. However, for a new SFTP connection, enter SFTP credentials such as **Host**, **Port, Host Key Fingerprint, Username**, **Password**, and **Storage Path**. Similarly, based on the storage service (file-based or API-based), you need to enter the credentials to build the configuration. Then, select the tables and attributes to export data from the skyData platform.
</Tip>

<Note>
  If you configure it with an API-based connector, click **Save** after entering a valid API key. The system will not allow you to proceed without providing the API key.
</Note>

## Run, Cancel Run, and Remove the exported data

1. After creating an export connection, it appears in the **Destinations** tab.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/ExportsOutput.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=7551de0348039d00af4c311b7b45d35b" alt="Exports Output" style={{border: "1px solid black"}} width="1571" height="600" data-path="doc_snippets/ExportsOutput.png" />

| Item          | Description                                                                                                                   |
| :------------ | :---------------------------------------------------------------------------------------------------------------------------- |
| Name          | Name of the Export connection.                                                                                                |
| Display Name  | Displays the name of the exported data. It can be different from the Export connection name. Also, you can change this later. |
| Type          | Displays the connector type.                                                                                                  |
| Created       | Displays date of creation.                                                                                                    |
| Last Exported | Displays last modified date.                                                                                                  |
| Status        | Indicates whether the data is exported successfully.                                                                          |
| All           | Option to view all export connections. Also, you can view the items in a specific Group (for example, name, type, status).    |

2. Select the horizontal ellipsis in the **Actions** column and do the following:

| If you want to                                                        | Then                   |
| :-------------------------------------------------------------------- | :--------------------- |
| Modify the Export                                                     | Select **Edit**.       |
| Execute the Export process                                            | Select **Run**.        |
| Cancel the execution of the data export                               | Select **Cancel Run**. |
| Configure a refresh schedule to add new or updated data in the Export | Select **Schedule**.   |
| Delete the Export                                                     | Select **Remove**.     |
| See the history of the Export                                         | Select **History**.    |

## Check real-time Export status

Follow the below steps to check the real-time status of your data exports:

1. Go to **Exports > Destinations**.
2. Click the three horizontal ellipsis under the **Actions** column for your export.
3. Click **History** on the **Actions** menu.

The **Export History** pop-up appears, displaying the real-time export details.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/Export_History.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=2a2454aaf4c37f001a7f41e273abc1ab" alt="Export History" style={{border: "1px solid black"}} width="764" height="375" data-path="doc_snippets/Export_History.png" />

## Edit the Export

You can update the exported data for the existing storage account.

1. Go to **Dataflow** > **Exports**.
2. Open the **Destinations** tab and select the export that you want to update.
3. In the **Actions** column, click the horizontal ellipsis and select **Edit**.
4. Modify the data and select **Update**.
5. Click **Run** to execute modification.

## Schedule the Export

skyData platform provides you to set a time for new or updated data to include in the exported file. The Export process runs whenever the system refreshes data or system refresh is triggered. With the **Schedule** feature, you can customize the refresh schedule. By default, export runs as part of every scheduled system refresh run for the particular instance. The system refresh schedule is shown on the **Settings** page. You can check through **Settings** > **Schedule**.

1. Go to **Dataflow** > **Exports**.
2. Open the **Destinations** tab and select the export that you want to schedule.
3. In the **Actions** column, click the horizontal ellipsis and select **Schedule**.

The Schedule window appears.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/ExportSchedule.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=b597cabc22e9810f34df1a2a01bf54f8" alt="Export Schedule" style={{border: "1px solid black"}} width="668" height="713" data-path="doc_snippets/ExportSchedule.png" />

4. To activate the scheduled export automatically, click on the **Schedule run** button to set **On**. If turned off, the export will only run if activated manually.
5. Choose a **Recurrence** value to refresh the exported data automatically.
6. Click **Save** to apply your changes.

## To export metadata along with CSV files

You can export a metadata JSON file, containing information about the purpose, frequency, etc. The metadata JSON file is exported with each exported CSV file.

Follow the below steps:

1. Go to **Dataflow > Exports**.
2. In the **Exports** page, click **Destinations** tab.
3. Select the created Export connector and click the horizontal ellipses under **Actions** column.
4. Click **Edit**.

The **Edit export** form appears.

<img src="https://mintcdn.com/skypoint/GxPM0bRCdkUs_uDj/doc_snippets/Exports_Metadata1.png?fit=max&auto=format&n=GxPM0bRCdkUs_uDj&q=85&s=596dd9885b7160e04a5eeea4f76d9922" alt="Exports Metadata" style={{border: "1px solid black"}} width="541" height="573" data-path="doc_snippets/Exports_Metadata1.png" />

5. Click **Next** and select a table for export.
6. Add key-value pairs in the **Metadata to be exported** section. You can add up to 10 key-value pairs.
7. Click **Update**.

## List of all export connectors

* [Amazon S3](amazons3export)
* [Azure Data Lake Storage Gen2](adlsgen2export)
* [Campaign Monitor](campaignmonitorexport)
* [Facebook Ads](facebookadsexport)
* [Google Ads](googleadsexport)
* [Klaviyo](klaviyoexport)
* [Salesforce Marketing Cloud](sfmcexport)
* [SendGrid](sendgridexport)
* [Actions](actions)
* [Triggers](triggers)
* [Throttling](throttling)

## See also

* [Dataflows](dataflows)
* [Platform Schedule Settings](schedule)
* [Connectors](connectors)