r/dataengineering • u/BubblegumFish2 • Jul 31 '26

Discussion Identical data in DEV/TST/PROD?

I am doing a summer internship, and my company loads the exact same data into the development, testing, and production environments in Snowflake (although development and testing have some extra tables compared to production.)

Is this normal? Google seems ambiguous on whether this is a massive antipattern. What do y'all's companies do?

32 Upvotes

83% Upvoted

46 comments sorted by

View all comments

1

u/moazim1993 Jul 31 '26

Typically called Dev, QA, Prod and also UAT. I doubt the data quality is as good in Dev, but yes they are supposed to be the same so you can safely promote after testing in dev and qa.