Hi Everyone, I hope you're all doing well! I'm experiencing issues when trying to insert Boolean values (true, false) into a Bit(1, 0) datatype column using the PutDatabaseRecord processor. The source table contains a column of Bit datatype; however, the Avro logical type, along with the Avro reader and other readers (like JSON/CSV) in QueryDatabaseTable and PutDatabaseRecord respectively, fetch the records as Boolean by default.
Could anyone provide assistance on how to properly insert Boolean data into a Bit column? Thank you in advance for your help! Best regards, Deepanshu
