Question: How do we send SQL queries?

[dkullmann]

@jngli hello, do you know how we can send an SQL query?

I see the telemetry type is a metric, but I don't know what the custom properties are that should be included.

[jngli]

There are multiple telemetry types as defined in the contract classes, all of them support properties which are custom defined, that is, you define the property and responsible for tracking its value.

[dkullmann]

@jngli thank you, we'll try sending SQL data using this and setting it to 3

Our goal is to make sure the SQL metrics show up here:

We also weren't sure if SQL metrics could include SQL-specific things like Time + Query (we can include them as custom properties.)

[jngli]

The rdd (RemoteDependencyData) is not officially supported by Ruby SDK yet, not exposed directly via TelemetryClient. You could manually create an rdd and send to AI using the telemetry channel, what you've done I think. However there are two issues while processing rdd:

1. The dependency kind is not processed correctly and got addressed recently with a schema change but not updated in Ruby SDK yet.
2. The rdd would be ignored if ai.device.id is not specified which would be fixed in the server side in the near future.

You can work around the above issues with following changes:

1. rdd.dependency_kind = 0 # SQL should be set to 0
2. tc.context.device.id = "1" # explicitly set device id

What do you mean by 'Time', the time stamp making the sql query, execution time, or something else? For query, yes, you can use the custom property to track it.

Thanks,
Jing

[dkullmann]

@jngli exactly — the SQL query execution time.

Thank for all the other info, btw.

[jngli]

The 'value' field is supposed to use for tracking execution time (i.e., dependency duration used in UI).

[dkullmann]

@jngli ok perfect, thank you!

[jngli]

@dkullmann the sdk is updated with latest schema where the dependency kind issue should be fixed.