Grokking the Data Engineering Interview
Vote

0% completed

​

Warehouse Costs

An online furniture retailer has an analytics team that stores 20 TB in its warehouse. A TiB (tebibyte) is 2 to the power 40 bytes, about 1.1 TB. In one month, the team's queries read 180 TiB: 120 TiB from analysts and dashboards, and 60 TiB from the nightly transforms. The analysts keep the warehouse busy about 6 hours on each of 22 workdays, and the nightly transform runs 1.5 hours on each of 30 nights. That is 6 x 22 + 1.5 x 30 = 177 busy hours.

Those three numbers (bytes read, busy hours, and bytes stored) are enough to price the month on BigQuery, Snowflake, and Amazon Redshift

.....

.....

.....

Like the course? Get enrolled and start learning!

Reading Progress

0%

Vote for new content