Run

datasqill allows starting multiple transformations in a context. For example, all transformations of a worksheet or a folder can be started.

datasqill collects all transformations from all worksheets belonging to the started context, recognizes the dependencies between the transformations, and automatically ensures the correct execution order. If transformation A uses an object that is written by transformation B, then transformation A waits until transformation B is finished. Dependencies exist only between transformations but are determined through the objects used.

In our concrete case, the table DATA_MART.D_PART is written by the transformation "upsert: d_part" and then used by the transformation "insert: f_profit", which triggers a dependency between the two transformations. When starting the folder with the example transformations, the run would therefore look like this.