how to allow conection form datastudio

[Juan Pablo Vidal]

Hi guys!!

I need connect from Google Datastudio to my server Database MySQL that is runing on Compute Engine.

But i have to create a rule in the firewall for allow the connection.

Any idea?

because i dont want to public my Machine on internet.

Thanks for the help 

[pralove]

Hello,

If you have instance with no external Ip in GCP, you can connect from external networks by using the following methods[1].

1. Connecting an instance over a VPn connection[2]

2. Connecting through a bastion host instance[3]

3. Connecting using IAP for TCP forwarding[4]

You can also create a firewall rule[5] to allow connection only from your public ip to the external ip of your database server on ssh port(eg: port 22) that is running on compute engine.

I hope this helps. 

Thanks. 

[1] https://cloud.google.com/compute/docs/instances/connecting-advanced#sshbetweeninstances

[2] https://cloud.google.com/compute/docs/instances/connecting-advanced#vpn

[3] https://cloud.google.com/compute/docs/instances/connecting-advanced#bastion_host

[4] https://cloud.google.com/compute/docs/instances/connecting-advanced#cloud_iap

[5] https://cloud.google.com/vpc/docs/using-firewalls#creating_firewall_rules