Categories:
Semi-structured Data Functions (Cast)

AS_OBJECT

Casts a VARIANT value to an object.

See also:
AS_<object_type> , AS_ARRAY

Syntax

AS_OBJECT( <variant_expr> )

Arguments

variant_expr
An expression that evaluates to a value of type VARIANT.

Examples

This shows how to use the function:

Create a table and data:

CREATE TABLE multiple_types (
    array1 VARIANT,
    boolean1 VARIANT,
    char1 VARIANT,
    varchar1 VARIANT,
    decimal1 VARIANT,
    double1 VARIANT,
    integer1 VARIANT,
    object1 VARIANT
    );
INSERT INTO multiple_types 
     (array1, boolean1, char1, varchar1, 
      decimal1, double1, integer1, object1)
   SELECT 
     TO_VARIANT(TO_ARRAY('Example')), 
     TO_VARIANT(TRUE), 
     TO_VARIANT('X'), 
     TO_VARIANT('I am a real character'), 
     TO_VARIANT(1.23::DECIMAL(6, 3)),
     TO_VARIANT(3.21::DOUBLE),
     TO_VARIANT(15),
     TO_VARIANT(TO_OBJECT(PARSE_JSON('{"Tree": "Pine"}')))
     ;

Now run the query:

SELECT AS_ARRAY(array1) AS "ARRAY",
       AS_BOOLEAN(boolean1) AS "BOOLEAN",
       AS_CHAR(char1) AS "CHAR",
       AS_DECIMAL(decimal1, 6, 3) AS "DECIMAL",
       AS_DOUBLE(double1) AS "DOUBLE",
       AS_INTEGER(integer1) AS "INTEGER",
       AS_OBJECT(object1) AS "OBJECT"
  FROM multiple_types;
+-------------+---------+------+---------+--------+---------+------------------+
| ARRAY       | BOOLEAN | CHAR | DECIMAL | DOUBLE | INTEGER | OBJECT           |
|-------------+---------+------+---------+--------+---------+------------------|
| [           | True    | X    |   1.230 |   3.21 |      15 | {                |
|   "Example" |         |      |         |        |         |   "Tree": "Pine" |
| ]           |         |      |         |        |         | }                |
+-------------+---------+------+---------+--------+---------+------------------+