@erez I cannot share the full logs because there’s too much to redact here - but maybe it’ll help when I explain what I see; otherwise I can probably provide them to you directly via E-Mail.
I’m wondering if this might be related to GCP APIs rate limiting us (e.g. for quota reasons) since we are querying data for ~4400 accounts. What I can say is that other tables work fine with the same configuration.
apiVersion: v1
data:
config-gcp.yaml: |
kind: source
spec:
name: "gcp"
path: "cloudquery/gcp"
version: "v23.0.0"
tables: ["${CLOUDQUERY_GCP_TABLE}"]
skip_tables: ["gcp_dataproc_regions","gcp_dataproc_autoscaling_policies"]
destinations: ["postgresql", "bigquery"]
backend_options:
table_name: "cq_gcp_state"
connection: "@@plugins.postgresql.connection"
kind: ConfigMap
We’re using a JSON env file:
apiVersion: v1
data:
service-account-gcp.json: |-
{
"type": "external_account", (...)
The logs start out clean, let me try to copy and paste the most notable entries:
(...)
{"level":"info","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"Using service account for GCP authentication","module":"gcp-source","service_account":"application-default-credentials","time":"2026-07-08T07:06:18Z","time":"2026-07-08T07:06:18Z"}
{"level":"info","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"No organization_ids or organization_filter specified - assuming all organizations","module":"gcp-source","time":"2026-07-08T07:06:18Z","time":"2026-07-08T07:06:18Z"}
{"level":"info","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"Listing organizations...","module":"gcp-source","time":"2026-07-08T07:06:18Z","time":"2026-07-08T07:06:18Z"}
{"level":"info","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"No project_ids, folder_ids, or project_filter specified - assuming all active projects","module":"gcp-source","time":"2026-07-08T07:06:18Z","time":"2026-07-08T07:06:18Z"}
{"level":"info","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"Found 4384 projects. First 100
(...)
{"level":"info","client":"project:{1}","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"top level table resolver started","module":"gcp-source","table":"gcp_iam_predefined_roles","time":"2026-07-08T07:07:17Z","time":"2026-07-08T07:07:17Z"}
{"level":"info","client":"project:{2}","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"top level table resolver started","module":"gcp-source","table":"gcp_iam_predefined_roles","time":"2026-07-08T07:07:17Z","time":"2026-07-08T07:07:17Z"}
(...)
{"level":"info","client":"project:{100}","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"top level table resolver started","module":"gcp-source","table":"gcp_iam_predefined_roles","time":"2026-07-08T07:07:17Z","time":"2026-07-08T07:07:17Z"}
{"level":"info","grpc.code":"Unauthenticated","grpc.component":"client","grpc.error":"rpc error: code = Unauthenticated desc = transport: per-RPC creds failed due to error: Get "``http://169.254.169.254/latest/meta-data/iam/security-credentials\``": EOF","grpc.method":"ListRoles","grpc.method_type":"unary","grpc.request.deadline":"2026-07-08T07:08:17Z","grpc.service":"google.iam.admin.v1.IAM","grpc.start_time":"2026-07-08T07:07:17Z","grpc.time_ms":"1047.618","invocation_id":"6dc1a99c-8947-4911-baeb-0bd9d64dff34","message":"finished call","module":"gcp-source","peer.address":"@","protocol":"grpc","time":"2026-07-08T07:07:18Z","time":"2026-07-08T07:07:18Z"}
and that’s where we start seeing tons of errors and the sync ultimately fails.