Subquery JOINs and Lookups now available across all data types, GeoIP available for logs

June 29, 2023

Resolve business-critical incidents with your data in one query

With these powerful new query capabilities, not only will you be able to get answers from your data much faster, but we've unlocked entirely new use cases for you, including understanding how your technology stack impacts your business.

By correlating any telemetry data and any business data in one place, you can connect the dots between the performance of your applications and infrastructure, business operations, and customer experiences, all without using additional tools or importing and exporting data between other systems.

Check out this Data Bytes video to see all three capabilities in action.

Subquery JOINs

Subquery JOINs allow you to combine data from different tables in the New Relic database. You might use this to correlate APM event data with logs data, or infrastructure metrics with synthetics, to understand how the performance of different systems impact each other.

Learn more:

Lookups

Lookups allow you to combine data that's not in New Relic with the rest of your telemetry, so you can understand how the performance of your systems impacts other business-related metrics. You might use this to understand at which locations are my point-of-sale terminals having more errors?

To learn more, read the Lookups documentation

GeoIP

GeoIP translates IP addresses into geographical data, allowing you to understand the origin of your traffic. You could use this to ask which locations have the most cache response code errors?

To learn more, read the GeoIP documentation.

A screenshot showing a query with JOINs, Lookups, and GeoIP.

A screenshot showing a query with JOINs, Lookups, and GeoIP.