LOOKUP_STRING
Learn how to use the LOOKUP_STRING meta function in PlaidCloud Lakehouse. Looks up a string in a dictionary and returns the corresponding ID.
Looks up a string in a dictionary and returns the corresponding ID.
Analyze Syntax
func.lookup_string(<dict_table>, <value>)
Analyze Examples
func.lookup_string('status_dict', 'Active')
┌───┐
│ 1 │
└───┘
SQL Syntax
LOOKUP_STRING(<dict_table>, <value>)
SQL Examples
SELECT LOOKUP_STRING('status_dict', 'Active');
┌───┐
│ 1 │
└───┘