topic SQL Identifier clause in Data Engineering

SQL Identifier clause

jura — Wed, 20 Mar 2024 08:28:31 GMT

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

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

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

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

Any suggestions?

#identifier #sql

Re: SQL Identifier clause

raphaelblg — Thu, 21 Mar 2024 22:31:19 GMT

Hello @jura ,

I'm Raphael and i'll be helping you out.

The approach below should work:

USE CATALOG dev; CREATE OR REPLACE TABLE IDENTIFIER("bronze.jura_test") as SELECT ...

Please let me know the outcome and feel free to ask any further questions. If my response addresses your needs then please mark it as the official solution.

Thanks!

Re: SQL Identifier clause

jura — Fri, 22 Mar 2024 07:28:52 GMT

Hi @raphaelblg

thanks for your answer, but this doesn't work.

Problem is in WITH AS clause, when it is used in combination of CREATE TABLE and IDENTIFIER functions. Your example is same as my case 2 in opening post.

Do you have any other propositions ?

Another thing that I've found is that in SQL notebook + SQL Warehouse parameters cannot be used for some commands, i.e. USE CATALOG.

Thanks for your answer, but if you have any other suggestions, feel free to share

br
Dino

Re: SQL Identifier clause

vinay_yogeesh — Wed, 05 Mar 2025 09:41:36 GMT

Hey, I am struck with the same issue, did you find any workaround. I am trying to run DESCRIBE & ALTER command using IDENTIFIER() using databricks-sql-connector. Did u figure out how to run the identifier command statements??