10 December 2018        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. 


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