Accelerated automatic creation of data transformations

Abstract

A computer-implemented method comprising receiving, from a user computer at a server computer, a configuration file specifying one or more data source identifiers of source database tables in a target database system, one or more data sink identifiers of sink database tables in the target database system, and two or more data transformations; the server computer initiating execution of a data transformation framework by loading one or more configuration parameters of the configuration file into main memory of the server computer to define a workflow; creating and storing a configuration table based on the configuration file, the configuration table comprising a plurality of dynamic queries, a plurality of identifiers of transformation functions, and names of the one or more data transformations; in the configuration table, for each of the transformations, creating a plurality of dynamic common table expression queries, each of the dynamic common table expression queries being associated with a particular transformation function matching one of the identifiers of the transformation functions; based on the configuration table, serially executing the dynamic common table expression queries to serially execute the one or more data transformations of the source database tables to the sink database tables.