# ETL Summary

In the ETL Home page, click the required ETL Name. The Summary page is displayed. It provides a centralized view of the selected ETL pipeline, including configuration details, execution settings, SQL scripts, and audit history.

This page helps users review and manage the ETL setup, monitor configuration changes, verify scheduling details, and understand the pipeline's structure for staging and reporting workflows.

The Audit History section tracks updates made to the ETL configuration, including user and timestamp details.<br>

<figure><img src="/files/wS4UHila1ZQDSf7gSAHD" alt=""><figcaption></figcaption></figure>

<table><thead><tr><th width="197.3333740234375">Field</th><th>Description</th></tr></thead><tbody><tr><td>Description</td><td>Displays the business purpose, functional scope, or usage details of the ETL configuration. It helps users understand why the ETL job was created, what type of data it processes, and how it supports reporting or analytics requirements.</td></tr><tr><td>ETL Metadata</td><td>Displays audit and ownership details related to the ETL configuration. It helps users identify who made the latest changes and when the configuration was modified.</td></tr><tr><td>ETL Connection Info</td><td>Displays the connector details associated with the ETL job. It helps users verify which connection is used to run the ETL process, including connector identifiers and names used for source or target database access.</td></tr><tr><td>ETL Configuration</td><td>Displays the execution settings configured for the ETL job. It helps users review schedule details such as the cron expression, next execution time, and other run-time preferences that control when and how the ETL job is executed.</td></tr><tr><td>Staging Tables Creation SQL Scripts</td><td>Displays the SQL scripts used to create staging tables, schemas, or required database objects before the ETL load process begins. It helps users understand the structures required for ETL processing.</td></tr><tr><td>Staging Tables Creation SQL Scripts Pop-up</td><td>Displays a detailed and expanded view of the staging table creation scripts. It helps users review the full SQL statements used to create tables, indexes, schemas, or related database objects required for ETL processing.</td></tr><tr><td>Data Insertion SQL Scripts</td><td>Displays the SQL scripts used to extract, transform, and load data into the staging tables. It helps users understand the logic behind populating reporting structures.</td></tr><tr><td>Data Insertion SQL Scripts Pop-up</td><td>Displays a detailed and expanded view of the data insertion scripts. It helps users review the complete SQL logic used during ETL execution to load and refresh staging data.</td></tr><tr><td>Clear Existing Data SQL Scripts</td><td>Displays the SQL scripts for removing existing records from staging tables while retaining the table structures. It helps users clear staged data before reprocessing or refreshing records.</td></tr><tr><td>Clear Existing Data SQL Scripts Pop-up</td><td>Displays a detailed and expanded view of the scripts used to clear existing data from staging tables. It helps users review, truncate, delete, or clean up statements configured for pre-load processing.</td></tr><tr><td>Staging Tables Deletion SQL Scripts</td><td>Displays the SQL scripts for dropping staging tables, schemas, or other related database objects when the ETL configuration is no longer required. It helps users remove obsolete staging structures.</td></tr><tr><td>Staging Tables Deletion SQL Scripts Pop-up</td><td>Displays a detailed and expanded view of the deletion scripts. It helps users review the SQL statements for removing staging tables and related structures from the database.</td></tr><tr><td>Clear Data Before Running</td><td>Use the toggle button to define whether existing data in staging tables will be cleared before the ETL load process starts. It helps users avoid duplicate records during reprocessing or refresh operations.</td></tr><tr><td>Audit History</td><td>Displays the history of changes made to the ETL configuration. It helps users track updates with user and timestamp details.</td></tr></tbody></table>

**More Actions**

Click the 9-Dots Menu to perform the following actions.

<table><thead><tr><th width="160.66668701171875">Action</th><th>Description</th></tr></thead><tbody><tr><td>Run ETL</td><td>Executes the selected ETL pipeline immediately.</td></tr><tr><td>Clone ETL</td><td>Creates a copy of the current ETL configuration for reuse.</td></tr><tr><td>Delete ETL</td><td>Removes the selected ETL configuration from the system.</td></tr><tr><td>Clear Data From Staging Tables</td><td>Removes existing records from staging tables while retaining table structures.</td></tr></tbody></table>

***

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ovaledge.com/release8.1/advanced-tools/etls/etl-summary.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.