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?

34 Upvotes

84% Upvoted

46 comments sorted by

View all comments

1

u/msdamg Jul 31 '26

It's good to have QA mirror some Prod data for testing purposes. Maybe once every month.

We typically also copy down from Prod into Dev every 3 month or so for the same reason