You can use transformations to define SQL statements. You can have these transformation SQL statements executed:
After deploying a data model. The applicable transformation categories are 'Modeling' and 'Instrumentation'.
Before or after exporting data. The applicable transformation category is 'Processing'.