System and method for automatic generation of extract, transform, load (etl) asserts

Abstract

In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. Each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. During the process of populating a data warehouse instance, the system can automatically generate dynamic data-driven ETL asserts, including determining a list of columns for tables in the data warehouse; determining a data type for each column; generating an assert for each determined data type; validating the generated assert; and maintaining the generated assert.