Reg: Using Zeppelin as a Visualisation tool for my SQL backend system

[Naresh Kancharla <na...@gmail.com>]

Hi All,

I came to know about this tool from Spark meetup.

I am using AWS Redshift. Redshift supports SQL queries.
For example: I can use SQL Workbench which connects to Redshift and return
response.
Also RedShift has Python SDK which will return data for the query using
Redshift SDK.

*My Requirement:*
I am looking for Visualisation tool for my query responses.

Doubts:
1) Can I use Zeppelin for this ?

2) Looks like Zeppelin is used only for Spark end point. Am I right ?

3) How Can I use Zeppelin as a visualisation tool for my requirement ?


Can I do like this?
1) On Zeppelin GUI  user enters SQL query.
2) Python will connects to Redshift, executes above given query and gets
query response.
3) Pass this response to Zeppelin.
4) Can Zeppelin render this in different graph formats?


Thanks,
Naresh.

Re: Reg: Using Zeppelin as a Visualisation tool for my SQL backend system

[Jongyoul Lee <jo...@gmail.com>]

Hi Naresh,

You can use JDBCInterpreter for what you want to do. It needs jdbc_url
only, and Zeppelin convert your result into table automatically.

Hope this help,

Regards,
J

On Thu, Apr 21, 2016 at 3:29 PM, Naresh Kancharla <
naresh.kancharla@gmail.com> wrote:

> Hi All,
>
> I came to know about this tool from Spark meetup.
>
> I am using AWS Redshift. Redshift supports SQL queries.
> For example: I can use SQL Workbench which connects to Redshift and return
> response.
> Also RedShift has Python SDK which will return data for the query using
> Redshift SDK.
>
> *My Requirement:*
> I am looking for Visualisation tool for my query responses.
>
> Doubts:
> 1) Can I use Zeppelin for this ?
>
> 2) Looks like Zeppelin is used only for Spark end point. Am I right ?
>
> 3) How Can I use Zeppelin as a visualisation tool for my requirement ?
>
>
> Can I do like this?
> 1) On Zeppelin GUI  user enters SQL query.
> 2) Python will connects to Redshift, executes above given query and gets
> query response.
> 3) Pass this response to Zeppelin.
> 4) Can Zeppelin render this in different graph formats?
>
>
> Thanks,
> Naresh.
>
>
>
>
>


-- 
이종열, Jongyoul Lee, 李宗烈
http://madeng.net

RE: Using Zeppelin as a Visualisation tool for my SQL backend system

[Venkat Muthuswamy <ve...@esgyn.com>]

You can use the generic JDBC interpreter to connect to your SQL engine, run
the query that you typed in Zeppelin and display the results in tabular
form or in charts.

https://zeppelin.incubator.apache.org/docs/0.6.0-incubating-SNAPSHOT/interpreter/jdbc.html



Venkat



*From:* Naresh Kancharla [mailto:naresh.kancharla@gmail.com]
*Sent:* Wednesday, April 20, 2016 11:30 PM
*To:* users@zeppelin.incubator.apache.org
*Subject:* Reg: Using Zeppelin as a Visualisation tool for my SQL backend
system



Hi All,



I came to know about this tool from Spark meetup.



I am using AWS Redshift. Redshift supports SQL queries.

For example: I can use SQL Workbench which connects to Redshift and return
response.

Also RedShift has Python SDK which will return data for the query using
Redshift SDK.



*My Requirement:*

I am looking for Visualisation tool for my query responses.



Doubts:

1) Can I use Zeppelin for this ?



2) Looks like Zeppelin is used only for Spark end point. Am I right ?



3) How Can I use Zeppelin as a visualisation tool for my requirement ?





Can I do like this?

1) On Zeppelin GUI  user enters SQL query.

2) Python will connects to Redshift, executes above given query and gets
query response.

3) Pass this response to Zeppelin.

4) Can Zeppelin render this in different graph formats?





Thanks,

Naresh.