Hi Naresh,
You can try the current psql (PostgresSQL) interpreter in the 0.5.x binaries. You can set the postgresql.driver.name and postgresql.url properties to the jdbc driver/url for your SQL engine. I have tried this and made it work for the Apache Trafodion SQL engine. Here is an example for using the psql interpreter for MySQL. http://thedataist.com/tutorial-using-apache-zeppelin-with-mysql/ Regards Venkat *From:* Naresh Kancharla [mailto:naresh.kancha...@gmail.com] *Sent:* Thursday, April 21, 2016 3:13 AM *To:* users@zeppelin.incubator.apache.org *Subject:* Re: Using Zeppelin as a Visualisation tool for my SQL backend system Thanks Venkat. I couldn't find JDBC Interpreter on default installation(out-of box installation). Is JDBC interpreter support exist by default? In order to get JDBC interpreter on Zeppelin GUI, Do I need to add any config to zeppelin-site.xml ? <property> <name>zeppelin.interpreters</name> <value> ??? Please let me know. It would be great help. Thanks, Naresh. On Thu, Apr 21, 2016 at 12:09 PM, Venkat Muthuswamy < venkat.muthusw...@esgyn.com> wrote: 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.kancha...@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.
