Pages

Tuesday, October 27, 2026

Data 360: Objects Query

Use SOQL to query the following:

DLO >> DataLakeObjectInstance
  • Id - prefix "1dl"
  • Name - this is "Field Label" e.g. "Account_Home", "Base Events_Main" 
  • ExternalName - this is "Field API Name", e.g. Account_Home__dll, base_events_Main__dll
  • DataLakeObjectStatus: ACTIVE
  • Category: Profile, Engagement, Other
  • DataLakeObjectRef - prefix "0GO"
  • Billable: Yes or blank
  • TotalNumberOfFields
  • TotalRecords

DataStream >> DataStream
  • Id  - prefix "1ds"
  • Name - e.g. "Account_Home"
  • LastRefreshedDate  - date/time
  • LastNumberOfRowsAddedCount - rows added in last refresh
  • TotalRowsProcessed
  • TotalNumberOfRowsAdded - all rows for the object
  • RefreshFrequency: BATCH, NONE, MINUTES_5, HOURLY
  • RefreshMode: UPSERT, INCREMENTAL
  • StreamType
  • DataStreamStatus: ACTIVE
  • ImportRunStatus: SUCCESS

No comments:

Post a Comment

Page-level ad