How to find a data warehouse's design diagram?
You probably need a product that can perform database design reverse engineering.

Having said that, we refrain from giving product advice on dba.stackexchange.com since questions about which tool, library, product or resource you should use quickly become obsolete and often are just about the preferences of the answerer.