Forum Discussion
Could not find stored procedure 'OPTIMIZE' in Synapse
Hi Fellow Azure people! I'm trying to use the OPTIMIZE procedure on a delta table in Synapse but I'm getting a "Could not find stored procedure 'OPTIMIZE'" error. Delta's docs do mention that...
The OPTIMIZE command is not supported in Azure Synapse serverless SQL pools. It is a Databricks Delta Lake feature, and while Microsoft Fabric and Databricks both support OPTIMIZE for Delta tables, Synapse does not currently implement this stored procedure. In Synapse, you must use alternative compaction strategies (e.g., partitioning, auto compaction, or optimize write) rather than calling OPTIMIZE.