01 Dec 20 · ramesh-hdpsqlsnowflake-gmail-com · #Snowflake ·   Bookmark   ×

Snowflake Pricing - How many credits will be used when we take record count from a table?

select count(*) from table_name; will get data from meta_data or virtual warehouse has to run?

If virtual warehouse to run. Let us say the query took 35 seconds to complete. How many credits will be used?


Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds




npack02-Dec-20

  • Simple Count(*) query will be directly answered by the cloud services layer (Metadata Layer). It will not spin up a virtual warehouse
  • And the metadata queries are FREE (unless, they exceed more than 10% of the compute credits, which is unlikely)
  • More details are here