Material doesn't appears properly
The material uses a displacement and will work only with Cycles rendering.
Also, the displacement scale is relatively low.
So, use Cycles and increase the displacement scale (check all parts in green below):

Additionally, you may need to add some subdivision to the object for a better rendering of this displacement.