That's a good idea (I'll probably use production data though as it's a DWH so not hit frequently). I'm actually thinking about just duplicating production data

That's a good idea (I'll probably use production data though as it's a DWH so not hit frequently). I'm actually thinking about just duplicating production data to a local database and be a shadow DBA.