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:ย 

Unity Catalog 2.1 API Not Returning SQL Function/View Dependencies

DatabricksHero
New Contributor II

Hi all,

I have a problem with reading responses generated by Unity Catalog API 2.1 as they are missing fields that are otherwise described in the specification:

  • List functions - The fields routine_dependenciesreturn_params, and input_params are missing. Moreover, in the Data Explorer -> SQL Function -> Details, the field "Return Params" has the value "parameters=(unrenderable)" - what "unrenderable" means in this case?
  • List fields - The field view_dependencies is missing. Similarly, in the Data Explorer, I can see "dependencies=(unrenderable)" as the value for "View Dependencies".

Is it necessary to modify some configuration in Databricks to be able to see these fields? Do I need special permissions to do so (even though I am logged in as admin)? Please help, this issue is a blocker for my project (building a dependency tree of database objects).

2 REPLIES 2

Hi @Retired_mod, thanks for you reply. What does it mean, that a dependency list is not provided? How do I ensure it will be provided?

vyas
New Contributor II

Hi @Retired_mod , I have the same issue as @DatabricksHero .

View dependencies are not returned. Could you clarify the usage of this API call?

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group