Can I query an App Search Index with ElasticSearch SQL

I have a long running import process for my App Search index and I'd like to get perform checkpoints and get various count. I see SQL for Elasticsearch and wonder if something like "select count(*) where state = 'MI'" is possible.

If not, any suggestions that you may have used with App Search in the past? Thanks in advance.

Get your index name:
GET _cat/indices/.ent-search-engine-documents-**{wildcard or engine name}**
Get Count:
GET **{index name from _cat}**/_count

1 Like

Thanks, I'll experiment with that.

using this syntax:

GET .ent-search-engine-documents-gcp-schema-2/_count{}

I get

"hits" : {
    "total" : {
      "value" : 10000,
      "relation" : "gte"
    },

It seems that App Search always return the ceiling for paging. Any insight you have would be appreciated. Thanks in advance.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.