title: How to find the number of rows for all views in a schema?
body: <p>Sometimes I have access to schemas with hundreds of views (when using the Snowflake Data Marketplace). How can I find the number of rows for each of these views?</p>
  <p>What I need is an efficient way to do something like:</p>
  <pre class="lang-sql prettyprint-override"><code>select count(*)
  from KNOEMA_FORECAST_DATA_ATLAS.FORECAST.&quot;ABORIGINAL_POP_PROJ&quot;;
  </code></pre>
  <p>... but for all views in that Knoema schema.</p>