DICTIONARY_GET
Returns the value for a specified key from a dictionary object.
Analyze Syntax
func.dictionary_get(<dict_name>, <key_column>, <key_value>)
Analyze Examples
func.dictionary_get('status_dict', get_column(table, 'status_code'))
┌──────────┐
│ 'Active' │
└──────────┘
SQL Syntax
DICTIONARY_GET(<dict_name>, <key_column>, <key_value>)
SQL Examples
SELECT DICTIONARY_GET('status_dict', status_code) FROM records;
┌────────┐
│ Active │
└────────┘