OvalEdge Logo
Uncategorized

Filtered Row Extraction from OE Table by Schema ID and Table Name Pattern Match

Description

This ETL workflow performs a targeted data retrieval operation against the oetable source, applying dual-predicate filtering logic to isolate specific records. Execution begins with ingestion of the full oetable dataset, followed by a schema-scoped filter enforcing oeschemaid equality to the integer value 1000. A secondary string-pattern filter is then applied to the tablename column, performing a substring containment match for the value "Cheddar." The resulting filtered rowset is surfaced as the final output, enabling downstream consumers to inspect only records satisfying both predicate conditions. This workflow supports schema-level data auditing, metadata validation, and targeted record inspection use cases within the OE data domain.

Details

This ETL workflow performs a targeted data retrieval operation against the oetable source, applying dual-predicate filtering logic to isolate specific records. Execution begins with ingestion of the full oetable dataset, followed by a schema-scoped filter enforcing oeschemaid equality to the integer value 1000. A secondary string-pattern filter is then applied to the tablename column, performing a substring containment match for the value "Cheddar." The resulting filtered rowset is surfaced as the final output, enabling downstream consumers to inspect only records satisfying both predicate conditions. This workflow supports schema-level data auditing, metadata validation, and targeted record inspection use cases within the OE data domain.