https://signoz.io logo
#support
Title
# support
v

Vishnu Teja Vallala

05/11/2023, 3:52 PM
Hi, I want to create dashboard/query for the exceptions recorded grouped by a custom field like userId/tenantId. While recording the exception in the application, we have the option to pass Attributes with opentelemetry.
Copy code
Span.current().recordException(throwable, Attributes.of(AttributeKey.stringKey("userId"), userId));
Can you please let me know which table in clickhouse will store this attribute or query to achieve the above. I checked in signoz_traces.signoz_error_index_v2 table. Also please share if there is any documentation on the database schema for clickhouse.
s

Srikanth Chekuri

05/12/2023, 2:18 AM
Can you please let me know which table in clickhouse will store this attribute or query to achieve the above. I checked in signoz_traces.signoz_error_index_v2 table.
You are looking at the right table
v

Vishnu Teja Vallala

05/12/2023, 8:43 AM
@Srikanth Chekuri Not able to find that field in this table, can you please let me know the column. There is a column of resourceTagsMap but that dosen't contain this
s

Srikanth Chekuri

05/12/2023, 3:37 PM
I just realised we are not storing all the exception attributes. This needs some development work. Would you mind opening an issue?
v

Vishnu Teja Vallala

05/12/2023, 5:03 PM
@Srikanth Chekuri Sure will do that, but i can see the attribute on the event tab of the trace where the exception is recorded. But could not find in the table that i mentioned above.
@Srikanth Chekuri I can see the new attributes on the ui, not sure which table this is being stored.
s

Srikanth Chekuri

05/15/2023, 4:48 AM
They are not part of the exceptions table. They are part of the
signoz_index_v2
which has stringified event json.
v

Vishnu Teja Vallala

05/15/2023, 4:54 AM
Understood. These should be present in the error index as well. Should i create a issue?
s

Srikanth Chekuri

05/15/2023, 6:46 AM
Yes, please do.
v

Vishnu Teja Vallala

05/15/2023, 7:22 AM
https://github.com/SigNoz/signoz/issues/2691 Done @Srikanth Chekuri, let me know if i need to update anything here.