Missing ACTIVITY Table

Issue

The ACTIVITY table is not available from the Salesforce connector, even though the Activity object is a standard Salesforce object. There is also a greyed-out ActivityHistory table with a message that says, Cannot select - not queryable. How can we get this data through our connector?

Environment

Connector: Salesforce

Resolution

We do not have the ACTIVITY table in our ERD. We store the data for activities in the TASK and EVENT tables. You can access all the relevant data from these tables.

The message for the greyed-out ActivityHistory table, is mostly informational. The message indicates that we can see this data structure but we're unable to query it. When we cannot query the data, it is usually due to limitations in the Salesforce API.