A data engineer needs to create a table in Databricks using data from their organization’s existing SQLite database. They run the following command: Which of the following lines of code fills in the above blank to successfully complete the task?
To specify the JDBC driver and other options, the using clause should be followed by the fully qualified name of the JDBC data source, which is org.apache.spark.sql.jdbc.
Answer A -
CREATE TABLE new_employees_table
USING JDBC
OPTIONS (
url "<jdbc_url>",
dbtable "<table_name>",
user '<username>',
password '<password>'
) AS
SELECT * FROM employees_table_vw
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
rafahb
Highly Voted 2 years ago7082935
Highly Voted 8 months agoSoumyaHK
Most Recent 4 days, 15 hours agoranjan24
9 months, 2 weeks agobenni_ale
1 year agoSerGrey
1 year, 3 months agoHuroye
1 year, 5 months agochris_mach
1 year, 7 months agoKalavathiP
1 year, 7 months agojuliom6
1 year, 10 months agojuliom6
1 year, 10 months agoMajjjj
1 year, 12 months agoVarma_Saraswathula
2 years agonaxacod574
2 years agoXiltroX
2 years agosdas1
2 years agosurrabhi_4
2 years agoknivesz
2 years ago