title: How to create a external table when date is in between s3 path
body: <p>I have s3 bucket as below,</p>
  <pre><code>s3://rawzone/toyoto/2020-11-04/
  </code></pre>
  <p>inside each date I have 4 files</p>
  <pre><code> s3://rawzone/toyoto/2020-11-04/Company.json
   s3://rawzone/toyoto/2020-11-04/sales.json
   s3://rawzone/toyoto/2020-11-04/transport.json
   s3://rawzone/toyoto/2020-11-04/preaquisitions.json
  </code></pre>
  <p>and I have so many dates like this</p>
  <pre><code> s3://rawzone/toyoto/2020-11-05/Company.json
   s3://rawzone/toyoto/2020-11-05/sales.json
   s3://rawzone/toyoto/2020-11-05/transport.json
   s3://rawzone/toyoto/2020-11-05/preaquisitions.json
  </code></pre>
  <p>I need to create a table for across all dates for Company,sales,transport,preaquisitions</p>
  <p>How can I retrieve this data from s3 bucket for each table?</p>
  <p>So far tried (kept ??? where I don't know how to replace it)</p>
  <pre><code> create or replace external table toyoto.PB_compnay
      (
         columns mapping......
      )
      partition by ???
      with location = @raw_zone/pitchbook/??????
      file_format = json_format
      aws_sns_topic='arn:aws:sns:us-west-1:5438:dev-autore'
      auto_refresh = true 
  </code></pre>