Missing ACCOUNT_USER Table

Issue

The ACCOUNT_USER table is included in the connection schema in Fivetran. However, it's missing from the destination.

Environment

Connector: Alchemer

Resolution

To resolve this issue, ensure the authenticating user has an Account Administrator user role in Alchemer. For more information, see the Alchemer documentation on managing user roles.

Cause

This issue occurs when the authenticating user doesn't have an Account Administrator user role in Alchemer, which is required to access the AccountUser object and set up Fivetran connections. For more information, see our Alchemer setup prerequisites.