SQL Identifier clause

jura
New Contributor II

Hi, 

I was trying to prepare some dynamic SQLs to create table using the IDENTIFIER clause and WITH AS clause, but I'm stuck on some bug as it seems. 
could someone verify it or tell me that I am doing something wrong?
code is running on SQL Warehouse 

Thanks in advance

Case 1 => Create Table Conventional => Success

 

jura_2-1710922868633.png

Case 2 => Create Table using IDENTIFIER clause (without with as clause) => Success

jura_3-1710923081107.png

Case 3 => Create Table using IDENTIFIER clause and using WITH AS clause => FAIL

jura_4-1710923152252.png

I've tried using brackets around with as and select, didn't help ..

 

Any suggestions? 

#identifier #sql