Forum Discussion
KamKam15
Nov 07, 2022Copper Contributor
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 this feature is only available in Delta Lake 1.2.0 and above, I've double checked and we are running Delta 1.2
Below is an example of what I'm doing:
OPTIMIZE '/path/to/delta/table' -- Optimizes the path-based Delta Lake table
Does anyone know what this could be happening?
I did notice that there was no reference to OPTIMIZE in the Synapse docs but it did exist in the Databricks docs. Perhaps the procedure hasn't been implemented in Synapse yet?
No RepliesBe the first to reply