{"record":{"id":"2c81f94558f15700","repo":"risingwavelabs/risingwave","slug":"bigquery-error-0","errorCode":null,"errorMessage":"BigQuery error: {0}","messagePattern":"BigQuery error: (.+?)","errorType":"exception","errorClass":"SinkError","httpStatus":null,"severity":"error","filePath":"src/connector/src/sink/mod.rs","lineNumber":1196,"sourceCode":"        anyhow::Error,\n    ),\n    #[error(\"Starrocks error: {0}\")]\n    Starrocks(String),\n    #[error(\"File error: {0}\")]\n    File(String),\n    #[error(\"Pulsar error: {0}\")]\n    Pulsar(\n        #[source]\n        #[backtrace]\n        anyhow::Error,\n    ),\n    #[error(transparent)]\n    Internal(\n        #[from]\n        #[backtrace]\n        anyhow::Error,\n    ),\n    #[error(\"BigQuery error: {0}\")]\n    BigQuery(\n        #[source]\n        #[backtrace]\n        anyhow::Error,\n    ),\n    #[error(\"DynamoDB error: {0}\")]\n    DynamoDb(\n        #[source]\n        #[backtrace]\n        anyhow::Error,\n    ),\n    #[error(\"SQL Server error: {0}\")]\n    SqlServer(\n        #[source]\n        #[backtrace]\n        anyhow::Error,\n    ),\n    #[error(\"Postgres error: {0}\")]","sourceCodeStart":1178,"sourceCodeEnd":1214,"githubUrl":"https://github.com/risingwavelabs/risingwave/blob/6469eb736d691e8e9b8a419a57edd6429ca77417/src/connector/src/sink/mod.rs#L1178-L1214","documentation":"A SinkError variant wrapping an anyhow::Error from the gcp-bigquery-client crate. Raised when BigQuery sink operations fail: authentication, dataset/table resolution, insertAll (streaming insert) errors, or quota/permission rejections.","triggerScenarios":"Loading GCP credentials fails, the dataset or table does not exist, BigQuery rejects rows via insertAll (invalid schema, missing required fields), or API quota/permission errors occur.","commonSituations":"Missing/invalid GOOGLE_APPLICATION_CREDENTIALS or service-account key, wrong dataset/table id, schema mismatch with the BigQuery table, exceeded quota or lacking bigquery.tables.updateData permission.","solutions":["Verify GCP credentials (service account key path/env) and that they grant BigQuery Data Editor on the target table.","Confirm dataset and table names in the sink options exist and schemas match.","Check the wrapped message for insertAll row errors and fix mismatched columns/types.","Watch for quota/permission errors and request increases or correct IAM bindings."],"exampleFix":null,"handlingStrategy":"try-catch","validationCode":"bq show --format=prettyjson project:dataset.table # pre-check table existence, schema, and access","typeGuard":null,"tryCatchPattern":"match err { SinkError::BigQuery(e) => { log::error!(\"bigquery: {e:#}\"); /* on 429/5xx retry with backoff; on permission/schema errors fix IAM or schema */ } _ => return Err(err) }","preventionTips":["Set GOOGLE_APPLICATION_CREDENTIALS correctly and pre-test auth with gcloud/bq","Match sink columns/types to the BigQuery table schema","Grant bigquery.tables.updateData and monitor quota usage"],"tags":["sink","bigquery","gcp","authentication"],"backgroundTag":"upstream-api-error","analyzedSha":"6469eb736d691e8e9b8a419a57edd6429ca77417","analyzedAt":"2026-09-11T21:06:21.487Z","contentChangedAt":"2026-09-11T21:06:21.487Z","schemaVersion":2},"datasetVersion":"2026-09-14T21:17:11.552Z"}