USER_AGENT_PARSER
Parse the user agent and extract a parameter from it
USER_AGENT_PARSER(attributes1[, attributes2, ..., attributesN], User Agent String)
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 } |
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;
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 } |
Last modified 28d ago