CODEWITHSUNDEEP
compiler-errorssnowflake-cloud-data-platform
bobo
bobo

Reputation: 13

Snowflake Error - 'SQL compilation error: Empty SQL statement'

when I run the snowflake Lab exercise query it gets the error while the data actually inserted into the table. what's wrong?

sql query

error screenshot

data screenshot

Upvotes: 1

Views: 7938

Answers (1)

Simon D
Simon D

Reputation: 6279

I think it's because you're highlighting the SQL statement and clicking run. See how you've highlighted beyond the last semi-colon (;) ? It's trying to run both the SQL statement before the ; AND the one after which is simply a comment // Links 2015 book... because you've highlighted that too.

In the Snowflake UI, you don't have to highlight the SQL statement to run just that block. Simply put your mouse into the SQL statement and click Ctrl+Enter (cmd+enter on mac) and it'll run the piece of SQL after the preceding ;

Upvotes: 4

Related Questions