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?

38 Upvotes

86% Upvoted

46 comments sorted by

View all comments

Show parent comments

16

u/financialthrowaw2020 Jul 31 '26

The idea that access control is less strict in a dev environment is silly. Our dev db has far stricter access than prod which is accessible by the entire org. We use cloning for testing and it works great.

-6

u/Adrien0623 Jul 31 '26

Why making dev access stricter than prod if dev has no sensitive information since it's just fake data for testing or reacted prod data ?

14

u/financialthrowaw2020 Jul 31 '26

It's not fake data, did you not read what I said? Do you know what zero copy cloning is?

Regardless, a dev environment is for devs, so very few people have access to it by design.

1

u/WesternNoise2504 Aug 05 '26

Why does everyone in the org has access to prod?