title: Selecting specific files for athena
body: <p>While creating a table in Athena, I am not able to create tables using specific files. Is there any way to select all the files starting with "year_2019" from a given bucket? For e.g.
  s3://bucketname/prefix/year_2019*.csv</p>
  
  <hr>
  
  <p>The documentation is very clear about it and it is not allowed. </p>
  
  <p>From:
  <a href="https://docs.aws.amazon.com/athena/latest/ug/tables-location-format.html" rel="noreferrer">https://docs.aws.amazon.com/athena/latest/ug/tables-location-format.html</a></p>
  
  <blockquote>
    <p>Athena reads all files in an Amazon S3 location you specify in the
    CREATE TABLE statement, and cannot ignore any files included in the
    prefix. When you create tables, include in the Amazon S3 path only the
    files you want Athena to read. Use AWS Lambda functions to scan files
    in the source location, remove any empty files, and move unneeded
    files to another location.</p>
  </blockquote>
  
  <p>I will like to know if the community has found some work-around :)</p>