Warning: Cannot Select – Not Available in Your HubSpot Subscription

Issue

It's not possible to include some tables in the connection schema configuration. The tables are grayed out and the following warning appears:

Cannot select - Not available in your HubSpot subscription.

Environment

Connector: HubSpot

Resolution

To resolve this issue, do the following:

1. Ensure the authenticating user has Super Admin access to your HubSpot account. For more information, see HubSpot's User permissions guide.

2. Re-authorize the connection as a Super Admin user, or ask a user with Super Admin access to do this for you.

   i. In Fivetran, go to your HubSpot connection page.

   ii. Select the Setup tab.

   iii. Click Edit connection.

   iv. Click Re-Authorize Connection. You will be redirected to your HubSpot account.

   v. Log in to your HubSpot account and select the account you want to sync.

   vi. You will be redirected back to Fivetran. Click Save & Test.

For more information, see our HubSpot setup guide.

Cause

This issue occurs when the connection's authenticating user doesn't have Super Admin access to your HubSpot account. When this happens, we receive an error while querying the applicable table endpoint in the HubSpot API and provide the following warning in the connector logs:

Do not have enough permissions to sync deal table, if the table is checked in schema it will be unchecked.