Connect External Data for Complete Insight, Without the Ingestion Tax
Today, we are excited to announce the General Availability of New Relic Lens—a powerful data federation capability designed to simplify and accelerate data discovery and analysis across multiple environments. With New Relic Lens, you can easily connect your observability data directly to your business outcomes and transform that data into actionable insights, all without paying for extra data ingestion.
What is New Relic Lens?
New Relic Lens allows you to connect and query multiple external data sources—like Snowflake, Google Sheets, PostgreSQL, MySQL, and more—using standard SQL, all from within the New Relic UI. Users can combine, analyze, and correlate telemetry and non-telemetry (business) data using sophisticated cross-database JOINs without ingesting the external data, effectively breaking down organizational data silos.
Query your metadata on your uses stored in Snowflake:
SELECT userId, name, company FROM snowflake.users.user_metadata
Query New Relic data through Lens:
SELECT enduser.id FROM telemetry.PageView
Join your page view data with metadata from Snowflake to group the data by company
SELECT sf.company, COUNT(*)
FROM telemetry.PageView nr
JOIN snowflake.users.user_metadata sf ON nr.enduser.id = sf.userId
GROUP BY sf.company
Why Lens?
If you are an engineering leader, product manager, or IT Ops lead, this scenario probably sounds familiar: You want to tie system performance (like checkout latency) to business metrics (like shopping cart revenue), but that business data lives in a separate database like Snowflake.
Traditionally, integrating this data meant paying a "double tax" on ingestion: you paid once to store the data in your database, and you paid again to ingest it into your observability platform just to visualize it. Alternatively, you resorted to chaotic workarounds, manually exporting data into separate BI tools. New Relic Lens changes the game by querying the data exactly where it lives.
Example of Lens used to query APM telemetry and sales databases. Screenshot shows correlation and casual effect of system performance and revenue. One of many use cases for Lens.
Key Features & Capabilities
- Zero-Ingestion Connectors: Query external databases directly without duplicating or persistently storing raw data within New Relic. Seamlessly access data that includes Google Sheets, Iceberg, Snowflake, Postgres, MySQL, Redshift, Prometheus, MongoDB, ElasticSearch, AWS CloudWatch, ClickHouse, SQL Server, Databricks (Azure) with more being added.
- Cross-Database JOINs in SQL: Uniquely combine datasets from entirely different external databases into a single query and visualization widget. Write complex queries joining all of your data in standard SQL, going beyond traditional NRQL boundaries.
- Materialized Views: Accelerate dashboard performance and reduce external compute costs by storing precomputed query results in Iceberg-backed databases. This is especially effective for complex, high-volume datasets and results in only minimal data ingestion fees.
- Unified Data View: Embed external business metrics alongside Application, AI, and Infrastructure telemetry natively within Dashboards and the new New Relic Notebooks feature to gain immediate, actionable context.
- Ephemeral Caching for Security: Security is built-in. Data is queried on demand and only briefly cached—for about a minute—to render in the UI. We do not ingest, index, or store your raw business data in New Relic, except when you explicitly choose to use Materialized Views.
Transforming Your Workflows
New Relic Lens empowers you to perform deep analysis that previously took hours of manual correlation. Here is how it transforms your workflows:
- Align System Performance with Revenue: Compare New Relic infrastructure metrics directly with budget or revenue data stored in Snowflake, placing it all on the same dashboard to instantly see the financial impact of downtime or latency.
- Cross-Database Correlation: Track usage or incidents by combining data from disparate sources, such as correlating support tickets in Jira with infrastructure provisioning data natively inside New Relic.
- Optimize Dashboard Performance and Costs: Use Materialized Views for high-traffic executive dashboards to prevent repeated, expensive compute calls on your source database while ensuring visualizations load instantly.
Get Started Today
It's time to break down the barriers between your databases and analyze your aggregated data in a single, unified observability platform. Stop double ingesting and start saving.
New Relic Lens is available to all paid customers. By default, access is restricted to users with the 'organization_manager' role. Administrators can easily adjust these permissions or configure Fine-Grained Access (FGA) for connectors to grant access to other team members as needed.
이 블로그에 표현된 견해는 저자의 견해이며 반드시 New Relic의 견해를 반영하는 것은 아닙니다. 저자가 제공하는 모든 솔루션은 환경에 따라 다르며 New Relic에서 제공하는 상용 솔루션이나 지원의 일부가 아닙니다. 이 블로그 게시물과 관련된 질문 및 지원이 필요한 경우 Explorers Hub(support.newrelic.com)에서만 참여하십시오. 이 블로그에는 타사 사이트의 콘텐츠에 대한 링크가 포함될 수 있습니다. 이러한 링크를 제공함으로써 New Relic은 해당 사이트에서 사용할 수 있는 정보, 보기 또는 제품을 채택, 보증, 승인 또는 보증하지 않습니다.
