Netflix supports a vast array of devices, from smart TVs to gaming consoles and streaming sticks. Each device has different capabilities. Some support 4K, others only HD. Some support Spatial Audio, others do not. To ensure a high-quality experience for every user, Netflix must understand the specific hardware and software limitations of each device.
The Data Model
Netflix has invested heavily in a comprehensive device capability data model. The system integrates feature flags from internal systems to build a rich profile of each device. This data is stored in a cumulative table designed to efficiently capture the latest state of each device's capabilities, such as screen resolution, video profiles supported, and RAM size.
This structure supports both point-in-time queries and historical analysis. The goal is to provide a unified view of the device landscape, allowing engineers to answer questions like: "How many devices can support our new Spatial Audio feature?" or "What is the distribution of HEVC support among streaming sticks?
Aggregate Analytics with Histograms
For aggregate analytics and reporting, Netflix uses a histogram table. This table tracks active device counts over a rolling 28-day window. It breaks down the data by device model and software version. Most importantly, it records the number of devices supporting specific features.
This enables detailed distribution analysis. For example, analysts can determine that out of a total X number of devices, all support the HD profile (PlayReady), while only 20% support the UHD profile (HEVC).
Driving Innovation
This data-driven approach allows Netflix to make informed decisions about feature rollouts. By understanding the penetration of a feature, the company can identify bottlenecks and accelerate innovation.
Before rolling out a new codec or UI feature, Netflix can predict how many users will benefit. They can avoid enabling features that would degrade performance on older devices. This granular control ensures that the streaming experience is optimized for reliability and performance, regardless of the user's hardware.