Article

Cloud Data Warehousing Benefits and Considerations

Learn how to evaluate and implement a cloud data warehousing solution for your enterprise.

A cloud data warehouse brings together data from transactional systems, applications, and other sources for analytical queries and business intelligence, with storage and compute that scale on demand.

Cluster-based systems use multiple nodes to process queries, while in serverless systems the cloud provider manages compute resources dynamically. Pricing differs as well. Serverless models charge per query or by utilization, which can be hard to predict. Tenancy is a separate decision. Choose single-tenant if you need strict performance isolation, or multi-tenant if lower cost matters more.

A data warehouse stores relational data under a schema defined in advance, optimized for fast SQL queries and reporting. A data lake stores structured and unstructured data as-is, at any scale, for analytics such as big data processing and machine learning.

Start with your workloads, budget, and deployment needs rather than a ranking. Decide between a cluster-based and a serverless architecture, compare pricing models, and check whether you need a single cloud, multi-cloud, or hybrid deployment. Platforms that run in the cloud, on premises, and in hybrid deployments can process data where it resides, minimizing data movement.

Mainly cost and early performance. Pricing can be the most complicated part of the choice. Serverless models charge per query or by utilization, which is difficult to anticipate. And moving data out of the cloud adds cost. Initial implementation can also run slower than expected and require users to adjust their practices.

Stay in the know

Subscribe to get weekly insights delivered to your inbox.



Teradata may send me marketing emails about products, data analytics, and events, which I can unsubscribe from at any time.

Your privacy is important. Your personal information will be collected, stored, and processed in accordance with the Teradata Global Privacy Statement.