JDBC connection to Databricks

mat007g — Fri, 15 Nov 2024 23:21:12 GMT

I have created a tJDBCconnection and succesfully connected to databricks. However I need to use a tJDBCRow to execute a series of SQL commands : Update/delete/insert (Merge) . However, for some reason, the component is throwing a runtime exception. I then end up creating multiple tJDBCRow components , and assigning 1 sql statement to each. As you might imagine, this is not practical. Moreover, I cannot use the database/schema name in the SQL, as I get thrown a "Catalog namespace is not supported." exception.

Any thoughts on the above?

Re: JDBC connection to Databricks

Anonymous — Tue, 01 Mar 2022 08:55:49 GMT

Hello,

Are you able to retrieve table schemas successfully when you complete JDBC connection?

Here is online documentation about: TalendHelpCenter: Retrieving table schemas

Best regards

Sabrina

topic Re: JDBC connection to Databricks in Talend Studio

JDBC connection to Databricks

Re: JDBC connection to Databricks