# ETL Staging Tables

In the ETL Summary page, click the S**taging Tables** tab. The Staging Tables tab is displayed. It provides a read-only view of the tables created and managed by the selected ETL pipeline.

These staging tables are used as the primary data source for reporting and analytics in external tools such as Tableau and Power BI.

This tab helps users verify table availability, understand where staging data is stored, and confirm that metadata is ready for downstream reporting use cases.

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

<table><thead><tr><th width="148">Field</th><th>Description</th></tr></thead><tbody><tr><td>Connector</td><td>Displays the connector associated with the staging table location. It helps users identify the linked database connection.</td></tr><tr><td>Database</td><td>Displays the database name where the staging table is stored. It helps users identify the reporting or staging database.</td></tr><tr><td>Schema</td><td>Displays the schema name that contains the staging table. It helps users locate the table within the selected database.</td></tr><tr><td>Table</td><td>Displays the name of the staging table created or managed by the ETL pipeline.</td></tr><tr><td>Crawl Status</td><td>Displays the metadata crawl status of the staging table. It helps users verify whether the table metadata is available in OvalEdge.</td></tr></tbody></table>

**More Actions**

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

<table><thead><tr><th width="158">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>

## Important Points

{% hint style="warning" %}
Error Handling: Any failure triggers a complete rollback to ensure consistency and prevent partial loads.
{% endhint %}

**Clearing Data**

<table><thead><tr><th width="126">Aspect</th><th>Description</th></tr></thead><tbody><tr><td>Purpose</td><td>Removes data from target tables without deleting structures.</td></tr><tr><td>Use Case</td><td>Reprocess data or perform periodic cleanups while retaining table definitions.</td></tr><tr><td>Rollback</td><td>Complete rollback on script failure.</td></tr></tbody></table>

**Deleting ETL Configuration**

<table><thead><tr><th width="129.33331298828125">Aspect</th><th>Description</th></tr></thead><tbody><tr><td>Purpose</td><td><ul><li>Drops created tables/schemas</li><li>Removes associated ETL configurations.</li></ul></td></tr><tr><td>Behavior</td><td>Deletion occurs only after the delete script executes successfully.</td></tr><tr><td>Outcome</td><td>Database elements and the ETL configuration are permanently removed.</td></tr></tbody></table>

**Notes**

<table><thead><tr><th width="134.66668701171875">Note Type</th><th>Details</th></tr></thead><tbody><tr><td>Critical</td><td>Always verify database connectivity before running ETL scripts to ensure seamless data processing.</td></tr><tr><td>Operational</td><td>Schedule ETL runs during off-peak hours to minimize system impact.</td></tr><tr><td>Maintenance</td><td>Clear scripts can be used before reprocessing data to prevent duplication.</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-staging-tables.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.