title: SQL - Find Record count for multiple tables at a time in snowflake
body: <p>I want to see counts have Tables at 1 time, instead of Running each.</p>
  <p>For EX:</p>
  <pre><code>select COUNT(*) from  &quot;Fact_MASTER &quot;;
  select COUNT(*) from  &quot;Dim_MASTER &quot;;
  select COUNT(*) from  &quot;Fact2 &quot;;
  select COUNT(*) from  &quot;Dim2&quot;;   
  select COUNT(*) from  &quot;Fact3&quot;;
  select COUNT(*) from  &quot;Dim3&quot;
  </code></pre>
  <p>Is there any way we can write a CTE to pull as Record count for each in a temp table or so like below:</p>
  <p><a href="https://i.stack.imgur.com/gz0MD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gz0MD.png" alt="enter image description here" /></a></p>