title: proc or function that will loop over each database in snowflake and list tables with empty rows
body: <p>Can someone help find these zero row tables?</p>
  <pre><code>CREATE OR REPLACE PROCEDURE checkrows()
  RETURNS VARIANT
  LANGUAGE JAVASCRIPT
  AS
  $
  function ExecuteNonQuery(querystring) {
  
   var out = '';
  
   cmd1 = {sqlText: select * from information_schema.tables where rows_count = 0;};
  
   stmt = snowflake.createStatement(cmd1);
  
   var rs;
  
   try{
  
       rs = stmt.execute();
  
       rs.next();
  
       out = &quot;SUCCESS: &quot; + rs.getColumnValue(0);
  
        }
  
        catch(err) {
  
        throw &quot;ERROR: &quot; + err.message.replace(/\n/g, &quot; &quot;);
  
        }enter code here
  
       return out;
  
      }
      
      $$;
  </code></pre>