Answer-first summary for fast verification
Answer: To split a string and flatten the results into rows
The SPLIT_TO_TABLE function in Snowflake is specifically designed to split a string into multiple rows based on a delimiter. According to Snowflake's official documentation and the community consensus (100% agreement on option C with upvoted comments), this function takes a string input, splits it using a specified delimiter, and returns the results as separate rows in a table format. Option A describes character counting, which is handled by functions like LENGTH. Option B describes basic string splitting that returns an array, which is what the SPLIT function does. Option D is incorrect because SPLIT_TO_TABLE flattens results into rows, not columns.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is the purpose of the Snowflake SPLIT_TO_TABLE function?
A
To count the number of characters in a string
B
To split a string into an array of sub-strings
C
To split a string and flatten the results into rows
D
To split a string and flatten the results into columns
No comments yet.