Schema Info
Schema Name: sfdl_stage_segment.sfdc_click
- created: 2017-11-01 11:59:34
- disabled: False
- format: raw
- id: 243
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_segment", "table": "sfdc_click" } - type: segment
Schema Versions: 15
-
Version 2032
- created: 2017-11-01 19:44:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `daysOut` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `outsideResWindow` : string , `closedForTheDay` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `date` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string ,`value` : struct< `breadcrumb` : string >, `activePhlags_sf_2066_value_prop_mab` : string , `formData` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`campaign` : struct< `content` : string , `source` : string , `medium` : string , `name` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 2032
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Segment.io" ], "unbundled": [] }, "anonymousId": "e9c2757f-8061-4034-b020-e26d91bb3e01", "channel": "client", "context": { "campaign": { "content": "Dynamic", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_dynamic", "source": "google" }, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Austin-TX-self-storage/Cedar-Park-Self-Storage-Austin-12342-Rr-620-North-178737.html", "referrer": "", "search": "", "title": "Cedar Park Self Storage - Austin - 12342 Rr 620 North | North Dr | SpareFoot", "url": "http://localhost:9000/Austin-TX-self-storage/Cedar-Park-Self-Storage-Austin-12342-Rr-620-North-178737.html" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-7a2848305992ab1ad1924fb791756543", "originalTimestamp": "2017-07-18T16:05:01.880Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1500393901879, "activePhlags": { "sf_1426_mobile_first_search_listings_v2": "control", "sf_1932_value_prop_search_hero": "control" }, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "fss callout interactions-oonFacilityPage", "customDimensions": { "timestamp": 1478122461545 }, "daysOut": 3, "formData": "{\"firstName\":\"\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"moveInDate\":\"2017-09-08\",\"facilityId\":\"152925\",\"unitId\":\"14043117\"}", "label": "State", "selectedDate": { "closed": false, "closedForTheDay": false, "date": "2017-06-10T05:00:00.000Z", "notOpenOnMoveIn": false, "outsideResWindow": true, "past": false }, "site_id": -1, "timstamp": 1478122461545, "value": { "breadcrumb": "Austinself-storage" } }, "receivedAt": "2017-07-18T16:05:00.179Z", "sentAt": "2017-07-18T16:05:01.882Z", "timestamp": "2017-07-18T16:05:00.177Z", "type": "track", "userId": null, "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.daysOut": "string", "properties.formData": "string", "properties.label": "string", "properties.selectedDate.closed": "string", "properties.selectedDate.closedForTheDay": "string", "properties.selectedDate.date": "string", "properties.selectedDate.notOpenOnMoveIn": "string", "properties.selectedDate.outsideResWindow": "string", "properties.selectedDate.past": "string", "properties.site_id": "string", "properties.timstamp": "string", "properties.value.breadcrumb": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: 2019-04-18 13:34:44
-
Version 2023
- created: 2017-11-01 19:08:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`campaign` : struct< `content` : string , `source` : string , `medium` : string , `name` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `daysOut` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `outsideResWindow` : string , `closedForTheDay` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `date` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string , `formData` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 2023
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io", "Zopim" ], "unbundled": [] }, "anonymousId": "b10cd5dd-e833-4bf0-8b7f-ac736051f129", "channel": "client", "context": { "campaign": { "content": "Dynamic", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_dynamic", "source": "google" }, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Dallas-TX-self-storage/Security-Self-Storage-Skillman-152925.html", "referrer": "", "search": "?location=Dallas,%20TX,%20United%20States", "title": "Security Self Storage - Skillman | 6640 Skillman Street | SpareFoot", "url": "https://www.sparefoot.extrameter.com/Dallas-TX-self-storage/Security-Self-Storage-Skillman-152925.html?location=Dallas,%20TX,%20United%20States" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-eda5f5c8b5192b6ea1db582eefb1c5d8", "originalTimestamp": "2017-07-03T21:17:59.170Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1499116679169, "activePhlags": { "sf_1426_mobile_first_search_listings_v2": "control", "sf_1932_value_prop_search_hero": "control" }, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "reservation form interactions-facilityPage", "customDimensions": { "timestamp": 1478122461545 }, "daysOut": 3, "formData": "{\"firstName\":\"\",\"lastName\":\"\",\"email\":\"\",\"phone\":\"\",\"moveInDate\":\"2017-09-08\",\"facilityId\":\"152925\",\"unitId\":\"14043117\"}", "label": "out-of-res-window message book", "selectedDate": { "closed": false, "closedForTheDay": false, "date": "2017-06-10T05:00:00.000Z", "notOpenOnMoveIn": false, "outsideResWindow": true, "past": false }, "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-07-03T21:17:59.191Z", "sentAt": "2017-07-03T21:17:59.172Z", "timestamp": "2017-07-03T21:17:59.189Z", "type": "track", "userId": "52592f01fa72ebc4224337380", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.daysOut": "string", "properties.formData": "string", "properties.label": "string", "properties.selectedDate.closed": "string", "properties.selectedDate.closedForTheDay": "string", "properties.selectedDate.date": "string", "properties.selectedDate.notOpenOnMoveIn": "string", "properties.selectedDate.outsideResWindow": "string", "properties.selectedDate.past": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 2020
- created: 2017-11-01 18:58:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `daysOut` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `outsideResWindow` : string , `closedForTheDay` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `date` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`campaign` : struct< `content` : string , `source` : string , `medium` : string , `name` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 2020
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io", "Zopim" ], "unbundled": [] }, "anonymousId": "1300c5a7-c632-4cbb-aaf3-fe8fd13804d5", "channel": "client", "context": { "campaign": { "content": "Dynamic", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_dynamic", "source": "google" }, "ip": "172.58.14.202", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Miami-FL-self-storage/21st-Century-Storage-and-UHaul-Miami-158752.html", "referrer": "http://www.google.com/", "search": "?tsid=google-ppc&cid=pro_national_nogeo_noproduct_dynamic&ctid=Dynamic&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=Dynamic&ploc=9011927&iloc=&mkwid=sWNyRB1Yu|pcrid|192663399083|pkw||pmt|b|pdv|m|&muid=a43dbe53-295c-4dc2-b275-eeb7638309ae&gclid=Cj0KEQjwg47KBRDk7LSu4LTD8eEBEiQAO4O6r_mBhEB_TkRBjHKhETKklcz0T8IY2kC7XwhOojJtXLQaAoQ08P8HAQ", "title": "21st Century Storage and UHaul - Miami | 200 NW 79th St | SpareFoot", "url": "https://www.sparefoot.com/Miami-FL-self-storage/21st-Century-Storage-and-UHaul-Miami-158752.html?tsid=google-ppc&cid=pro_national_nogeo_noproduct_dynamic&ctid=Dynamic&utm_source=google&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=Dynamic&ploc=9011927&iloc=&mkwid=sWNyRB1Yu|pcrid|192663399083|pkw||pmt|b|pdv|m|&muid=a43dbe53-295c-4dc2-b275-eeb7638309ae&gclid=Cj0KEQjwg47KBRDk7LSu4LTD8eEBEiQAO4O6r_mBhEB_TkRBjHKhETKklcz0T8IY2kC7XwhOojJtXLQaAoQ08P8HAQ" }, "userAgent": "Mozilla/5.0 (Linux; Android 6.0.1; SM-J700M Build/MMB29K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.83 Mobile Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-9dbf45c7e5a82ee0160171b9ec32302e", "originalTimestamp": "2017-06-16T20:36:07.805Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1497645367801, "activePhlags": { "sf_1426_mobile_first_search_listings_v2": "control", "sf_1932_value_prop_search_hero": "control" }, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "image carousel interactions-facilitypage", "customDimensions": { "timestamp": 1478122461545 }, "daysOut": 3, "label": "right arrow", "selectedDate": { "closed": false, "closedForTheDay": false, "date": "2017-06-10T05:00:00.000Z", "notOpenOnMoveIn": false, "outsideResWindow": true, "past": false }, "site_id": -1, "timstamp": 1478122461545 }, "receivedAt": "2017-06-16T20:36:07.768Z", "sentAt": "2017-06-16T20:36:07.814Z", "timestamp": "2017-06-16T20:36:07.759Z", "type": "track", "userId": null, "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.daysOut": "string", "properties.label": "string", "properties.selectedDate.closed": "string", "properties.selectedDate.closedForTheDay": "string", "properties.selectedDate.date": "string", "properties.selectedDate.notOpenOnMoveIn": "string", "properties.selectedDate.outsideResWindow": "string", "properties.selectedDate.past": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 2019
- created: 2017-11-01 18:54:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `daysOut` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `outsideResWindow` : string , `closedForTheDay` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `date` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 2019
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io", "Zopim" ], "unbundled": [] }, "anonymousId": "a058b71d-0ff7-4a6a-8b8f-3eeed13cbfa6", "channel": "client", "context": { "campaign": {}, "ip": "166.155.168.205", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Perryville-AK-self-storage/Fake-Storage-Facility-Product-155558.html", "referrer": "", "search": "?location=99648", "title": "Fake Storage Facility - Product | 400 Brooks Road | SpareFoot", "url": "http://www.sparefoot.local/Perryville-AK-self-storage/Fake-Storage-Facility-Product-155558.html?location=99648" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-5b3a028e9f59873991638426c04e6506", "originalTimestamp": "2017-06-06T21:50:41.224Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1496785841223, "activePhlags": { "sf_1426_mobile_first_search_listings_v2": "control", "sf_1932_value_prop_search_hero": "control" }, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "reservation form interactions-facilityPage", "customDimensions": { "timestamp": 1478122461545 }, "daysOut": 3, "label": "show out-of-res-window message", "selectedDate": { "closed": false, "closedForTheDay": false, "date": "2017-06-10T05:00:00.000Z", "notOpenOnMoveIn": false, "outsideResWindow": true, "past": false }, "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-06-06T21:50:41.491Z", "sentAt": "2017-06-06T21:50:41.232Z", "timestamp": "2017-06-06T21:50:41.483Z", "type": "track", "userId": "51590b8a8da00eb7294427715", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.daysOut": "string", "properties.label": "string", "properties.selectedDate.closed": "string", "properties.selectedDate.closedForTheDay": "string", "properties.selectedDate.date": "string", "properties.selectedDate.notOpenOnMoveIn": "string", "properties.selectedDate.outsideResWindow": "string", "properties.selectedDate.past": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 2003
- created: 2017-11-01 18:26:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `date` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `closedForTheDay` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 2003
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io", "Zopim" ], "unbundled": [] }, "anonymousId": "a058b71d-0ff7-4a6a-8b8f-3eeed13cbfa6", "channel": "client", "context": { "campaign": {}, "ip": "74.192.139.176", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Perryville-AK-self-storage/Fake-Storage-Facility-Product-155558.html", "referrer": "", "search": "?location=99648", "title": "Fake Storage Facility - Product | 400 Brooks Road | SpareFoot", "url": "http://www.sparefoot.local/Perryville-AK-self-storage/Fake-Storage-Facility-Product-155558.html?location=99648" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-0cb5ae1b90d004add1dc08be83ff48d5", "originalTimestamp": "2017-06-01T04:08:48.523Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1496290128519, "activePhlags": { "sf_1426_mobile_first_search_listings_v2": "control", "sf_1932_value_prop_search_hero": "control" }, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "reservation form interactions-facilityPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "show out-of-res-window message", "selectedDate": { "closed": false, "closedForTheDay": false, "date": "2017-06-15T05:00:00.000Z", "notOpenOnMoveIn": false, "past": false }, "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-06-01T04:08:48.163Z", "sentAt": "2017-06-01T04:08:48.527Z", "timestamp": "2017-06-01T04:08:48.159Z", "type": "track", "userId": "51590b8a8da00eb7294427715", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.selectedDate.closed": "string", "properties.selectedDate.closedForTheDay": "string", "properties.selectedDate.date": "string", "properties.selectedDate.notOpenOnMoveIn": "string", "properties.selectedDate.past": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1973
- created: 2017-11-01 17:15:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1973
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "a852c175-178e-47c1-b991-155d3f9ac868", "channel": "client", "context": { "campaign": {}, "ip": "207.254.7.145", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "", "search": "?location=Perryville,AK", "title": "Find Self Storage Units and Facilities in Perryville, AK | SpareFoot", "url": "https://www.sparefoot.moreyard.com/search.html?location=Perryville,AK" }, "userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-98feada85fc2daafb41bb4d19e37f0c0", "originalTimestamp": "2016-12-14T21:08:57.537Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1481749737536, "activePhlags": { "sf_1426_mobile_first_search_listings_v2": "control", "sf_1932_value_prop_search_hero": "control" }, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "facility interactions-searchPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "facility title", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2016-12-14T21:08:58.357Z", "sentAt": "2016-12-14T21:08:57.548Z", "timestamp": "2016-12-14T21:08:58.346Z", "type": "track", "userId": "685851b4d1bb67f9980259480", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1938
- created: 2017-11-01 16:12:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1938
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "0f7a384f-5c58-4f89-aeec-8a5b1eb60ed1", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "http://www.sparefoot.local:8080/", "search": "?searchType=fss-only&location=95%20Old%20Colony%20Avenue%20Quincy,%20MA%2002170&latitude=&longitude=&distance=31.5472868314003&zoom=9&moveInDate=&order=recommended&page=1&city=&state=&locationSource=google_map_change&streetAddress=&zip=", "title": "Find Self Storage Units and Facilities in Quincy, MA | SpareFoot", "url": "https://www.sparefoot.local:8080/search.html?searchType=fss-only&location=95%20Old%20Colony%20Avenue%20Quincy,%20MA%2002170&latitude=&longitude=&distance=31.5472868314003&zoom=9&moveInDate=&order=recommended&page=1&city=&state=&locationSource=google_map_change&streetAddress=&zip=" }, "userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/55.0.2883.87 Chrome/55.0.2883.87 Safari/537.36" }, "dedupe_metadata": { "offset": "1811063056" }, "event": "click", "integrations": {}, "messageId": "ajs-26e523dd089cf306c977321be656f276", "originalTimestamp": "2017-02-08T21:52:59.415Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1486590779412, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "map interactions-searchPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "zoom_out", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-02-08T21:52:59.516Z", "sentAt": "2017-02-08T21:52:59.424Z", "timestamp": "2017-02-08T21:52:59.507Z", "type": "track", "userId": "11589b8f450a5ca3817276446", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1913
- created: 2017-11-01 15:35:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1913
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "01446753-7436-4c59-ba31-802edb632716", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "", "search": "?moveInDate=&location=78701", "title": "Find Self Storage Units and Facilities in Austin, TX 78701 | SpareFoot", "url": "http://www.sparefoot.local/search.html?moveInDate=&location=78701" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-1a1268aebf18a3a52197bca11b25cce5", "originalTimestamp": "2017-01-26T19:06:17.383Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1485457577382, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_rent", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_sf_2214_connect_map_and_listings": "matching", "activePhlags_sf_2217_serp_email_capture": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "map interactions-searchPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "facility pin", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-26T19:06:15.175Z", "sentAt": "2017-01-26T19:06:17.387Z", "timestamp": "2017-01-26T19:06:15.171Z", "type": "track", "userId": "355887bd7862dd67561073938", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1904
- created: 2017-11-01 15:22:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1904
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "14dd14a5-c56d-4d85-8014-3d4e278ef4f0", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "http://www.sparefoot.local/", "search": "?moveInDate=&location=78701", "title": "Find Self Storage Units and Facilities in Austin, TX 78701 | SpareFoot", "url": "http://www.sparefoot.local/search.html?moveInDate=&location=78701" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:50.0) Gecko/20100101 Firefox/50.0" }, "event": "click", "integrations": {}, "messageId": "ajs-6e232a4841cba63a6a6eb695bac57c75", "originalTimestamp": "2017-01-24T19:30:02.592Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1485286202590, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_sf_2063_stacked_ui_flow": "control", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_compare", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "control", "activePhlags_sf_2213_view_all_filtered_units": "filtered", "activePhlags_sf_2214_connect_map_and_listings": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "map interactions-searchPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "facility pin", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-24T19:30:03.829Z", "sentAt": "2017-01-24T19:30:02.593Z", "timestamp": "2017-01-24T19:30:03.828Z", "type": "track", "userId": "48588645c5420a43059424327", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1897
- created: 2017-11-01 15:10:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1897
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "c86db982-2f58-49ab-ab36-539cedb19ce8", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/", "referrer": "", "search": "", "title": "Search for Self Storage Units | SpareFoot.com", "url": "https://www.sparefoot.extrameter.com/" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-ef3761589904970a39bc0b8a2a596a6b", "originalTimestamp": "2017-01-20T20:28:50.965Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1484944130964, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_feature_sfdc_iron_markets": "variation", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "variation", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "zoomed", "activePhlags_sf_2016_aa_groundhog_day": "variation", "activePhlags_sf_2063_stacked_ui_flow": "control", "activePhlags_sf_2064_mobile_map_v2": "control", "activePhlags_sf_2066_value_prop_mab": "find_compare", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "control", "activePhlags_sf_2213_view_all_filtered_units": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "search interactions-homePage", "customDimensions": { "timestamp": 1478122461545 }, "label": "autocomplete selection", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-20T20:28:51.413Z", "sentAt": "2017-01-20T20:28:50.967Z", "timestamp": "2017-01-20T20:28:51.411Z", "type": "track", "userId": "100584191ce9c1775390329657", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1871
- created: 2017-11-01 14:45:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1871
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "661c4f4b-c924-411a-ad4a-346fc1e37601", "channel": "client", "context": { "campaign": {}, "ip": "207.254.7.18", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Perryville-AK-self-storage/Fake-Storage-Facility-Product-155558.html", "referrer": "", "search": "", "title": "Fake Storage Facility - Product | 400 Brooks Road, Perryville, AK | SpareFoot", "url": "https://www.sparefoot.moreyard.com/Perryville-AK-self-storage/Fake-Storage-Facility-Product-155558.html" }, "userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.75 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-031476b4d0d47a5393b8296f8b431122", "originalTimestamp": "2017-01-11T14:31:00.033Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1484145060028, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "help_widget", "activePhlags_sf_1994_map_zoom": "zoomed", "activePhlags_sf_2016_aa_groundhog_day": "variation", "activePhlags_sf_2063_stacked_ui_flow": "control", "activePhlags_sf_2064_mobile_map_v2": "control", "activePhlags_sf_2066_value_prop_mab": "find_compare", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "facility interactions-facilityPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "unit-selfstorage-5x11", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-11T14:30:58.733Z", "sentAt": "2017-01-11T14:31:00.053Z", "timestamp": "2017-01-11T14:30:58.713Z", "type": "track", "userId": "1458764167e80f72900379581", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1851
- created: 2017-11-01 14:22:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `category` : string , `activePhlags_sf_2066_value_prop_mab` : string , `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `site_id` : string , `activePhlags_sf_2064_mobile_map_v2` : string ,`customDimensions` : struct< `timestamp` : string >, `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_1936_search_help_widget` : string , `timstamp` : string , `activePhlags_sf_1994_map_zoom` : string , `label` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1851
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "28f115b7-ea78-4533-9496-a55561e6c699", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/.html", "referrer": "", "search": "?sftest=on", "title": "10 Cheap Austin TX Self-Storage Facilities | SpareFoot", "url": "http://www.sparefoot.local/.html?sftest=on" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-a161025573b5392095488a8a1bfef074", "originalTimestamp": "2017-01-09T23:31:59.852Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1484004719851, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "variation", "activePhlags_sf_1936_search_help_widget": "help_widget", "activePhlags_sf_1994_map_zoom": "zoomed", "activePhlags_sf_2016_aa_groundhog_day": "variation", "activePhlags_sf_2064_mobile_map_v2": "variation", "activePhlags_sf_2066_value_prop_mab": "find_compare", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_sf_2158_gate_page": "gate_page", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "header interactions-cityLandingPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "my facilities open", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-09T23:31:59.888Z", "sentAt": "2017-01-09T23:31:59.854Z", "timestamp": "2017-01-09T23:31:59.886Z", "type": "track", "userId": "795874163985eb33585523603", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1772
- created: 2017-11-01 14:07:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `site_id` : string , `label` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1772
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "d01f14db-e58b-425e-b13e-a3c38189c408", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "http://www.sparefoot.local/Austin-TX-self-storage.html", "search": "?searchType=storage-only&latitude=30.322834411971453&longitude=-97.73726051318363&distance=11.3145005358875&zoom=11&moveInDate=&order=recommended&page=1", "title": "Find Self Storage Units and Facilities in Austin, TX | SpareFoot", "url": "http://www.sparefoot.local/search.html?searchType=storage-only&latitude=30.322834411971453&longitude=-97.73726051318363&distance=11.3145005358875&zoom=11&moveInDate=&order=recommended&page=1" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-2debca953f7cee37b0e3ef8eee046fae", "originalTimestamp": "2017-01-04T22:43:28.081Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1483569808078, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "variation", "activePhlags_sf_2081_mobile_map_ctr": "bold", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "map interactions-searchPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "redo search button", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-04T22:43:28.106Z", "sentAt": "2017-01-04T22:43:28.082Z", "timestamp": "2017-01-04T22:43:28.105Z", "type": "track", "userId": "71586ac68e0137b4229927798", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1692
- created: 2017-11-01 13:50:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string , `event` string , `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` string , `type` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `site_id` : string , `label` : string ,`customDimensions` : struct< `timestamp` : string >, `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `timstamp` : string , `activePhlags_sf_1933_improved_filter_visibility` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1692
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "8f012e15-aaf1-4a7e-8712-52365ef77113", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Houston-TX-self-storage.html", "referrer": "", "search": "?sf_forced_tests[sf_1936_search_help_widget]=help_widget", "title": "10 Cheap Self-Storage Units Houston, TX: $15/month | SpareFoot", "url": "https://www.sparefoot.extrameter.com/Houston-TX-self-storage.html?sf_forced_tests[sf_1936_search_help_widget]=help_widget" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-e09553a07f23089fece55209841851cd", "originalTimestamp": "2017-01-02T22:01:03.374Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1483394463370, "activePhlags_branded_fss_facility_pages": "control", "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "control", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "control", "activePhlags_sf_1933_improved_filter_visibility": "variation", "activePhlags_sf_1936_search_help_widget": "control", "activePhlags_sf_1994_map_zoom": "zoomed", "activePhlags_sf_2016_aa_groundhog_day": "variation", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "header interactions-cityLandingPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "my facilities open", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2017-01-02T22:01:03.443Z", "sentAt": "2017-01-02T22:01:03.380Z", "timestamp": "2017-01-02T22:01:03.437Z", "type": "track", "userId": "625806c5ef8870d7614517594", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
-
Version 1664
- created: 2017-11-01 13:11:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `label` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `timstamp` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_1933_improved_filter_visibility` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/click
- id: 1664
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "496d3172-eaa7-4cfa-bcce-2d3a98312421", "channel": "client", "context": { "campaign": {}, "ip": "70.124.148.85", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Los-Angeles-CA-full-service.html", "referrer": "", "search": "", "title": "Full-Service Storage in Los Angeles, CA | SpareFoot", "url": "http://www.sparefoot.local/Los-Angeles-CA-full-service.html" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.98 Safari/537.36" }, "event": "click", "integrations": {}, "messageId": "ajs-678d247a561e19f32f4171d29b25f3a8", "originalTimestamp": "2016-12-21T14:55:38.843Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1482332138841, "activePhlags_sf_1426_mobile_first_search_listings_v2": "control", "activePhlags_sf_1592_curated_new_york_page": "variation", "activePhlags_sf_1626_mobile_map": "redesign", "activePhlags_sf_1904_remove_facility_unit_filter": "nounitfilter", "activePhlags_sf_1932_value_prop_search_hero": "value_prop", "activePhlags_sf_1933_improved_filter_visibility": "control", "activePhlags_sf_1936_search_help_widget": "help_widget", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "control", "activePhlags_z_z_z_sparefoot_web_v7_test_test": "control", "category": "map interactions-fssCityLandingPage", "customDimensions": { "timestamp": 1478122461545 }, "label": "zoom_in", "site_id": "-1", "timstamp": 1478122461545 }, "receivedAt": "2016-12-21T14:55:40.315Z", "sentAt": "2016-12-21T14:55:38.848Z", "timestamp": "2016-12-21T14:55:40.310Z", "type": "track", "userId": "945849bccab46151054511959", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "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.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.label": "string", "properties.site_id": "string", "properties.timstamp": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 243
- schema_scan_id: None
- updated: None
Schema Scans: 0
- count: 4
- ddl:
[ "ALTER TABLE\n `sfdl_stage_segment.sfdc_click`\nADD\n\n\n PARTITION (dt='2017-11-02') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-02/'\n PARTITION (dt='2017-11-03') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-03/'\n PARTITION (dt='2017-11-04') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-04/'\n PARTITION (dt='2017-11-07') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-07/'\n;" ] - name: dt
- state:
[ { "info": { "id": 9491, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-02/", "name": "dt", "value": "2017-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2017-12-12 10:02:29", "last_data": null }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 11481, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-03/", "name": "dt", "value": "2017-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2017-12-12 10:02:29", "last_data": null }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 11488, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-04/", "name": "dt", "value": "2017-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2017-12-12 10:02:29", "last_data": null }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 11539, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-07/", "name": "dt", "value": "2017-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2017-12-12 10:02:29", "last_data": null }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.source": "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", "dedupe_metadata.offset": "string", "event": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags.sf_1932_value_prop_search_hero": "string", "properties.activePhlags_branded_fss_facility_pages": "string", "properties.activePhlags_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "string", "properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string", "properties.activePhlags_sf_1592_curated_new_york_page": "string", "properties.activePhlags_sf_1626_mobile_map": "string", "properties.activePhlags_sf_1904_remove_facility_unit_filter": "string", "properties.activePhlags_sf_1932_value_prop_search_hero": "string", "properties.activePhlags_sf_1933_improved_filter_visibility": "string", "properties.activePhlags_sf_1936_search_help_widget": "string", "properties.activePhlags_sf_1994_map_zoom": "string", "properties.activePhlags_sf_2016_aa_groundhog_day": "string", "properties.activePhlags_sf_2063_stacked_ui_flow": "string", "properties.activePhlags_sf_2064_mobile_map_v2": "string", "properties.activePhlags_sf_2066_value_prop_mab": "string", "properties.activePhlags_sf_2081_mobile_map_ctr": "string", "properties.activePhlags_sf_2158_gate_page": "string", "properties.activePhlags_sf_2213_view_all_filtered_units": "string", "properties.activePhlags_sf_2214_connect_map_and_listings": "string", "properties.activePhlags_sf_2217_serp_email_capture": "string", "properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string", "properties.category": "string", "properties.customDimensions.timestamp": "string", "properties.daysOut": "string", "properties.formData": "string", "properties.label": "string", "properties.selectedDate.closed": "string", "properties.selectedDate.closedForTheDay": "string", "properties.selectedDate.date": "string", "properties.selectedDate.notOpenOnMoveIn": "string", "properties.selectedDate.outsideResWindow": "string", "properties.selectedDate.past": "string", "properties.site_id": "string", "properties.timstamp": "string", "properties.value.breadcrumb": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2017-11-01 19:44:39
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `daysOut` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `outsideResWindow` : string , `closedForTheDay` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `date` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string ,`value` : struct< `breadcrumb` : string >, `activePhlags_sf_2066_value_prop_mab` : string , `formData` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`campaign` : struct< `content` : string , `source` : string , `medium` : string , `name` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`", "repair_table": "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2017-11-01 11:59:34",
"disabled": false,
"format": "raw",
"id": 243,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_segment",
"table": "sfdc_click"
},
"type": "segment"
},
"partition": {
"count": 4,
"ddl": [
"ALTER TABLE\n `sfdl_stage_segment.sfdc_click`\nADD\n\n\n PARTITION (dt='2017-11-02') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-02/'\n PARTITION (dt='2017-11-03') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-03/'\n PARTITION (dt='2017-11-04') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-04/'\n PARTITION (dt='2017-11-07') location 's3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-07/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 9491,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-02/",
"name": "dt",
"value": "2017-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2017-12-12 10:02:29",
"last_data": null
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 11481,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-03/",
"name": "dt",
"value": "2017-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2017-12-12 10:02:29",
"last_data": null
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 11488,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-04/",
"name": "dt",
"value": "2017-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2017-12-12 10:02:29",
"last_data": null
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 11539,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/click/dt=2017-11-07/",
"name": "dt",
"value": "2017-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2017-12-12 10:02:29",
"last_data": null
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_metadata.bundled": "",
"_metadata.unbundled": "",
"anonymousId": "string",
"channel": "string",
"context.campaign.content": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.source": "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",
"dedupe_metadata.offset": "string",
"event": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.activePhlags.sf_1426_mobile_first_search_listings_v2": "string",
"properties.activePhlags.sf_1932_value_prop_search_hero": "string",
"properties.activePhlags_branded_fss_facility_pages": "string",
"properties.activePhlags_con_1314_serp_slideshow": "string",
"properties.activePhlags_feature_sfdc_iron_markets": "string",
"properties.activePhlags_sf_1426_mobile_first_search_listings_v2": "string",
"properties.activePhlags_sf_1592_curated_new_york_page": "string",
"properties.activePhlags_sf_1626_mobile_map": "string",
"properties.activePhlags_sf_1904_remove_facility_unit_filter": "string",
"properties.activePhlags_sf_1932_value_prop_search_hero": "string",
"properties.activePhlags_sf_1933_improved_filter_visibility": "string",
"properties.activePhlags_sf_1936_search_help_widget": "string",
"properties.activePhlags_sf_1994_map_zoom": "string",
"properties.activePhlags_sf_2016_aa_groundhog_day": "string",
"properties.activePhlags_sf_2063_stacked_ui_flow": "string",
"properties.activePhlags_sf_2064_mobile_map_v2": "string",
"properties.activePhlags_sf_2066_value_prop_mab": "string",
"properties.activePhlags_sf_2081_mobile_map_ctr": "string",
"properties.activePhlags_sf_2158_gate_page": "string",
"properties.activePhlags_sf_2213_view_all_filtered_units": "string",
"properties.activePhlags_sf_2214_connect_map_and_listings": "string",
"properties.activePhlags_sf_2217_serp_email_capture": "string",
"properties.activePhlags_z_z_z_sparefoot_web_v7_test_test": "string",
"properties.category": "string",
"properties.customDimensions.timestamp": "string",
"properties.daysOut": "string",
"properties.formData": "string",
"properties.label": "string",
"properties.selectedDate.closed": "string",
"properties.selectedDate.closedForTheDay": "string",
"properties.selectedDate.date": "string",
"properties.selectedDate.notOpenOnMoveIn": "string",
"properties.selectedDate.outsideResWindow": "string",
"properties.selectedDate.past": "string",
"properties.site_id": "string",
"properties.timstamp": "string",
"properties.value.breadcrumb": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2017-11-01 19:44:39",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_click`\n(\n`dedupe_metadata` struct< `offset` : string >, `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `daysOut` : string , `site_id` : string ,`customDimensions` : struct< `timestamp` : string >, `timstamp` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_branded_fss_facility_pages` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1426_mobile_first_search_listings_v2` : string , `category` : string , `activePhlags_z_z_z_sparefoot_web_v7_test_test` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `label` : string , `activePhlags_con_1314_serp_slideshow` : string , `activePhlags_sf_1994_map_zoom` : string ,`selectedDate` : struct< `outsideResWindow` : string , `closedForTheDay` : string , `past` : string , `notOpenOnMoveIn` : string , `closed` : string , `date` : string >, `activePhlags_sf_1933_improved_filter_visibility` : string ,`activePhlags` : struct< `sf_1426_mobile_first_search_listings_v2` : string , `sf_1932_value_prop_search_hero` : string >, `activePhlags_feature_sfdc_iron_markets` : string , `activePhlags_sf_2063_stacked_ui_flow` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_2217_serp_email_capture` : string , `activePhlags_sf_2213_view_all_filtered_units` : string , `activePhlags_sf_2214_connect_map_and_listings` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string ,`value` : struct< `breadcrumb` : string >, `activePhlags_sf_2066_value_prop_mab` : string , `formData` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array , `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `userAgent` : string ,`library` : struct< `version` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`campaign` : struct< `content` : string , `source` : string , `medium` : string , `name` : string >, `ip` : string >, `projectId` 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-stage/separated_dt/click'",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_click`",
"repair_table": "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_click`"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}