Azure synapse : partition a table that has no partition

sakuraime 2,316 Reputation points
2020-12-03T03:02:21.147+00:00

Is it possible to partition a table (which current not partitioned) , without recreate the table ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,358 questions
{count} votes

1 answer

Sort by: Most helpful
  1. HarithaMaddi-MSFT 10,126 Reputation points
    2020-12-07T09:44:08.67+00:00

    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.