Skip to content
Advertisement

Create table in snowflake – Syntax

I am trying to create a table and insert rows into it. But it keeps giving me this syntax error. ERROR : SQL compilation error: syntax error line 3 at position 1 unexpected ‘EventName’. syntax

Any help would be appreciated.

Advertisement

Answer

You need to type those columns, and you are missing a comma after the int of EnventTypeID

and your insert needs a VALUES keyword:

EVENTTYPEID EVENTNAME EVENTDESCRIPTION EVENTCATEGORYNAME SYSTEMNAME RECORDCHECKSUM RECORDAPPEND RECORDUPDATE
-1 NO_EVENT_TYPE Event Type Not Defined NO_EVENT_CATEGORY INSITE -770355665 0.00218634259259259 0.00218634259259259
User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement