Constraints on primordial non-Gaussianity from large scale structure probes