Zeppeline: how to populate a dynamic form dropdown from sql interpreter

I connected my zeppeline to postgresql using the native driver provided in the zeppeline package. I have a column - ID (tables 'a' ), which consist of the entire identifier needed for further processing.

Example

 ==================================== ID | Value 1 | Value2 ==================================== 1 | 23 | text1 2 | 13 | text2 3 | 03 | text3 4 | 99 | text4 5 | 12 | text5 

Now, how to fill this ID column into a dynamic form for further drop down user selection?

I know that I can use a spark context and a JDBC drive. But that would be superfluous. All my further processing is performed from the database itself for analysis. Therefore, I would prefer to create a dynamic dropdown form from the psql interpreter itself.

+5
source share

Source: https://habr.com/ru/post/1258719/


All Articles