topic Unity Catalog 2.1 API Not Returning SQL Function/View Dependencies in Data Engineering

Unity Catalog 2.1 API Not Returning SQL Function/View Dependencies

DatabricksHero — Thu, 10 Aug 2023 12:19:47 GMT

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_dependencies, return_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).

Re: Unity Catalog 2.1 API Not Returning SQL Function/View Dependencies

DatabricksHero — Fri, 11 Aug 2023 12:21:59 GMT

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?

Re: Unity Catalog 2.1 API Not Returning SQL Function/View Dependencies

vyas — Tue, 23 Jul 2024 09:22:16 GMT

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

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