AI Playground access Tools(SQL Function) with spark connect PERMISSION_DENIED

loujiang
New Contributor II

Hello, Dear community, 

I have one SQL function defined in Unity Catalog accessing delta table in the unity catalog. It works normally if i use SQL to execute Function. 

I see the possibility connecting function to Agent/ Chat. For the quick prototype, I just try with the AI playground tab and include the function as a tool. With the first trial, it give back the Error: dbconnectshaded.v15.org.sparkproject.io.grpc.StatusRuntimeException: PERMISSION_DENIED: PERMISSION_DENIED: Cannot access Spark Connect. (requestId=fd346bc6-eafb-42eb-a32e-883578db6d1b)Error: Error: dbconnectshaded.v15.org.sparkproject.io.grpc.StatusRuntimeException: PERMISSION_DENIED: PERMISSION_DENIED: Cannot access Spark Connect. (requestId=fd346bc6-eafb-42eb-a32e-883578db6d1b). 

Seems like the Tool and Function call are different. How can I enable the Tool getting the spark and how it will be authenticated? For my simple case, I do not what to use the heavy solution with link to genie spaces. 

Thanks 

best wishes

loujiang