Hey all, I started using Airbyte yesterday. I managed to set it up and create a source (planetscale) and destination (bigquery) When doing the sync I’m getting a bunch of errors

2022-07-24 19:55:48 normalization > 19:55:42.951512 [error] [MainThread]: Database Error in model users_scd (models/generated/airbyte_incremental/scd/dev_planetscale_sync/users_scd.sql)
2022-07-24 19:55:48 normalization > 19:55:42.952160 [error] [MainThread]:   Bad bool value: 1
2022-07-24 19:55:48 normalization > 19:55:42.952742 [error] [MainThread]:   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/scd/dev_planetscale_sync/users_scd.sql
2022-07-24 19:55:48 normalization > 19:55:42.953318 [info ] [MainThread]: 
2022-07-24 19:55:48 normalization > 19:55:42.953890 [error] [MainThread]: Database Error in model series_scd (models/generated/airbyte_incremental/scd/dev_planetscale_sync/series_scd.sql)
2022-07-24 19:55:48 normalization > 19:55:42.954516 [error] [MainThread]:   Bad bool value: 0
2022-07-24 19:55:48 normalization > 19:55:42.955168 [error] [MainThread]:   compiled SQL at ../build/run/airbyte_utils/models/generated/airbyte_incremental/scd/dev_planetscale_sync/series_scd.sql

Any idea on what I’m doing wrong here?

Same here. Seems that tinyInt for PlanetScale is not recognized as tinyInt but as bool, then normalization process gives the error “Bad bool value: 1”. If we removed all the tables that have boolean(tinyInt), normalization passed. But I haven’t found the solution so far.

same except mine shows as null and just says “Problem with x column”