Fired at the muzzle, a representative 9mm Luger load (8 g, FMJ, 360 m/s) reaches roughly 154 mm (6.1 inches) into packed sand. That is enough to defeat a typical barrier of this material — treat anything behind it as exposed.
Packed sand (~150 mm), e.g. a single sandbag.