cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC table to delta table

elgeo
Valued Contributor II

Hello experts. We need to transfer couple of tables from our old system to Databricks through JDBC connection. So, the first step was to create the corresponding table as below:

CREATE TABLE IF NOT EXISTS jdbc_table

USING JDBC

OPTIONS (DRIVER = "DriverX", URL = "jdbc:xxxxxxxx", dbtable="table_name", user = "user1", password="pass" )

Since querying the above table is not efficient, we tried to create a delta table using the jdbc_table:

CREATE OR REPLACE TABLE table_name AS 

 SELECT * FROM jdbc_table

However, the above process is extremely slow and the table is not created at the end.

Do you have any other suggestions in order to achieve this?

Thank you in advance.

0 REPLIES 0
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.