title: Track data load history in Snowflake
body: <p>Snowflake stores few metadata sets in its INFORMATION_SCHEMA object. I tried to investigate how specific table got loaded by procedure/query.</p>
  
  <p><code>History</code> allows to investigate high-level but I wanted to have custom SQL code to drill more deep.
  <a href="https://i.stack.imgur.com/fbYVp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/fbYVp.png" alt="enter image description here"></a></p>
  
  <p>After executing below code i got <code>Statement not found</code> error even though Query_ID is valid.
  Is there any way to navigate history load so I can track what procedure loaded data to which table?</p>
  
  <pre><code>SELECT * FROM table(RESULT_SCAN('xxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxxx'));
  </code></pre>