Posted On: May 28, 2019
New SQL support enables you to query your domain using the familiar SQL syntax without compromising on Elasticsearch’s full-text search and scoring capabilities. With SQL support, you can query your data using aggregations, group by, and where clauses to investigate your data.
Amazon Elasticsearch Service supports more than 40 SQL functions, data types, and commands, including direct export to CSV and query translation from SQL to the Elasticsearch DSL. You can run SQL queries against your domains with the built-in REST API and the Kibana Dev Console. SQL also supports a JDBC driver to connect to your favorite SQL tools.
SQL support on Amazon Elasticsearch Service is available across 21 regions globally: US East (N. Virginia, Ohio), US West (Oregon, N. California), AWS GovCloud (US-Gov-East, US-Gov-West), Canada (Central), South America (Sao Paulo), EU (Ireland, London, Frankfurt, Paris, Stockholm), Asia Pacific (Singapore, Sydney, Tokyo, Seoul, Mumbai, Hong Kong), AWS China (Beijing), operated by Sinnet, and AWS China (Ningxia), operated by NWCD. Please refer to the AWS Region Table for more information about Amazon Elasticsearch Service availability.