SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ2

Transform Data

How can the following relational data be converted into semi-structured data with the least operational overhead?

Question Image

Explanation

OBJECT_CONSTRUCT creates a Snowflake OBJECT directly from relational column values; with a wildcard, it uses column names as object keys. This produces one semi-structured object per row without first serializing or parsing JSON, or converting each column individually.

Learn more

Community Discussion

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