[APM] JSON formatting for database spans

[smith]

Related elastic/apm-agent-nodejs#2019

We show queries for spans with type db, but if it's not SQL it just renders this text field:

Figure out if we can determine if the query language is JSON, and give it pretty formatting and highlighting in these cases.

[elasticmachine]

Pinging @elastic/apm-ui (Team:apm)

[Pranjal-dew]

Hi, is this issue still open? Care if I take it?

[sorenlouv]

Hi @Pranjal-dew , yes, please take it. I'll assign it to you. Let me know if you need some help. For setting up Kibana and APM please follow: https://github.com/elastic/kibana/blob/master/x-pack/plugins/apm/readme.md#local-environment-setup

[Pranjal-dew]

Thanks, @sqren for responding. I'll get back to you if I stuck somewhere.

[matschaffer]

Just thought I'd mention that in the case of an elasticsearch db, being able to open the query in profiler or dev tools could be a really awesome feature add. And probably make our internal work easier on any APM-enabled front (like kibana).

[sorenlouv]

being able to open the query in profiler or dev tools could be a really awesome feature add.

@smith You added this functionality for inspectable queries, right?

[smith]

@smith You added this functionality for inspectable queries, right?

Yes, but in this case it would be a bit trickier, since if you're viewing a query from elasticsearch, what is the URL of the kibana instance associated with the cluster where this query was performed? If you want to run it against the kibana you're currently running, that could work, assuming the data and indexes are the same.

I think it's an interesting feature idea, but separate from this and requiring more thought and planning.

[botelastic]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[elasticmachine]

Pinging @elastic/obs-ux-infra_services-team (Team:obs-ux-infra_services)

[botelastic]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.