Hi All,
I’m working on Salesforce Data Cloud and would like to create a dashboard that reports on data ingestion status, showing both success and failure counts for each data stream or ingestion run.
Could anyone guide me on how to achieve this in Data Cloud?
Is there an existing object or report source that captures ingestion logs and statuses?
Any best practices or references would be really helpful.
Thanks,
Clinton Fernandes
To create a dashboard in Salesforce Data Cloud that reports ingestion success and failure counts for each data stream or ingestion run, leverage the Data Stream Refresh History and related system logs that track ingestion statuses.
Data ingestion occurs via the Ingestion API and Data Streams, and the success or failure of each ingestion attempt is recorded in the Refresh History tab of each Data Stream, which captures detailed logs including errors and failures.
To build the dashboard, use the Refresh History data as the source for reporting on ingestion statuses, create custom reports on Data Model Objects (DMOs) related to Data Streams to visualize success and failure counts, and apply filters or aggregations to show results per ingestion run or per data stream. Best practices include regularly monitoring the Refresh History for errors and permissions issues that commonly cause ingestion failures.
https://developer.salesforce.com/docs/data/data-cloud-int/references/data-cloud-ingestionapi-ref/c360-a-api-streaming-insert-example.html
https://help.salesforce.com/s/articleView?id=001787651&type=1
https://help.salesforce.com/s/articleView?id=data.c360_a_refresh_history.htm&type=5
https://help.salesforce.com/s/articleView?id=004947530&type=1
https://help.salesforce.com/s/articleView?id=002630830&type=1Hope this helps. Thanks!