Error in DLT Streaming table

[Dnirmania]

Hello

I am trying to create DLT streaming table in Azure Data bricks but getting following error. I checked online article regarding this error but none of the article shown complete resolution.

[STREAM_FAILED] Query [id = 9989a41e-741d-48d7-9a87-fc14344d66e4, runId = 2f7a11fb-e61c-4247-a3fb-0c112a4daa2d] terminated with exception: object com.databricks.cdc.spark.DebeziumJDBCMicroBatchProvider not found.

More info: So I am trying to build DLT streaming table on top off Azure SQL Database catalog and getting above error. However, I was able to create live table\Materialized view on top off same catalog.

If any one can help me with issue it would be highly appreciated..

Thanks,

Dinesh 

[Kaniz_Fatma]

Hi @Dnirmania, 

1. • Ensure that the required library or package containing the missing class (com.databricks.cdc.spark.DebeziumJDBCMicroBatchProvider) is correctly included in your environment. Double-check the dependencies and make sure they are properly configured.

[Dnirmania]

HI @Kaniz_Fatma

Can you pls share the library or package name which contain "com.databricks.cdc.spark.DebeziumJDBCMicroBatchProvider" class. I tried to add databricks-cdc and Debezium library using maven but unable to install them because they are not available in maven package list.