The comment_count Column in the POST_HISTORY Table Contains null Values

Issue

The comment_count column in the POST_HISTORY table contains null values, even though there are comments on the associated Facebook posts.

Environment

Connector: Facebook Pages

Resolution

To resolve this issue, do the following:

1. In Fivetran, go to your Facebook Pages connection page.
2. Select the Schema tab.
3. Select the checkbox next to the POST_COMMENT_HISTORY table to include it in your syncs.
4. Click Save changes.

Cause

The comment_count column in the POST_HISTORY table depends on data from the POST_COMMENT_HISTORY table. As a result, if you don't include the POST_COMMENT_HISTORY table in your connection schema, the comment_count values will remain null.