--- title: "#datawarehouse articles | Hashnode" description: "Explore 63 articles tagged #datawarehouse on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/datawarehouse" --- Tag # #datawarehouse 63 posts · 13 followers [Soham Gaichor](https://hashnode.com/@soham111) · [Oct 14](https://hashnode.com/posts/the-cashier-and-the-ceo-a-tale-of-two-database-worlds-oltp-vs-olap/6acfb01f1b7c7ffa439d5e26) ### [The Cashier and the CEO: A Tale of Two Database Worlds (OLTP vs. OLAP)](https://soham111.hashnode.dev/the-cashier-and-the-ceo-a-tale-of-two-database-worlds-oltp-vs-olap?utm_source=hashnode&utm_medium=feed) Master the core differences between OLTP (transactions) and OLAP (analytics). Discover how databases handle fast updates and multi-dimensional reports 5 min read · [soham111.hashnode.dev](https://soham111.hashnode.dev/the-cashier-and-the-ceo-a-tale-of-two-database-worlds-oltp-vs-olap?utm_source=hashnode&utm_medium=feed) [Dipak Mali](https://hashnode.com/@malidipak) · [Sep 26](https://hashnode.com/posts/slowly-changing-dimensions-scd-in-data-engineering/6ab830c84a9c6292b152a099) ### [Slowly Changing Dimensions (SCD) in Data Engineering](https://malidipak.hashnode.dev/slowly-changing-dimensions-scd-in-data-engineering?utm_source=hashnode&utm_medium=feed) While working with data warehouses, one common challenge is handling changes in dimension data while maintaining data accuracy and historical information. For example, consider a customer dimension: 8 min read · [malidipak.hashnode.dev](https://malidipak.hashnode.dev/slowly-changing-dimensions-scd-in-data-engineering?utm_source=hashnode&utm_medium=feed) [Vikaskumar](https://hashnode.com/@vikaskumarpandey) · [Aug 4](https://hashnode.com/posts/data-cloud-deep-dive-data-warehouse-vs-data-lake-vs-data-lakehouse-and-where-data-360-fits/6aa4ee4f1d3c4de902ed689f) ### [⚡ Data Cloud Deep Dive: Data Warehouse vs. Data Lake vs. Data Lakehouse — and Where Data 360 Fits](https://vikaskumarpandey.hashnode.dev/data-cloud-deep-dive-data-warehouse-vs-data-lake-vs-data-lakehouse-and-where-data-360-fits?utm_source=hashnode&utm_medium=feed) Data warehouse vs data lake vs data lakehouse compared — with full tables, a library analogy, and exactly where Salesforce Data 360 fits in. 8 min read · [vikaskumarpandey.hashnode.dev](https://vikaskumarpandey.hashnode.dev/data-cloud-deep-dive-data-warehouse-vs-data-lake-vs-data-lakehouse-and-where-data-360-fits?utm_source=hashnode&utm_medium=feed) [Gabriela Caldas](https://hashnode.com/@GabiC) · [Jun 24](https://hashnode.com/posts/snowflake-cost-optimization-a-practical-playbook-for-data-engineers/6a3b35880541f77f2eb4669a) ### [Snowflake Cost Optimization: A Practical Playbook for Data Engineers](https://byte-sizedjourneys.hashnode.dev/snowflake-cost-optimization-a-practical-playbook-for-data-engineers?utm_source=hashnode&utm_medium=feed) A breakdown of the Snowflake optimizations that cut our dbt build time from 2+ hours to under 1 hour. 7 min read · [byte-sizedjourneys.hashnode.dev](https://byte-sizedjourneys.hashnode.dev/snowflake-cost-optimization-a-practical-playbook-for-data-engineers?utm_source=hashnode&utm_medium=feed) [Hammad Tariq](https://hashnode.com/@hamad-tariq) · [Jun 20](https://hashnode.com/posts/data-warehouse-migration-guide-2026-snowflake-vs-redshift-vs-big-query-vs-databricks/6a36ce611b65ca376673d61b) ### [Data Warehouse Migration Guide 2026: Snowflake vs Redshift vs Big Query vs Databricks](https://thehammadtariq.hashnode.dev/data-warehouse-migration-guide-2026-snowflake-vs-redshift-vs-big-query-vs-databricks?utm_source=hashnode&utm_medium=feed) The strategic way to choose between Snowflake, Redshift, Big Query and Databricks and what the move actually costs. 3 min read · [thehammadtariq.hashnode.dev](https://thehammadtariq.hashnode.dev/data-warehouse-migration-guide-2026-snowflake-vs-redshift-vs-big-query-vs-databricks?utm_source=hashnode&utm_medium=feed) [Vishnu D](https://hashnode.com/@vishd) · [May 14](https://hashnode.com/posts/star-schema-vs-snowflake-schema/6a053e69a0c15402779b0277) ### [Star Schema vs Snowflake Schema: Why the Real Difference Isn't What You Think](https://thedatatrench.hashnode.dev/star-schema-vs-snowflake-schema?utm_source=hashnode&utm_medium=feed) Real examples, SQL patterns, and a decision framework — because "denormalized vs normalized" isn't enough. 10 min read · [thedatatrench.hashnode.dev](https://thedatatrench.hashnode.dev/star-schema-vs-snowflake-schema?utm_source=hashnode&utm_medium=feed) [Shashidhar BA](https://hashnode.com/@shashi321) · [Apr 15](https://hashnode.com/posts/nobody-explained-the-data-warehouse-to-me-properly-so-i-ll-do-it-with-a-warehouse/69df1ff091716f3cfba9d81d) ### [Nobody explained the data warehouse to me properly. So I'll do it with a warehouse](https://shashidharblog.hashnode.dev/nobody-explained-the-data-warehouse-to-me-properly-so-i-ll-do-it-with-a-warehouse?utm_source=hashnode&utm_medium=feed) "A centralized repository for structured and semi-structured data." Cool. Thanks. Completely useless. Here's what it actually means. 3 min read · [shashidharblog.hashnode.dev](https://shashidharblog.hashnode.dev/nobody-explained-the-data-warehouse-to-me-properly-so-i-ll-do-it-with-a-warehouse?utm_source=hashnode&utm_medium=feed) [chatforest\_grove](https://hashnode.com/@chatforest) · [Mar 25](https://hashnode.com/posts/data-warehouse-lakehouse-mcp-servers/69c3702497482221dd57c259) ### [Data Warehouse & Lakehouse MCP Servers — Snowflake, BigQuery, Databricks, ClickHouse, DuckDB, Redshift](https://chatforest.hashnode.dev/data-warehouse-lakehouse-mcp-servers?utm_source=hashnode&utm_medium=feed) At a glance: Data warehousing has exceptional MCP coverage — every major platform has official support. ClickHouse leads the open-source community with 720 stars. BigQuery offers a fully managed remote server. Snowflake brings Cortex AI integration. ... 3 min read · [chatforest.hashnode.dev](https://chatforest.hashnode.dev/data-warehouse-lakehouse-mcp-servers?utm_source=hashnode&utm_medium=feed) [SANDEEP KUMAR RAJU SANGARAJU](https://hashnode.com/@sangarajus) · [Mar 16](https://hashnode.com/posts/teradata-to-bigquery-migration-the-case-sensitivity-trap-nobody-warns-you-about/69b891e72ad6ae51840ba03a) ### [Teradata to BigQuery Migration: The Case Sensitivity Trap Nobody Warns You About](https://datatrail.hashnode.dev/teradata-to-bigquery-migration-the-case-sensitivity-trap-nobody-warns-you-about?utm_source=hashnode&utm_medium=feed) Why queries break after migrating Teradata to BigQuery. Learn 8 practical solutions to fix case sensitivity issues at enterprise scale. 18 min read · [datatrail.hashnode.dev](https://datatrail.hashnode.dev/teradata-to-bigquery-migration-the-case-sensitivity-trap-nobody-warns-you-about?utm_source=hashnode&utm_medium=feed) [Tech Insights Hub](https://hashnode.com/@JohnMikes) · [Feb 12](https://hashnode.com/posts/redshift-aws-petabyte-scale-data-warehouse/698dd451d25b7b245f797534) ### [Redshift AWS: Petabyte-Scale Data Warehouse](https://topperblog.hashnode.dev/redshift-aws-petabyte-scale-data-warehouse?utm_source=hashnode&utm_medium=feed) Redshift AWS: Petabyte-Scale Data Warehouse Modern tool for developers. Overview Key features. Setup const use = () => true; Patterns Best practices. FAQ Q: Ready? Yes. Conclusion Start today. 1 min read · [topperblog.hashnode.dev](https://topperblog.hashnode.dev/redshift-aws-petabyte-scale-data-warehouse?utm_source=hashnode&utm_medium=feed)