Description

Kibana's discover has a setting that lets you limit searching to certain tiers (hot, warm, cold, frozen, whatever). That's something ESQL should at least be able to work with. And we should be able to provide the same speed savings for it - namely, we should make sure that such limits prevent us from hitting shards on that tier at all.

We should probably also be able to reference the tier as a bit of index metadata so you can view it in the language. And, likely filter on it there as well.