cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

IDENTIFIER clause

RobsonNLPT
Contributor

Hi all.

Just trying to implement adb sql scripts using identifier clause but I have errors like that using an example:

DECLARE mytab = 'tab1'

CREATE TABLE IDENTIFIER(mytab) (c1 INT);

 

[UNSUPPORTED_FEATURE.TEMP_VARIABLE_ON_DBSQL] The feature is not supported: Temporary variables are not yet supported for queries from SQL warehouses

 

https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-names-identifier-clau...

 

 

 

 

1 REPLY 1

shan_chandra
Honored Contributor III
Honored Contributor III

@RobsonNLPT  - Engineering is still working on the feature that allow DECLARE statements in DBSQL. This is with a tentative ETA of Feb 20 available on preview channel.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.