title: How to avoid sub folders in snowflake copy statement
body: <p>I have a requirement to exclude certain folder from prefix and process the data in snowflake (Copy statement)</p>
  
  <p>In the below example I need to process files under emp/ and exclude files from abc/</p>
  
  <p>Input :</p>
  
  <p>s3://bucket1/emp/ </p>
  
  <pre><code>E1.CSV
  E2.CSV
  /abc/E11.csv
  </code></pre>
  
  <p>s3://bucket1/emp/abc/ - E11.csv</p>
  
  <p>Output :</p>
  
  <p>s3://bucket1/emp/ </p>
  
  <pre><code>E1.CSV
  E2.CSV
  </code></pre>
  
  <p>Is there any suggestion around pattern to handle this ?</p>