Unflattening JSON data with New Relic Flex
Blog post from New Relic
The blog post by Leon Adato, a developer relations advocate at New Relic, discusses the challenges and solutions related to handling JSON data output from the Pi-hole DNS platform. The article highlights the common issue where data meant to be recorded in sequential rows often ends up spread across multiple fields, leading to variability and complexity in data analysis. Adato showcases the use of the jq utility to transform this data into a more organized format suitable for querying and display in New Relic, particularly for metrics such as top domains and advertisers, top DNS query sources, and query types. The post emphasizes the flexibility of New Relic's platform in not only collecting telemetry but also transforming it into actionable insights, and encourages readers to explore these capabilities by providing a complete YAML file example for integration. Additionally, it invites developers to improve their data handling processes by leveraging these tools and offers a free New Relic account for hands-on experience.