PARSE_SYNTAX_ERROR: Syntax error at or near 'VACUUM'

[Dicer]

I tried to VACUUM a delta table, but there is a Syntax error.

Here is the code:

%sql
set spark.databricks.delta.retentionDurationCheck.enabled = False
 
VACUUM test_deltatable

[Ravi · Accepted solution]

@Cheuk Hin Christophe Poon​ Missing semi-colon at end of line 2?

%sql
set spark.databricks.delta.retentionDurationCheck.enabled = False;
 
VACUUM test_deltatable

[Dicer]

I asked a stupid question😂 I forgot to add ;

This one works

%sql
set spark.databricks.delta.retentionDurationCheck.enabled = False;
 
VACUUM test_deltatable;