Schema Info
Schema Name: sfdl_stage_segment.sfdc_swipedown
- created: 2017-11-01 12:58:00
- disabled: False
- format: raw
- id: 268
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_segment", "table": "sfdc_swipedown" } - type: segment
Schema Versions: 2
-
Version 1673
- created: 2017-11-01 13:24:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_swipedown`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_swipedown`\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< `category` : string , `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `site_id` : string , `label` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1933_improved_filter_visibility` : 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/swipedown'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_swipedown`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/swipedown
- id: 1673
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Mixpanel", "Segment.io" ], "unbundled": [] }, "anonymousId": "ec6de4fe-a920-4276-b86c-c42d4595d8f2", "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": "?searchType=storage&location=Houston,+TX,+United+States&latitude=29.760192&longitude=-95.36939&distance=15&order=recommended&page=1&mobileView=map", "title": "Find Self Storage Units and Facilities in Houston, TX 77002 | SpareFoot", "url": "http://www.sparefoot.local/search.html?searchType=storage&location=Houston,+TX,+United+States&latitude=29.760192&longitude=-95.36939&distance=15&order=recommended&page=1&mobileView=map" }, "userAgent": "Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.95 Mobile Safari/537.36" }, "event": "swipedown", "integrations": {}, "messageId": "ajs-cbd599baa865315dc9f452ada3401037", "originalTimestamp": "2016-12-21T15:10:56.127Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1482333056126, "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", "category": "sf_1626_mobile_map redesign search interactions-searchPage", "label": "map banner close", "site_id": "59" }, "receivedAt": "2016-12-21T15:10:56.167Z", "sentAt": "2016-12-21T15:10:56.129Z", "timestamp": "2016-12-21T15:10:56.165Z", "type": "track", "userId": "6158598ea65859e5333385613", "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.category": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 268
- schema_scan_id: None
- updated: 2019-04-18 13:21:15
-
Version 1572
- created: 2017-11-01 12:58:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_swipedown`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_swipedown`\n(\n `version` string , `timestamp` string , `projectId` string , `userId` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `site_id` : string , `label` : 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/swipedown'", "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_swipedown`" ] - hive_path: s3://sfdl-segment-sfdc-stage/separated_dt/swipedown
- id: 1572
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Segment.io" ], "unbundled": [] }, "anonymousId": "2bc4f94b-26d4-48b2-be0b-58adca1dd919", "channel": "client", "context": { "campaign": {}, "ip": "207.71.19.142", "library": { "name": "analytics.js", "version": "3.0.0" }, "page": { "path": "/search.html", "referrer": "", "search": "?searchType=storage-only&location_id=1599622&location=Taylor,%20TX&latitude=30.570755&longitude=-97.409444&distance=15&order=recommended&page=1&mobileView=map", "title": "Find Self Storage Units and Facilities in Taylor, TX 76574 | SpareFoot", "url": "http://www.sparefoot.local/search.html?searchType=storage-only&location_id=1599622&location=Taylor,%20TX&latitude=30.570755&longitude=-97.409444&distance=15&order=recommended&page=1&mobileView=map" }, "userAgent": "Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.23 Mobile Safari/537.36" }, "event": "swipedown", "integrations": {}, "messageId": "ajs-dd2433993c9f96977f0c1e2fc5c1690b", "originalTimestamp": "2016-12-01T20:38:29.228Z", "projectId": "MK1uoFcf4t", "properties": { "Hit Timestamp": 1480624709227, "category": "sf_1626_mobile_map variation search interactions-searchPage", "label": "map overlay close", "site_id": "59" }, "receivedAt": "2016-12-01T20:38:29.254Z", "sentAt": "2016-12-01T20:38:29.229Z", "timestamp": "2016-12-01T20:38:29.253Z", "type": "track", "userId": "385823712ca3b751782826908", "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.category": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 268
- schema_scan_id: None
- updated: None
Schema Scans: 0
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_stage_segment.sfdc_swipedown`\nADD\n\n\n PARTITION (dt='2016-12-01') location 's3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-01/'\n PARTITION (dt='2016-12-21') location 's3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-21/'\n PARTITION (dt='2017-01-10') location 's3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2017-01-10/'\n;" ] - name: dt
- state:
[ { "info": { "id": 8842, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-01/", "name": "dt", "value": "2016-12-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": 8843, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-21/", "name": "dt", "value": "2016-12-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": 8844, "location": "s3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2017-01-10/", "name": "dt", "value": "2017-01-10" }, "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_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.category": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2017-11-01 13:24:27
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_swipedown`\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< `category` : string , `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `site_id` : string , `label` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1933_improved_filter_visibility` : 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/swipedown'", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_swipedown`", "repair_table": "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_swipedown`" }
- 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:58:00",
"disabled": false,
"format": "raw",
"id": 268,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_segment",
"table": "sfdc_swipedown"
},
"type": "segment"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_stage_segment.sfdc_swipedown`\nADD\n\n\n PARTITION (dt='2016-12-01') location 's3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-01/'\n PARTITION (dt='2016-12-21') location 's3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-21/'\n PARTITION (dt='2017-01-10') location 's3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2017-01-10/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 8842,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-01/",
"name": "dt",
"value": "2016-12-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": 8843,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2016-12-21/",
"name": "dt",
"value": "2016-12-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": 8844,
"location": "s3://sfdl-segment-sfdc-stage/separated_dt/swipedown/dt=2017-01-10/",
"name": "dt",
"value": "2017-01-10"
},
"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_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.category": "string",
"properties.label": "string",
"properties.site_id": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2017-11-01 13:24:27",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.sfdc_swipedown`\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< `category` : string , `Hit_Timestamp` : string , `activePhlags_sf_2016_aa_groundhog_day` : string , `activePhlags_sf_1932_value_prop_search_hero` : string , `activePhlags_sf_1904_remove_facility_unit_filter` : string , `site_id` : string , `label` : string , `activePhlags_sf_1936_search_help_widget` : string , `activePhlags_sf_1994_map_zoom` : string , `activePhlags_sf_1626_mobile_map` : string , `activePhlags_sf_1592_curated_new_york_page` : string , `activePhlags_sf_1933_improved_filter_visibility` : 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/swipedown'",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.sfdc_swipedown`",
"repair_table": "MSCK REPAIR TABLE `sfdl_stage_segment.sfdc_swipedown`"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}