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, 4 months ago7082935
Highly Voted 11 months, 2 weeks agoSoumyaHK
Most Recent 3 months, 1 week agoranjan24
1 year agobenni_ale
1 year, 3 months agoSerGrey
1 year, 7 months agoHuroye
1 year, 8 months agochris_mach
1 year, 10 months agoKalavathiP
1 year, 10 months agojuliom6
2 years, 1 month agojuliom6
2 years, 1 month agoMajjjj
2 years, 3 months agoVarma_Saraswathula
2 years, 3 months agonaxacod574
2 years, 3 months agoXiltroX
2 years, 4 months agosdas1
2 years, 4 months agosurrabhi_4
2 years, 4 months agoknivesz
2 years, 4 months ago