title: How do I save csv file to AWS S3 with specified name from AWS Glue DF?
body: <p>I am trying to generate a file from a Dataframe that I have created in AWS-Glue, I am trying to give it a specific name, I see most answers on stack overflow actually uses Filesystem modules, but here this particular csv file is generated in S3, also I want to give the file a name while generating it, and not rename it after it is generated, is there any way to do that?</p>
  
  <p>I have tried using df.save(s3:://PATH/filename.csv) which actually generates a new directory in S3 named filename.csv and then generates part-*.csv inside that directory</p>
  
  <pre><code>df.repartition(1).write.mode('append').format('csv').save('s3://PATH').option("header", "true")
  </code></pre>