QuestionQ36Verified/SQLCopy linkReport a problemAsk AstroTutorSave questionWhat is the purpose of the LATERAL modifier for the FLATTEN function?ACasts the values of the flattened dataBExtracts the path of the flattened dataCJoins information outside the object with the flattened dataDRetrieves a single instance of a repeating element in the flattened dataShow AnswerAnswerExplanationThe LATERAL modifier correlates the FLATTEN output with the preceding row source, preserving and joining information outside the flattened object or array with each resulting flattened row.Learn moreQuerying Semi-structured DataLATERALShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion