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?
There is no
Activity table in our ERD as such - activities are split between two other tables
EVENT so you will be able to get the data you need from these tables.
As for the
ActivityHistory table being greyed out with the message, this is an informational notice to let you know that we can see this data structure but we're not able to query it. When we cannot query data, it is usually because of some API limitation.