Hi, for users of the default oracle tap, pipelinewise-tap-oracle, I have introduced a breaking change https://github.com/s7clarke10/pipelinewise-tap-oracle/commit/b0437b8df841da1185e4fc3d1bb51d90366328a7 . The tap was making an assumption if you have number data with a precision 1 and a scale of 0 that you are dealing with boolean data. While this assumption is often correct it is possible in Oracle to define a data type of number(1) and store single integer values i.e. 0 to 9 safely. This tap will incorrectly modify the data in the example provided to a Boolean. Any usage of this enhancement under a Meltano setup, will create a new column with a number(1) datatype rather than a bool. If you require a bool data, please run a post process in the likes of

dbt

to transform the data content. This change needed to be made as it was too dangerous to assume the datatype is a boolean. If you need to work with an older version (bool datatype), I suggest you pin to

v1.2.3

following the Meltano guide for pinning https://docs.meltano.com/guide/plugin-management#pinning-a-plugin-to-a-specific-version