snowflake.snowpark.functions.object_pick¶
- snowflake.snowpark.functions.object_pick(obj: Union[Column, str], key1: Union[Column, str], *keys: Union[Column, str]) Column [source]¶
Returns a new OBJECT containing some of the key-value pairs from an existing object.
To identify the key-value pairs to include in the new object, pass in the keys as arguments, or pass in an array containing the keys.
If a specified key is not present in the input object, the key is ignored.
- Example::
>>> from snowflake.snowpark.functions import lit >>> df = session.sql( ... "select object_construct(a,b,c,d,e,f) as obj, k, v from " ... "values('age', 21, 'zip', 21021, 'name', 'Joe', 'age', 0)," ... "('age', 26, 'zip', 94021, 'name', 'Jay', 'age', 0) as T(a,b,c,d,e,f,k,v)" ... ) >>> df.select(object_pick(col("obj"), col("k"), lit("name")).alias("result")).show() ------------------- |"RESULT" | ------------------- |{ | | "age": 21, | | "name": "Joe" | |} | |{ | | "age": 26, | | "name": "Jay" | |} | -------------------