Background - I created a SQL function with the name schema.function_name, which returns a table, in a notebook, the function works perfectly, however, I want to execute it via API using SQL Endpoint. In API, I got insufficient privileges error, so granted it SELECT access to the function. I am still getting the same error: insufficient privileges.
We checked with our Admins and they couldn't locate the function to check its privileges. With the Describe Function you can't see the location of the function.
Any idea where the functions are stored or how to grant necessary privileges so that it can be used in the API?
Note: We are not using Unity Catalog.
