#support

Locating `webhookStartAt` in Dashboard's Traace Data

TLDR Div was unable to locate webhookStartAt in the stringTagMap. Srikanth questioned its data type. Div established the data was in numberTagMap, resolving the issue.

3mo

Join the chat

Jun 01, 2023 (4 months ago)

Photo of md5-69a12cc92bad5b259938b070788a11aa

Div

09:47 AM

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.

SELECT
      stringTagMap
              FROM
              signoz_traces.distributed_signoz_index_v2
              WHERE
              stringTagMap['channel'] IS NOT NULL
              AND timestamp >= NOW() - INTERVAL 1 HOUR
              LIMIT 1;

Jun 02, 2023 (3 months ago)

Photo of md5-ce04a9988e2fd758a659dc55be6f2543

Srikanth

12:30 AM

> when doing this query first to see where is this webhookStartAt I cant see that in the stringTagmap
What is the query for this?

Div

02:43 AM

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

08:29

Div

08:29 AM

Srikanth?

Srikanth

08:37 AM

What is the type of webhookStartAt ?

Div

09:09 AM

Srikanth

          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

09:11

Div

09:11 AM

got it, its in numberTagMap

SigNoz Community

Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI

Indexed 825 threads (61% resolved)

Join Our Community Manage subscription

Similar Threads

Creating Signoz Dashboard for GC Metrics

Div wanted to create a dashboard for GC events and metrics. Ankit and vishal-signoz provided help with Clickhouse queries and template variables.

4mo

Grouping Fields in Clickhouse Query for Graph

Romario had difficulty displaying `http_status` in a graph using a clickhouse query. Srikanth suggested using `toString` to resolve the issue.

4mo

Creating GraphQL Query Traces Graph

Romario requested help with a graph for GraphQL queries. vishal-signoz provided a sample query and additional resources, while Ankit suggested potential improvements to the documentation and integrations.

5mo