Updated data with tracking column for sql server binary timestamp

Elastic Stack Logstash
1

Hi all,

I have a table with a version column which is a timestamp as a binary. This is changed every time there is a change/update in the row.

I can transmit this table to elastic but my format is not really correct

<Sequel::SQL::Blob:0x9b18 bytes=8 content="\u0000\u0000\u0000\u0000\u0001\xE6\u0016\xEF"
instead of
00000000000000000001E60016xEF"

is there a way to correctly import this binary column and set it as a tracking column so when there is a change is this field logstash only updates/sends the changed row to Elasatic ?

i'm breaking my head sinds last night without any luck.

thx in advance

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.