I would like to connect to Tableau using SparkSQL via JDBC driver. So far, I looked into forums for answers but I am still quite confused how to access it.
Programmatically using Spark, I am able to work with my dataset as follows:
spark.read.format("jdbc").option("url", "jdbc:oracle:tihn:@<HOST>:<PORT>:<DATABASE_NAME>").option("dbtable", "<some db name>").option("user", "<username>").option("password", "<password>").option("driver", "oracle.jdbc.driver.OracleDriver").load()
What could be its equivalent to connect using Tableau?
Have you located a solution to this question. The Tableau help for this topic is located here: Spark SQL and an example walk through from this here: http://downloads.tableau.com/beta/Tableau%20Spark%20SQL%20Setup%20Instructions.pdf
I hope that helps.