Columns Not Appear in Row Filter Drop-Down Menu
Issue
The Column drop-down menu is empty when trying to configure row filtering in the Schema tab.
Environment
Connector: Zendesk Support
Resolution
To resolve this issue:
- In Fivetran, go to your Zendesk Support connection page.
- Select the Schema tab.
- Find the relevant table and click to expand its column list.
- If the columns are missing, wait for the current sync to finish, then click the Refresh icon (Update latest schema from source).
- Select the checkbox next to each column you want to sync, then click Save changes.
- Ensure the column uses a supported data type.
If the drop-down menu remains empty, contact our support team.
Cause
This issue occurs when we haven't captured the table's column metadata or you haven't included any columns with a supported data type in the connection schema.