title: How can I connect to a Netezza database from a Spark SQLContext
body: <p>I have a Spark instance and I'm trying to connect to an existing Netezza datawarehouse applicance to retrieve some data.</p>
  
  <p>Using SparkSQL's <code>SQLContext</code>, and according to <a href="http://spark.apache.org/docs/latest/sql-programming-guide.html#jdbc-to-other-databases" rel="nofollow" title="Spark doc">Spark SQL Programming Guide</a>, this is achievable with the <code>read</code> method. I've determined that I need to provide the JDBC driver using <code>--jars</code> flag, rather than <code>SPARK_CLASSPATH</code> as in the documentation. The operation looks like </p>
  
  <pre><code>// pyspark
  df = sqlContext.read.format('jdbc').options( ... ).load()
  
  // spark-shell
  val df = sqlContext.read.format("jdbc").options( ... ).load()
  </code></pre>
  
  <p>I can find some documentation about connecting to Netezza using JDBC, but not how to correctly pass the username and password. What are the 'options' I need to pass here?</p>