Export New Relic to CSV
Overview
Welcome to our comprehensive guide on how to export your New Relic logs to a CSV file—an essential process for data analysis and archival purposes. Whether you're looking to create backups, conduct detailed analysis in spreadsheet programs, or share data with team members who prefer a more traditional data format, exporting to CSV offers unmatched simplicity and flexibility. On this page, we'll explore the ins and outs of New Relic, provide a step-by-step tutorial on exporting to CSV, discuss various use cases for your exported data, introduce SigNoz as a formidable alternative for CSV exports using Sourcetable, and address common questions you might have about the process.
What is New Relic?
New Relic is an observability tool that offers engineers a comprehensive suite of services to monitor, debug, and improve their entire engineering stack. As a data-focused platform, it enables a data-driven approach for engineering teams to refine their systems efficiently. Recognized as the first APM designed for AI, New Relic facilitates the monitoring of the entire AI stack, ensuring that engineers can manage and improve their AI applications effectively.
With over 30 capabilities, New Relic's versatility extends to full stack monitoring—including the front end, back end, infrastructure, vulnerabilities, and logs—along with specialized AI capabilities. The tool is designed to provide a complete picture of an engineer's system, enhancing collaboration and allowing for a streamlined workflow. Its transparent, predictable, and flexible pricing model offers more value by charging only for the data and users, not the tools, ensuring that costs are aligned with usage.
New Relic's generous free tier, which requires no credit card, along with its extensive library of over 700 integrations, including popular languages and frameworks such as Java, Node.js, .NET, PHP, MySQL, Python, and more, makes it accessible and practical for engineers across various domains. Moreover, New Relic is trusted by companies like Tokopedia and HealthifyMe for achieving end-to-end observability and scaling systems efficiently, and by World Fuel Services for its cost-effective pricing strategy.
On the security front, New Relic is committed to maintaining high standards with enterprise-level security measures. It complies with GDPR, is A–LIGN 27001 certified, SOC2 Type II verified, and FEDRAMP compliant, ensuring that user data is handled with the utmost care and in accordance with stringent regulations.
Exporting Logs to CSV in New Relic
Using Logs UI for Standard Export
New Relic has introduced a feature that allows you to export logs directly from the Logs UI. This feature, made available on August 11, 2023, provides the flexibility to export logs in either JSON or CSV formats. To perform a standard export to CSV, navigate to the Logs UI and select the CSV format when exporting. It is important to note that there is a limit to the number of logs that can be exported in a single operation.
Expanding Export Capabilities with Data Plus
To export a volume of logs beyond the standard limit, you can utilize the Data Plus offering. Data Plus enhances your exporting capabilities by allowing for both Streaming Export and Historical Export. This means you can choose to export logs in real time (Streaming Export) or access and export logs from the past (Historical Export), suiting different requirements such as deeper data exploration or compliance needs. To use these features, you must first subscribe to Data Plus, after which you can export additional logs through the same Logs UI, selecting CSV as the export format.
Streamline Your Data Management with Sourcetable
Forget the cumbersome process of exporting New Relic data to a CSV file only to import it into another spreadsheet program. Sourcetable enhances your workflow by directly synchronizing with your live data from New Relic, offering a seamless and efficient way to manage your data in real-time. By eliminating the traditional export-import cycle, Sourcetable saves you precious time and reduces the risk of errors that can occur when handling data across different platforms.
Sourcetable's intuitive spreadsheet interface allows you to effortlessly pull in data from New Relic, alongside other apps and databases, without the need for complex integration tools. This centralized approach not only streamlines your data analysis but also empowers you with advanced automation capabilities, making it an indispensable tool for business intelligence. Embrace the simplicity and power of Sourcetable for an optimized data management experience.
Common Use Cases
-
Analyzing exported logs in a spreadsheet programN
-
Creating backups of dashboard data for offline accessN
-
Performing custom data analysis using external toolsN
-
Sharing chart data with team members who do not have New Relic accessN
-
Generating reports to comply with security and compliance requirementsN
Frequently Asked Questions
How do I export a chart as a CSV in New Relic?
To export a chart as a CSV, click the dropdown in the top right of the chart and select 'Export as CSV' from the dropdown menu.
Are there any limitations when exporting a chart as a CSV from New Relic?
Yes, exporting a chart as a CSV has limitations such as always exporting in UTC time (-7:00), and it does not support aggregator functions like average() or the COMPARE_WITH clause.
Can I export New Relic logs in formats other than CSV?
The new export feature allows you to download logs in either JSON or CSV format.
Is there a limit to how much data I can export using New Relic’s export feature?
Yes, the export feature has an export limit. However, you can use the Data Plus offering to export more than the export limit allows.
What time zone is used when exporting CSVs from New Relic?
CSV exports are in UTC time (-7:00).
Conclusion
New Relic provides flexible options for exporting your logs, offering both CSV and JSON formats to suit your data analysis needs. You can easily export dashboards or individual charts to CSV, keeping in mind the limitations such as UTC time format, and the exclusion of aggregator functions and COMPARE_WITH clause. Should your export needs exceed the log limit, New Relic's Data Plus comes to the rescue with its Streaming Export and Historical Export features, ensuring you have access to the comprehensive data you require. However, if you're looking for a more streamlined process, consider using Sourcetable to import your data directly into a spreadsheet. Sign up for Sourcetable to simplify your data management and get started with a more efficient workflow.
