SQL client applications
Elastic Cloud Serverless projects are autoscaled environments, fully managed by Elastic and available on Elastic Cloud. Availability This functionality is generally available and ready for production usage. Serverless interfaces and procedures might differ from classic Elastic Stack deployments. The Elastic Stack includes Elastic's core products such as Elasticsearch, Kibana, Logstash, and Beats. Availability This functionality is generally available and ready for production usage. Unless stated otherwise on the page, this functionality is available when your Elastic Stack is deployed on Elastic Cloud Hosted, Elastic Cloud Enterprise, Elastic Cloud on Kubernetes, and self-managed environments. This documentation corresponds to the latest patch available for each minor version. If you're not using the latest patch, check the release notes for changes.
Serverless
Generally available
Stack
Generally available
Thanks to its JDBC and ODBC interfaces, a broad range of third-party applications can use Elasticsearch's SQL capabilities. This section lists, in alphabetical order, a number of them and their respective configuration - the list however is by no means comprehensive (feel free to submit a PR to improve it): as long as the app can use the Elasticsearch SQL driver, it can use Elasticsearch SQL.
- DBeaver
- DbVisualizer
- Microsoft Excel
- Microsoft Power BI Desktop
- Microsoft PowerShell
- MicroStrategy Desktop
- Qlik Sense Desktop
- SQuirreL SQL
- SQL Workbench
- Tableau Desktop
- Tableau Server
Elastic does not endorse, promote or provide support for any of the applications listed. For native Elasticsearch integration in these products, reach out to their respective vendor.
Each application has its own requirements and license these are outside the scope of this documentation which covers only the configuration aspect with Elasticsearch SQL.
The support for applications implementing the ODBC 2.x standard and prior is currently limited.