DICT_GET
Learn how to use the DICT_GET dictionary function in PlaidCloud Lakehouse. Retrieves the value of a specified attribute from a dictionary using a provided...
Retrieves the value of a specified attribute from a dictionary using a provided key expression.
SQL Syntax
DICT_GET([db_name.]<dict_name>, '<attr_name>', <key_expr>)
| Parameter | Description |
|---|---|
| dict_name | The name of the dictionary. |
| attr_name | The name of the attribute in the dictionary that you want to retrieve the value for. |
| key_expr | The key expression used to locate a specific entry in the dictionary. It represents the value of the dictionary's primary key to retrieve the corresponding data. |