Synapse Spark - create delta table with partition

Ryan Abbey 1,181 Reputation points
2021-08-27T05:29:21.87+00:00

Has anyone else created a delta table with partition on Synapse 2.4?

The below command created the table but there is no partition folder and the json has partitionBy:[] so appears to be ignoring the partitionby

df.select('Col1', 'Col2', 'Col3', 'Col4', 'Col5').write.format("delta").mode("overwrite").option("mergeSchema", 'true').partitionBy("Col3").option("path", "/path/x").saveAsTable('x')

Is there anything wrong with the command?

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,566 questions
{count} votes