cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
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

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now