Is there a way in PP to identify columns which have all 0 values or columns where the data shows very little variance?

Yes, please use the attached component. Place it on the stream, and it will remove such properties.

Note. The data will be temporarily accumulated in a cache file (which will then be auto-deleted).