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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
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
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
1 -
Thank you so much @DashboardDude ,It would surely help .
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 114 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive