I have deployed simple multi agent genie app on serving endpoint and it always fails PERMISSION error on tables accessed by Genie agent, however the same app works perfectly when tested from notebook. not sure what am i missing here. I checked all the permissions for my user and i am the workspace admin and I have given all privileges to all the tables but still fails at serving review chat app. I have followed steps mentioned in this notebook to create app.
https://docs.databricks.com/aws/en/notebooks/source/generative-ai/dspy/dspy-multiagent-genie.html
Please help here.
Genie query failed with error: {'error': \"PERMISSION_DENIED: Failed to fetch tables for the space. Please resolve these errors to continue: No access to table 'xxxxx.xxxxx.xxx'. Code: 42.\", 'type': 'TABLES_MISSING_EXCEPTION'}"