You can copy your Redshift driver jar to the “lib” sub-folder under zeppelin install. Make sure the user account which is running zeppelin has read access to this jar file.
*From:* Naresh Kancharla [mailto:naresh.kancha...@gmail.com] *Sent:* Thursday, April 21, 2016 10:20 AM *To:* users@zeppelin.incubator.apache.org *Subject:* Re: Using Zeppelin as a Visualisation tool for my SQL backend system I tried with interpreter psql it didn't work. I used below configuration using SQL Workbench to connect to Redshift *SQL Workbench configuration* (successfully connected) DriverName: com.amazon.redshift.jdbc41.Driver (AWS Redshift JDBC Driver. Downloaded jar for the same) URL: jdbc:redshift:// services-redshift.cxz0.us-west-1.redshift.amazonaws.com:5439/myservice *Zeppelin (Used "psql Interpreter") * postgresql.driver.name = com.amazon.redshift.jdbc41.Driver postgresql.url = jdbc:redshift://services-redshift.cxz0.us-west- 1.redshift.amazonaws.com:5439/myservice Zeppelin Interpreter Creation Page I didn't find any page to give AWS Redshift Driver jar path. Where can I give driver jar path? I couldn't able to connect. Thanks, Naresh. On Thu, Apr 21, 2016 at 10:02 PM, Venkat Muthuswamy < venkat.muthusw...@esgyn.com> wrote: 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.
