region related error when i try to list cloud_run_services

[omeredizaydin]

Describe the bug

When i execute a sql query to fetch Cloud Run Services on GCP, I am getting an error that says

"ERROR: rpc error: code = Unknown desc = productdevdev_gcp_security: googleapi: Error 400: region: Unsupported region northamerica-south1 Details: [ { "@type": "type.googleapis.com/google.rpc.BadRequest", "fieldViolations": [ { "description": "Unsupported region northamerica-south1", "field": "region" } ] } ] , badRequest (SQLSTATE HV000)"

My Query is something like:
select * from gcp_cloud_run_service;
or
select * from gcp_cloud_run_service where location <>'northamerica-south1';

I try also to use region column instead of location but it says there is no such a column.

Steampipe version (steampipe -v)
v1.0.1

Plugin version (steampipe plugin list)
v1.0.0

To reproduce

1. Select STEAM PIPE under pipes
2. Under Query tab, select tenant_name_GCP_SECURITY (in my case)
3. Select gcp_cloud_run_service table.

Error will show up. I intended to resolve the issue by changing the query but it still occurs.

Expected behavior
I expected it to list cloud_run_services on GCP. I made sure that i have required permissions on GCP side.

[ramses999]

Hi, I am also getting similar error in below query
select project, location, name, title, client, uri, create_time, creator, ingress, annotations, tags from gcp.gcp_cloud_run_service
then I get an error

[
  {
    "@type": "type.googleapis.com/google.rpc.BadRequest",
    "fieldViolations": [
      {
        "description": "Unsupported region northamerica-south1",
        "field": "region"
      }
    ]
  }
]

Can you fix this?

[edizduman]

Hi,

When running an SQL query to retrieve Cloud Run Services on GCP, I encounter the following error:

"fieldViolations": [{ "description": "Unsupported region northamerica-south1", "field": "region" }]}]

SELECT * FROM gcp_cloud_run_service;

[halit-c4c]

Hi, I am getting the exact same error when i execute the sql query below.

select
*
from
gcp_cloud_run_service
limit
100;

ERROR: rpc error: code = Unknown desc = userName: googleapi: Error 400: region: Unsupported region northamerica-south1 Details: [ { "@type": "type.googleapis.com/google.rpc.BadRequest", "fieldViolations": [ { "description": "Unsupported region northamerica-south1", "field": "region" } ] } ] , badRequest (SQLSTATE HV000)