UNREGISTER TABLE

Description

Stops Onehouse from observing (blacklists) a single table in an Observed Lake without deleting the table's data in your storage bucket. The table's metrics and table services stop updating, and the periodic discovery process no longer re-discovers it. This is reversible with REGISTER TABLE.

The table is identified by its base path (TABLE_BASE_PATH). Any table services running on the table must be turned off before it can be unregistered.

Note that the SQL statement does not end with ;

Syntax

UNREGISTER TABLE LAKE = <string> TABLE_BASE_PATH = <string>

Example

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