Can I query an App Search Index with ElasticSearch SQL

[David_Robbins]

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 Elastic Search 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.

[cromagnon35 (Jeff Lewis)]

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

[David_Robbins]

Thanks, I'll experiment with that.

[David_Robbins]

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.