Answer-first summary for fast verification
Answer: org.apache.spark.sql.jdbc
Using the JDBC library, Spark SQL can extract data from any existing relational database that supports JDBC. Examples include mysql, postgres, SQLite, and more. Reference: [Microsoft Learn](https://learn.microsoft.com/en-us/azure/databricks/external-data/jdbc)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What should you fill in the blank to successfully create a table in Databricks using data from an existing PostgreSQL database? The command is: CREATE TABLE employees USING ____________ OPTIONS (url “jdbc:postgresql:dbserver“, dbtable “employees“)
A
postgresql
B
DELTA
C
org.apache.spark.sql.jdbc
D
dbserver
E
cloudfiles