I would like to write a dockerized Python application. This application should extract data from a Postgres table and save it as a csv file in Google Cloud Storage.
The source Postgres database is located on an external on premise server behind VPN.
My quesion is how to efficienlty establish a connection from Google Clould to this VPN server to be able to have access to the Postgres database.
The application should be invoked only once a month so the amount of the transfered data will not be significant.