Features
Real-time analytical queries on petabytes of data
Column-oriented storage with high compression ratios
Distributed query execution across clusters
Cascading refreshable materialized views (26.6)
Hypothetical skip indexes for query optimization (26.6)
Experimental continuous queries for streaming (26.6)
Built-in vector search for AI/ML workloads
Separate compute and storage scaling
Auto-scaling to zero on idle (Cloud)
Over 100 native integrations via ClickPipes
Open-source (Apache 2.0) with managed cloud option
Time-series functions and window functions
Support for semi-structured data (JSON, arrays)
Role-based access control and data masking
LLM observability via Langfuse integration
Data Agent for data analysis with Python/SQL execution
Plugins Agent integrating 200+ third-party plugins
Web Agent for autonomous web browsing via Chrome extension
Auto plugin selection by the agent
Combined plugin usage for multi-step tasks
Chat-based web UI optimized for swift responses
Open-source full-stack code (backend + frontend)
Local deployment via Docker
Free online demo on OpenAgents website
Data visualization using Python libraries
Integration with 200+ plugins including Klarna, XWeather, Wolfram Alpha
Lemur foundation models for language agents (open-source)
Real-world evaluation and research support
Troubleshooting support via Discord
COLM 2024 publication with paper available
