Total Rows In Datawarehouse
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 ?
Best Answers
-
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.
If I solved your problem, please select "yes" above
1 -
@Ajita in case you need some extra guidance
I made a video for you showing you how to check and clean up rows:
John Le
You're only one dashboard away.
Click here for more video solutions:
1
Answers
-
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.
If I solved your problem, please select "yes" above
1 -
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 ?
0 -
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.
If I solved your problem, please select "yes" above
1 -
Thank you Wilson
0 -
@Ajita in case you need some extra guidance
I made a video for you showing you how to check and clean up rows:
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
Thank you so much @DashboardDude ,It would surely help .
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive