Hi @sakuraime ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
As per the documentation, synapse currently supports enabling partitions during table creation whereas modifying the partitions later is permitted. Partition function can to be a possible approach for such scenarios in SQL but this is not yet supported in Synapse.
As Synapse is still evolving, more features are gradually added to the product. I would recommend creating an idea in the feedback forum which is closely monitored by the Synapse product team and the ideas are implemented in future releases.
Please let us know for further queries and we will be glad to assist.
-------
- Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
- Want a reminder to come back and check responses? Here is how to subscribe to a notification.