Oracle

The below code snippet shows you how to read in data from an Oracle database. This method requires that you have the correct driver installed on the cluster. See Libraries to learn how to install a library JAR for databases whose drivers are not available in Databricks.

CREATE TABLE oracle_table
USING org.apache.spark.sql.jdbc
OPTIONS (
  dbtable 'table_name',
  driver 'oracle.jdbc.driver.OracleDriver',
  user 'username',
  password 'pasword',
  url 'jdbc:oracle:thin://@<hostname>:1521/<db>')