The problem I’m having
Hey everybody! I have a dbt ↔ BQ question. In a nutshell the problem is - dbt ingests data from a prod replica DB - we use
- Data gets loaded from our GCP-hosted MySQL DB
- One or two rows is loaded incorrectly/corrupted, e.g.
is_bool_columngets loaded as null instead of 0/1
- We perform group by on the column within our dbt transformations
- we get a duplicated record for an order/retailer/…
What I’ve already tried
There is already a GH issue and I’ve included all detailed information here - [CT-2117] [CT-2113] [Bug] Corrupted data load from GCP-hosted MySQL DB · Issue #534 · dbt-labs/dbt-bigquery · GitHub
If there are any additional questions, please let me know, happy to provide as much context as possible!