I'm using a Google Sheet that has a field for employee ID number. In the sheet, the column is formatted as plain text as the ID number has 4-5 leading zeros.
When I try to bring the sheet into the flow, I get this error and Alteryx doesn't load in any data from the sheet: Error: Google Drive Input (185): ("Expected bytes, got a 'int' object", 'Conversion failed for column Employee ID with type object')
Solved! Go to Solution.
apparently this is a pyarrow thing which shows up with streamlit, bigquery and some other pyarrow integrations...
https://github.com/googleapis/python-bigquery-pandas/issues/616.
I'm curious if that's the offending column - can you try to bring that one in indivudally? And also - open an alteryx bug ticket - this would require a type mapping/code change in the tool's underlying python.