Contents x
    Useful Settings After Creating an ETL Configuration
    • 12 Jun 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Contents

    Useful Settings After Creating an ETL Configuration

    • Updated on 12 Jun 2023
    • 1 Minute to read
    • Print
    • Dark
      Light
    Article Summary

    Overview

    This page outlines the various settings you can apply to your ETL Configuration after creation.


    Schedule Settings enable you to automate the run timing of the configuration.
    Notifications can be used to notify users about the result of the execution, such as job completion or failure, errors, etc.
    Change History enables you to check any changes that have been made to the configuration, as well as the ability to restore a previous iteration.

    Schedules & Notifications

    You can also set up schedules and notifications for Data Mart and Workflow configurations.

    ETL Configuration Details Page

    The ETL Configuration details page is separated into four tabs.
    For information on how to get to the ETL Configuration details page from the main page, see Running an ETL Job.

    image.png

    ETL Configuration Overview

    Here, you can see information such as recently run jobs, data source and destination details, and an execution preview.
    Additionally, you can add and remove labels using the Labels tab in the right-side menu.

    image.png

    Schedule Settings

    Here, you can set schedules to automatically run your ETL job.
    For example, by setting a schedule you can run a job every Monday at 00:00.

    To set a schedule, first click Add Schedule.
    trocco currently supports four schedule frequencies: hourly, daily, weekly , and monthly.

    image.png

    image.png

    Notifications

    Here, you can set notifications for jobs that are run.
    By setting notifications, you can achieve the following:

    • Notify if an ETL Job execution fails
    • Notify if there is a 0 record difference after a transfer completes

    For information on setting up notifications, see Creating Notifications.

    image.png

    Change History

    Here, you can view any changes made to your ETL Configuration.
    You can view the details of past ETL Configurations, and the difference between the pre-edited and post-edited configurations.
    If necessary, you can also restore previous iterations.

    Under the Change History tab, you can achieve the following:

    • Return to the previous configuration after updating your ETL Configuration broke your pipeline
    • Checking the before and after when other users have made changes to the configuration

    image.png

    Restoring a Previous ETL Configuration

    Click Advanced Settings & Restore for the revision you wish to restore.
    Check the differences in the revision details, and if there are no issues, click the Restore Revision button.

    image.png

    The subsequent steps are the same as step 3 when setting up your ETL Configuration.

    Was this article helpful?
    What's Next