Where Can I Find Multi-Select Field Data?

Question

I can't find Zendesk multi-select field data in the TICKET_CUSTOM_FIELD table. Where does Fivetran sync this data?

Environment

Connector: Zendesk Support

Answer

We sync data about each Zendesk multi-select field to its own table using the naming format TICKET_FIELD_<MULTI-SELECT-FIELD-NAME>.