Update view table: add broker, pamm.name, external_id