cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Updating Databricks/Delta Lake tables in Standard Pipelines

fkhan060
New Contributor II

Hi community, I was wondering if anyone has tried doing Inserts/Updates to Databricks/Delta Lake Table using the generic JDBC Snaps (or any other work around if you have it).

Using the latest Databricks JDBC Driver, I was able to setup an account successfully but I only seem to be able to do SELECT statements using the Generic JDBC - Execute Snap, if I try any other statement like an INSERT/UPDATE, I get the following error:

Failure: SQL operation failed, Reason: SQL [null]; Error message not found: NOT_IMPLEMENTED. Canโ€™t find resource for bundle java.util.PropertyResourceBundle, key NOT_IMPLEMENTED, Resolution: Please check for valid Snap properties and input data.

1 REPLY 1

fkhan060
New Contributor II

Nevermind, figured it out. Was able to use the generic JDBC Insert Snap.