Schema Info
Schema Name: sfdl_stage_segment.sfdc_promotion_clicked
- created: 2017-11-01 12:10:06
- disabled: False
- format: raw
- id: 263
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_segment", "table": "sfdc_promotion_clicked" } - type: segment
Schema Versions: 4
-
Version 1963
- created: 2017-11-01 16:56:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_promotion_clicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_promotion_clicked`\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< `ip` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `promotion_id` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `creative` : 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 , `name` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string , `position` : 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/Promotion Clicked'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_promotion_clicked`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked
- id: 1963
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "51c06cb1-621e-40ae-83e8-09307aa5d371", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "https://www.sparefoot.extrameter.com/", "search": "?moveInDate=&location=austin", "title": "Find Self Storage Units and Facilities in Austin, TX | SpareFoot", "url": "https://www.sparefoot.extrameter.com/search.html?moveInDate=&location=austin" }, "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": "Promotion Clicked", "integrations": {}, "messageId": "ajs-15936accf9db8148d36316556c0fb416", "originalTimestamp": "2017-01-24T18:29:28.655Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1485282568654, "activePhlags_con_1314_serp_slideshow": "slideshow", "activePhlags_feature_sfdc_iron_markets": "variation", "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": "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": "click_to_facility", "activePhlags_sf_2064_mobile_map_v2": "control", "activePhlags_sf_2066_value_prop_mab": "guaranteed_prices", "activePhlags_sf_2081_mobile_map_ctr": "control", "activePhlags_sf_2158_gate_page": "control", "activePhlags_sf_2213_view_all_filtered_units": "filtered", "activePhlags_sf_2214_connect_map_and_listings": "control", "creative": "full_service_banner_grey", "name": "Full-Service Storage is here", "position": 3, "promotion_id": "full_self_storage_is_here_listing_banner", "site_id": "-1" }, "receivedAt": "2017-01-24T18:29:27.878Z", "sentAt": "2017-01-24T18:29:28.657Z", "timestamp": "2017-01-24T18:29:27.876Z", "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_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "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.creative": "string", "properties.name": "string", "properties.position": "string", "properties.promotion_id": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 263
- schema_scan_id: None
- updated: 2019-07-30 13:23:36
-
Version 1953
- created: 2017-11-01 16:34:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_promotion_clicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_promotion_clicked`\n(\n `version` string , `timestamp` string , `messageId` string , `userId` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `name` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `site_id` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `position` : string , `activePhlags_sf_1626_mobile_map` : string , `promotion_id` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `creative` : string , `activePhlags_sf_1933_improved_filter_visibility` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `ip` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : 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/Promotion Clicked'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_promotion_clicked`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked
- id: 1953
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "b51195b6-2e95-4ee5-9592-6f85df5804b7", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "https://www.sparefoot.extrameter.com/", "search": "?moveInDate=&location=perryville%2C+ak", "title": "Find Self Storage Units and Facilities in Perryville, AK | SpareFoot", "url": "https://www.sparefoot.extrameter.com/search.html?moveInDate=&location=perryville%2C+ak" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.98 Safari/537.36" }, "event": "Promotion Clicked", "integrations": {}, "messageId": "ajs-120f28cd26f2609d9ede555d783b78da", "originalTimestamp": "2016-12-20T16:56:28.156Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1482252988155, "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": "control", "activePhlags_sf_1994_map_zoom": "control", "activePhlags_sf_2016_aa_groundhog_day": "variation", "creative": "full_service_banner_grey", "name": "Full-Service Storage is here", "position": 3, "promotion_id": "full_self_storage_is_here_listing_banner", "site_id": "-1" }, "receivedAt": "2016-12-20T16:56:28.176Z", "sentAt": "2016-12-20T16:56:28.158Z", "timestamp": "2016-12-20T16:56:28.174Z", "type": "track", "userId": "70584b013acd8b66299201011", "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_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.creative": "string", "properties.name": "string", "properties.position": "string", "properties.promotion_id": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 263
- schema_scan_id: None
- updated: None
-
Version 1564
- created: 2017-11-01 12:42:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_promotion_clicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_promotion_clicked`\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< `ip` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `name` : string , `site_id` : string , `creative` : string , `position` : string , `promotion_id` : 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/Promotion Clicked'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_promotion_clicked`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked
- id: 1564
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Segment.io" ], "unbundled": [] }, "anonymousId": "627c6051-e9be-4bc3-96f7-72b36ed262b3", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Los-Angeles-CA-self-storage.html", "referrer": "", "search": "", "title": "10 Cheap Self-Storage Units Los Angeles, CA | SpareFoot", "url": "https://www.sparefoot.extrameter.com/Los-Angeles-CA-self-storage.html" }, "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 9_1 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13B143 Safari/601.1" }, "event": "Promotion Clicked", "integrations": {}, "messageId": "ajs-278322b67d6ed70fcde33a2f813c6e19", "originalTimestamp": "2016-11-28T17:00:30.655Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1480352430654, "creative": "full_service_banner_grey", "name": "Full-Service Storage is here", "position": 3, "promotion_id": "full_self_storage_is_here_listing_banner", "site_id": "59" }, "receivedAt": "2016-11-28T17:00:30.634Z", "sentAt": "2016-11-28T17:00:30.656Z", "timestamp": "2016-11-28T17:00:30.633Z", "type": "track", "userId": null, "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.creative": "string", "properties.name": "string", "properties.position": "string", "properties.promotion_id": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 263
- schema_scan_id: None
- updated: None
-
Version 1532
- created: 2017-11-01 12:10:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_promotion_clicked`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_promotion_clicked`\n(\n `version` string , `timestamp` string , `projectId` string , `userId` string ,`properties` struct< `promotion_id` : string , `creative` : string , `name` : string , `position` : string >, `receivedAt` string ,`_metadata` struct< `bundled`:array, `unbundled`:array >, `anonymousId` string , `originalTimestamp` string ,`context` struct< `ip` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : string >, `messageId` 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/Promotion Clicked'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_promotion_clicked`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked
- id: 1532
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Segment.io" ], "unbundled": [] }, "anonymousId": "007ff553-6e11-4b03-94ae-abc96b672ae7", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/Austin-TX-self-storage.html", "referrer": "http://www.sparefoot.local/Austin-TX-self-storage.html?searchType=storage-only&location=Austin,+TX,+United+States&latitude=30.267153&longitude=-97.743061&distance=15&zoom=10&order=recommended&page=1", "search": "?searchType=storage-only&location_id=21961023&location=Austin,+TX,+United+States&latitude=30.267153&longitude=-97.743061&distance=15&zoom=10&order=recommended&page=1", "title": "10 Cheap Self-Storage Units Austin, TX: $30/month | SpareFoot", "url": "http://www.sparefoot.local/Austin-TX-self-storage.html?searchType=storage-only&location_id=21961023&location=Austin,+TX,+United+States&latitude=30.267153&longitude=-97.743061&distance=15&zoom=10&order=recommended&page=1" }, "userAgent": "Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.76 Mobile Safari/537.36" }, "event": "Promotion Clicked", "integrations": {}, "messageId": "ajs-4b3c1522a53059a302c5895ec0919445", "originalTimestamp": "2016-11-02T16:16:48.214Z", "projectId": "MK1uoFcf4t", "properties": { "creative": "full_service_banner_grey", "name": "Full-Service Storage is here", "position": 3, "promotion_id": "full_self_storage_is_here_listing_banner" }, "receivedAt": "2016-11-02T16:16:48.253Z", "sentAt": "2016-11-02T16:16:48.216Z", "timestamp": "2016-11-02T16:16:48.251Z", "type": "track", "userId": "5579f731a7f8625225379109", "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.creative": "string", "properties.name": "string", "properties.position": "string", "properties.promotion_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 263
- schema_scan_id: None
- updated: None
Schema Scans: 0
- count: 17
- ddl:
[ "ALTER TABLE\n `sfdl_stage_segment.sfdc_promotion_clicked`\nADD\n\n\n PARTITION (dt='2016-11-01') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-01/'\n PARTITION (dt='2016-11-02') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-02/'\n PARTITION (dt='2016-11-03') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-03/'\n PARTITION (dt='2016-11-04') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-04/'\n PARTITION (dt='2016-11-14') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-14/'\n PARTITION (dt='2016-11-15') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-15/'\n PARTITION (dt='2016-11-16') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-16/'\n PARTITION (dt='2016-11-17') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-17/'\n PARTITION (dt='2016-11-21') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-21/'\n PARTITION (dt='2016-11-28') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-28/'\n PARTITION (dt='2016-12-07') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-07/'\n PARTITION (dt='2016-12-09') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-09/'\n PARTITION (dt='2016-12-13') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-13/'\n PARTITION (dt='2016-12-20') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-20/'\n PARTITION (dt='2017-01-24') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-24/'\n PARTITION (dt='2017-01-26') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-26/'\n PARTITION (dt='2017-03-14') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-03-14/'\n;" ] - name: dt
- state:
[ { "info": { "id": 7739, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-01/", "name": "dt", "value": "2016-11-01" }, "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": 7735, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-02/", "name": "dt", "value": "2016-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": 7751, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-03/", "name": "dt", "value": "2016-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": 7749, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-04/", "name": "dt", "value": "2016-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": 7737, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-14/", "name": "dt", "value": "2016-11-14" }, "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": 7746, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-15/", "name": "dt", "value": "2016-11-15" }, "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": 7743, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-16/", "name": "dt", "value": "2016-11-16" }, "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": 7740, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-17/", "name": "dt", "value": "2016-11-17" }, "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": 7742, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-21/", "name": "dt", "value": "2016-11-21" }, "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": 7748, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-28/", "name": "dt", "value": "2016-11-28" }, "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": 7736, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-07/", "name": "dt", "value": "2016-12-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 } } }, { "info": { "id": 7741, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-09/", "name": "dt", "value": "2016-12-09" }, "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": 7744, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-13/", "name": "dt", "value": "2016-12-13" }, "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": 7750, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-20/", "name": "dt", "value": "2016-12-20" }, "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": 7738, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-24/", "name": "dt", "value": "2017-01-24" }, "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": 7747, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-26/", "name": "dt", "value": "2017-01-26" }, "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": 7745, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-03-14/", "name": "dt", "value": "2017-03-14" }, "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.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_con_1314_serp_slideshow": "string", "properties.activePhlags_feature_sfdc_iron_markets": "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.creative": "string", "properties.name": "string", "properties.position": "string", "properties.promotion_id": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2017-11-01 16:56:17
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_promotion_clicked`\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< `ip` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `promotion_id` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `creative` : 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 , `name` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string , `position` : 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/Promotion Clicked'", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_promotion_clicked`", "repair_table": "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_promotion_clicked`" }
- 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 12:10:06",
"disabled": false,
"format": "raw",
"id": 263,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_segment",
"table": "sfdc_promotion_clicked"
},
"type": "segment"
},
"partition": {
"count": 17,
"ddl": [
"ALTER TABLE\n `sfdl_stage_segment.sfdc_promotion_clicked`\nADD\n\n\n PARTITION (dt='2016-11-01') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-01/'\n PARTITION (dt='2016-11-02') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-02/'\n PARTITION (dt='2016-11-03') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-03/'\n PARTITION (dt='2016-11-04') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-04/'\n PARTITION (dt='2016-11-14') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-14/'\n PARTITION (dt='2016-11-15') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-15/'\n PARTITION (dt='2016-11-16') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-16/'\n PARTITION (dt='2016-11-17') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-17/'\n PARTITION (dt='2016-11-21') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-21/'\n PARTITION (dt='2016-11-28') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-28/'\n PARTITION (dt='2016-12-07') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-07/'\n PARTITION (dt='2016-12-09') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-09/'\n PARTITION (dt='2016-12-13') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-13/'\n PARTITION (dt='2016-12-20') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-20/'\n PARTITION (dt='2017-01-24') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-24/'\n PARTITION (dt='2017-01-26') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-26/'\n PARTITION (dt='2017-03-14') location 's3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-03-14/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 7739,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-01/",
"name": "dt",
"value": "2016-11-01"
},
"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": 7735,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-02/",
"name": "dt",
"value": "2016-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": 7751,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-03/",
"name": "dt",
"value": "2016-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": 7749,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-04/",
"name": "dt",
"value": "2016-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": 7737,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-14/",
"name": "dt",
"value": "2016-11-14"
},
"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": 7746,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-15/",
"name": "dt",
"value": "2016-11-15"
},
"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": 7743,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-16/",
"name": "dt",
"value": "2016-11-16"
},
"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": 7740,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-17/",
"name": "dt",
"value": "2016-11-17"
},
"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": 7742,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-21/",
"name": "dt",
"value": "2016-11-21"
},
"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": 7748,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-11-28/",
"name": "dt",
"value": "2016-11-28"
},
"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": 7736,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-07/",
"name": "dt",
"value": "2016-12-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
}
}
},
{
"info": {
"id": 7741,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-09/",
"name": "dt",
"value": "2016-12-09"
},
"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": 7744,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-13/",
"name": "dt",
"value": "2016-12-13"
},
"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": 7750,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2016-12-20/",
"name": "dt",
"value": "2016-12-20"
},
"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": 7738,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-24/",
"name": "dt",
"value": "2017-01-24"
},
"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": 7747,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-01-26/",
"name": "dt",
"value": "2017-01-26"
},
"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": 7745,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/Promotion Clicked/dt=2017-03-14/",
"name": "dt",
"value": "2017-03-14"
},
"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.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_con_1314_serp_slideshow": "string",
"properties.activePhlags_feature_sfdc_iron_markets": "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.creative": "string",
"properties.name": "string",
"properties.position": "string",
"properties.promotion_id": "string",
"properties.site_id": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2017-11-01 16:56:17",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_promotion_clicked`\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< `ip` : string ,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : string >, `projectId` string , `type` string ,`properties` struct< `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `site_id` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1626_mobile_map` : string , `promotion_id` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_2081_mobile_map_ctr` : string , `creative` : 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 , `name` : string , `activePhlags_sf_2158_gate_page` : string , `activePhlags_sf_2064_mobile_map_v2` : string , `activePhlags_sf_2066_value_prop_mab` : string , `position` : 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/Promotion Clicked'",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_promotion_clicked`",
"repair_table": "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_promotion_clicked`"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}