If you or your data practitioners could analyze hierarchical/transactional/granular data from the original source without normalizing/summarizing it first, how much of an impact would it have on project timelines/data workloads?
Tremendous impact11%
Some impact75%
Little impact11%
No impact2%
237 PARTICIPANTS
Isn't this just allowing direct access to source data, even in a read replica or fully replicated form in a data warehouse?
Technically there's never been any blocks to accessing source data, so I'd expect this to be largely one of regulation/process versus any other reason.
I think humans should not be messing around in live data even if it's just query as that could have negative impacts on system performance, but that's still just a process or procedure note.