ODBC SQL SELECT queries for DataStreams?

Elastic Observability
1

I see that ESQL can easily be used to query a DataStream. What about the SQL queries supported by the ODBC connector? I want use the ODBC connector to look at data in my ELK Cloud stack. Thank you.

4

Hi @Yechezkal_Gutfreund

Yes you can query datastream with Elastic SQL

First command queries multiple data streams, the second queries a specific data stream. I just tested this on 8.16.1

POST /_sql?format=txt
{
  "query": """SELECT * FROM "logs-*" LIMIT 10"""
}

POST /_sql?format=txt
{
  "query": """SELECT * FROM "logs-kubernetes.container_logs-default" LIMIT 10"""
}
1 Like