Скачать или смотреть 8. How to resolve the “syntax error: unexpected” error in Snowflake? |Snowflake | DWH | VCKLY Tech

In this video, I am going to show you how to resolve the “syntax error: unexpected” error in Snowflake?

----------------DEMO---------------------

-----------------------------------------------------------
-- How to resolve the Syntax error: unexpected
----------------------------------------------------------

-- Setting context for the current SQL worksheet

use role accountadmin;
use warehouse compute_wh;
use database demo_db;
use schema public;

/*
Tabele Names : group,order,qualify,by,where,connect
sample, values, as ,with , into,from
insert, update, delete
*/

create table group( c1 varchar);

--Syntax error: unexpected 'group'. (line 9)

create table group1( c1 varchar);

create table merge( c1 varchar);



create table order(c1 varchar);

--Syntax error: unexpected 'order'. (line 14)

create table order1(c1 varchar);


create table by(c1 varchar);

--Syntax error: unexpected 'by'. (line 19)

create table by1(c1 varchar);


create table qualify(c1 varchar);

--Syntax error: unexpected 'qualify'. (line 25)

create table qualify1(c1 varchar);


create table where(c1 varchar);

create or replace table where(c1 varchar);

--Syntax error: unexpected 'where'. (line 30)

create table where1(c1 varchar);


create table connect(c1 varchar);

--Syntax error: unexpected 'connect'. (line 36)

create table connect1(c1 varchar);



create table sample(c1 varchar);

--Syntax error: unexpected 'sample'. (line 44)

create table sample1(c1 varchar);


create table values(c1 varchar);

--Syntax error: unexpected 'values'. (line 44)

create table values1(c1 varchar);

create table as(c1 varchar);

--Syntax error: unexpected 'as'. (line 44)

create table as1(c1 varchar);


create table with(c1 varchar);

--Syntax error: unexpected 'with'. (line 44)

create table with1(c1 varchar);

create table into(c1 varchar);

--Syntax error: unexpected 'into'. (line 44)

create table into1(c1 varchar);

create table from(c1 varchar);

--Syntax error: unexpected 'from'. (line 44)
create table from1(c1 varchar);
create table insert(c1 varchar);

--Syntax error: unexpected 'insert'. (line 44)

create table insert1(c1 varchar);


create table update(c1 varchar);

--Syntax error: unexpected 'update'. (line 44)

create table update1(c1 varchar);


create table delete(c1 varchar);

--Syntax error: unexpected 'delete'. (line 44)

create table delete1(c1 varchar);


create table sum(c1 varchar);