Anyone here have advice on #etl #datawrangling #testing?
I have several ETL processes in SQL, mostly dealing with the "T", and I want to test them to validate that the transformations are happening as expected. Any good guides or advice on testing ETL?
I've thought about creating test input and output data and verifying the ETL results that way. I figure there has to be methods in place already for doing this kind of thing and I just don't know about it.
🍪🍪🍪🍪🍪🍪🍪🍪🍪🍪