Benefits of being in the same network

I have been using QuickSight for a couple of days now, and I want to know if there are any benefits of connecting to a database on the same network (private) compared to connecting to a public database / database of another network.

We support both the options and cannot prescribe one over another. You may have to consult your admin and security team for the best practices.