Salesforce Warning: MALFORMED_QUERY: Implementation Restriction
In Fivetran, you may encounter one of the following warnings:
{MALFORMED_QUERY: "Implementation restriction: TopicAssignment only allows security evaluation for non-admin users when either (1) LIMIT is specified and at most 1000 or(2) WHERE is specified and filter on Id or Entity"}
{MALFORMED_QUERY: "Implementation restriction: FeedRevision requires a filter by FeedEntityId"}
{MALFORMED_QUERY: "Implementation restriction: FeedItem requires a filter by Id"}
What causes the MALFORMED_QUERY
error?
This issue occurs when the connection's authorizing user hasn't been granted the View All permission, which is required to access the objects referenced in the warning message.
Required object permissions in Salesforce
To resolve this issue, provide the connection's authorizing user with the View All permission on the Salesforce objects referenced in the error.
For guidance on managing permissions more precisely, see our Limit Salesforce permissions to tables or columns documentation.