Hey Phil!

Flow is as follows:

Text File --> Raw Table --> Staging Table --> Production Staging Table (Different VM) --> Production Table.

A lot, if not all of the Transformations happen in the Staging Table. As a general rule, I don't think any CRUD/MACD should happen once the data is pushed to the production environment.