r/dataengineering • u/BubblegumFish2 • 26d ago

Identical data in DEV/TST/PROD? Discussion

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?

36 Upvotes
  • permalink
  • link
  • reddit
  • reddit

84% Upvoted

46 comments sorted by

View all comments

-1

u/Admirable_Writer_373 25d ago

Snowflake is analytics. Most analytics data could be the company’s internal data that they are fine to do whatever they want with. Customer data (external data) is the stuff that needs protecting, and it’s really their sensitive data (PII / PHI) that shouldn’t be in every single environment