Creating a delta table Mismatch Input Error

Brose
New Contributor III

I am trying to create a delta table for streaming data, but I am getting the following error; Error in SQL statement: ParseException:

mismatched input 'CREATE' expecting {<EOF>, ';'}(line 2, pos 0).

My statement is as follows;

%sql

DROP TABLE IF EXISTS table1

CREATE TABLE table1 (

  col_1 STRING,

  col_2 STRING,

  col_date_1 DATE,

  col_dat_2 DATE,

  col_3 Double,

  col_4 Double,

) USING DELTA

I can't figure out why I am getting this error.