I successfully deployed my app and fixed the database permission issue.
The main issue was with permissions in Overview โ Roles & Database. I found a separate randomly generated role/number associated with the database, and after granting it the required access, my app was able to query the todos table successfully.
For troubleshooting, I used Google Gemini as my AI agent. I provided the error message and my code, and used its suggestions to understand what was causing the database access problem.
Agent used: Google Gemini
Prompt used:
โI'm getting a failed to get todos error in my deployed Databricks Lakebase app. Here is my code and the error message. Help me identify the database permission issue and explain how to fix it.โ
Now the app is working successfully!
