REGISTER TABLE

Description

Re-registers a previously unregistered table in an Observed Lake so Onehouse resumes observing it. The table is re-discovered on the next discovery cycle and its metrics start fresh.

The table is identified by its base path (TABLE_BASE_PATH) — the same path used to unregister it (see SHOW UNREGISTERED TABLES).

caution

For tables discovered via an AWS Glue or Iceberg catalog, re-register the table from the Onehouse console instead of this SQL statement. The console re-registers by the table's internal ID directly; this statement resolves the table from its base path, which does not reliably match Glue/Iceberg-discovered tables today.

Note that the SQL statement does not end with ;

Syntax

REGISTER TABLE LAKE = <string> TABLE_BASE_PATH = <string>

Example

REGISTER TABLE LAKE = 'my_lake' TABLE_BASE_PATH = 's3://my-bucket/domain/my_table'