sorry i’m back with more zendesk to BQ schema questions. there’s a field in the ticket audits schema that is sometimes a string and sometimes an array of strings (the type declared in the schema is

["null", "array", "string"]

), and obviously BQ doesn’t know what to do with this. say i didn’t want to exclude the field from the extraction, is there anything i can do to get this to load to bigquery? ideally i’d want to be able to take the cases where it’s a string and convert those to one element arrays.

Hi, @prratek_ramchandani. As discussed in office hours today, this is certainly tricky. The only proposal I can think of would be to fork the repo and cast to an array, as you mention here.

i’ll see if there’s appetite for a PR to that effect in

tap-zendesk

first!