AI agent not working for SQL blocks and connection metadata embeddings #362
Description
I'm experiencing issues while configuring the AI features in Briefer using Azure OpenAI. After setting all the environment variables, only the AI functionality for Python code blocks is working as expected. When I try to use it with SQL code blocks, the UI gets stuck loading indefinitely, and I see error logs in the API deployment. Additionally, Briefer is failing to generate schema embeddings for the tables connected via Trino. I'm using the latest briefer version, deployed in Kubernetes using the Helm chart provided, with minimal changes to accommodate to my necessities.
Here's the error log from the API deployment related to Trino schema embedding:
{
"level": 50,
"time": 1751055757212,
"pid": 17,
"hostname": "api-deployment-4cf5df6bnd-ljrll",
"err": {
"type": "NotFoundError",
"message": "404 Resource not found",
"stack": "Error: 404 Resource not found\n at APIError.generate (file:///app/node_modules/openai/error.mjs:50:20)\n at OpenAI.makeStatusError (file:///app/node_modules/openai/core.mjs:286:25)\n at OpenAI.makeRequest (file:///app/node_modules/openai/core.mjs:330:30)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)",
"status": 404,
"headers": {
"apim-request-id": "20f3a12b-6179-4223-8719-c83b5d00c3a3",
"content-length": "56",
"content-type": "application/json",
"date": "Fri, 27 Jun 2025 20:22:36 GMT",
"strict-transport-security": "max-age=31536000; includeSubDomains; preload",
"x-content-type-options": "nosniff"
},
"error": {
"type": "Object",
"message": "Resource not found",
"stack": "",
"code": "404"
},
"code": "404"
},
"dataSourceId": "v4144ca4-4411-4cdc-7966-0fas227b60d79",
"dataSourceType": "trino",
"schemaName": "<schema_name>",
"tableName": "<table_name>",
"msg": "Failed to create embedding"
}Here's the error log from the API deployment related to the SQL block editor:
{
"level": 50,
"time": 1750969237170,
"pid": 18,
"hostname": "api-deployment-5cf5gb6bdd-wgv42",
"workspaceId": "86e210a3-661b-486b-ad6c-962ed15e6ab5",
"documentId": "b1ba9076-03b7-5254-8ee6-4543b92f5541",
"blockId": "13648ea5-76c8-37e1-8fb3-44b48f22233b",
"err": {
"type": "NotFoundError",
"message": "404 Resource not found",
"stack": "Error: 404 Resource not found\n at APIError.generate (file:///app/node_modules/openai/error.mjs:50:20)\n at OpenAI.makeStatusError (file:///app/node_modules/openai/core.mjs:286:25)\n at OpenAI.makeRequest (file:///app/node_modules/openai/core.mjs:330:30)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)",
"status": 404,
"headers": {
"apim-request-id": "9237325c-c34f-45a3-fa88-f1b1ea701a76",
"content-length": "56",
"content-type": "application/json",
"date": "Thu, 26 Jun 2025 20:20:36 GMT",
"strict-transport-security": "max-age=31536000; includeSubDomains; preload",
"x-content-type-options": "nosniff"
},
"error": {
"type": "Object",
"message": "Resource not found",
"stack": "",
"code": "404"
},
"code": "404"
},
"msg": "Error editing SQL block with AI"
}For python code blocks, it works perfect.
I'm not sure if I'm missing a configuration step, if these features aren't fully supported in the open-source version, or if there's a bug. Could someone help clarify this?