INSTANCE_LABELS view
This Information Schema view displays a row for each label that is assigned to an instance in the current project.
Columns
| Column | Data Type | Description |
|---|---|---|
| ID | integer | The unique ID of the assignment |
| PATTERN | string | The pattern to which the instance belongs |
| FOLDER | string | The folder path to the instance |
| INSTANCE | string | The name of the instance |
| LABEL | string | The name of the label |
| COLOR | string | The color of the label |
| USER_NAME | string | The name of the user who assigned the label to the instance |
| CREATED | timestamp | The time the label was assigned |
Examples
The following query retrieves all assigned instance labels inside the current project.
sql
SELECT * FROM @INFORMATION_SCHEMA.INSTANCE_LABELS;txt
+----+-----------------+------------+--------------+------------+--------+-----------------+---------------------+
| ID | PATTERN | FOLDER | INSTANCE | LABEL | COLOR | USER_NAME | CREATED |
+----+-----------------+------------+--------------+------------+--------+-----------------+---------------------+
| 35 | CORE_DATA_VAULT | /RAW_VAULT | ACCOUNT_HUB | to_do | blue | max@muster.com | 2025-08-23 13:11:01 |
| 36 | CORE_DATA_VAULT | /RAW_VAULT | CUSTOMER_SAT | deprecated | brown | max@muster.com | 2025-09-04 14:25:01 |
| 37 | LDG_FLAT_FILE | /SRC_A | Acc_obj_tbl | for_review | orange | johndoe@web.com | 2025-11-25 15:33:54 |
| 38 | LDG_FLAT_FILE | /SRC_B | Partners | for_review | orange | johndoe@web.com | 2024-07-13 16:47:21 |
+----+-----------------+------------+--------------+------------+--------+-----------------+---------------------+