True or False: When active, a Pipe requires a dedicated Virtual Warehouse to execute.
True or False: When active, a Pipe requires a dedicated Virtual Warehouse to execute.
In Snowflake, a Pipe (Snowpipe for continuous data loading) does not require a dedicated Virtual Warehouse to execute. Instead, it uses Snowflake-supplied compute resources and charges based on the compute usage. Therefore, the statement is False.
Correct Answer Bulk-loading: Requires virtual warehouse to use COPY INTO command. Snowpipe (continuous loading): Uses Snowflake-supplied compute resources and charges based on how much of that is used.
why do we need a VW to run a serverless service?
Pipe not required
B is correct
B Is Correct