How does your data team unit test data transformation code, especially when that code is written in SQL?

2.6k viewscircle icon3 Comments
Sort by:
Head of Technical Delivery Services in Travel and Hospitality2 years ago

Use simulated data streams to create artificial datasets using data tranformation code and validate it against expected output.

Director of Customer Engineering - APAC in Software2 years ago

Validate with dummy data

Director of Engineering in Healthcare and Biotech2 years ago

Use fake input into the code under test and check to ensure the output matches what's expected. 

Content you might like

Unrealistic13%

Highly optimistic48%

Moderately optimistic20%

Cautiously optimistic14%

Pessimistic4%

Other1%

View Results

Yes84%

No12%

Not sure3%

View Results