Hello! I'm using the Close extractor and Snowflake loader, and the pipeline created the target tables, even loaded data to some of them, but failed with this error

Loading failed code=1 message=snowflake.connector.errors.ProgrammingError: 100038 (22018): Numeric value 'false' is not recognized

I'm guessing this is an issue with the formatting of one of the columns? I couldn't find much. Any help is much appreciated.

This looks like the schema that’s being sent over is improperly flagging a column as numeric but there’s boolean data in it. It’s likely a bug with the Close extractor. You can try to invoke the tap itself and inspect the output

meltano --log-level=debug invoke tap-close

and see what the raw output is.

@taylor thank you! I will do that and see what I can find.