We ended up 1) deleting the metastore (which only contained catalogs/schemas/tables), 2) creating a new one in the desired storage account and 3) re-populating it by running all Delta Live Tables pipeline. All our underlying raw data is stored in another storage account in delta format. Our Tableau connection to the SQL warehouse remained intact due to the same naming.