ETL Staging Tables

In the ETL Summary page, click the Staging 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.

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

More Actions

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

Action	Description
Run ETL	Executes the selected ETL pipeline immediately.
Clone ETL	Creates a copy of the current ETL configuration for reuse.
Delete ETL	Removes the selected ETL configuration from the system.
Clear Data From Staging Tables	Removes existing records from staging tables while retaining table structures.

Important Points

Error Handling: Any failure triggers a complete rollback to ensure consistency and prevent partial loads.

Clearing Data

Aspect	Description
Purpose	Removes data from target tables without deleting structures.
Use Case	Reprocess data or perform periodic cleanups while retaining table definitions.
Rollback	Complete rollback on script failure.

Deleting ETL Configuration

Aspect	Description
Purpose	Drops created tables/schemas Removes associated ETL configurations.
Behavior	Deletion occurs only after the delete script executes successfully.
Outcome	Database elements and the ETL configuration are permanently removed.

Notes

Note Type	Details
Critical	Always verify database connectivity before running ETL scripts to ensure seamless data processing.
Operational	Schedule ETL runs during off-peak hours to minimize system impact.
Maintenance	Clear scripts can be used before reprocessing data to prevent duplication.

---

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