Getting Started with AI Insights
Prerequisites
- At least one deployed dataset in the Warehouse
- Datasets marked as searchable by BEEM AI
- Dataset descriptions (recommended for better results)
Step 1: Enable Datasets for AI Search
- Navigate to the Warehouse in the left sidebar
- Open the folder containing your dataset
- Click on the specific dataset
- In the right panel, locate the Automation section
- Toggle ON "Mark dataset as searchable by BEEM AI"
- Click Save
Step 2: Add Dataset Descriptions (Recommended)
- Open the dataset in the Warehouse
- Locate the Description field
- Use "Generate a description" for auto-generation based on columns
- Review and optionally use "Improve description" to refine
- Save changes
Step 3: Open AI Insights
- Click AI Insights in the left sidebar
- The chat interface opens, showing the number of searchable datasets
Step 4: Ask a Question
Type a question in natural language:
- "How many orders do I have?"
- "What is the average order value?"
- "Describe my datasets"
- "Tell me what [dataset name] is used for"
The AI generates a SQL query, runs it, and displays results.
Step 5: Work with Results
- View SQL: Click the code icon to see the generated query with syntax highlighting
- Copy Data: Transfer query results to your clipboard
- Copy Query: Extract the SQL for use elsewhere
- Export as TSV: Download results for further analysis
Step 6: Continue the Conversation
- Ask follow-up questions in the same conversation for context
- Use suggested follow-up questions for deeper exploration
- Start a New Conversation for a different topic
- Access past conversations from the history panel
How It Works Under the Hood
- Built on AWS Bedrock (multi-model: Anthropic, Mistral, Cohere)
- Operates within your dedicated cloud environment. Your data never leaves your infrastructure.
- Workspace-scoped: AI can only access data within your current workspace
- Works with both owned and shared datasets
- Chats are not used to train AI models
Best Practices
- Be specific and include dataset names when possible
- Add comprehensive descriptions to all datasets you want to query
- Start with simple questions before complex analysis
- Review generated SQL queries to verify accuracy
- Use suggested follow-up questions for exploration
- Verify results before using them for critical decisions
Need help? Contact support@beemdata.com.