Cloud vs On-Premise
| Feature | Cloud Datawarehouse | On-Premise |
|---|---|---|
| Scalability | Instant Up / Down, Scale In / Out | Reconfiguring / purchasing hardware, software, etc. |
| Availability | Up to 99.99% | Depends on infrastructure. |
| Security | Provided by cloud provider | Depends on the competence of the in-house IT team. |
| Performance | Serve multiple geo locations, helps query performance | Scalability challenge |
| Cost-effectiveness | No hardware / initial cost. Pay only for usage. | Requires significant initial investment, salary. |