cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How can I connect databricks apps with Unity Catalog?

vedant1611
New Contributor

Hi,

I'm working on building a Databricks app to streamline several team tasks through a user-friendly data application.

One key feature Iโ€™d like to implement is integrating Databricks Apps with Unity Catalog. Specifically, I want to display a dropdown in the UI that lists all tables within a selected Unity Catalog schema. Once a table is selected, users should be able to perform data profiling directly from the app.

Is it possible to achieve this level of connectivity and interaction between Databricks Apps and Unity Catalog? If so, could you provide guidance or best practices for implementing this functionality?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

ximenesfel
Databricks Employee
Databricks Employee

Hi @vedant1611 ,

Yes, it is possible to integrate Databricks Apps with Unity Catalog to achieve the functionality you're describing.

You can build a Databricks appโ€”such as one using Streamlitโ€”that dynamically queries Unity Catalog to list schemas, tables, and even perform operations like data profiling on selected tables. The Unity Catalog APIs allow you to programmatically retrieve catalog metadata, which can be used to populate UI elements like dropdowns.

To help you get started, the following resource provides a practical example of how to integrate Databricks Apps with Unity Catalog using Streamlit:

๐Ÿ‘‰ Databricks Apps Cookbook โ€“ Unity Catalog Integration Example

This example demonstrates how to:

  • Query Unity Catalog to fetch catalog, schema, and table metadata

  • Build interactive dropdowns based on those metadata

  • Perform actions like displaying table previews or profiling data

By following this guide, you can enable your users to seamlessly interact with Unity Catalog directly from the Databricks App interface.

View solution in original post

1 REPLY 1

ximenesfel
Databricks Employee
Databricks Employee

Hi @vedant1611 ,

Yes, it is possible to integrate Databricks Apps with Unity Catalog to achieve the functionality you're describing.

You can build a Databricks appโ€”such as one using Streamlitโ€”that dynamically queries Unity Catalog to list schemas, tables, and even perform operations like data profiling on selected tables. The Unity Catalog APIs allow you to programmatically retrieve catalog metadata, which can be used to populate UI elements like dropdowns.

To help you get started, the following resource provides a practical example of how to integrate Databricks Apps with Unity Catalog using Streamlit:

๐Ÿ‘‰ Databricks Apps Cookbook โ€“ Unity Catalog Integration Example

This example demonstrates how to:

  • Query Unity Catalog to fetch catalog, schema, and table metadata

  • Build interactive dropdowns based on those metadata

  • Perform actions like displaying table previews or profiling data

By following this guide, you can enable your users to seamlessly interact with Unity Catalog directly from the Databricks App interface.

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now