snowflake.snowpark.functions.as_object¶

snowflake.snowpark.functions.as_object(variant: Union[Column, str]) → Column[source]¶

Casts a VARIANT value to an object.

Example::

CopyExpand

>>> df = session.sql("select object_construct('A',1,'B','BBBB')::variant as a")
>>> df.select(as_object("a").alias("result")).show()
-----------------
|"RESULT"       |
-----------------
|{              |
|  "A": 1,      |
|  "B": "BBBB"  |
|}              |
-----------------

Show lessSee more

Scroll to top