Schema Info
Schema Name: sfdl_dev_segment.ssdc_nearby_facilities_list_viewed
- created: 2020-03-25 12:05:07
- disabled: False
- format: raw
- id: 1466
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_segment", "table": "ssdc_nearby_facilities_list_viewed" } - type: segment
Schema Versions: 15
-
Version 4681951
- created: 2020-08-21 15:35:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681951
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-21T20:35:15Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597968000000/1598041945320.dba5e5cc232b.baa71ec.42d1739a-6cbe-4e1b-9519-4371ed21fb5e.gz|segment_separator:34", "anonymousId": "11687bbb-2c38-4b6a-8707-e6f2c4909ee3", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/", "referrer": "http://localhost:9116/self-storage/new-york/new-york/car-storage", "search": "", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-4298ea581bf87161085e95eb1f289835", "originalTimestamp": "2020-08-21T20:04:02.539Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1598040242538, "category": "nearby facilities list", "env": "development", "facilitiesInTray": [ 157056, 153768, 155484 ], "isReact": true, "label": "nearby facilities list open", "searchId": "3be75f401a3333d123.79585627", "site_id": 27 }, "receivedAt": "2020-08-21T20:04:02.709Z", "sentAt": "2020-08-21T20:04:02.542Z", "timestamp": "2020-08-21T20:04:02.706Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5673664
- updated: 2020-08-21 15:35:35
-
Version 4681950
- created: 2020-08-21 15:33:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681950
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-21T20:33:31Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597968000000/1598041900527.2945ff8f51a7.baa71ec.a330e120-f5f2-4c07-bea7-f8b3ca11ff16.gz|segment_separator:34", "anonymousId": "11687bbb-2c38-4b6a-8707-e6f2c4909ee3", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/", "referrer": "http://localhost:9116/self-storage/new-york/new-york/car-storage", "search": "", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-2ec84ee1ef6f3a177c37657ce83ad1d1", "originalTimestamp": "2020-08-21T20:05:32.290Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1598040332289, "category": "nearby facilities list", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "176e5f402902e9fb12.19654253", "site_id": 27 }, "receivedAt": "2020-08-21T20:05:32.449Z", "sentAt": "2020-08-21T20:05:32.293Z", "timestamp": "2020-08-21T20:05:32.446Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5673651
- updated: 2020-08-21 15:34:09
-
Version 4681915
- created: 2020-08-20 16:38:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681915
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T21:37:37Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597959165474.0d3aa5cd95d0.baa71ec.171e5766-d101-42b6-9108-bdb246cb2fa4.gz|segment_separator:34", "anonymousId": "11687bbb-2c38-4b6a-8707-e6f2c4909ee3", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "", "title": "20 Best Austin, TX Self-Storage Units | $1 First Month Rent", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-4ee4d7c2437f2a4650a4aa3e2704f01e", "originalTimestamp": "2020-08-20T20:39:35.195Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597955975191, "category": "nearby facilities list-cityLandingPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "52575f3ede8da94aa0.68611446", "site_id": 27 }, "receivedAt": "2020-08-20T20:39:35.382Z", "sentAt": "2020-08-20T20:39:35.200Z", "timestamp": "2020-08-20T20:39:35.377Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5672606
- updated: 2020-08-20 16:38:28
-
Version 4681914
- created: 2020-08-20 16:37:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681914
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T21:37:15Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597959132953.1443184baef8.baa71ec.319fecbb-a1ae-45d3-a44d-8179229916a0.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?location=Austin%2C%20TX%2C%20USA&page=1&sftest=on&sort=yielddistancelowltveconmir100forced", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?location=Austin%2C%20TX%2C%20USA&page=1&sftest=on&sort=yielddistancelowltveconmir100forced" }, "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-5ac2be943e814f0f848730cabedfaa5a", "originalTimestamp": "2020-08-20T21:18:31.142Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597958310246, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "90115f3ee8a200e803.54091203", "site_id": 27 }, "receivedAt": "2020-08-20T21:18:31.284Z", "sentAt": "2020-08-20T21:18:31.144Z", "timestamp": "2020-08-20T21:18:31.282Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5672599
- updated: 2020-08-20 16:38:07
-
Version 4681913
- created: 2020-08-20 12:44:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681913
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T17:42:58Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597944770283.53652990185e.baa71ec.65ec9ecd-4525-464a-a8bc-11283c5cea94.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?location=Austin%2C%20TX%2C%20USA&page=1&sftest=on&sort=yielddistancelowltveconmir100forced", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?location=Austin%2C%20TX%2C%20USA&page=1&sftest=on&sort=yielddistancelowltveconmir100forced" }, "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-03bfba3c1dafff0213ece0275886a2fc", "originalTimestamp": "2020-08-20T16:36:43.778Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597941402999, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "b7b45f3ea69748e8c0.85558998", "site_id": 27 }, "receivedAt": "2020-08-20T16:36:43.931Z", "sentAt": "2020-08-20T16:36:43.780Z", "timestamp": "2020-08-20T16:36:43.929Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5672224
- updated: 2020-08-20 12:44:17
-
Version 4681912
- created: 2020-08-20 12:42:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681912
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T17:41:42Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597944762267.1443184baef8.baa71ec.336476ac-4019-44d7-b11a-85f3ae0109aa.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?location=Austin%2C%20TX%2C%20USA&page=1&sftest=on&sort=yielddistancelowltveconmir100forced", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?location=Austin%2C%20TX%2C%20USA&page=1&sftest=on&sort=yielddistancelowltveconmir100forced" }, "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-675f33da58574ae728e5e92d2e5762a7", "originalTimestamp": "2020-08-20T16:49:25.313Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597942164802, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "c7c45f3ea9918a1a10.63829904", "site_id": 27 }, "receivedAt": "2020-08-20T16:49:25.464Z", "sentAt": "2020-08-20T16:49:25.315Z", "timestamp": "2020-08-20T16:49:25.462Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5672212
- updated: 2020-08-20 12:42:47
-
Version 4681911
- created: 2020-08-20 11:42:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681911
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T16:42:08Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597941159323.3f38069ae695.baa71ec.228ee393-0500-4490-a4d4-0596f257586f.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-ad6bf51394ca66b9b483bb5f3acbe4fe", "originalTimestamp": "2020-08-20T16:02:14.480Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597939334478, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "90605f3e9e80d46d49.64343702", "site_id": 27 }, "receivedAt": "2020-08-20T16:02:14.655Z", "sentAt": "2020-08-20T16:02:14.482Z", "timestamp": "2020-08-20T16:02:14.653Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5672056
- updated: 2020-08-20 11:42:56
-
Version 4681910
- created: 2020-08-20 11:42:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681910
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T16:42:03Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597941157732.2945ff8f51a7.baa71ec.13fcb643-c9ab-4cf5-b030-4687d3c3fcec.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-e016df912222f2d31d266cb41f87f13e", "originalTimestamp": "2020-08-20T16:01:23.423Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597939282370, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "d9535f3e9e4e98f958.41817216", "site_id": 27 }, "receivedAt": "2020-08-20T16:01:23.608Z", "sentAt": "2020-08-20T16:01:23.425Z", "timestamp": "2020-08-20T16:01:23.606Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5672053
- updated: 2020-08-20 11:42:36
-
Version 4681909
- created: 2020-08-20 11:37:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681909
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T16:37:01Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597941185796.dba5e5cc232b.baa71ec.ac16dce8-3709-4239-a066-494c1f84faf1.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-24b0cc1d73414429fe387eeaa368a8a2", "originalTimestamp": "2020-08-20T16:02:10.522Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597939330520, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "f8205f3e9e679b66a7.54232392", "site_id": 27 }, "receivedAt": "2020-08-20T16:02:10.687Z", "sentAt": "2020-08-20T16:02:10.524Z", "timestamp": "2020-08-20T16:02:10.685Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671994
- updated: 2020-08-20 11:37:38
-
Version 4681908
- created: 2020-08-20 11:36:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681908
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T16:36:24Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597941186846.59448da486ed.baa71ec.e2ff3897-d75f-4a9a-bbe6-042d90dfdd4c.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-aab9acec8cb6c9cd0124421060b93b4d", "originalTimestamp": "2020-08-20T16:09:33.294Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597939772371, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "1cad5f3ea0394f4813.03983605", "site_id": 27 }, "receivedAt": "2020-08-20T16:09:33.474Z", "sentAt": "2020-08-20T16:09:33.296Z", "timestamp": "2020-08-20T16:09:33.472Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671988
- updated: 2020-08-20 11:37:18
-
Version 4681907
- created: 2020-08-20 11:34:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681907
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T16:34:14Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597941111310.53652990185e.baa71ec.36c782ff-4167-4b08-b217-cd6fc6454e33.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-1050507d4ce9049425cca2567d04f6e0", "originalTimestamp": "2020-08-20T16:00:52.671Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597939252670, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "c4c15f3e9d37152db0.37791551", "site_id": 27 }, "receivedAt": "2020-08-20T16:00:52.851Z", "sentAt": "2020-08-20T16:00:52.674Z", "timestamp": "2020-08-20T16:00:52.848Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671935
- updated: 2020-08-20 11:34:35
-
Version 4681906
- created: 2020-08-20 11:33:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681906
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T16:33:11Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597941139253.39e4152f97f7.baa71ec.0ac3fea4-7b0f-4b68-b9d9-a33165ab2ab7.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-da524243b473ba69dc7681163b5f03f5", "originalTimestamp": "2020-08-20T16:02:14.149Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597939333223, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "90605f3e9e80d46d49.64343702", "site_id": 27 }, "receivedAt": "2020-08-20T16:02:14.284Z", "sentAt": "2020-08-20T16:02:14.151Z", "timestamp": "2020-08-20T16:02:14.282Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671891
- updated: 2020-08-20 11:33:32
-
Version 4681905
- created: 2020-08-20 10:33:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681905
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T15:32:35Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597937535838.59448da486ed.baa71ec.2f289578-17cf-4497-88e3-5b2020ddf1f9.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/search", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "http://localhost:9116/search?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-ae82b5cc72444c4912ab2033059f99e5", "originalTimestamp": "2020-08-20T15:18:19.878Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597936699876, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "566b5f3e939e86b075.41259078", "site_id": 27 }, "receivedAt": "2020-08-20T15:18:20.053Z", "sentAt": "2020-08-20T15:18:19.880Z", "timestamp": "2020-08-20T15:18:20.051Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671730
- updated: 2020-08-20 10:34:16
-
Version 4681904
- created: 2020-08-20 10:33:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`projectId`STRING,`timestamp`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`isReact`:STRING,`label`:STRING,`something`:array,`env`:STRING,`category`:STRING,`facilitiesInTray`:array ,`Hit_Timestamp`:STRING,`site_id`:STRING,`searchId`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681904
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T15:32:53Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597937538059.9e6048cf9afb.baa71ec.ab014627-dbdc-4adb-a45f-472b00e95899.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-50aa3c8fec893a2b007c396296d4acac", "originalTimestamp": "2020-08-20T15:21:18.884Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597936878284, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [], "isReact": true, "label": "nearby facilities list open", "searchId": "f90b5f3e94eb17c452.72466970", "site_id": 27 }, "receivedAt": "2020-08-20T15:21:19.071Z", "sentAt": "2020-08-20T15:21:18.886Z", "timestamp": "2020-08-20T15:21:19.069Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "string" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671728
- updated: 2020-08-20 10:33:51
-
Version 4681903
- created: 2020-08-20 10:33:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed
- id: 4681903
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-08-20T15:32:50Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1597881600000/1597937536790.0d3aa5cd95d0.baa71ec.395536ff-8bcc-482c-b249-a6b00119f2dc.gz|segment_separator:34", "anonymousId": "73c513d6-d682-4b08-9dab-a303234f0b95", "channel": "client", "context": { "campaign": {}, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.13.6" }, "locale": "en-US", "page": { "path": "/self-storage/texas/austin/", "referrer": "", "search": "?sftest=on&location=Austin%2C%20TX%2C%20USA", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.extrameter.com/self-storage/texas/austin/?sftest=on&location=Austin%2C%20TX%2C%20USA" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36" }, "event": "Nearby Facilities List Viewed", "integrations": {}, "messageId": "ajs-905556076ee26c961d251d1c56b0fc7e", "originalTimestamp": "2020-08-20T15:24:31.632Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1597937071631, "category": "nearby facilities list-searchPage", "env": "development", "facilitiesInTray": [ 213515, 213693, 213520 ], "isReact": true, "label": "nearby facilities list open", "searchId": "f90b5f3e94eb17c452.72466970", "site_id": 27 }, "receivedAt": "2020-08-20T15:24:31.796Z", "sentAt": "2020-08-20T15:24:31.635Z", "timestamp": "2020-08-20T15:24:31.793Z", "type": "track", "userId": "error", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 1466
- schema_scan_id: 5671727
- updated: 2020-08-20 10:33:32
Schema Scans: 15
Last at 2020-08-21 15:35:17
-
Scan 5673664
- duration: 0:00:21.661497
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 25, "partitions_applied": false, "success": true } - id: 5673664
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-21/", "name": "dt", "type": "string", "value": "2020-08-21" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-21/1598041945320.dba5e5cc232b.baa71ec.42d1739a-6cbe-4e1b-9519-4371ed21fb5e.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-21 15:35:17
- success: True
- trace_id: 3921727792007109124
-
Scan 5673651
- duration: 0:00:21.755034
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 25, "partitions_applied": false, "success": true } - id: 5673651
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-21/", "name": "dt", "type": "string", "value": "2020-08-21" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-21/1598041900527.2945ff8f51a7.baa71ec.a330e120-f5f2-4c07-bea7-f8b3ca11ff16.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-21 15:33:50
- success: True
- trace_id: 2303774970396097656
-
Scan 5672606
- duration: 0:00:18.951399
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5672606
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597959165474.0d3aa5cd95d0.baa71ec.171e5766-d101-42b6-9108-bdb246cb2fa4.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 16:38:12
- success: True
- trace_id: 5770797707292748683
-
Scan 5672599
- duration: 0:00:21.500071
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5672599
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597959132953.1443184baef8.baa71ec.319fecbb-a1ae-45d3-a44d-8179229916a0.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 16:37:49
- success: True
- trace_id: 11508441208070199340
-
Scan 5672224
- duration: 0:00:19.030315
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5672224
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597944770283.53652990185e.baa71ec.65ec9ecd-4525-464a-a8bc-11283c5cea94.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 12:44:00
- success: True
- trace_id: 4934586435459222121
-
Scan 5672212
- duration: 0:00:22.124752
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5672212
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597944762267.1443184baef8.baa71ec.336476ac-4019-44d7-b11a-85f3ae0109aa.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 12:42:28
- success: True
- trace_id: 13120294802049752268
-
Scan 5672056
- duration: 0:00:19.368416
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5672056
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597941159323.3f38069ae695.baa71ec.228ee393-0500-4490-a4d4-0596f257586f.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 11:42:39
- success: True
- trace_id: 6290688139386679114
-
Scan 5672053
- duration: 0:00:19.472793
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5672053
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597941157732.2945ff8f51a7.baa71ec.13fcb643-c9ab-4cf5-b030-4687d3c3fcec.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 11:42:19
- success: True
- trace_id: 9667810526917041684
-
Scan 5671994
- duration: 0:00:19.628538
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671994
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597941185796.dba5e5cc232b.baa71ec.ac16dce8-3709-4239-a066-494c1f84faf1.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 11:37:22
- success: True
- trace_id: 6794095810254556616
-
Scan 5671988
- duration: 0:00:21.629863
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671988
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597941186846.59448da486ed.baa71ec.e2ff3897-d75f-4a9a-bbe6-042d90dfdd4c.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 11:36:59
- success: True
- trace_id: 3107919955088512632
-
Scan 5671935
- duration: 0:00:19.164243
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671935
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597941111310.53652990185e.baa71ec.36c782ff-4167-4b08-b217-cd6fc6454e33.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 11:34:19
- success: True
- trace_id: 1400807164885531752
-
Scan 5671891
- duration: 0:00:19.276492
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671891
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597941139253.39e4152f97f7.baa71ec.0ac3fea4-7b0f-4b68-b9d9-a33165ab2ab7.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 11:33:16
- success: True
- trace_id: 4838238948790683690
-
Scan 5671730
- duration: 0:00:24.414749
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671730
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597937535838.59448da486ed.baa71ec.2f289578-17cf-4497-88e3-5b2020ddf1f9.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 10:33:55
- success: True
- trace_id: 4452685991927268963
-
Scan 5671728
- duration: 0:00:19.549592
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671728
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597937538059.9e6048cf9afb.baa71ec.ab014627-dbdc-4adb-a45f-472b00e95899.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 10:33:35
- success: True
- trace_id: 12909490298712794933
-
Scan 5671727
- duration: 0:00:21.567321
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 24, "partitions_applied": false, "success": true } - id: 5671727
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/", "name": "dt", "type": "string", "value": "2020-08-20" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed", "key": "separated_dt/Nearby Facilities List Viewed/dt=2020-08-20/1597937536790.0d3aa5cd95d0.baa71ec.395536ff-8bcc-482c-b249-a6b00119f2dc.gz.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_Nearby_Facilities_List_Viewed", "type": "segment" } } - running: False
- schema_name_id: 1466
- start_time: 2020-08-20 10:33:13
- success: True
- trace_id: 14422956734282429137
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\nADD\n\n\n PARTITION (dt='2020-08-27') location 's3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-27/'\n PARTITION (dt='2020-08-28') location 's3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-28/'\n PARTITION (dt='2020-09-01') location 's3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-09-01/'\n;" ] - name: dt
- state:
[ { "info": { "id": 159540, "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-27/", "name": "dt", "value": "2020-08-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2020-08-27 09:38:26", "last_data": "2020-08-27 11:38:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 159596, "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-28/", "name": "dt", "value": "2020-08-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2020-08-28 10:33:27", "last_data": "2020-08-28 10:39:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 159742, "location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-09-01/", "name": "dt", "value": "2020-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2020-09-01 10:39:37", "last_data": "2020-09-01 10:41:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.ip": "string", "context.library.name": "string", "context.library.version": "string", "context.locale": "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.env": "string", "properties.facilitiesInTray": [ "int" ], "properties.isReact": "string", "properties.label": "string", "properties.searchId": "string", "properties.segmentProperties.facilityId": "string", "properties.site_id": "string", "properties.something": [ "string" ], "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2020-08-21 15:35:17
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array ,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2020-03-25 12:05:07",
"disabled": false,
"format": "raw",
"id": 1466,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_segment",
"table": "ssdc_nearby_facilities_list_viewed"
},
"type": "segment"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\nADD\n\n\n PARTITION (dt='2020-08-27') location 's3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-27/'\n PARTITION (dt='2020-08-28') location 's3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-28/'\n PARTITION (dt='2020-09-01') location 's3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-09-01/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 159540,
"location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-27/",
"name": "dt",
"value": "2020-08-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2020-08-27 09:38:26",
"last_data": "2020-08-27 11:38:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 159596,
"location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-08-28/",
"name": "dt",
"value": "2020-08-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2020-08-28 10:33:27",
"last_data": "2020-08-28 10:39:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 159742,
"location": "s3://sfdl-segment-ssdc-dev/separated_dt/Nearby Facilities List Viewed/dt=2020-09-01/",
"name": "dt",
"value": "2020-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2020-09-01 10:39:37",
"last_data": "2020-09-01 10:41:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.ip": "string",
"context.library.name": "string",
"context.library.version": "string",
"context.locale": "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.env": "string",
"properties.facilitiesInTray": [
"int"
],
"properties.isReact": "string",
"properties.label": "string",
"properties.searchId": "string",
"properties.segmentProperties.facilityId": "string",
"properties.site_id": "string",
"properties.something": [
"string"
],
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2020-08-21 15:35:17",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`\n(\n`context`struct<`library`:struct<`name`:STRING,`version`:STRING>,`locale`:STRING,`userAgent`:STRING,`ip`:STRING,`page`:struct<`search`:STRING,`path`:STRING,`title`:STRING,`url`:STRING,`referrer`:STRING>>,`projectId`STRING,`userId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`sentAt`STRING,`properties`struct<`label`:STRING,`isReact`:STRING,`something`:array,`env`:STRING,`searchId`:STRING,`category`:STRING,`facilitiesInTray`:array,`site_id`:STRING,`Hit_Timestamp`:STRING,`segmentProperties`:struct<`facilityId`:STRING>>,`messageId`STRING,`receivedAt`STRING,`version`STRING,`channel`STRING,`event`STRING,`timestamp`STRING,`type`STRING,`_origin`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-ssdc-dev/separated_dt/Nearby Facilities List Viewed'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_nearby_facilities_list_viewed`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_nearby_facilities_list_viewed"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}