No credit cardStart free
rq
Start free

Lakehouse

Browse your data catalog: Iceberg tables stored in S3, managed by Nessie.

Overview

The Lakehouse view shows all tables in your data catalog. Tables are organized by schema (namespace) and show metadata like row count, size, and column count. Click any table to see its full schema and preview data.

Tables are scoped to your workspace. Each workspace has its own catalog branch in Nessie, so table names stay clean (e.g., my_stripe.customers) without cross-workspace conflicts.

Features

  • Table catalog - All Iceberg tables grouped by schema with metadata (rows, size, columns)
  • Search - Filter tables by name across all schemas
  • Grid and list views - Toggle between card grid and compact table list
  • Table detail - Click a table to see its column schema with types
  • Data preview - Load the first 100 rows of any table directly in the UI
  • Open in Query Editor - Each table's detail panel has an "Open in Query Editor" link that navigates to the query editor with a pre-filled SELECT * FROM schema.table LIMIT 100 ready to run

Workflow

The Lakehouse is your starting point for data discovery. A typical workflow:

  1. Browse schemas and tables to find the data you need
  2. Click a table to inspect its columns and types
  3. Load a preview to see sample data
  4. Click "Open in Query Editor" to start writing queries against that table

API Endpoints

All endpoints require authentication via Bearer token or API key.

GET /api/v1/query/tables

List all tables in the catalog with basic metadata (name, schema, row count, size, column count).

GET /api/v1/query/tables/{schema.table}/metadata

Get detailed metadata for a specific table, including full column schema with types.

GET /api/v1/workspaces/{workspace_id}/query/tables

List tables scoped to your workspace. Uses the workspace's Nessie branch for catalog isolation.

GET /api/v1/workspaces/{workspace_id}/query/tables/{schema.table}/metadata

Get detailed metadata for a table within your workspace, including full column schema with types.

POST /api/v1/query

Execute a preview query (SELECT * FROM schema.table LIMIT 100) to see sample data.

How Data Gets Here

Tables appear in the lakehouse after data is synced from a connection (PostgreSQL, MySQL, Stripe, HubSpot, Salesforce, Shopify, Google Sheets) or created via a transform. The data pipeline is:

Connection sync -> S3 (Parquet) -> Iceberg table (workspace branch in Nessie) -> Lakehouse view