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