All Tables Except the ADVERTISER_ACCOUNT Table Are Missing From the Destination

Issue

Fivetran successfully synced the ADVERTISER_ACCOUNT table to my destination. However, all other tables from my schema are missing.

Environment

Connector: Awin

Resolution

To resolve this issue, ensure your Awin account has API access. For more information, see our Awin setup guide.

Cause

This issue occurs when you authorize your Awin connector with an account that doesn't have API access. As a result, we receive errors every time we try to sync tables other than the ADVERTISER_ACCOUNT table.