BigQuery AI Slack Agent

Transform your Slack into a powerful BigQuery interface where you can ask questions about your data in natural language without any SQL knowledge required. The AI assistant handles table discovery, schema analysis, and query writing automatically.

Use Cases

• Get data insights without learning SQL or BigQuery syntax
• Explore datasets through conversational questions during team meetings
• Run complex data analysis through simple English requests
• Understand database structures without technical expertise
• Share data findings with non-technical stakeholders in real-time

How It Works

1. Message Trigger: Workflow activates when someone mentions @Markifact in a Slack message
2. AI Agent Activation: Your message is sent to an AI assistant equipped with three BigQuery tools
3. Table Discovery: AI uses "List Tables" to help identify the correct tables when not specified
4. Schema Analysis: AI uses "Get Table Schema" to understand table structure before running queries
5. Query Execution: AI uses "Run Query" to execute SQL and return results to your Slack channel

Setup Instructions

1. Connect Your Slack Account by clicking 'On New Message' and linking your workspace
2. Connect Your BigQuery Account by clicking any BigQuery node and authenticating
3. Save and Activate the Workflow using the active switch at the top
4. Start Asking Data Questions by mentioning the bot and describing what you need
5. Optional: Set Dataset Permissions to limit which datasets the bot can access