An AzTEC 1.1 mm survey of the GOODS‐N field – II. Multiwavelength identifications and redshift distribution