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.
>
>
>
>
>
>
>
>
>
>
>
