Data Transformation Best Practices
Where do you prefer to perform data transformations and why? Should it be done in a data warehouse, or is it best fit for a BI tool? I have a preferred answer, but I'm really interested to hear what ...
Forum Discussion
I try to think about who might need to update that transformation in the future - our data team has an engineer and an analyst. If it's something I only want the engineer to manage, we'll perform the transformation in Redshift. If it's something I want our analyst to manage, we'll perform the transformation in an Elasticube. That Redshift<>Elasticube connection point is where we delineate a lot of job responsibilities.
