USER_AGENT_PARSER

Parse the user agent and extract a parameter from it

Syntax

USER_AGENT_PARSER(attributes1[, attributes2, ..., attributesN], User Agent String)

Arguments

Name	Type	Description	Default Value
attributes#	useragentattribute	The attributes to extract
User Agent String	string	String representation of a user agent

Examples

attributes	User Agent String	Output
array['Matching Pattern', 'Rendering Engine Maker', 'Rendering Engine Description', 'Rendering Engine Version', 'Rendering Engine Name', 'Device Brand Name', 'Device Code Name', 'Device Pointing Method', 'Device Type', 'Device Maker', 'Device Name', 'Aol Version', 'Css Version', 'Is Modified', 'Is Anonymized', 'Is Fake', 'Crawler', 'Is SyndicationReader', 'Is Tablet', 'Is MobileDevice', 'ActiveX Controls', 'Java Applets', 'VBScript', 'JavaScript', 'BackgroundSounds', 'Cookies', 'Tables', 'IFrames', 'Frames', 'Win64', 'Win32', 'Win16', 'Beta', 'Alpha', 'Platform Maker', 'Platform Bits', 'Platform Description', 'Platform Version', 'Platform', 'Minor Version', 'Major Version', 'Version', 'Browser Modus', 'Browser Maker', 'Browser Bits', 'Browser Type', 'Browser', 'Comment', 'Parent', 'LiteMode', 'Master Parent']	'Mozilla/5.0 (Mac OS X 10?12) adbeat.com* Version* Safari*'	{Matching Pattern: Mozilla/5.0 (*Mac OS X 10?12*) adbeat.com* Version* Safari*, Rendering Engine Maker: Apple Inc, Rendering Engine Description: For Google Chrome, iOS (including both mobile Safari, WebViews within third-party apps, and web clips), Safari, Arora, Midori, OmniWeb, Shiira, iCab since version 4, Web, SRWare Iron, Rekonq, and in Maxthon 3., Rendering Engine Version: , Rendering Engine Name: `WebKit`, Device Brand Name: `Apple`, Device Code Name: `Macintosh`, Device Pointing Method: `mouse`, Device Type: `Desktop`, Device Maker: `Apple Inc`, Device Name: `Macintosh`, Aol Version: `0`, Css Version: `0`, Is Modified: `false`, Is Anonymized: `false`, Is Fake: `false`, Crawler: `true`, Is SyndicationReader: `false`, Is Tablet: `false`, Is MobileDevice: `false`, ActiveX Controls: `false`, Java Applets: `true`, VBScript: `false`, JavaScript: `false`, BackgroundSounds: `false`, Cookies: `false`, Tables: `false`, IFrames: `false`, Frames: `false`, Win64: `false`, Win32: `false`, Win16: `false`, Beta: `false`, Alpha: `false`, Platform Maker: `Apple Inc`, Platform Bits: `32`, Platform Description: `macOS`, Platform Version: `10.12`, Platform: `macOS`, Minor Version: `0`, Major Version: `0`, Version: `0.0`, Browser Modus: , Browser Maker: adbeat.com, Browser Bits: 32, Browser Type: Bot/Crawler, Browser: Adbeat Bot, Comment: Adbeat, Parent: Adbeat, LiteMode: false, Master Parent: false}

Transformation job example

SQL

CREATE JOB function_operator_example
    ADD_MISSING_COLUMNS = true
    AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data MAP_COLUMNS_BY_NAME
    SELECT attributes[], User Agent String,
        USER_AGENT_PARSER(array['Matching Pattern', 'Rendering Engine Maker', 'Rendering Engine Description', 'Rendering Engine Version', 'Rendering Engine Name', 'Device Brand Name', 'Device Code Name', 'Device Pointing Method', 'Device Type', 'Device Maker', 'Device Name', 'Aol Version', 'Css Version', 'Is Modified', 'Is Anonymized', 'Is Fake', 'Crawler', 'Is SyndicationReader', 'Is Tablet', 'Is MobileDevice', 'ActiveX Controls', 'Java Applets', 'VBScript', 'JavaScript', 'BackgroundSounds', 'Cookies', 'Tables', 'IFrames', 'Frames', 'Win64', 'Win32', 'Win16', 'Beta', 'Alpha', 'Platform Maker', 'Platform Bits', 'Platform Description', 'Platform Version', 'Platform', 'Minor Version', 'Major Version', 'Version', 'Browser Modus', 'Browser Maker', 'Browser Bits', 'Browser Type', 'Browser', 'Comment', 'Parent', 'LiteMode', 'Master Parent'], User Agent String) AS Output
    FROM default_glue_catalog.upsolver_samples.orders_raw_data
    LET attributes = array['Matching Pattern', 'Rendering Engine Maker', 'Rendering Engine Description', 'Rendering Engine Version', 'Rendering Engine Name', 'Device Brand Name', 'Device Code Name', 'Device Pointing Method', 'Device Type', 'Device Maker', 'Device Name', 'Aol Version', 'Css Version', 'Is Modified', 'Is Anonymized', 'Is Fake', 'Crawler', 'Is SyndicationReader', 'Is Tablet', 'Is MobileDevice', 'ActiveX Controls', 'Java Applets', 'VBScript', 'JavaScript', 'BackgroundSounds', 'Cookies', 'Tables', 'IFrames', 'Frames', 'Win64', 'Win32', 'Win16', 'Beta', 'Alpha', 'Platform Maker', 'Platform Bits', 'Platform Description', 'Platform Version', 'Platform', 'Minor Version', 'Major Version', 'Version', 'Browser Modus', 'Browser Maker', 'Browser Bits', 'Browser Type', 'Browser', 'Comment', 'Parent', 'LiteMode', 'Master Parent'],
        User Agent String = 'Mozilla/5.0 (*Mac OS X 10?12*) adbeat.com* Version* Safari*'
    WHERE time_filter()
    LIMIT 1;

Query result

attributes[]	User Agent String	Output
array['Matching Pattern', 'Rendering Engine Maker', 'Rendering Engine Description', 'Rendering Engine Version', 'Rendering Engine Name', 'Device Brand Name', 'Device Code Name', 'Device Pointing Method', 'Device Type', 'Device Maker', 'Device Name', 'Aol Version', 'Css Version', 'Is Modified', 'Is Anonymized', 'Is Fake', 'Crawler', 'Is SyndicationReader', 'Is Tablet', 'Is MobileDevice', 'ActiveX Controls', 'Java Applets', 'VBScript', 'JavaScript', 'BackgroundSounds', 'Cookies', 'Tables', 'IFrames', 'Frames', 'Win64', 'Win32', 'Win16', 'Beta', 'Alpha', 'Platform Maker', 'Platform Bits', 'Platform Description', 'Platform Version', 'Platform', 'Minor Version', 'Major Version', 'Version', 'Browser Modus', 'Browser Maker', 'Browser Bits', 'Browser Type', 'Browser', 'Comment', 'Parent', 'LiteMode', 'Master Parent']	'Mozilla/5.0 (Mac OS X 10?12) adbeat.com* Version* Safari*'	{Matching Pattern: Mozilla/5.0 (*Mac OS X 10?12*) adbeat.com* Version* Safari*, Rendering Engine Maker: Apple Inc, Rendering Engine Description: For Google Chrome, iOS (including both mobile Safari, WebViews within third-party apps, and web clips), Safari, Arora, Midori, OmniWeb, Shiira, iCab since version 4, Web, SRWare Iron, Rekonq, and in Maxthon 3., Rendering Engine Version: , Rendering Engine Name: `WebKit`, Device Brand Name: `Apple`, Device Code Name: `Macintosh`, Device Pointing Method: `mouse`, Device Type: `Desktop`, Device Maker: `Apple Inc`, Device Name: `Macintosh`, Aol Version: `0`, Css Version: `0`, Is Modified: `false`, Is Anonymized: `false`, Is Fake: `false`, Crawler: `true`, Is SyndicationReader: `false`, Is Tablet: `false`, Is MobileDevice: `false`, ActiveX Controls: `false`, Java Applets: `true`, VBScript: `false`, JavaScript: `false`, BackgroundSounds: `false`, Cookies: `false`, Tables: `false`, IFrames: `false`, Frames: `false`, Win64: `false`, Win32: `false`, Win16: `false`, Beta: `false`, Alpha: `false`, Platform Maker: `Apple Inc`, Platform Bits: `32`, Platform Description: `macOS`, Platform Version: `10.12`, Platform: `macOS`, Minor Version: `0`, Major Version: `0`, Version: `0.0`, Browser Modus: , Browser Maker: adbeat.com, Browser Bits: 32, Browser Type: Bot/Crawler, Browser: Adbeat Bot, Comment: Adbeat, Parent: Adbeat, LiteMode: false, Master Parent: false}