Explanation:
The SPLIT_TO_TABLE function in Snowflake is a table function that returns a table, so it must be called using the TABLE() constructor in a FROM clause. Option C correctly uses SELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.')) which is the proper syntax according to Snowflake documentation. Option A is incorrect because it doesn't use the TABLE() constructor and tries to call the function directly in the SELECT clause. Option B is invalid syntax as it lacks a FROM clause entirely. Option D is incorrect because it omits the TABLE() constructor wrapper. The community discussion with 100% consensus on option C and the reference to official Snowflake documentation confirms this is the correct approach.
Ultimate access to all questions.
No comments yet.
How should the SPLIT_TO_TABLE(<string>, <delimiter>) function be called?
A
SELECT SPLIT_TO_TABLE(COL1, '.') FROM DUAL;
B
SELECT SPLIT_TO_TABLE('a.b.c', '.');
C
SELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.'));
D
SELECT * FROM SPLIT_TO_TABLE('a.b.c', '.');