Natural language queries to Snowflake with interactive…

This workflow enables users to ask data questions in plain language and instantly receive results from Snowflake as interactive tables and charts. It uses AI to convert text into secure SQL queries, executes them, and visualizes the output — no coding required.

## Who it´s for
- Data analysts who need fast access to Snowflake without writing SQL
- Developers integrating databases with chat interfaces
- Business users requesting reports via simple text input
- Teams automating analytics using AI

## What the automation does
- Receives a natural language query via HTTP webhook or chat message
- Uses a LangChain agent with OpenAI to generate a valid SQL query
- Executes the query on Snowflake
- Formats results and displays them in an interactive HTML dashboard with Chart.js
- Returns a link to the full report instead of inline data if result exceeds 100 rows
- Supports filtering, sorting, and CSV export

## What´s included
- Ready-to-use n8n workflow
- Trigger logic (webhook, message)
- Integrations with Snowflake, OpenAI, and HTTP API
- JavaScript-based processing and visualization logic
- Basic setup and adaptation guide

## Requirements for setup
- n8n instance with workflow execution capability
- Snowflake credentials (user, password, account, role, warehouse)
- OpenAI API key
- Publicly accessible endpoint or tunnel for webhook reception

## Benefits and outcomes
- Accelerates data access for non-technical users
- Reduces analyst workload through self-service querying
- Delivers built-in visualization without external tools
- Minimizes errors from manually written SQL
- Scales via webhooks for integration with other systems

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.