In order for AI Agents to generate insights you will need to provide them with read access to the SQL tables containing the unstructured text data generated by your users, such as support tickets, call transcripts, or survey responses.
These commands are automatically generated when creating an AI agent.
See Loom video above.
--- Check it in Data Products > Apps. Make sure to use the correct name.
SET LANGAI_APP_NAME = 'LANGAI_APP';
--- Give the application access to the tables
GRANT USAGE ON DATABASE YOUR_DATABASE TO APPLICATION IDENTIFIER($LANGAI_APP_NAME);
GRANT USAGE ON SCHEMA YOUR_DATABASE.YOUR_SCHEMA TO APPLICATION IDENTIFIER($LANGAI_APP_NAME);
--- NOTE: Add here the additional tables you will be using when creating AI agents
GRANT SELECT ON TABLE YOUR_DATABASE.YOUR_SCHEMA.YOUR_DATABASE TO APPLICATION IDENTIFIER($LANGAI_APP_NAME);
If you have any question about creating and using views, please get in touch with your CSM.