SQL metadata interface (SHOW TABLE) not showing DataStreams

Elastic Stack Elasticsearch
1

Hello, I have defined a data stream with backing indices and an index policy. So far so good.

POST http://localhost:9200/_sql?format=txt
Content-Type: application/json

{
  "query": "select * from \"my-data-stream\""
}

Returns results, OK

POST http://localhost:9200/_sql?format=txt
Content-Type: application/json

{
  "query": "SHOW TABLES"
}

Only returns the backing indices and not the actual data stream. Is that normal? This breaks some downstream tools like the SQLAlchemy interface that rely on SHOW TABLES.

Thanks, JP

3

@JPMoresmau , this is currently to be expected, yes.

Edit: opened an issue on it.