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