Hello everyone,
I'm experiencing a specific permissions issue when using an AI agent that queries a Genie space via MCP (Model Context Protocol) within a Model Serving endpoint.
I developed an AI agent to query a Genie space to retrieve retail sales data for predictions. I own the catalog, schema, and Genie space.
When interacting with the agent via the Review app (Model Serving), any query that triggers a call to the Genie tool fails with the following error:
PERMISSION_DENIED: Unable to retrieve tables for the space. Please resolve these errors to continue: No access to the table 'fashion_retail.ppl_schema.silver_transactions'. Code: 42.
What is the best practice for granting Unity Catalog permissions (USE CATALOG, USE SCHEMA, SELECT) to a system identity created from a Model Serving endpoint?
Any suggestions on how to properly configure the authorization chain between Model Serving -> MCP -> Genie -> Unity Catalog would be greatly appreciated.
Thanks in advance!