I am new to Databricks SQL and want to create a variable which can hold calculations either from static values or from select queries similar to SQL Server. Is there a way to do so?

Sudeshna
Databricks Partner

‎03-15-2022 11:49 AM

I was trying to create a variable and i got the following error -

command -

SET a = 5;

Error -

Error running query

Configuration a is not available.

Labels:
0 Kudos