Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
How would you define an external SQL table by connecting to a local instance of an SQLite database using JDBC in Databricks?
A
CREATE TABLE users_jdbc USING SQLITE OPTIONS (url = “jdbc:/sqmple_db“, dbtable = “users“)
B
CREATE TABLE users_jdbc USING org.apache.spark.sql.jdbc OPTIONS (url = “jdbc:sqlite:/sqmple_db“, dbtable = “users“)
C
CREATE TABLE users_jdbc USING SQLURL = {server:“jdbc:/sqmple_db“,dbtable: “users”}
D
CREATE TABLE users_jdbc USING org.apache.spark.sql.jdbc.sqlite OPTIONS (url = “jdbc:/sqmple_db“, dbtable = “users“)
E
CREATE TABLE users_jdbc USING SQL OPTIONS (url = “jdbc:sqlite:/sqmple_db“, dbtable = “users“)
