Equivalent of Postgres' application_name per connection?

Help Connectors and Pipelines
1

Hi,

We have multiple identical web servers connecting to Singlestore … being identical they’re using the same user name which makes it impossible to tell (within Studio) where Queries are being run from.

Does Singlestore have a per-connection parameter equivalent to the Postgres application_name that can be used to tag connections with textual metadata; which can then be surfaced in the Singlestore Studio Active Queries (or similar) tab ?

(IP Address is unfortunately not useful to us)

Regards,
Nick

1 Like
2

Maybe something like the connection attributes in the ODBC driver?

https://docs.singlestore.com/cloud/developer-resources/connect-with-application-development-tools/connect-with-odbc/the-singlestore-odbc-driver/

https://docs.singlestore.com/cloud/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-connection-attributes/

Alternatively, I’m guessing you said not IP as the IP are dynamic, but maybe the hostname is static and can be captured from the process list:

https://docs.singlestore.com/cloud/reference/information-schema-reference/query-performance-workload-management-and-statistics/mv-processlist/