topic Does Replicate support Databricks SQL Warehouse as a target? in Qlik Replicate

Does Replicate support Databricks SQL Warehouse as a target?

MoeE — Wed, 11 Sep 2024 02:11:24 GMT

Hi,

As the title says, does Replicate support Databricks Delta target that is using SQL Warehouse instead of General Purpose? I've heard that SQL Warehouse can be more performant than General Purpose. Thank you.

Regards,

Mohammed

Re: Does Replicate support Databricks SQL Warehouse as a target?

Geetha — Wed, 11 Sep 2024 09:05:24 GMT

Hi @MoeE

Thank you for contacting us through Qlik community.

Yes, this is supported. More info: https://help.qlik.com/en-US/replicate/May2024/pdf/Replicate-Support-Matrix.pdf

Databricks Lakehouse (Delta) l All-purposes (Interactive)
cluster:
l 9.1 LTS
l 10.4 LTS
l 11.3 LTS
l 12.2 LTS
l 13.3 LTS
l SQL Warehouse cluster
l Databricks SQL Serverless

Best Regards,
Geetha

Re: Does Replicate support Databricks SQL Warehouse as a target?

john_wang — Wed, 11 Sep 2024 12:54:26 GMT

Hello Mohammed, @MoeE

Qlik Replicate supports 3 types of Databricks cluster:

All-purposes (Interactive) cluster
SQL Warehouse cluster
Databricks SQL Serverless

So, yes, the Databricks SQL Warehouse is supported as target endpoint.

BTW, there is a comparison: Data Lakes vs. Data Warehouses Comparison Guide. Please check.

Hope this helps.

John.