# SQL\_input lack of documentation and non working integration (version 9.1.4)

**URL:** <https://discuss.elastic.co/t/sql-input-lack-of-documentation-and-non-working-integration-version-9-1-4/382326>\
**Category:** Elastic Agent\
**Created:** [September 30, 2025, 3:11pm UTC](https://discuss.elastic.co/t/sql-input-lack-of-documentation-and-non-working-integration-version-9-1-4/382326 "2025-09-30T15:11:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![dao](https://avatars.discourse-cdn.com/v4/letter/d/a6a055/32.png) [@dao](https://discuss.elastic.co/u/dao)\
**Post date:** [September 30, 2025, 3:11pm UTC](https://discuss.elastic.co/t/sql-input-lack-of-documentation-and-non-working-integration-version-9-1-4/382326/1 "2025-09-30T15:11:47Z")

</div>

I am trying to log all the new lines coming from a postgres database. I want to use the SQL\_input integration, but I cannot achieve what I want. The documentation is not complete, so that I cannot figure out how to do.

Here is my query:

```yaml
- query: "SELECT reg, aircraft_type, airline, is_uplink_enabled, uplink_routing, is_downlink_enabled, downlink_routing, updated_at FROM datalink.aircraft where updated_at > :sql_last_value order by updated_at ASC"

  response_format: table

  sql_tracking_column: "updated_at"

```

As you can see, I want to use the updated\_at column as the tracking point. Unfortunately, it does not work. According to some AI searches, the SQL metrics does not accept the tracking. If I disable it in the kbn HMI, still does not work. it always complains about the : in the query in the elastic-agent logs

```auto
error while fetching:fetch table mode failed: pq: syntax error at or near \":\"

```

So please can you point me the correct and complete documentation ? and explain a bit here?

Once done, I’d like to know if it is possible to define a `_id` as a column, and perform some `upserts` (here the column reg should be the `_id`

thank’s