SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ98

Transform Data

When would a Data Engineer use TABLE with the FLATTEN function rather than the LATERAL FLATTEN combination?

Explanation

TABLE(FLATTEN(...)) can flatten an independently supplied VARIANT, OBJECT, or ARRAY expression without a preceding table source. LATERAL FLATTEN is needed when the flatten operation must reference columns from a preceding FROM-clause expression.

Learn more

Community Discussion

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