Does Replicate support Databricks SQL Warehouse as a target?

[MoeyE]

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

[Geetha · Accepted solution]

Hi @MoeyE 

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

[john_wang · Accepted solution]

Hello Mohammed, @MoeyE 

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.