USA Variation

Snowflake's annual user conference is returning to San Francisco. Register today and save on a full conference pass.

Use case

Empower Teams and Drive Outcomes withLakehouse Analytics

Connect data in-place to accelerate AI and advanced analytics with world-class performance on open table formats.

Overview

Stop battling complex infrastructure. Start empowering your organization with enterprise-ready analytics and AI for your lakehouse.

Snowflake’s single, unified platform provides governed access to virtually all lakehouse data, delivering fast, trusted insights and exceptional price and performance on open table formats.

Platform diagram

Connect data in place

Go beyond formats and catalogs to get a unified, governed view of your data estate — without the complexity of moving and copying data.

AI icon

Focus on innovation

Accelerate your roadmap with Snowflake's elastic engine, which separates compute and adaptive concurrency to offer reliable speed without intervention.

Scale icon

Supercharge decision-making

Scale your team’s impact by equipping nontechnical users with governed analytics, AI and data products they can trust.

Virtual Hands on Labs

The Essential Guide to Lakehouse Analytics and AI

Download your free guide and discover how to architect an AI-ready lakehouse with Iceberg tables & interoperable REST catalogs.

Benefits

Unleash the possibilities ofpowerful lakehouse analytics

Fast analytics on data anywhere

Harness your open data ecosystem for powerful insights with a single-engine platform

  • Access existing or easily create Apache IcebergTM tables across catalogs, regions, and clouds without double compute.

  • Achieve performant, reliable analytics — without the complexity — by querying existing Delta and Apache Parquet files in place in addition to Iceberg tables.

  • Enrich insights with unstructured data with Documents AI and trusted external knowledge from reputable publishers like the AP, Washington Post, Stripe and more with Cortex Knowledge Extensions.

Structured and semi-structured data stored within a single repository
Snowflake Cortex diagram

ANALYZE AT ENTERPRISE SPEED

Power AI, BI and more for all of your data — no matter where it lives

  • Achieve 2X faster query performance¶ on Apache Iceberg tables by extending our leading analytics engine to open table formats.

  • Accelerate time to value and continually streamline workflows with performance improvements that are automatically enabled — no manual tuning required.

  • Maintain productivity and system efficiency by running complex joins and queries without resource contention.

Technology

Indeed Reimagines Architecture and Data Collaboration to Help Job Seekers and Employers

With Snowflake’s native support for Iceberg tables, Indeed converted its 52-petabyte data lake, breaking down data silos and allowing analysts to directly read and write Iceberg tables through Snowflake.

Read the story

  • 43–74% cost reduction compared to previous analytical tools
woman wearing blue collared shirt wearing glasses and holding a tablet

Harmonize Your Data

Securely extend the power of data to every team

  • Break down data silos and enhance collaboration with Secure Data Sharing for open table formats. 

  • Improve SLAs on dashboards and applications with native integrations.

  • Deliver AI- and ML-powered insights faster with Snowflake’s fully managed Cortex AI service.

lakehouse analytics

Get Started

Take the next stepwith Snowflake

Start your 30-day free Snowflake trial today

  • $400 in free usage to start
  • Immediate access to the AI Data Cloud
  • Enable your most critical data workloads

Lakehouse Analytics

Frequently Asked Questions

Most common questions about Snowflake's approach to data lakehouse analytics, including querying data in place, managing Iceberg tables and using open catalog solutions.

A data lakehouse integrates the cost-effective scalability and flexibility of a data lake, ideal for storing diverse raw data, with the robust data management, governance, and high-performance analytics features typically found in a data warehouse.

Snowflake allows you to analyze data stored directly in your external cloud storage (like Amazon S3, Azure Blob Storage or Google Cloud Storage) without needing to move or copy it into Snowflake. This is primarily done using:

  • External Tables: Query data files (e.g., Parquet, CSV, JSON) in your existing cloud storage as if they were native Snowflake tables.
  • Iceberg Tables: Leverage Apache Iceberg, an open table format, to query data in your data lake with Snowflake, benefiting from Iceberg's features like schema evolution and time travel, while using Snowflake's powerful query engine.

The main difference lies in who manages the Iceberg table's metadata (catalog) and lifecycle.

  • Snowflake-managed Iceberg Tables: Snowflake Horizon catalog manages and performs operations like compaction. This offers a tightly integrated experience with read/write access directly from Snowflake. For multi-engine read access, sync these tables with Snowflake Open Catalog.

  • Externally-managed Iceberg Tables: An external catalog (e.g., AWS Glue, or an open source catalog like Apache Polaris™ ) manages the table's transactions and metadata. Snowflake connects to these for querying.
  • Snowflake Horizon Catalog provides unified governance, security, and discovery capabilities across all your data assets within the Snowflake platform. It is also the catalog for Snowflake Managed Iceberg tables.
  • Snowflake Open Catalog is a managed service for Apache Polaris™, a vendor-neutral open source catalog. Apache Polaris and Snowflake Open Catalog deliver secure, multi-engine access control and read-and-write interoperability.

Where Data Does More

  • 30-day free trial
  • No credit card required
  • Cancel anytime