Is it possible to set global variables in a Zeppelin Notebook?

Question

I'm trying to create a multi-paragraph dashboard using a Zeppelin notebook. I'd like people using the dashboard to only have to enter certain parameters once. E.g. if I'm making a dashboard with information about different websites, the dashboard user only has to select the particular website they want information about once and the whole multi-paragraph dashboard will update. Is this possible? How do I set global variables like this in a notebook?

To clarify, the parameter input that I intend to use for Zeppelin is referred to as "dynamic form".

I'm not very sure what do you mean by global variable ? A variable is shared among notebooks in Zeppelin — eliasah, Oct 28 '16 at 06:18
I think @eliasah means that a variable (e.g. : `${formName}`) is visible only within its paragraph and not across all the paragraphs of the notebook. What he means is "set once, use everywhere". — marius_neo, Oct 28 '16 at 08:01

score 4 · Accepted Answer · edited May 23 '17 at 12:26

4

Using z.put and z.get can share variable over different notebooks.

z.put("name", "zeppelin")
z.get("name")

Possibly combine with z.angularBind and z.angular to use it in dashboard. ref How to put a variable into z ZeppelinContext in javascript in Zeppelin?

edited May 23 '17 at 12:26

Community

1
1

answered Oct 28 '16 at 11:14

Rockie Yang

4,725
31
34

This won't work using a spark SQL interpreter, correct? – Danny David Leybzon Oct 31 '16 at 22:09
2

Use sqlContext.sql instead of directly write %sql shall help. Combine with z.angularWatch and z.run can even make it more dynamic. Check this https://www.youtube.com/watch?v=n9SvBBXjojU – Rockie Yang Nov 01 '16 at 05:25
3

Why in hell would someone watch a video when text is so easier to read and use and create. – Kiwy May 09 '18 at 11:42

score 2 · Answer 2 · answered Jan 24 '19 at 09:45

You can use notebook-level global variables in the SQL by using the syntax $${variableName} instead of ${variableName}. [Reference].

When you run one of the paragraphs that uses global variables, the global variable input fields will appear above all the paragraphs.

Is it possible to set global variables in a Zeppelin Notebook?

2 Answers2

Linked