Glossary
Data warehouse
A central database built for reporting and analytics across the whole business.
A data warehouse is a central, structured database designed for analytics and reporting. It collects cleaned data from many source systems, organizes it into consistent models, and answers analytical SQL queries without slowing down the operational apps that produced the data. Cloud examples include Snowflake, Google BigQuery and Amazon Redshift.
Data usually arrives through an ETL or ELT pipeline and is modeled into tables that business users and BI tools can query. The warehouse becomes the shared source for dashboards, finance reports and metrics.
Warehouses are strongest for structured data and governed reporting. Teams with large volumes of raw files, logs or machine learning workloads often add a data lake or move to a lakehouse.
Start in 60 seconds
Put this to work on your project.
Get an AI-assisted, architect-reviewed scope, cost range, and timeline. Free, no login.