Links

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}