title: Dynamic stage path in snowflake
body: <p>I  have a stage path as below</p>
  <pre><code>copy into table1 as (
  select $1:InvestorID::varchar as Investor_ID from  @company_stage/pbook/2022-03-10/Invor/part-00000-33cbc68b-69c1-40c0-943c-f586dfab3f49-c000.snappy.parquet
  
  )
  </code></pre>
  <p>This is my S3 location <code>company_stage/pbook/2022-03-10/Invor</code>,</p>
  <p>I need to make this dynamic:</p>
  <p>I) I need to change this &quot;2022-03-10&quot;  folder to current date</p>
  <p>II)it must take all parquet files in the folder automatically, without me mentioning of filename. How to achieve this?</p>