Export service metrics via OpenTelemetry and count errors per target

as a user Id like to know how many queries were sent to my exasol deployment vs transactional deployment (knowing at first its send to both). As a KPI in enterprise manager + mariadb cloud can help understand the workload going through it.

Likewise a counter for the number of failed routing attempts to the exasol side because of syntax failures to run or errored response codes?
(this part could be a separate ticket if needed) maybe a regexable log of queries or a dedicated log when debug is turned on - of not runnable SQL on exasol so mariadb can improve compatibility + make it easy to share a list of not working queries.