We explore the potential to prove light extra gauge $Z^prime$ boson inducing non-standard neutrino interactions (NSIs) in the coherent-elastic neutrino-nucleus scattering (CE$ u $NS) experiments. We intend to examine how the latest COHERENT-CsI and CENNS-10 data can constrain this model. A detailed investigation for the upcoming Ge, LAr-1t, and NaI detectors of COHERENT collaboration has also been made. Depending on numerous other constraints coming from oscillation experiments, muon $ (g-2) $, beam-dump experiments, LHCb, and reactor experiment CONUS, we explore the parameter space in $Z^prime$ boson mass vs coupling constant plane. Moreover, we study the predictions of two-zero textures that are allowed in the concerned model in light of the latest global-fit data.