I am writing a Zeppelin notebook that has two paragraphs. The first paragraph is a scala notebook that defines some default values to be used in later notebooks. For eg In the first paragraph if I define
%scala
var table_name = "my_table"
How can this be used in the later %sql paragraphs eg:
%sql
select count(*) from <how to get value of table_name>
I can put the values in the ZepplinContext using z.put() but how will I access the same in the sql paragraphs?