I am not expert on this but if your terrace roof has a slope, which it must, the water will not lie under the bed, which is good.
Whether the roof cracks depends on the roof material and the strength of it’s supporting timbers. You need to find some advice on how much weight they can support.
I would fill a bed with compost which is lighter than soil.
