GCP BigQuery fedarated query to cloudsql gives connection not found error

Solution 1:

I found that this error occurs when your connection is created in a region / location that is different from the region where the cloudsql instance resides. As far as you create a connection in the SAME region as your cloudsql mysql instance's region this works fine . Thanks !