JDBC table to delta table

elgeo — Fri, 21 Mar 2025 13:00:47 GMT

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.

topic JDBC table to delta table in Warehousing & Analytics

JDBC table to delta table