This section provides reference information for dictionary functions in PlaidCloud Lakehouse.
This is the multi-page printable view of this section. Click here to print.
Dictionary Functions
- 1: DICT_GET
1 - DICT_GET
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. |