No credit cardStart free
rq
Start free

Lakehouse

Browse your data catalog: Parquet tables stored in S3, catalogued by DuckLake.

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, so table names stay clean (e.g., my_stripe.customers) without cross-workspace conflicts.

Features

  • Table catalog - All 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 own catalog for 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 -> Parquet on S3 -> DuckLake catalog (workspace) -> Lakehouse view