topic Re: DLT pipeline - DebeziumJDBCMicroBatchProvider not found in Data Engineering

DLT pipeline - DebeziumJDBCMicroBatchProvider not found

ksenija — Thu, 20 Jun 2024 09:48:59 GMT

Hi!

I created DLT pipeline and I'm getting this error:[STREAM_FAILED] Query [id = ***, runId = ***] terminated with exception: object com.databricks.cdc.spark.DebeziumJDBCMicroBatchProvider not found.

I'm using Serverless.

How to verify that the required library or package containing the missing class is correctly included in my environment?

How to check my Spark configuration to ensure that the necessary dependencies are available?

I saw in other answers/questions ideas what to do, but I don't know how to check it.

Re: DLT pipeline - DebeziumJDBCMicroBatchProvider not found

ksenija — Fri, 21 Jun 2024 09:14:09 GMT

Hi @Retired_mod ,

How to check "libraries associated with your cluster" if I'm using Serverless option?

Best regards,

Ksenija

Re: DLT pipeline - DebeziumJDBCMicroBatchProvider not found

jlachniet — Mon, 24 Jun 2024 13:09:22 GMT

@Retired_mod I am experiencing the same error as @ksenija , using enhanced autoscaling clusters in my dlt pipeline. This is when trying to create a streaming table off of a foreign catalog using a sql server external connection.

Re: DLT pipeline - DebeziumJDBCMicroBatchProvider not found

Dnirmania — Tue, 02 Jul 2024 13:50:51 GMT

@jlachniet Are you able to resolve your issue? because I am also facing same issue for sql server connection..

Re: DLT pipeline - DebeziumJDBCMicroBatchProvider not found

ksenija — Tue, 02 Jul 2024 17:41:34 GMT

@Dnirmania, @jlachniet I didn’t manage to resolve this issue, but I created a regular notebook and I’m using MERGE statement. If you can’t merge all data at once, you can use a loop with hourly intervals