Hi guys. I’m trying to load data from closeio to s...
# plugins-generalc
cristian_munoz_rosenfeld
08/23/2022, 2:17 PMHi guys. I’m trying to load data from closeio to snowflake. I’m loading only one table but It’s failed with the next error message
Copy code
snowflake.connector.errors.ProgrammingError: 100038 (22018): Numeric value 'false' is not recognizedt
taylor
08/23/2022, 2:22 PMhttps://meltano.slack.com/archives/C01TCRBBJD7/p1660854088040599 is a recent user who was experiencing the same thing. check the thread for some possible steps
c
cristian_munoz_rosenfeld
08/23/2022, 2:42 PMthanks
cristian_munoz_rosenfeld
08/23/2022, 5:04 PM@taylor is there any way to select only one column from source. In this case close.io? I’m trying to do this adding into extractor into meltano.yml ()forcing data type), but It is not working.
cristian_munoz_rosenfeld
08/23/2022, 5:05 PMonce finished I check into snowflake and table is numeric
t
taylor
08/23/2022, 5:47 PMYes - checkout https://docs.meltano.com/concepts/plugins#select-extra