\n

Dashboard

\n \n \n\n \n \n\n \n \n\n \n\n"}]}},"typeVersion":3.4},{"id":"e08d0061-a5b9-452d-aae1-dd06c5e76478","name":"Respond to Webhook","type":"n8n-nodes-base.respondToWebhook","position":[2020,860],"parameters":{"options":{},"respondWith":"text","responseBody":"={{ $json.html }}"},"typeVersion":1.1},{"id":"caec4943-2a9e-4c93-b9f0-46c05e1c977b","name":"Snowflake1","type":"n8n-nodes-base.snowflake","onError":"continueErrorOutput","position":[1200,860],"parameters":{"query":"{{ $json.query.sql }}","operation":"executeQuery"},"credentials":{"snowflake":{"id":"YWnLSlN2NAjYvAfU","name":"Snowflake account"}},"retryOnFail":false,"typeVersion":1},{"id":"7bf75ddf-38df-454d-908f-32cbeb785464","name":"Aggregate1","type":"n8n-nodes-base.aggregate","position":[1420,860],"parameters":{"options":{},"aggregate":"aggregateAllItemData"},"typeVersion":1},{"id":"eb82d533-e0a0-4328-a31c-39433cf45740","name":"When Executed by Another Workflow","type":"n8n-nodes-base.executeWorkflowTrigger","position":[1000,320],"parameters":{"workflowInputs":{"values":[{"name":"query"}]}},"typeVersion":1.1},{"id":"3b69b3eb-7a91-43b3-8839-13b5bbdf3203","name":"Retrieve Data","type":"@n8n/n8n-nodes-langchain.toolWorkflow","position":[1400,-80],"parameters":{"workflowId":{"__rl":true,"mode":"list","value":"kqpZSjy0tzRRY4hH","cachedResultName":"My workflow 41"},"description":"Generate custom SQL queries using knowledge about DB schema and table definitions to provide needed response for user request.\nUse ->> operator to extract JSON data.\n\nSupported functions for big data analysis:\n• GROUP BY – for grouping data\n• SUM() – for summing values\n• AVG() – for calculating averages\n• COUNT() – for counting records\n• MIN() – for finding the minimum value\n• MAX() – for finding the maximum value\n• MEDIAN() – for median calculation\n• STDDEV() – for standard deviation\n• VARIANCE() – for variance calculation\n• PERCENTILE_CONT() – for percentile calculations\n• MODE() – for most frequent value\n• TREND() – for trend analysis over time\n• WINDOW FUNCTIONS – for advanced analytics (e.g., ROW_NUMBER(), RANK(), PARTITION BY)\n\nQuery example:\nSELECT * FROM FILES","workflowInputs":{"value":{"query":"={{ $fromAI(\"sql_query\",\"SQL query\") }}"},"schema":[{"id":"query","type":"string","display":true,"removed":false,"required":false,"displayName":"query","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["query"],"attemptToConvertTypes":false,"convertFieldsToString":false}},"typeVersion":2.2},{"id":"8968d722-6b26-42d9-b750-0b13c382f7ab","name":"Sticky Note","type":"n8n-nodes-base.stickyNote","position":[940,120],"parameters":{"width":1140,"height":560,"content":"### Tool\n"},"typeVersion":1},{"id":"33544700-b10f-441a-852c-0f985158cb5c","name":"Sticky Note1","type":"n8n-nodes-base.stickyNote","position":[940,720],"parameters":{"width":1360,"height":480,"content":"### Report workflow"},"typeVersion":1},{"id":"d279cb96-4fc5-4554-9363-669aea575926","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[940,-360],"parameters":{"width":900,"height":440,"content":"### Agent"},"typeVersion":1},{"id":"fc341443-ec9c-4005-8b67-dce59e8b4119","name":"Execute SQL","type":"n8n-nodes-base.snowflake","onError":"continueErrorOutput","position":[1200,320],"parameters":{"query":"{{ $json.query }}","operation":"executeQuery"},"credentials":{"snowflake":{"id":"YWnLSlN2NAjYvAfU","name":"Snowflake account"}},"retryOnFail":false,"typeVersion":1},{"id":"935f1932-e803-4daf-89ae-e3ce9f322962","name":"Aggregate Data","type":"n8n-nodes-base.aggregate","position":[1420,260],"parameters":{"options":{},"aggregate":"aggregateAllItemData"},"typeVersion":1},{"id":"1c7362be-e338-4976-8a18-a40f11e01ef1","name":"If Count>100","type":"n8n-nodes-base.if","position":[1600,280],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"5a485a5a-28fb-4914-8fb6-131a159db08d","operator":{"type":"array","operation":"lengthGt","rightType":"number"},"leftValue":"={{ $json.data }}","rightValue":100}]}},"typeVersion":2.2},{"id":"36440a5e-d254-4995-be8e-2e8313b8bc29","name":"Link to Report","type":"n8n-nodes-base.set","position":[1800,200],"parameters":{"mode":"raw","options":{},"jsonOutput":"={\"output\":\"[Link to report](https://n8n.lowcoding.dev/webhook/87893585-d157-468d-a9af-7238784e814c?sql={{ $('When Executed by Another Workflow').item.json.query.urlEncode() }})\"}"},"typeVersion":3.4},{"id":"c581ea63-c210-4df9-b029-f58c1c8da75d","name":"Return Data","type":"n8n-nodes-base.set","position":[1800,360],"parameters":{"mode":"raw","options":{},"jsonOutput":"={{ $json }}"},"typeVersion":3.4},{"id":"4fa89cd3-64d8-40cf-87f1-d604aca9c7eb","name":"Return Error","type":"n8n-nodes-base.set","position":[1600,460],"parameters":{"mode":"raw","options":{},"jsonOutput":"={{ $json }}"},"typeVersion":3.4},{"id":"c67e5a20-e116-4955-bc66-fe8b4384b284","name":"Error page","type":"n8n-nodes-base.set","position":[1800,1000],"parameters":{"options":{},"assignments":{"assignments":[{"id":"1257d6ca-3c5c-476b-8d26-f8fb84a0c38e","name":"html","type":"string","value":"=\n\n\n \n \n\n\n \n\n \n\n"}]}},"typeVersion":3.4},{"id":"f614bdcc-e19a-4048-9b13-2adf8b416e56","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[1980,200],"parameters":{"color":5,"height":80,"content":"### Replace webhook address"},"typeVersion":1},{"id":"6ac29201-e714-4d00-b9ca-e2063267dcb3","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[1360,60],"parameters":{"color":5,"width":160,"height":80,"content":"### Map this workflow"},"typeVersion":1},{"id":"3955749d-31e0-4dc8-9e39-13c1f3de700d","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[1540,60],"parameters":{"color":5,"height":80,"content":"### Replace name of schema and database"},"typeVersion":1},{"id":"b71fbe78-5527-4857-a259-bfa9fc0a0537","name":"Sticky Note11","type":"n8n-nodes-base.stickyNote","position":[260,-360],"parameters":{"color":7,"width":636.2128494576581,"height":497.1532689930921,"content":"\n## AI Agent to chat with Snowflake database with UI\n**Made by [Mark Shcherbakov](https://www.linkedin.com/in/marklowcoding/) from community [5minAI](https://www.skool.com/5minai-pro)**\n\nThis workflow is designed for developers, data analysts, and business professionals who want to interact with their Snowflake data conversationally. It suits users looking to automate SQL query generation with AI, manage large datasets efficiently, and produce interactive reports without deep technical knowledge.\n\n**Preparation** \n- Create your Snowflake credentials in n8n with required host and account details, warehouse (e.g., \"computer_warehouse\"), database, schema, username, and password. \n- Replace placeholder variables in schema retrieval workflows with your actual database and data source names. \n- Verify the credentials by testing the connection; reset passwords if needed.\n\n"},"typeVersion":1},{"id":"a207fdbc-7223-49ed-9798-9d3415634b39","name":"Sticky Note12","type":"n8n-nodes-base.stickyNote","position":[560,160],"parameters":{"color":7,"width":330.5152611046425,"height":240.6839895136402,"content":"### ... or watch set up video [5 min]\n[](https://youtu.be/r7er-HCRsX4)\n"},"typeVersion":1}],"pinData":{},"connections":{"Webhook":{"main":[[{"node":"Snowflake1","type":"main","index":0}]]},"Set HTML":{"main":[[{"node":"Respond to Webhook","type":"main","index":0}],[{"node":"Error page","type":"main","index":0}]]},"AI Agent1":{"main":[[]]},"Aggregate1":{"main":[[{"node":"Set HTML","type":"main","index":0}]]},"DB Schema1":{"ai_tool":[[{"node":"AI Agent1","type":"ai_tool","index":0}]]},"Error page":{"main":[[{"node":"Respond to Webhook","type":"main","index":0}]]},"Snowflake1":{"main":[[{"node":"Aggregate1","type":"main","index":0}],[{"node":"Error page","type":"main","index":0}]]},"Execute SQL":{"main":[[{"node":"Aggregate Data","type":"main","index":0}],[{"node":"Return Error","type":"main","index":0}]]},"If Count>100":{"main":[[{"node":"Link to Report","type":"main","index":0}],[{"node":"Return Data","type":"main","index":0}]]},"Retrieve Data":{"ai_tool":[[{"node":"AI Agent1","type":"ai_tool","index":0}]]},"Simple Memory":{"ai_memory":[[{"node":"AI Agent1","type":"ai_memory","index":0}]]},"Aggregate Data":{"main":[[{"node":"If Count>100","type":"main","index":0}]]},"OpenAI Chat Model1":{"ai_languageModel":[[{"node":"AI Agent1","type":"ai_languageModel","index":0}]]},"Get table definition":{"ai_tool":[[{"node":"AI Agent1","type":"ai_tool","index":0}]]},"When chat message received":{"main":[[{"node":"AI Agent1","type":"main","index":0}]]},"When Executed by Another Workflow":{"main":[[{"node":"Execute SQL","type":"main","index":0}]]}}}