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

Joe_Beckner · December 2023

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 · December 2023

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 · December 2023

@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 · December 2023

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 · December 2023

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 · December 2023

@Joe_Beckner

Something like this?

ColemenWilson · December 2023

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 · December 2023

@Joe_Beckner

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

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

Best Answers

Answers

Categories