If I use Starburst Galaxy to access EMR Hive, do I need to launch the public ip of the hive meta store? Or are there other ways to do this?
You can use a bastion host. You would add the Galaxy allow list IP range for the region you are in to the security group on the bastion host.