Total Rows In Datawarehouse

Ajita · November 2023

Hi Experts ,

I need some inputs on the no of rows showing in Domo DW .

It is showing 214 M rows ,I deleted unused datasets ,connectors and limited the no of rows for some datasets .

It is still showing as 214M rows ,is there anything I can do to reduce the no of rows ?

Also , if you can clarify that if I use Dataset A for Card A (rows 210K) and use View of Dataset A for Card B(rows 210k) will be counted as 420k rows in Domo ?

ColemenWilson · November 2023

If this image below is where you are looking, then it is total count of stored rows. It believe it only updates daily. Domostats reports are your best bet for accurate row count.

Screen Shot 2023-11-29 at 8.35.12 AM.png

DashboardDude · November 2023

@Ajita in case you need some extra guidance

I made a video for you showing you how to check and clean up rows:

https://www.loom.com/share/fea32eeda9aa4dc5bd472ffa4ace865d?sid=49057427-1791-402b-a04b-7e4432b14834

ColemenWilson · November 2023

You can get exact row counts using the Domostats datasets report. Dataset views are considered “virtual rows” that are considered stored rows from a credit consumption perspective.

Ajita · November 2023

Thanks Wilson for the inputs but the question that comes to my mind is total #rows shown on Domo is it cumulative count or per day rows imported count ?

ColemenWilson · November 2023

If this image below is where you are looking, then it is total count of stored rows. It believe it only updates daily. Domostats reports are your best bet for accurate row count.

Ajita · November 2023

Thank you Wilson

DashboardDude · November 2023

@Ajita in case you need some extra guidance

I made a video for you showing you how to check and clean up rows:

https://www.loom.com/share/fea32eeda9aa4dc5bd472ffa4ace865d?sid=49057427-1791-402b-a04b-7e4432b14834

Ajita · November 2023

Thank you so much @DashboardDude ,It would surely help .

Total Rows In Datawarehouse

Best Answers

Answers

Categories