Make 3D scene fade on an axis?

Godot Version

4.3

Question

I have a scene that is supposed to give an illusion that it is somewhat high up. I have an object that extends downwards that I want to seem as if it went on for ages.
image
My question is; how can I apply a “fade” to the scene where any object that crosses a value on the Z axis would have a fade applied to it so that you don’t see the end?

Sorry if this all sounds confusing, I’m finding it hard to put into words.

shaders are good for this. Without getting into code I see it’s a transparent material, maybe you can set this material to blend with a Gradient2D.