The best tonneau covers are made of waterproof materials such as aluminum, fiberglass, and vinyl. The problem is the edges, as these might contain gaps that allow the water in.
When looking for a cover, be keen on the unit’s features for preventing the water from getting in through the edges. Some come with Velcro strips, and some come with rubber strips and weather stripping. These guards are vital.