I’d like to query tables in CloudSQL from Dataform.
I set up an external connection to the CloudSQL database in bigquery, and am able to get query results when I run the federated query from BigQuery.

However, when I try to run the same query from a GCP Dataform job, it does not work, and I get an error that it cannot find the connection.

Is it possble to run federated queries from GCP Datafrom, and if so which setting and/or permissions are needed to get this working?