snowflake.snowpark.functions.get_ignore_case¶

snowflake.snowpark.functions.get_ignore_case(obj: Union[Column, str], field: Union[Column, str]) → Column[source]¶

Extracts a field value from an object. Returns NULL if either of the arguments is NULL. This function is similar to get() but applies case-insensitive matching to field names.

Examples:

>>> df = session.create_dataframe([{"a": {"aa": 1, "bb": 2, "cc": 3}}])
>>> df.select(get_ignore_case(df["a"], lit("AA")).alias("get_ignore_case")).collect()
[Row(GET_IGNORE_CASE='1')]

Copy