You are viewing documentation about an older version (1.3.0). View latest version

snowflake.snowpark.functions.get_ignore_case

snowflake.snowpark.functions.get_ignore_case(obj: ColumnOrName, field: ColumnOrName) 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