Nathan Scully created ZEPPELIN-1494: ---------------------------------------
Summary: Bind JDBC result to a dataset on the zeppelin context Key: ZEPPELIN-1494 URL: https://issues.apache.org/jira/browse/ZEPPELIN-1494 Project: Zeppelin Issue Type: Improvement Reporter: Nathan Scully There doesn't seem to be an easy way to leverage the JDBC interpreter to offload the work to a database then use the result in the following paragraph. I would like an easy way for a team to write SQL using a predefined connection against our database then use python to work with the results. E.g. {code} %jdbc(dataset='mytableresult') SELECT 1 FROM mytable; {code} Then access it: {code} %python df =z.datasets('mytableresult) {code} The only other way I could see this working is using pyspark and the sqlc.read.jdbc but having to remember the URLs and driver etc is impractical unless they could be accessed as properties from the main context. Eg: {code} %pyspark jdbcDF = sqlc.read.format("jdbc").options(z.interpreters.jdbc()).load() {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)