SQL variables in a notebook

MikeK_ — Fri, 29 Nov 2019 19:32:28 GMT

Hi,

In an SQL notebook, using this link: https://docs.databricks.com/spark/latest/spark-sql/language-manual/set.html I managed to figure out to set values and how to get the value.

SET my_val=10; //saves the value 10 for key my_val

SET my_val; //displays the value for the key my_val

How can I use this value in my SQL query? I tried a few things it's not working:

select * from mytable where Id=[value of my_val]

Basically in the example above, I want the select to run for Id=10.

Thanks in advance.

Mike

EDIT: if there's a different/better way to accomplish this, I'm all ears 🙂

Re: SQL variables in a notebook

shyam_9 — Mon, 02 Dec 2019 07:38:37 GMT

Hi @Mike K.., you can do this with widgets and getArgument.