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}

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

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`}

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`}

GEO_IP

Spatial functions

Last modified 28d ago