I want to use special character $ in my SQL-questions with Oracle internal view, but Signoz seems to invalidate the call as the $ is not recognised since PostgreSQL interpret it like a parameter. Are there any solution or workaround how to use $ in SQL-questions in Signoz?

but Signoz seems to invalidate the call as the $ is not recognised

What do you mean SigNoz invalidates the call?

Signoz didnt seem to take action of the question, like ignoring the question. But if I change my question to you guys and to save my time: Could you confirm that it should work and how exactly then?

I asked a question. You would save time for everyone if you answered the question and helped us understand your issue.

Now I´ve confirm the problem and I don´t get my Metric name as an option in Signoz. The sql query I use is: "select count(*) as TEST_SESSIONS from v$session" And in the log for the docker container it cuts off the question as below. So it seems like the dollar sign don´t work. Or how should it work? select count(*) as TEST_SESSIONS from v

Can you help me understand where you are using this? Is it a trace or log or metrics?

Sorry, it is a metric.

Is this an attribute or name of the metric? You should try to follow these conventions https://prometheus.io/docs/practices/naming/#metric-and-label-naming

TEST_SESSIONS is the name of the metric. I´m not using attributes. But I can´t see that the metric name is the problem since I´ve tried with other names and got the same problem. I know is not the best practice name but it´s just for testing the dollar sign question. But please be more specific if the name is the problem since Im new to Signoz. Are there any other rules to follow when it becomes to metrics and dollar sign? And can you say why the log cuts off the question as above?

TEST_SESSIONS is the name of the metric. I´m not using attributes.

But I can´t see that the metric name is the problem since I´ve tried with other names and got the same problem

Then metric name is not the problem. It's you reporting itself that is not sending the data.

Are there any other rules to follow when it becomes to metrics and dollar sign? And can you say why the log cuts off the question as above?

The rules are mentioned in the above linked document. Please go through it to understand the format you need to follow.

More background to the problem: We are not using Prometheus. Instead otlp (open telemetry protocol), which I understand is equivalent. We are using SQLQuery receiver and I´ve put the question in the config file for the otel-collector. FYI - Solution (If other users have the same problem): It turns out you can escape environment variable substitution with an additional $-sign. ($$ -> $)