LOOKUP_STRING (Lakehouse v2)

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  │
└───┘