A Column Is Missing From the Destination and Schema Tab

Issue

A column from my list is missing from the destination and the Schema tab in Fivetran, even though it contains data.

Environment

Connector: Microsoft Lists

Resolution

To resolve this issue, do the following:

1. Query the <SITENAME>_COLUMNS metadata table in your destination.
2. Find the row corresponding to the relevant list.
3. Compare the values in the name and display_name columns.

The name value represents how the column name appears in the destination table and in the Schema tab in Fivetran.

Cause

Microsoft Lists assigns each column both a display name and a column name. The display name represents how the column appears in the Microsoft Lists interface, while the column name is used internally.

We use the column name to represent the columns in your destination. As a result, this issue may occur when we sync a column, but it appears under a different name than you expect.