Create table Partition on an existing table in synapse

• Steve Dell

  SSCarpal Tunnel

  Points: 4623

  More actions

  January 4, 2023 at 4:08 pm

  #4133589

  I have a table in Synapse with huge volume of data and planning to create a  partition by year wise with out dropping the table or data. I have seen many examples of creating a new table with partition but never came across of Alter table statements with add partition .So my question is ..is it possible to add partition to the existing table with out dropping it? If so can you please provide me with the script ?

  Thanks in advance

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  January 5, 2023 at 4:10 pm

  #4134091

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.