DLT pipeline - DebeziumJDBCMicroBatchProvider not found

[ksenija]

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.

[ksenija]

Hi @Retired_mod ,

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

Best regards,

Ksenija

[jlachniet]

@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. 

[Dnirmania]

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

[ksenija]

@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