snowflake error "SQL compilation error: Empty SQL statement."

Question

ALTER VIEW "test_RAWDATA" RENAME TO "TBD_test_RAWDATA";

I am getting following error: SQL compilation error: Empty SQL statement.

I have tried with new sheet as well but it is giving this error everywhere.

Are you sure you run correctly the SQL statement? I just did a quick test with something like this: create view "test_RAWDATA" as SELECT * FROM A; ALTER VIEW "test_RAWDATA" RENAME TO "TBD_test_RAWDATA"; and it worked fine. I think the issue is caused by the way you run the SQL statement. — Sergiu
– Sergiu, Commented Oct 12, 2021 at 11:51

Robert Long · Accepted Answer · 2021-10-12 13:14:17Z

1

This can happen when you execute certain SQL statements in the GUI along with some comments in the same line of the code. For example:

USE ROLE SYSADMIN;
USE "DEMO_DB"."PUBLIC";
CREATE TABLE t1 (id integer);
CREATE VIEW test_view as SELECT * FROM t1;

## View TEST_VIEW successfully created.

Now we can ALTER the view:

ALTER VIEW test_view RENAME TO test_view2;

##  Statement executed successfully.

but, if we add a comment:

ALTER VIEW test_view2 RENAME TO test_view3 ;  /* A comment */

## SQL compilation error: Empty SQL statement.

answered Oct 12, 2021 at 13:14

Robert Long

7,6276 gold badges37 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

patrick_at_snowflake Over a year ago

This no longer occurs in Snowsight, just tested it

Robert Long Over a year ago

@patrick_at_snowflake it still happens in the classic Web UI though

sonia mawandia Over a year ago

I will try..thanks so much for swift response

patrick_at_snowflake Over a year ago

Snowsight will at some point replace Classic UI - you won't expect any more development on the Classic UI

Collectives™ on Stack Overflow

snowflake error "SQL compilation error: Empty SQL statement."

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related