snowflake.snowpark.functions.object_delete¶

snowflake.snowpark.functions.object_delete(obj: ColumnOrName, key1: ColumnOrName, *keys: ColumnOrName) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/release-v1.3.0/src/snowflake/snowpark/functions.py#L3767-L3797)¶

Returns an object consisting of the input object with one or more keys removed. The input key must not exist in the object.

Example:

CopyExpand

>>> from snowflake.snowpark.functions import lit
>>> df = session.sql(
...     "select object_construct(a,b,c,d,e,f) as obj from "
...     "values('age', 21, 'zip', 21021, 'name', 'Joe'),"
...     "('age', 26, 'zip', 94021, 'name', 'Jay') as T(a,b,c,d,e,f)"
... )
>>> df.select(object_delete(col("obj"), lit("age")).alias("result")).show()
--------------------
|"RESULT"          |
--------------------
|{                 |
|  "name": "Joe",  |
|  "zip": 21021    |
|}                 |
|{                 |
|  "name": "Jay",  |
|  "zip": 94021    |
|}                 |
--------------------

Show lessSee more

Scroll to top