Answer: SELECT * FROM TABLE(SPLIT_TO_TABLE('a.b.c', '.'));

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.

Author: LeetQuiz Editorial Team