@Marvin I have been trying to add my cloud sql instance to my job configuration in my work pool but everytime I make the change all deployments using the workpool crashes. My job config that keep crashes, look like this. Does anyone know what I am doing wrong

{
  "job_configuration": {
    "env": "{{ env }}",
    "name": "{{ name }}",
    "labels": "{{ labels }}",
    "region": "{{ region }}",
    "command": "{{ command }}",
    "timeout": "{{ timeout }}",
    "job_body": {
      "kind": "Job",
      "spec": {
        "template": {
          "metadata": {
            "annotations": {
              "<http://run.googleapis.com/vpc-access-connector|run.googleapis.com/vpc-access-connector>": "{{ vpc_connector_name }}"
            }
          },
          "spec": {
            "template": {
              "spec": {
                "containers": [
                  {
                    "image": "{{ image }}",
                    "command": "{{ command }}",
                    "resources": {
                      "limits": {
                        "cpu": "{{ cpu }}",
                        "memory": "{{ memory }}"
                      },
                      "requests": {
                        "cpu": "{{ cpu }}",
                        "memory": "{{ memory }}"
                      }
                    }
                  }
                ],
                "timeoutSeconds": "{{ timeout }}",
                "serviceAccountName": "{{ service_account_name }}"
              }
            }
          }
        }
      },
      "metadata": {
        "name": "{{ name }}",
        "annotations": {
          "<http://run.googleapis.com/launch-stage|run.googleapis.com/launch-stage>": "BETA"
        }
      },
      "apiVersion": "<http://run.googleapis.com/v1|run.googleapis.com/v1>"
    },
    "keep_job": "{{ keep_job }}",
    "credentials": "{{ credentials }}"
  }
}

I get an error message that looks like this

Failed to generate job configuration: 1 validation error for PushPoolCloudRunWorkerJobConfiguration
job_body
  Value error, Job is missing required attributes at the following paths: /spec/template/spec/template [type=value_error, input_value={'kind': 'Job', 'spec': {...'<http://run.googleapis.com/v1|run.googleapis.com/v1>'}, input_type=dict]
    For further information visit <https://errors.pydantic.dev/2.9/v/value_error>

Your message was too long by 251 tokens - please shorten it and try again. For reference, here's your message at the allowed limit:

I have been trying to add my cloud sql instance to my job configuration in my work pool but everytime I make the change all deployments using the workpool crashes. My job config that keep crashes, look like this. Does anyone know what I am doing wrong

```{ "job_configuration": { "env": "{{ env }}", "name": "{{ name }}", "labels": "{{ labels }}", "region": "{{ region }}", "command": "{{ command }}", "timeout": "{{ timeout }}", "job_body": { "kind": "Job", "spec": { "template": { "metadata": { "name": "{{ name }}", "annotations": { "<http://run.googleapis.com/cloudsql-instances%7Crun.googleapis.com/cloudsql-instances>": "{{ cloudsql_instance }}" } }, "spec": { "template": { "spec": { "containers": [ { "image": "{{ image }}", "command": "{{ command }}", "resources": { "limits": { "cpu": "{{ cpu }}", "memory": "{{ memory }}" }, "requests": { "cpu": "{{ cpu }}", "memory": "{{ memory }}" } } } ], "timeoutSeconds": "{{ timeout }}", "serviceAccountName": "{{ service_account_name }}" }

hi @Michael - it looks like there might be an extra layer of nesting? like

"spec": {
        "template": {

seems to be inside itself, are you building this programmatically somehow?

Hi @Nate, the documentation didn't help, was adapting from a solution I saw online. So I am trying to connect to CloudSQL when I send the flow to be ran in Cloud Run. The only way is to add it to the base job template found in the advanced tab of the Work pool. I didn't find any documentation on how to do this so I just adapted mine from a solution I saw at https://linen.prefect.io/t/15996175/is-it-possible-to-add-a-cloud-sql-connection-with-a-serverle

ok, i’m suggesting that maybe you have accidentally doubly nested the spec portion of your job config because of the validation error message shown above

It is actually cloud Run 😅

so i think the cloudsql instances are only supported in the cloud run v2 hybrid worker, meaning you'd have to run this worker yourself, though we could definitely get support added to the push pool at some point we'd essentially just have to port this PR

Okay, thank you very much for this, I would try it out. Just have to configure my worker first 😅

Finally @Nate which do you think is better for a Worker, Cloud Run service or a Kubernetes cluster?

cloud run service unless you have some strong idiosyncratic reason to use kubernetes

Not really. Thank you very much I really appreciate it

👍

@Nate I was able to change the kind of work pol, Now I am facing the final boss, the validation error