Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!

Qlik Replicate added support for Databricks Unity Catalog using feature flag from 2022.11 SP02

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
SwathiPulagam
Support
Support

Qlik Replicate added support for Databricks Unity Catalog using feature flag from 2022.11 SP02

Last Update:

Feb 15, 2023 6:00:05 AM

Updated By:

Sonja_Bauernfeind

Created date:

Feb 15, 2023 5:49:27 AM

Beginning with version 2022.11 SP02, Qlik Replicate supports the Unity Catalog for Databricks endpoint. A feature flag needs to be enabled before the endpoint can be used.

Before enabling the feature flag, Qlik Replicate allows to browse databases under hive_metastore only. See fig 1.

Fig 1Fig 1

 

To enable the Unity Catalog feature flag for the Databricks endpoint:

  1. In your Qlik Replicate Web Console, go to your Databricks Target endpoint
  2. Switch to the Advanced tab
  3. Open More Options
  4. Add the following feature name tag: UnityCatalog-DatabricksLHTarget
  5. Enable the feature by switching it to On 

    Switch on UnityCatalog-DatabricksLHTarget.png

  6. Click OK so save the endpoint
  7. Switch to the General tab
  8. Locate the option Use Unity Catalog and enable it by checking the box. You can also disable it from here.

    enable use unity catalog.png

  9. You can now browse the database under the catalog:

    select database after enable.png

 

 

Environment

Qlik Replicate 2022.11 SP02 and later
Databricks as Target

 

Labels (1)
Comments
MoeE
Partner - Specialist
Partner - Specialist

Hi Support,

One of my clients setup the settings exactly like this for his databricks delta endpoint. However upon searching for the catalog and database in the settings they are unable to find them. Typing the database and catalog name in also didn't work

Is there anything else to consider when setting this up maybe on the databricks side?

Kind regards,

Mohammed

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @MoeE 

Please post your query directly in our Qlik Replicate forum. Our active user base and support agents will be able to help you there.

All the best,
Sonja

Version history
Last update:
‎2023-02-15 06:00 AM
Updated by: