Each data warehouse implementation style has advantages and disadvantages.
The implementation that a company chooses requires them to weigh a number of factors against each other.
Although the factors an organization cares most about will differ among organizations, common considerations include speed, control, scalability, reliability, security and governance, and cost.
Factors that influence on-premise and cloud data warehouses
Factors |
Why it matters |
Speed | Requires a balance between setup time and time-to-insights once setup is complete |
Control | Decisions about setup, implementation, and access |
Scalability | The needs of a business will change over time, seasonally, and as a company grows |
Reliability | Backing up and accessing data is critical — how often will maintenance be required? |
Security and governance | Handling data, especially personally identifiable data, requires care and complying with regulations |
Cost | Whether you pay to implement your data warehouse upfront (CaPex) or as-you-go (OpEx) depends on your implementation and affects your company’s balance sheet and tax strategy. |
Cloud data warehouse vs On-premise data warehouse
We outline some of the advantages and disadvantages of on-prem data warehouse and cloud data warehouse installations.
The comparison looks at the seven specific factors listed above. Can you see any points where one installation type or another might be more advantageous in your organization?
Factors |
On-premise data warehouse |
Cloud data warehouse |
Speed | Quicker to obtain insights if a company is in one location | Quicker setup time because the hardware doesn’t need to be set up and fewer team members to train
Quicker to obtain insights if a company is spread out but needs to transfer data among locations |
Control | Company has complete control | Some decisions are left to the cloud vendor and may not be adjustable |
Scalability | No advantages over cloud data warehouses. | Easier to scale up and down because no hardware is required |
Reliability | Depends on your team. | Depends on the cloud provider
Some level of inherent backups or disaster recovery |
Security and governance | With a strong data access policy, on-prem is most secure.
Some legal or contractual requirements may not allow for cloud providers. |
Cloud vendors have security guarantees and can restrict access to employees |
Cost | Avoid annual costs from cloud vendors
May be cheaper over time if resource procurements are carefully managed No cost to query your own data, and your data belongs to you |
Lower upfront costs because you don’t need to pay for infrastructure
Potential lower ongoing employee costs because you don’t need to hire employees with on-prem with skills to maintain and administer on-prem data warehouses Allows you to scale storage and server usage up and down when needed, which can lower costs if done correctly No need to buy hardware that is used only during peak times |
Using a data warehouse with a data lake
For better data integration, data lakes are another type of data storage that can store non-standard and unstructured data without transforming them first. One challenge of storing data in multiple types of storage is aggregating them when both will be used in an analysis.
How Starburst helps
Solutions like Starburst help immensely with disparate data sets and improve the lives of data scientists and data engineers. Starburst works in conjunction with both data warehouses and data lakes to help you query data, using sql, from any location. This helps data consumers and business users overcome barriers and optimize more accurate data-driven insights on a dashboard.