Skip to main content

Data Warehouse

Warehouse connectors provide a SQL-first way to build reusable data catalogs in Columns.

Why Warehouse Connections​

If your modeling already lives in a modern warehouse, Columns can serve as the visualization and presentation layer.

You can:

  • write and test SQL in the built-in SQL IDE
  • save results as live data connections
  • analyze and share outputs with low-latency interaction

How It Works​

Columns executes your SQL, caches results for a user-defined interval, and serves them quickly for interactive exploration.

This architecture keeps:

  • data fresh (based on your sync policy)
  • visual interaction fast

Demo​

See this walkthrough for warehouse setup: Connect your data warehouse