Expected Salesforce data
After the Salesforce setup is complete, a table for each queryable - named sf_/\{sobject-name}
- is created in your Data Warehouse.
NOTE
The structure (columns) of each table depends on the fields contained in the object.
To get a list of objects available to your organization, refer to the Salesforce . After you have a list of objects, check out the of Salesforce documentation to see how entities relate to each other.
Unsupported Objects
Currently, Salesforce does not currently expose the following objects in their API:
-
Announcement
-
Attachment
-
ContentDocumentLink
-
External objects
- -
CollaborationGroupRecord
-
ContentDocument
-
ContentDocumentLink
-
FeedItem
-
FieldDefinition
-
IdeaComment
-
ListViewChartInstance
-
Order
-
PlatformAction
-
KnowledgeArticleVersion
-
NewsFeed
-
RecentlyViewed
-
TopicAssignment
-
UserRecordAccess
-
UserProfileFeed
-
Vote
e1f8a7e8-8cc7-4c99-9697-b1daa1d66dbc