10 December 2018 · DataFreak ·       Add to Favorites   Report

Snowflake Metadata query results

Snowflake is a columnar database and it stores the meta information of all the columns in a table. e.g, Number of rows in each partition, the total number of partitions, distinct values for the column in each partition and so on. So when you issue a command like,

SELECT COUNT(1) FROM HR.EMPLOYEE;

Snowflake just uses the metadata layer to process this information and it should return the results of the above query, without even,

  • Hitting the underlying table
  • Thereby saving on your compute costs

Similarly, the MAX() or MIN() functions work too without hitting the actual table. 

DataFreak

posted on 10 December 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied