Snowflake
COF-C02 · Question #392
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
The correct answer is A. Use the RESULT_SCAN function. first run SHOW FILE FORMATS then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1))) https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes
Snowflake Cloud Data Platform Features and Architecture
Question
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
Options
- AUse the RESULT_SCAN function.
- BCreate a CURSOR for the command.
- CPut it in the FROM clause in brackets.
- DAssign the command to RESULTSET.
How the community answered
(17 responses)- A94% (16)
- C6% (1)
Explanation
first run SHOW FILE FORMATS then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1))) https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes
Topics
#RESULT_SCAN#SHOW commands#Metadata querying#Table functions
Community Discussion
No community discussion yet for this question.