Step 2 - Data Preview and Advanced Settings
  • 31 May 2023
  • PDF

Step 2 - Data Preview and Advanced Settings

  • PDF

Article Summary

Overview

This page explains the Step 2 Data Preview & Advanced Settings step, when creating an ETL Configuration.

Step 2 - Data Preview & Advanced Settings

In step 2 you can preview the data that will be loaded to your destination.
On this page, there are also several templates that you can use to transform your data.

Schema & Data Preview

After proceeding from step 1 to step 2, a preview of your data will be generated.
The preview contains column information, data type, and records from your data source.

Preview generation time

Depending on the volume of data, it may take a few minutes to generate the preview.

  • Loading preview

image.png

  • Preview generation complete

image.png

When the preview result differs from the data you wish to extract

At the top of the screen click Data Source & Destination Settings to reconfigure your settings.
When returning to step 2 after modifying your settings, the following dialog box below will appear.
Here, select whether to run Automatic Data Configuration, and click Next.

image.png

Please note that if you re-generate the preview in step 2, any changes previously made will be reset.

Advanced Settings

In step 2, you can set advanced settings for the data you will load.
After confirming your data preview, scroll down to Advanced Settings.
The advanced settings are separated into four tabs.

image.png

Data Settings

Here you can apply prebuilt transformations, or customize your transformations with code.
For more information on the transformations in the Data Settings tab, see Template ETL and Programming ETL

Input Options

Here you can set options for your data source.
Please note that the options that are available vary depending on your source connector.

Output Options

Here you can set options for your data destination.
Please note that the options that are available vary depending on your destination connector.

File and storage connectors

For further information on input and output options for file and storage connectors, see the following:

Job Settings

Here you can configure settings related your specific ETL job.

Next Steps

After making any changes above be sure to click the Preview Changes button.
You must click Preview Changes for any changes you made to take effect.

After checking the preview, click the Confirm button.
Continue to Step 3 - Confirm & Apply.

image.png


Was this article helpful?