How do I point it to my cloudways? What records do I need to create?
Here is a KB article that will help you out. You need to set an A record equal to your server’s IP address.
There are 2 steps.
Firstly you need to ensure that your application is set to respond to yourdomain.com.
Secondly, you have to add your server IP address as an A record in your DNS table.
Here’s another link that will be useful in addition to the info linked by @russell https://support.cloudways.com/how-do-i-take-my-website-live-from-cloudways/