Explanation:
This SQL command for creating a new table through a JDBC connection in Databricks specifies the JDBC connection details and attempts to create a new table named new_table. If a table with that name already exists, Databricks will throw an error, which aligns with the default behavior for creating tables via JDBC connections.
Ultimate access to all questions.
Which SQL command correctly attempts to create a new table in Databricks using a JDBC connection and throws an error if the table already exists?
A
INSERT INTO new_table SELECT * FROM jdbc(‘jdbc:mysql://database.example.com:3306/mydb‘, ‘existing_table‘, ‘username‘, ‘password‘)
B
CREATE TABLE new_table AS SELECT * FROM jdbc(‘jdbc:mysql://database.example.com:3306/mydb‘, ‘table_name‘, ‘username‘, ‘password‘)
C
CREATE TABLE new_table USING jdbc OPTIONS ( url ‘jdbc:mysql://database.example.com:3306/mydb‘, dbtable ‘new_table‘, user ‘username‘, password ‘password‘)
D
CREATE TABLE IF NOT EXISTS new_table USING jdbc OPTIONS ( url ‘jdbc:mysql://database.example.com:3306/mydb‘, dbtable ‘existing_table‘, user ‘username‘, password ‘password‘)
No comments yet.