I don't understand how that's possible. I don't know of any lakes or rivers or aquifers larger enough to provide water to almost 40 million people in California.
Californian agriculture is 80% of water usage. That agriculture is largely shipped out of state, internationally, and supplying the rest of the US half of its produce outside staple grains: fruits, nuts, vegetables, berries, etc.
https://www.nature.org/media/california/california_drinking-...
The large greenery to the right is the Colorado River which provides 15% of CA water at the bottom.