QuestionQ16

Performance Optimization, Querying & Transformation

Which query produces a JSON-style object whose keys are name and age, with values Alice and 30?

Explanation

OBJECT_CONSTRUCT constructs a Snowflake OBJECT from alternating key-value arguments. With 'name', 'Alice', 'age', 30, it creates an object containing name: "Alice" and age: 30.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!