---
title: "What is a data warehouse?"
description: "A data warehouse stores analytical tables for SQL over large scans. Unstructured files are usually paths or external tables, not typed media with model columns."
url: "https://pixeltable.com/learn/what-is-a-warehouse"
updated: "2026-09-29"
vertical: "Storage"
doc: "https://docs.pixeltable.com/overview/quick-start"
---

# What is a data warehouse?

A data warehouse stores analytical tables for SQL over large scans. Unstructured files are usually paths or external tables, not typed media with model columns.

Updated: 2026-09-29
Part of [What is lakehouse export?](https://pixeltable.com/learn/what-is-lakehouse-export).

## On this page

- [How it works](https://pixeltable.com/learn/what-is-a-warehouse#how-it-works)
- [What it is not](https://pixeltable.com/learn/what-is-a-warehouse#what-it-is-not)
- [Comparison](https://pixeltable.com/learn/what-is-a-warehouse#comparison)
- [Where Pixeltable fits](https://pixeltable.com/learn/what-is-a-warehouse#where-pixeltable-fits)
- [Questions](https://pixeltable.com/learn/what-is-a-warehouse#questions)

## How it works {#how-it-works}


- Analysts query columnar tables.
- Files may be registered, not decoded into frames.
- A media pipeline can export rows into the warehouse when analysis needs them.

## What it is not {#what-it-is-not}

It is not the system that extracts frames or keeps an embedding index on those frames.

## warehouse: this, and the thing it is confused with {#comparison}

|  | This | Not this |
| --- | --- | --- |
| Query | SQL scans | Frame similarity |
| Files | Paths or external tables | Typed media columns |
| Models | Often elsewhere | Columns on the media row |

## Where Pixeltable fits {#where-pixeltable-fits}

Pixeltable keeps the media pipeline. A warehouse such as Snowflake or Databricks can receive an export. It does not replace the table the frames live on.

## Questions {#questions}

### How does warehouse work? {#faq-1}

Analysts query columnar tables. Files may be registered, not decoded into frames. A media pipeline can export rows into the warehouse when analysis needs them.

### What is warehouse often confused with? {#faq-2}

It is not the system that extracts frames or keeps an embedding index on those frames.

## In the blog

- [Export Pixeltable Tables to Apache Iceberg for Lakehouse Analytics](https://pixeltable.com/blog/export-iceberg-lakehouse-bridge-pixeltable)
- [Pixeltable + LanceDB Integration: AI Infrastructure with Seamless Vector Database Export](https://pixeltable.com/blog/pixeltable-lancedb-integration)
- [Databricks FILE Type vs Pixeltable Media Columns](https://pixeltable.com/blog/databricks-file-type-vs-pixeltable-media-columns)
- [Databricks LTAP and the HTAP Debate: What AI Developers Should Actually Care About](https://pixeltable.com/blog/databricks-ltap-htap-multimodal-data-plane-pixeltable)
- [The Open Source Databricks Alternative: Why AI Developers Are Choosing Pixeltable](https://pixeltable.com/blog/pixeltable-databricks-alternative)
- [Pixeltable February 2026 Release Highlights](https://pixeltable.com/blog/pixeltable-february-2026-release-highlights)

## Related

- [Documentation](https://docs.pixeltable.com/overview/quick-start)
- [Databricks LTAP and the HTAP Debate: What AI Developers Should Actually Care About](https://pixeltable.com/blog/databricks-ltap-htap-multimodal-data-plane-pixeltable)
- [The Open Source Databricks Alternative: Why AI Developers Are Choosing Pixeltable](https://pixeltable.com/blog/pixeltable-databricks-alternative)
- [Snowflake for AI: Pixeltable's Declarative ML Infrastructure](https://pixeltable.com/blog/snowflake-for-ai)