Schema Info
Schema Name: sfdl_prod_segment.sfdc_product_list_viewed
- created: 2017-11-02 13:19:40
- disabled: False
- format: raw
- id: 98
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "sfdc_product_list_viewed" } - type: segment
Schema Versions: 1
-
Version 29676
- created: 2018-05-14 15:02:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_product_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_product_list_viewed`\n(\n `version` string , `timestamp` string , `projectId` string , `userId` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `site_id` : string , `search_id` : string , `products`:array, `list_id` : string , `page` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array , `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `messageId` string , `_origin` string , `type` string , `event` string , `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed'\n", "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_product_list_viewed" ] - hive_path: s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed
- id: 29676
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Segment.io" ], "unbundled": [] }, "_origin": "2018-05-14T20:02:28Z|s3://sfdl-segment-sfdc-prod/segment-logs/SgsnnfL86n/1526256000000/1526328071000.e5c332ac088d.1.11.1.3821488f-9ef9-4e95-bbe4-f0a9ac99479b.gz|segment_separator:37", "anonymousId": "b2a68fb0-00a9-4205-9532-c9fc9a87f6e2", "channel": "client", "context": { "ip": "107.77.211.47", "library": { "name": "analytics.js", "version": "3.6.0" }, "page": { "path": "/Gresham-OR-self-storage.html", "referrer": "", "search": "", "title": "Self Storage E Powell Blvd Gresham OR: $20 Off | SpareFoot", "url": "https://www.sparefoot.com/Gresham-OR-self-storage.html" }, "userAgent": "Mozilla/5.0 (Linux; Android 7.0; SAMSUNG SM-G930A Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/6.4 Chrome/56.0.2924.87 Mobile Safari/537.36" }, "event": "Product List Viewed", "integrations": {}, "messageId": "ajs-292cb2926de3728a377f2fdcce581160", "originalTimestamp": "2018-05-14T19:52:01.868Z", "projectId": "SgsnnfL86n", "properties": { "Hit Timestamp": 1526327521860, "category": "Gresham, Oregon", "list_id": "search results: E-Powell-Blvd-storage-facility, Gresham, OR", "page": 1, "products": [ { "id": 205000, "inNetwork": true, "name": "Extra Space Storage - Portland - NE Columbia Blvd", "position": 1, "rank": 1, "reviewAverage": 4.778, "reviewCount": 9, "unitCount": 13, "units": [ { "amenitiesList": "", "id": 19299322, "maxBookingDate": 1528881334, "priceValue": 66, "promotion": "First Month Free", "regularPriceValue": 78, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 19299309, "maxBookingDate": 1528881334, "priceValue": 109, "promotion": "First Month Free", "regularPriceValue": 128, "sizeText": "10' x 5'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 19299311, "maxBookingDate": 1528881334, "priceValue": 132, "promotion": "First Month Free", "regularPriceValue": 155, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 206023, "inNetwork": true, "name": "Extra Space Storage - Portland - NE 72nd Ave", "position": 2, "rank": 2, "reviewAverage": 0, "reviewCount": 0, "unitCount": 7, "units": [ { "amenitiesList": "", "id": 19610567, "maxBookingDate": 1527498922, "priceValue": 77, "promotion": "First Month Half Off", "regularPriceValue": 90, "sizeText": "5' x 8'", "squareFootage": 40, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 19511351, "maxBookingDate": 1527498922, "priceValue": 99, "promotion": "First Month Half Off", "regularPriceValue": 117, "sizeText": "10' x 7'", "squareFootage": 70, "unitTypeText": "unit" } ] }, { "id": 157172, "inNetwork": true, "name": "162nd Avenue Additional Self Storage", "position": 3, "rank": 3, "reviewAverage": 4.538, "reviewCount": 26, "unitCount": 8, "units": [ { "amenitiesList": "Climate Controlled, Roll Up Door", "id": 16988925, "maxBookingDate": 1526462266, "priceValue": 72, "promotion": "Just Have Boxes? Check Out this Unit", "regularPriceValue": 72, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "Roll Up Door", "id": 16989516, "maxBookingDate": 1526462266, "priceValue": 99, "promotion": "2 Months @50% OFF", "regularPriceValue": 99, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "Climate Controlled, Roll Up Door", "id": 16990522, "maxBookingDate": 1526462266, "priceValue": 163, "promotion": "2 Months @50% OFF", "regularPriceValue": 163, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 69839, "inNetwork": true, "name": "Iron Guard Storage - Camas", "position": 4, "rank": 4, "reviewAverage": 4.8, "reviewCount": 5, "unitCount": 9, "units": [ { "amenitiesList": "", "id": 15088393, "maxBookingDate": 1526894354, "priceValue": 154, "promotion": "$10 off first month's rent.", "regularPriceValue": 154, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 106503, "inNetwork": true, "name": "Money Saver South Gresham", "position": 5, "rank": 5, "reviewAverage": 4.472, "reviewCount": 18, "unitCount": 6, "units": [ { "amenitiesList": "", "id": 13741063, "maxBookingDate": 1528103936, "priceValue": 68, "promotion": "Use our Moving Truck for Free with New Rental", "regularPriceValue": 68, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 13740663, "maxBookingDate": 1528103936, "priceValue": 90, "promotion": "Use our Moving Truck for Free with New Rental", "regularPriceValue": 90, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 13730230, "maxBookingDate": 1528103936, "priceValue": 145, "promotion": "Use our Moving Truck for Free with New Rental", "regularPriceValue": 145, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 106504, "inNetwork": true, "name": "Money Saver Gresham", "position": 6, "rank": 6, "reviewAverage": 4.238, "reviewCount": 21, "unitCount": 9, "units": [ { "amenitiesList": "", "id": 13747519, "maxBookingDate": 1528103936, "priceValue": 105, "promotion": "Use our Moving Truck for Free with New Rental", "regularPriceValue": 105, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 13742377, "maxBookingDate": 1528103936, "priceValue": 150, "promotion": "Use our Moving Truck for Free with New Rental", "regularPriceValue": 150, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 157173, "inNetwork": true, "name": "Burton Road East Additional Self Storage", "position": 7, "rank": 7, "reviewAverage": 4.421, "reviewCount": 19, "unitCount": 5, "units": [ { "amenitiesList": "Climate Controlled, Swing Door", "id": 16988777, "maxBookingDate": 1526894266, "priceValue": 68, "promotion": "50% OFF First Two Full Months", "regularPriceValue": 68, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "Climate Controlled, Swing Door", "id": 16989129, "maxBookingDate": 1526462266, "priceValue": 112, "promotion": "50% OFF First Two Full Months", "regularPriceValue": 112, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" } ] }, { "id": 157174, "inNetwork": true, "name": "Burton Road West Additional Self Storage", "position": 8, "rank": 8, "reviewAverage": 4.227, "reviewCount": 11, "unitCount": 6, "units": [ { "amenitiesList": "Roll Up Door", "id": 16988724, "maxBookingDate": 1526462266, "priceValue": 97, "promotion": "", "regularPriceValue": 97, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" } ] }, { "id": 200328, "inNetwork": true, "name": "Broadway Storage PDX", "position": 9, "rank": 9, "reviewAverage": 4.817, "reviewCount": 30, "unitCount": 10, "units": [ { "amenitiesList": "Climate Controlled, Roll Up Door", "id": 18038333, "maxBookingDate": 1528881415, "priceValue": 150, "promotion": "The second full month free", "regularPriceValue": 150, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 104882, "inNetwork": true, "name": "Wood Village Stow-A-Way", "position": 10, "rank": 10, "reviewAverage": 3.938, "reviewCount": 8, "unitCount": 1, "units": [ { "amenitiesList": "Drive Up Access, Roll Up Door", "id": 9899608, "maxBookingDate": 1531473541, "priceValue": 85, "promotion": "", "regularPriceValue": 85, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" } ] }, { "id": 106525, "inNetwork": true, "name": "Money Saver Johnson Creek", "position": 11, "rank": 11, "reviewAverage": 4.231, "reviewCount": 52, "unitCount": 21, "units": [ { "amenitiesList": "", "id": 13747512, "maxBookingDate": 1528103936, "priceValue": 78, "promotion": "FREE Use of Move In Truck with Rental", "regularPriceValue": 78, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 13743468, "maxBookingDate": 1528103936, "priceValue": 94, "promotion": "FREE Use of Move In Truck with Rental", "regularPriceValue": 94, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 13734990, "maxBookingDate": 1528103936, "priceValue": 175, "promotion": "ONE MONTH FREE RENT! Pay 1st full month's rent and get your 2nd month FREE!", "regularPriceValue": 175, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 109491, "inNetwork": true, "name": "Fort Knox Mini-Storage", "position": 12, "rank": 12, "reviewAverage": 4.418, "reviewCount": 55, "unitCount": 40, "units": [ { "amenitiesList": "", "id": 9744790, "maxBookingDate": 1527499120, "priceValue": 75, "promotion": "The first three full months free", "regularPriceValue": 75, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 9744792, "maxBookingDate": 1527499120, "priceValue": 99, "promotion": "The first three full months free", "regularPriceValue": 99, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 9744795, "maxBookingDate": 1527499120, "priceValue": 165, "promotion": "The first three full months free", "regularPriceValue": 165, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 150175, "inNetwork": true, "name": "Central Self Storage - Portland", "position": 13, "rank": 13, "reviewAverage": 4.573, "reviewCount": 55, "unitCount": 16, "units": [ { "amenitiesList": "", "id": 15993003, "maxBookingDate": 1526894307, "priceValue": 83, "promotion": "Military Waived Admin Fee", "regularPriceValue": 83, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 15994796, "maxBookingDate": 1526894307, "priceValue": 96, "promotion": "Military Waived Admin Fee", "regularPriceValue": 96, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "", "id": 16012726, "maxBookingDate": 1527499107, "priceValue": 169, "promotion": "First Month Free", "regularPriceValue": 169, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 157175, "inNetwork": true, "name": "503 Additional Self Storage", "position": 14, "rank": 14, "reviewAverage": 4.469, "reviewCount": 48, "unitCount": 3, "units": [ { "amenitiesList": "Roll Up Door", "id": 18325616, "maxBookingDate": 1526721466, "priceValue": 145, "promotion": "50% Off Three Months", "regularPriceValue": 145, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] }, { "id": 157171, "inNetwork": true, "name": "Hearthwood Additional Self Storage", "position": 15, "rank": 15, "reviewAverage": 4.342, "reviewCount": 19, "unitCount": 6, "units": [ { "amenitiesList": "Roll Up Door", "id": 16988702, "maxBookingDate": 1526894266, "priceValue": 72, "promotion": "NEED A PLACE FOR SMALL BOXES AND FURNITURE ! CHECK OUT THESE UNIT.", "regularPriceValue": 72, "sizeText": "5' x 5'", "squareFootage": 25, "unitTypeText": "unit" }, { "amenitiesList": "Roll Up Door", "id": 16988903, "maxBookingDate": 1526894266, "priceValue": 105, "promotion": "NEED A PLACE FOR SMALL BOXES AND FURNITURE ! CHECK OUT THESE UNIT.", "regularPriceValue": 105, "sizeText": "5' x 10'", "squareFootage": 50, "unitTypeText": "unit" }, { "amenitiesList": "Roll Up Door", "id": 16989817, "maxBookingDate": 1526894266, "priceValue": 149, "promotion": "", "regularPriceValue": 149, "sizeText": "10' x 10'", "squareFootage": 100, "unitTypeText": "unit" } ] } ], "search_id": "5af9e8e488d0e", "site_id": "59" }, "receivedAt": "2018-05-14T19:52:08.052Z", "sentAt": "2018-05-14T19:52:01.892Z", "timestamp": "2018-05-14T19:52:08.028Z", "type": "track", "userId": "0e8420acb60e722963fcfed6a5b88364", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.list_id": "string", "properties.page": "string", "properties.products": "", "properties.search_id": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 98
- schema_scan_id: 11694067
- updated: 2018-06-07 19:06:00
Schema Scans: 1
Last at 2018-05-14 15:02:36
-
Scan 11694067
- duration: 0:02:34.818568
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 428, "partitions_applied": false, "success": true } - id: 11694067
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-05-14/", "name": "dt", "type": "string", "value": "2018-05-14" }, "s3": { "bucket": "sfdl-segment-sfdc-prod", "hive_path": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed", "key": "separated_dt/Product List Viewed/dt=2018-05-14/1526328071000.e5c332ac088d.1.11.1.3821488f-9ef9-4e95-bbe4-f0a9ac99479b.json.gz" }, "schema": { "name": "sfdl_prod_segment.sfdc_Product_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 98
- start_time: 2018-05-14 15:02:36
- success: True
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.sfdc_product_list_viewed`\nADD\n\n\n PARTITION (dt='2018-07-30') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-07-30/'\n PARTITION (dt='2018-08-02') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-02/'\n PARTITION (dt='2018-08-16') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-16/'\n;" ] - name: dt
- state:
[ { "info": { "id": 363917, "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-07-30/", "name": "dt", "value": "2018-07-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-07-30 18:22:48", "last_data": "2018-07-30 19:03:37" }, "parquet": { "first_performed": "2018-07-30 18:28:35", "in_progress": null, "job_id": null, "last_performed": "2018-07-30 19:06:00", "queued": false } } }, { "info": { "id": 365012, "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-02/", "name": "dt", "value": "2018-08-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-08-02 17:23:02", "last_data": "2018-08-02 17:23:02" }, "parquet": { "first_performed": "2018-08-02 17:25:53", "in_progress": null, "job_id": null, "last_performed": "2018-08-02 17:25:53", "queued": false } } }, { "info": { "id": 366423, "location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-16/", "name": "dt", "value": "2018-08-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2018-08-16 11:03:12", "last_data": "2018-08-16 11:03:12" }, "parquet": { "first_performed": "2018-08-16 11:03:57", "in_progress": null, "job_id": null, "last_performed": "2018-08-16 11:03:57", "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.list_id": "string", "properties.page": "string", "properties.products": "", "properties.search_id": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2018-05-14 15:02:36
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_product_list_viewed`\n(\n `version` string , `timestamp` string , `projectId` string , `userId` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `site_id` : string , `search_id` : string , `products`:array, `list_id` : string , `page` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array , `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `messageId` string , `_origin` string , `type` string , `event` string , `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_product_list_viewed`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_product_list_viewed" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2017-11-02 13:19:40",
"disabled": false,
"format": "raw",
"id": 98,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "sfdc_product_list_viewed"
},
"type": "segment"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.sfdc_product_list_viewed`\nADD\n\n\n PARTITION (dt='2018-07-30') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-07-30/'\n PARTITION (dt='2018-08-02') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-02/'\n PARTITION (dt='2018-08-16') location 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-16/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 363917,
"location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-07-30/",
"name": "dt",
"value": "2018-07-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-07-30 18:22:48",
"last_data": "2018-07-30 19:03:37"
},
"parquet": {
"first_performed": "2018-07-30 18:28:35",
"in_progress": null,
"job_id": null,
"last_performed": "2018-07-30 19:06:00",
"queued": false
}
}
},
{
"info": {
"id": 365012,
"location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-02/",
"name": "dt",
"value": "2018-08-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-08-02 17:23:02",
"last_data": "2018-08-02 17:23:02"
},
"parquet": {
"first_performed": "2018-08-02 17:25:53",
"in_progress": null,
"job_id": null,
"last_performed": "2018-08-02 17:25:53",
"queued": false
}
}
},
{
"info": {
"id": 366423,
"location": "s3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed/dt=2018-08-16/",
"name": "dt",
"value": "2018-08-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2018-08-16 11:03:12",
"last_data": "2018-08-16 11:03:12"
},
"parquet": {
"first_performed": "2018-08-16 11:03:57",
"in_progress": null,
"job_id": null,
"last_performed": "2018-08-16 11:03:57",
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.category": "string",
"properties.list_id": "string",
"properties.page": "string",
"properties.products": "",
"properties.search_id": "string",
"properties.site_id": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2018-05-14 15:02:36",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.sfdc_product_list_viewed`\n(\n `version` string , `timestamp` string , `projectId` string , `userId` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `site_id` : string , `search_id` : string , `products`:array , `list_id` : string , `page` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array , `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `ip` : string >, `messageId` string , `_origin` string , `type` string , `event` string , `channel` string , `sentAt` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-sfdc-prod/separated_dt/Product List Viewed'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.sfdc_product_list_viewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.sfdc_product_list_viewed"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}