Multiple Dataset refresh and row count

Q&A
, ,
1

Hi Team,

For my QuickSight dashboard analysis, I have multiple datasets imported for different visuals in a single sheet.

Now, I want to create a visual for which I can see the last refresh time (which I have already figured how to implement) and number of rows for each full refresh.

Is it possible to add number of rows for each refresh into the visual on QS analysis?
Future enhancement: To implement the same for incremental refreshes.
PS: I am using AmazonBI account.

TIA.

2

Hello @Chaitase, I was looking through the API documentation, and I was able to find something that may be helpful. There is a command called DescribeIngestion that returns a JSON response containing this:
“RowInfo”: { “RowsDropped”: number , “RowsIngested”: number , “TotalRowsInDataset”: number }

This should lead you to be able to build out a small table that could contain all of the ingestion/refresh stats that you need for your visual. I will mark this as the solution for now, but if you have any follow-up questions please let me know!