Query to retrieve custom column option values. Useful for creating cusotm fields in Engage when importing form Classic.

custom_column_option_values.sql

select cc.label, cc.type, cco.value
from custom_column cc
left outer join custom_column_option cco
  on cco.custom_column_KEY = cc.custom_column_KEY
where cc.organization_KEY = 51035
and cco.organization_KEY = 51035
order by cc.label, cco.value;