Skip to content
Guides
Start For Free Contact Us

What is a Data Lakehouse?

Svg Vector Icons : http://www.onlinewebfonts.com/icon More Data Lake Topics

Data lakehouse architecture is designed to combine the benefits of data lakes and data warehouses by adding table metadata to files in object storage. This added metadata provides additional features to data lakes including time travel, ACID transactions, better pruning, and schema enforcement, features that are typical in a data warehouse, but are generally lacking in a data lake. However, just like any architecture, an open data lakehouse comes with trade offs. Storing data in an open table format can be greatly beneficial for improved interoperability, but can result in greater overhead in terms of tool version compatibility and upgrades, more challenging FinOps with disparate billing, variable performance, limited concurrency support, and disparate governance controls and auditing across many tools.

Five Best Practices for Data Warehouse Development

DATA LAKE FEATURES

  • Separation of storage and compute

  • Virtually unlimited scale data repository

  • Mixed data types: structured, semi-structured and unstructured

  • Choice of languages for processing (but not always SQL)

  • Process data in-place

  • Direct access to rawsource data

DATA WAREHOUSE FEATURES

  • Strong data governance, access to data only through the platform

  • High performance & concurrency support

  • No need to inventory or ingest data

  • ACID transactions

  • Direct access to curated data

  • Version history, time travel

data engineering - data engineering training

Both data lakes and data warehouses are big data repositories. The difference between data lake vs. data warehouse lies in how they handle compute and storage. Snowflake's Data Cloud can be used to build and adapt to various architecture patterns that align with needs of various use cases. Snowflake offers customers the ability to ingest data to a managed repository, in what’s commonly referred to as a data warehouse architecture, but also gives customers the ability to read and write data in cloud object storage, functioning as a data lake query engine. Regardless of the pattern, Snowflake adheres to core tenets of strong security, governance, performance, and simplicity.

DATA LAKEHOUSE FEATURES

In addition to the features above, Snowflake also provides the following features for a data lakehouse pattern:

  • Fully managed table format

  • Apache Iceberg table format

  • Polyglot, multi-cluster compute engine

  • Cost-effective performance for high concurrency

SNOWFLAKE DATA CLOUD

A data platform is not restricted to a single architectural pattern. Instead, it should have many architecture patterns for many functions and workloads, including:  

  • Collaboration

  • Analytics

  • Data exploration

  • Data engineering for ingestion and transformation of data

  • AI and ML

  • Data application development and operation

A flexible platform like Snowflake allows you to use traditional business intelligence tools and newer, more advanced technologies devoted to artificial intelligence, machine learning, data science, and applications. It’s a single platform that can be used to  power multiple types of workloads. 

See Snowflake’s capabilities for yourself. To give it a test drive, sign up for a free trial. 



Guides
  • Snowflake Workloads Overview
  • Applications
  • Data Engineering
  • Data Lake
  • Collaboration
  • AI and Data Science
  • Data Warehousing
  • Marketing
  • Unistore
  • Cybersecurity

Why Snowflake

Overview

Why Snowflake

Customer Stories

Partners

Services

The Data Cloud

Overview

Platform

Snowflake Marketplace

Snowpark

Powered by Snowflake

Live Demo

Workloads

Collaboration

Data Science & ML

Cybersecurity

Applications

Data Warehouse

Data Lake

Data Engineering

Unistore

Pricing

Pricing Options

Value Calculator

Solutions

For Industries

Advertising, Media, and Entertainment

Financial Services

Healthcare & Life Sciences

Manufacturing

Public Sector

Retail / CPG

Technology

For Departments

Marketing Analytics

Product Development

IT

Finance

Resources

Learn

Resource Library

Developers

Quickstarts

Documentation

Hands-on Labs

Training

Guides

Connect

Community

Events

Webinars

Blog

Podcast

Support

Trending

Company

Overview

About Snowflake

Investor Relations

Leadership & Board

Careers

Newsroom

Speakers Bureau

ESG at Snowflake

Snowflake Ventures

Why Snowflake

Overview

Why Snowflake

Customer Stories

Partners

Services

Resources

Learn

Resource Library

Developers

Quickstarts

Documentation

Hands-on Labs

Training

Guides

Connect

Community

Events

Webinars

Blog

Podcast

Support

Trending

The Data Cloud

Overview

Platform

Snowflake Marketplace

Snowpark

Powered by Snowflake

Live Demo

Workloads

Collaboration

Data Science & ML

Cybersecurity

Applications

Data Warehouse

Data Lake

Data Engineering

Unistore

Pricing

Pricing Options

Value Calculator

Solutions

For Industries

Advertising, Media, and Entertainment

Financial Services

Healthcare & Life Sciences

Manufacturing

Public Sector

Retail / CPG

Technology

For Departments

Marketing Analytics

Product Development

IT

Finance

Company

Overview

About Snowflake

Investor Relations

Leadership & Board

Careers

Newsroom

Speakers Bureau

ESG at Snowflake

Snowflake Ventures

Why Snowflake

Overview

Why Snowflake

Customer Stories

Partners

Services

Solutions

For Industries

Advertising, Media, and Entertainment

Financial Services

Healthcare & Life Sciences

Manufacturing

Public Sector

Retail / CPG

Technology

For Departments

Marketing Analytics

Product Development

IT

Finance

Company

Overview

About Snowflake

Investor Relations

Leadership & Board

Careers

Newsroom

Speakers Bureau

ESG at Snowflake

Snowflake Ventures

The Data Cloud

Overview

Platform

Snowflake Marketplace

Snowpark

Powered by Snowflake

Live Demo

Workloads

Collaboration

Data Science & ML

Cybersecurity

Applications

Data Warehouse

Data Lake

Data Engineering

Unistore

Pricing

Pricing Options

Value Calculator

Resources

Learn

Resource Library

Developers

Quickstarts

Documentation

Hands-on Labs

Training

Guides

Connect

Community

Events

Webinars

Blog

Podcast

Support

Trending

Sign Up for Our Newsletter

Must be valid email. [email protected]
By submitting this form, I understand Snowflake will process my personal information in accordance with its Privacy Notice. I may unsubscribe through unsubscribe links at any time.

© 2023 Snowflake Inc. All Rights Reserved

privacy notice
site terms
cookie settings
do not share my personal information