Datafusion connectivity with Cloud SQL (MS SQL )

[ajithsmin]

Team,

I am trying to connect cloud SQL (MS SQL) from datafusion (both are in same network) and there is  cloud SQL proxy running in between this. 

Cloud SQL proxy is getting started. 

Trying to access MS SQL from Datafusion ...it shows connection refused when I use 127.0.0.1 and port number 3307

when I use the Ip of VM where cloud SQL proxy is hosted ...it says not reachable..

[kvandres]

Good day @ajithsmin,

Welcome to Google Cloud Community! 

You can try checking the following if you were able to implement this: 

1. Verify if you were able to create a firewall rule that allows the  access to the proxy with the port 3307.
2. Verify if you were able to create a VPC Peering between the Data Fusion and the VPC. Here is how you can create a VPC Peering: https://cloud.google.com/data-fusion/docs/how-to/create-private-ip#set_up_network_peering
3. Try also allowing all IPs to bind on the Cloud SQL Proxy and set the port to 3307.
4. For the connection string, you need to use the proxy's private static IP address. 

Hope this helps!