ETL: DeviceFamily

Extract the device family name (iPhone, iPad, Galaxy) from a user agent string using ua_parser. Use for device analytics in ETL data pipelines.

Description

Extract device family (device name) from user agent string, based on ua_parser.

Syntax

DeviceFamily(user_agent_string)

Examples

DeviceFamily('Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; Crebergallery spider robot)') returns ‘Spider’

Return value datatype

string

Notes

Returns ‘Other’ if its device family and version can’t be extracted from string.

Impact of null value

If input is null, returns null.