- 31 May 2023
- Print
- DarkLight
- PDF
Step 2 - Data Preview and Advanced Settings
- Updated on 31 May 2023
- Print
- DarkLight
- PDF
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.
Depending on the volume of data, it may take a few minutes to generate the preview.
- Loading preview
- Preview generation complete
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.
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.
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.
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.