title: Snowflake: In a MERGE or COPY command (from external stage) can I specify that only the newest csv file should be merged/copied?
body: <p>Right now, our MERGE/COPY commands point to an s3 folder. Anytime there's more than a single csv file in the S3 folder, Snowflake throws a &quot;duplicate rows&quot; error.
  I manually move s3 files each morning so that there's only ever one file in the s3 folder.
  How can I tell snowflake to only MERGE/COPY the newest csv file in the folder?
  (NOTE: date/time is part of our naming convention for these csv files)</p>