Does snowflake incur charges when I abort long running queries?
CodePudding user response:
CPU is charged by the Virtual Warehouse being up and running, not by individual query. If you abort a query, and suspend the VWH you’re only charged during the time the VWH was in a running state.
CodePudding user response:
Yes. Because you pay for every second the warehouse is/was running (after the first 60 seconds which you get billed for just for starting the warehouse).
You also get billed if the long running query hits the execution timeout limit (default is something like 4 hours) you pay for those minutes, and you still have no answer.
But if you had the warehouse running many queries, and you run yet another query and then after time abort the new query, the warehouse was running so the new query itself will not be charged. But at the same time, the other queries run fractionally slow.