Contents x
    Step 2 - Data Preview & Advanced Settings
    • 31 May 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Step 2 - Data Preview & Advanced Settings

    • Updated on 31 May 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article Summary

    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.
    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?
    What's Next