Carney's visit is aimed at attracting investment from Emirati sovereign wealth funds and the private sector to help diversify Canada's economy in response to U.S. tariffs.