title: LIST directories in Snowflake STAGE from S3
body: <p>From Snowflake Docs of <a href="https://docs.snowflake.com/en/sql-reference/sql/list.html" rel="nofollow noreferrer">LIST</a></p>
  <blockquote>
  <p>Returns a list of files that have been staged</p>
  </blockquote>
  <p>Example like</p>
  <pre class="lang-sql prettyprint-override"><code>list @my_csv_stage/analysis/ pattern='.*data_0.*';
  </code></pre>
  <p>Is it possible to <em>LIST</em> <strong>directories</strong> under the list path?</p>