Explanation:
According to Snowflake documentation and the community discussion with upvoted comments, a virtual warehouse is required for operations that need compute resources. Loading data into a table (B) using COPY INTO commands and unloading data from a table (C) using COPY INTO location commands both require compute resources and therefore need a running virtual warehouse. Creating a table (A) is a metadata operation that doesn't require a warehouse. SHOW (D) and LIST (E) commands are also metadata operations that don't require compute resources from a virtual warehouse.
For which use cases is running a virtual warehouse required? (Choose two.)
A
When creating a table
B
When loading data into a table
C
When unloading data from a table
D
When executing a SHOW command
E
When executing a LIST command
No comments yet.