PARSE_SYNTAX_ERROR: Syntax error at or near 'VACUUM'

Dicer
Valued Contributor

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
Databricks Employee
Databricks Employee

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

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

View solution in original post

Dicer
Valued Contributor

I asked a stupid question😂 I forgot to add ;

This one works

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