LOCAL_SERVICES_* Tables Are Missing From the Destination
Issue
I have included the LOCAL_SERVICES_* tables in the connector schema, but the tables are missing from the destination.
Environment
Connector: Google Ads
Resolution
To resolve this issue, do the following:
- Ensure the authorizing user has the necessary permissions to access the relevant data in Google Ads.
- In Fivetran, go to your Google Ads connector page.
- Select the Setup tab.
- Click Edit connection.
- Click Re-Authorize with Google to allow Fivetran to authorize your account using OAuth.
- Click Save & Test.
Cause
This issue occurs when the authorizing user doesn't have the necessary permissions to access the relevant data in Google Ads.