title: how to automate ALTER TABLE ADD PARTITIONS with/without Glue Crawler
body: <p>I have noticed that ADD PARTITIONS are much more effective since I deal with JSON data in s3. A crawler I have set up is taking too long to complete. When I am asking it to only &quot;Crawl new folders only&quot;, it is not really adding the new partitions. I am also unticking the &quot;Update all new and existing partitions with metadata from the table&quot; option.</p>
  <p>What I essentially need is to automate ADD PARTITIONS as new partitions are added (should happen in seconds). I cannot do this from the code base that pushes data to s3 as they are a different team responsible for only s3 data population. I don't want the automating job to go through each record / metadata and fix the records (taking ~40 minutes now).</p>
  <p>Appreciate any help as I am new to Glue and Athena.</p>