Ingesting a sql query

OpenSearch
1

Does anyone have a step by step guide to ingest a sql query into Opensearch.
I’m migrating from Elastic v8 and this was an easy function using the metricbeat sql module.

2

hi @GRobertson ,

To ingest SQL query, you can send the request as in an example below:

POST _plugins/_sql
{
  "query": "SELECT * FROM my-index LIMIT 50"
}

Have you had the chance to read the following documentation?

3

Hi. I am referring to getting data from a SQL database into Opensearch, rather than querying data that already resides with my indices.

4

Metricbeat is also compatible with OpenSearch:

I think you can use the metricbeat sql module with OpenSearch as well.

5

Hi. Metricbeat OSS 7.12 doesn’t contain the sql module.

6

Another option is to use Fluent Bit or Logstash with an SQL input plugin and an OpenSearch output plugin: