How to combine an array into a single string value when using CSV output in jq?

You need to call join() on the tags list, not the individual tags. Try with:

jq -r '.tickets[] | [.created_at, .id, .via.channel, (.tags | join(","))] | @csv'