IDENTIFIER clause

RobsonNLPT — Fri, 21 Mar 2025 14:29:30 GMT

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-clause

Re: IDENTIFIER clause

shan_chandra — Tue, 16 Jan 2024 19:59:39 GMT

@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.

topic IDENTIFIER clause in Data Engineering

IDENTIFIER clause

Re: IDENTIFIER clause