Posted On: Jun 9, 2020
Amazon Elasticsearch Service now supports SQL Workbench and SQL CLI to run queries on Elasticsearch indexes with the conventional and familiar database language. SQL Workbench, a popular open source visual tool used to manage database environments, is now integrated in Kibana to view the results of SQL queries executed on Elasticsearch indexes. SQL CLI provides the flexibility to run ad-hoc or predefined queries from client applications written in different programming languages.
Amazon Elasticsearch Service already supports over 40 SQL functions, data types, and commands to query your domains. With the newly added support for joins, sub-queries, cursors, and functions, you can leverage SQL Workbench’s visual console and SQL CLI to create, optimize, and run queries interactively and in batch-mode across Elasticsearch indexes. You can then view and export the results to CSV and JSON formats.
All SQL support features are powered by Open Distro for Elasticsearch, an Apache 2.0-licensed distribution of Elasticsearch. To learn more about Open Distro for Elasticsearch, visit the website.
New SQL features are supported on all domains running Elasticsearch 7.4. To learn more, see the documentation.
Support for SQL Workbench, SQL CLI and complex queries in Amazon Elasticsearch Service is now available in 22 regions globally:US East (N. Virginia, Ohio), US West (Oregon, N. California), Canada (Central), South America (Sao Paulo), EU (Ireland, London, Frankfurt, Paris, Stockholm, Milan), Asia Pacific (Singapore, Sydney, Tokyo, Seoul, Mumbai, Hong Kong), Middle East (Bahrain), China (Beijing – operated by Sinnet, Ningxia – operated by NWCD), Africa (Cape Town). Please refer to the AWS Region Table for more information about Amazon Elasticsearch Service availability.