Skip to main content

Troubleshoot the DB2 to BigQuery Reference

SymptomCheck
DB2 connection failsDriver, DSN, network path, TLS, credentials, and query permissions.
Mapping rejects a rowRequired fields, input types, date formats, currency code, and null behavior.
Account fields are unexpectedMask format, deterministic-key input, salt or key ownership, and downstream joins.
BigQuery rejects outputDataset, table schema, field types, partition field, credentials, and write mode.
Duplicate or missing rowsSource watermark, retries, idempotency key, partial writes, and reconciliation query.

Use synthetic or approved test records and a non-production destination while diagnosing. The repository has not exercised these integrations.

Reference: Open the combined configuration.