InstaQuery

InstaQuery is a Generative AI-powered agent for Snowflake cost and performance optimization that automatically : 

·       Detects slow-running and most expensive queries

·       Applies exhaustive query analysis 

·       Returns **optimized rewritten queries with over 95% accuracy using kloudgen’s proprietary algorithm and generative AI**

·       Shares through multiple channels additional **recommendations about the environment where the queries run** with diagnosis and root causes of inefficiencies.  

**InstaQuery Optimizer**: Users can run it on a **schedule** in automated mode or manually specify their query IDs. They can use it for complex queries such as nested stored procedures. 

**InstaQuery Copilot**: Users can focus on query rewriting in minutes by **dragging and dropping hundreds of SQL query files and use of the power of generative AI**. Developers can use it as a part of their SDLC process to rewrite queries for optimization before deployment.

InstaQuery是一款面向Snowflake成本与性能优化的生成式AI（Generative AI）智能体，可自动执行以下操作：
· 检测运行缓慢与资源消耗最高的查询语句
· 开展全面的查询分析
· **依托Kloudgen的专有算法与生成式AI，以超95%的准确率返回经过优化重写的查询语句**
· 通过多渠道分享**针对查询运行环境的额外优化建议**，并附带低效问题的诊断与根本原因分析

**InstaQuery 优化器**：用户可通过设置调度任务以自动化模式运行该工具，也可手动指定查询ID。其支持处理嵌套存储过程等复杂查询语句。

**InstaQuery 助手**：用户仅需数分钟即可完成查询重写工作——可拖拽上传数百个SQL查询文件，借助生成式AI的强大能力完成优化。开发人员可将其集成至软件开发生命周期（SDLC）流程中，在部署前完成查询语句的重写优化。