What is the name of ride that Greg and Rowley in book 4?

You're likely thinking of The Cheese Touch, which is the name of the ride in Diary of a Wimpy Kid: Dog Days (book 4).

This is a water park ride where Greg and Rowley get stuck after Rowley gets "The Cheese Touch" from a piece of cheese that's been passed around on the ride.