title: How do me add/delete partition from AWS Glue without deleting old glue data
body: <p>My s3 bucket contains folders like <em>s3:///deviceid=xx/location=yy/year=??/month=zz/day=dd/</em>.parquet*. AWS Glue table is mapped to this s3 folder and it has partitions as deviceid,location,year,month,day. My AWS Crawler is scheduled and it is crawling on s3 bucket and populating the AWG Glue table with data. Problem is if we need to change the partitions later from AWS Glue like add/delete some partitions , we cannot delete all the existing old data. So how do we proceed.Also how we can plan these type of migration.I believe my s3 folder structure will also change if new partitions are added or deleted as AWS crawler will throw &quot;multiple scheme found error&quot; when it crawls s3.. Any help or pointers will be appreciated</p>