@Oliver Angelil​ one more thing we need to consider before opting managed or external is your gold layer consumers, if you have BI env most of things will be external based on need. Also we need to see type of tables that are present in yiu current existing hive metastore which is legacy