[Discover] [ES|QL] ES|QL mode should be the default in serverless

stratoula commented 4 months ago

Describe the feature:

We want the Discover app to start with the ES|QL mode as the default. This means:

we need to identify if a logs index(indices) exist and default to from logs-*-*
as the logs indices are timeseries we want the table to be sorted by timestamp by default (without adding the | sort @timestamp in the query . https://github.com/elastic/elasticsearch/issues/108305
We want to return by default the _id and _index as we will use them in flyouts to get the document and its metadata

elasticmachine commented 4 months ago

Pinging @elastic/kibana-data-discovery (Team:DataDiscovery)

elasticmachine commented 4 months ago

Pinging @elastic/kibana-esql (Team:ESQL)

elastic / kibana