Cauldrons fill up when exposed to rain (albeit extremely slowly). Cauldrons also activate comparators based off of their water level. However, when they fill with rain, the comparator only updates when it fills to 100%; at 33% or 66% the comparator remains off unless it receives a manual update.

Code analysis by marcono1234 can be found in this comment.