Lakehouse Management

Description

The Lakehouse area provides point-and-click management of your workspace's Lakehouse compute and Iceberg catalogs without leaving PlaidCloud. Open it from the Lakehouse button on the main toolbar.

A warehouse selector at the top of the window applies to every tab. The area is split into seven tabs: Queries, Profile, Catalog, Warehouses, Users, Load, and Admin.

Queries

Monitor running queries and browse history. The tab is split top/bottom by a movable divider:

• Running — queries executing right now. Auto-polls at the interval you choose from the toolbar.
• History — recent completed queries.

To view a query's plan:

1. Click the Profile icon at the start of the row
2. The query SQL is loaded into the Profile tab; from there you can run EXPLAIN or EXPLAIN ANALYZE

To kill running queries:

1. Select one or more rows in the Running table
2. Click Kill selected in the toolbar
3. Confirm in the dialog

Profile

Run EXPLAIN or EXPLAIN ANALYZE on a SQL statement and visualize the resulting plan as a heat-mapped tree.

1. Open Lakehouse > Profile
2. Paste or type a SQL statement
3. Click EXPLAIN (plan only) or EXPLAIN ANALYZE (plan + actual row counts and timings)

The plan tree highlights the most expensive nodes so the bottlenecks of a slow query are visible at a glance.

Catalog

Browse the Iceberg catalog of the selected warehouse. The pane lists namespaces on the left and tables on the right, with an action bar for create/drop operations.

To create a namespace:

1. Open Lakehouse > Catalog
2. Click New namespace
3. Enter the namespace name and confirm

To drop a table:

1. Select the namespace, then the table
2. Click Drop table
3. Confirm in the dialog

A dropped tables list at the bottom of the tab lets you UNDROP recently dropped tables for as long as they remain recoverable.

Warehouses

Create, list, and delete the Iceberg warehouses backing your lakehouse.

To create a warehouse:

1. Open Lakehouse > Warehouses
2. Click Add warehouse
3. Enter a warehouse name and the storage configuration
4. Click Add

To delete a warehouse:

1. Select the warehouse row
2. Click Delete
3. Confirm in the dialog

Users

Manage the database users that connect to the lakehouse from external SQL clients (DBeaver, etc.). Both password-based and SSO-provisioned users are listed.

To add a user:

1. Open Lakehouse > Users
2. Click Add user
3. Enter the username and password
4. Click Add
5. Save the password — it is shown once and cannot be retrieved later

To reset a password:

1. Select the user row
2. Click Reset password
3. Save the new password from the dialog

To remove a user:

1. Select the user row
2. Click Drop user
3. Confirm in the dialog

Load

Watch cluster activity at a glance. The tab shows a row of counters (active queries, recent throughput) with a sparkline below sampled on the same poll interval as the Queries tab.

Admin

Inspect compute workload status and restart the warehouse compute when needed.

The workload table lists each component with its current status. The Rolling restart section lets you cycle the compute pods of the selected warehouse.

To restart compute:

1. Open Lakehouse > Admin
2. Read the disruption warning
3. Type the warehouse id into the confirmation field
4. Click Restart compute

A cooldown between restarts prevents accidental rapid cycling. The remaining cooldown is shown next to the button.