- 31 May 2023
- 1 Minute to read
- Print
- DarkLight
Step 2 - Data Preview & Advanced Settings
- Updated on 31 May 2023
- 1 Minute to read
- Print
- DarkLight
This article explains the Step 2 Data Preview Advanced Settings step when creating an ETL Configuration. It provides a preview of the data that will be loaded to the destination, and allows users to apply prebuilt transformations or customize their own with code. Additionally, it allows users to set options for their data source and destination, as well as configure settings related to their specific ETL job. After making any changes, users must click Preview Changes for them to take effect before clicking Confirm.
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. Depending on the volume of data, it may take a few minutes to generate the preview.
The preview contains column information, data type, and records from your data source.
- Loading preview
- Preview generation complete
At the top of the screen click Data Source & Destination Settings to reconfigure your settings. Please note that if you re-generate the preview in step 2, any changes previously made will be reset.
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.
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. For further information on input and output options for file and storage connectors, see the following:
Please note that the options that are available vary depending on your destination connector.
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.