Hi, I am sending some trace events to our dashboa...
# support
d
Hi, I am sending some trace events to our dashboard called as webhookStartAt and webhookProcessedAt to draw a dashboard to see whats the time difference between these. when doing this query first to see where is this
webhookStartAt
I cant see that in the stringTagmap, where as it returns some data when
channel
is not null, which is also passed in that trace data.
Copy code
SELECT
      stringTagMap
              FROM
              signoz_traces.distributed_signoz_index_v2
              WHERE
              stringTagMap['channel'] IS NOT NULL
              AND timestamp >= NOW() - INTERVAL 1 HOUR
              LIMIT 1;
s
when doing this query first to see where is this
webhookStartAt
I cant see that in the stringTagmap
What is the query for this?
d
as per my understanding of how the schema in clickhouse is. all the traces we are pushing to signoz are adding data in the table but for extra data like our custom values, ex. channel, webhookStartAt, webhookProcessedAt are in the stringTagMap or numberTagMap, is this correct ? becuase querying stringTagMap[“channel”] =“facebook” does give data but the value for webhookStartAt is missing
@Srikanth Chekuri?
s
What is the type of
webhookStartAt
?
d
@Srikanth Chekuri
Copy code
span.setAttributes({
            channel: channel,
            webhookSentAt: msgTimestamp,
            webhookReceivedAt: curTz.getTime(),
            webhookProcessingFinishedAt: new Date().getTime(),
          });
this is what we are sending to signoz, so it must be
number
got it, its in
numberTagMap