How do I measure the size of our data warehouse over time?

Joe_Beckner

I'm working on our budget for next year, and I want to track the size of or data warehouse over time (month by month) to predict when/if we need to purchase additional data rows.

ColemenWilson

Gotcha, for that we use the Domostats report called "Credit Usage" and filter 'Usage Unit' to "Rows". You may not have this domostats report enabled currently, but can request it be enabled by reaching out to your CSM. This report will give you the row count over time.

DashboardDude

@Joe_Beckner

Made you a quick video to walk you through this: https://www.loom.com/share/224e9949a1ff4af6a393453ddd3ec7d5?sid=e6cb9b62-6034-4d79-90e7-e92cade6344e

ColemenWilson

The best way to do this is using Domogov datasets. In the connectors in Domo search "Domo" and you'll see this connector. Look for the "Datasets" report and there is a field called "Row Count". Using this field you can build cards and alerts that will help you monitor the change in rows.

Joe_Beckner

I have that, but what I can't get to is a count of rows in the warehouse as of X date I can see how many rows I'm creating by month, but not a total count of rows in the warehouse month-over-month

DashboardDude

@Joe_Beckner

Something like this?

ColemenWilson

Gotcha, for that we use the Domostats report called "Credit Usage" and filter 'Usage Unit' to "Rows". You may not have this domostats report enabled currently, but can request it be enabled by reaching out to your CSM. This report will give you the row count over time.

DashboardDude

@Joe_Beckner

Made you a quick video to walk you through this: https://www.loom.com/share/224e9949a1ff4af6a393453ddd3ec7d5?sid=e6cb9b62-6034-4d79-90e7-e92cade6344e