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).

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
Databricks Partner

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

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