title: Google BigQuery Federated Query connection Error
body: <p>I am trying to use the Federated Query functionality in BigQuery to query some data from my Cloud SQL Postgres DB.</p>
  <pre><code>SELECT * FROM 
  EXTERNAL_QUERY('{project_name}.US.app_postgres_db', 'select id from posts limit 10')
  </code></pre>
  <p>Unfortunately I get the following error:</p>
  <pre><code>Invalid table-valued function EXTERNAL_QUERY Connect to PostgreSQL server failed: missing &quot;=&quot; after &quot;xxxx&quot; in connection info string at [3:1]
  </code></pre>
  <p>It is quite similar to the error discussed here, but it was not solved (the word that appears in the quotes is different though):
  <a href="https://stackoverflow.com/questions/59585153/connection-error-while-running-federated-query-in-bigquery-to-postgres-cloud-sql">Connection Error while running federated query in BigQuery to Postgres Cloud SQL instance</a></p>
  <p>For reference, I set up the connection in BQ with the following command:</p>
  <pre><code>bq mk --connection --display_name='App DB' --connection_type='CLOUD_SQL' \
  --properties='{&quot;instanceId&quot;:&quot;{project-name}:us-central1:postgres-main&quot;,&quot;database&quot;:&quot;main&quot;,&quot;type&quot;:&quot;POSTGRES&quot;}' \
  --connection_credential='{&quot;username&quot;:&quot;{username}&quot;, &quot;password&quot;:&quot;{password}&quot;}' \
  --project_id={project-name} --location=us app_postgres_db
  </code></pre>