Schema Info
Schema Name: sfdl_stage_segment.reactfoot_modal_open
- created: 2017-11-01 12:03:29
- disabled: False
- format: raw
- id: 256
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_stage_segment", "table": "reactfoot_modal_open" } - type: segment
Schema Versions: 3
-
Version 246080
- created: 2020-01-17 10:09:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_modal_open`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_modal_open`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`_metadata`struct<`bundled`:array,`unbundled`:array >,`originalTimestamp`STRING,`context`struct<`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`search`:STRING,`url`:STRING,`title`:STRING>,`locale`:STRING,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>,`ip`:STRING>,`_origin`STRING,`original_key`STRING,`userId`STRING,`receivedAt`STRING,`version`STRING,`timestamp`STRING,`anonymousId`STRING,`messageId`STRING,`type`STRING,`event`STRING,`properties`struct<`env`:STRING,`isReact`:STRING,`category`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`label`:STRING>,`channel`STRING,`sentAt`STRING,`projectId`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-reactfoot-stage/separated_dt/modal open'\n", "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_modal_open" ] - hive_path: s3://sfdl-segment-reactfoot-stage/separated_dt/modal open
- id: 246080
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2020-01-17T16:08:32Z|s3://sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1579219200000/1579277206183.c1031d165a34.e4797d0.59eff416-3dcd-4b39-ba39-bf45dc4f041d.gz|segment_separator:37", "anonymousId": "9e54c91c-bffd-4fe9-a12b-0c08c1a55613", "channel": "client", "context": { "ip": "12.87.245.90", "library": { "name": "analytics.js", "version": "3.10.1" }, "locale": "en-US", "page": { "path": "/Salt-Lake-City-UT-self-storage.html", "referrer": "https://sparefoot.extrameter.com/?sftest=on", "search": "", "title": "15 Cheap Storage Units Salt Lake City, UT (from $19) | Compare & Save", "url": "https://www.sparefoot.extrameter.com/Salt-Lake-City-UT-self-storage.html" }, "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 11_0 like Mac OS X) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Mobile/15A372 Safari/604.1" }, "event": "modal open", "integrations": {}, "messageId": "ajs-b4d6298fb5cc39b4fed9684766805cef", "originalTimestamp": "2020-01-17T16:02:07.020Z", "projectId": "nQDzdrZI1K", "properties": { "Hit Timestamp": 1579276927019, "category": "missing category-cityLandingPage", "env": "stage", "isReact": true, "label": "missing label", "site_id": -1 }, "receivedAt": "2020-01-17T16:02:07.192Z", "sentAt": "2020-01-17T16:02:07.021Z", "timestamp": "2020-01-17T16:02:07.191Z", "type": "track", "userId": "7e40f0c2e0adeb868559de8e8c6c9955", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "_origin": "string", "anonymousId": "string", "channel": "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.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "original_key": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 256
- schema_scan_id: 2524032
- updated: 2020-01-17 10:11:11
-
Version 203234
- created: 2019-04-30 15:00:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_modal_open`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_modal_open`\n(\n`timestamp`STRING,`userId`STRING,`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`receivedAt`STRING,`anonymousId`STRING,`original_key`STRING,`_origin`STRING,`properties`struct<`category`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`label`:STRING,`env`:STRING>,`projectId`STRING,`event`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`version`STRING,`originalTimestamp`STRING,`context`struct<`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>,`userAgent`:STRING>,`messageId`STRING,`type`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-reactfoot-stage/separated_dt/modal open'\n", "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_modal_open" ] - hive_path: s3://sfdl-segment-reactfoot-stage/separated_dt/modal open
- id: 203234
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2019-04-30T19:58:59Z|s3://sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1556582400000/1556654218298.f38b02cc5633.9f83b95.f7fc4b35-faff-4862-8c97-8aaecb43fb15.gz|segment_separator:37", "anonymousId": "724d91d2-1a92-48f6-a13a-51b3a0a1043b", "channel": "client", "context": { "ip": "34.239.223.223", "library": { "name": "unknown", "version": "unknown" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36" }, "event": "modal open", "integrations": { "campaign": {}, "library": { "name": "analytics.js", "version": "3.8.2" }, "page": { "path": "/Alexandria-VA-self-storage/Self-Storage-Plus-Alexandria-210968.html", "referrer": "", "search": "?sftest=on", "title": "Self Storage Plus - Alexandria | 4900 Eisenhower Avenue | SpareFoot", "url": "https://www.sparefoot.extrameter.com/Alexandria-VA-self-storage/Self-Storage-Plus-Alexandria-210968.html?sftest=on" } }, "messageId": "ajs-02f47765cd9c5037d444646d5d489b7b", "originalTimestamp": "2019-04-30T19:35:08.899Z", "projectId": "nQDzdrZI1K", "properties": { "Hit Timestamp": 1556652908898, "category": "missing category-facilityPage", "env": "stage", "isReact": true, "label": "missing label", "site_id": -1 }, "receivedAt": "2019-04-30T19:35:09.076Z", "sentAt": "2019-04-30T19:35:08.904Z", "timestamp": "2019-04-30T19:35:09.071Z", "type": "track", "userId": "c755a5e44f0c7e48079219f5f800c655", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "_origin": "string", "anonymousId": "string", "channel": "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", "event": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "original_key": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 256
- schema_scan_id: 2084996
- updated: 2019-04-30 15:00:54
-
Version 2988
- created: 2018-03-20 12:03:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_modal_open`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_modal_open`\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 ,`campaign` : struct< `source` : string , `medium` : string , `name` : string >,`page` : struct< `url` : string , `path` : string , `search` : string , `referrer` : string , `title` : string >,`library` : struct< `version` : string , `name` : string >, `userAgent` : string >, `projectId` string , `original_key` string , `_origin` string , `type` string ,`properties` struct< `category` : string , `Hit_Timestamp` : string , `isReact` : string , `site_id` : string , `label` : string , `env` : 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-reactfoot-stage/separated_dt/modal open'\n", "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_modal_open" ] - hive_path: s3://sfdl-segment-reactfoot-stage/separated_dt/modal open
- id: 2988
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "unbundled": [] }, "_origin": "2018-03-20T17:02:42Z|s3://sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1521504000000/1521565271149.958eee4cd4b2.1.11.1.44381ac2-ba51-481d-8272-d3c1bd3c4698.gz|segment_separator:33", "anonymousId": "a3171caa-fc99-49d6-83b3-0cf14193eb6e", "channel": "client", "context": { "campaign": { "medium": "email", "name": "20171124_1713_DYMI_SFDC_2_v3_trans", "source": "Emarsys" }, "ip": "34.239.223.223", "library": { "name": "analytics.js", "version": "3.4.0" }, "page": { "path": "/Austin-TX-self-storage/Storage-Usa-143177.html", "referrer": "", "search": "?sftest=on", "title": "Storage Usa - Austin, TX | SpareFoot", "url": "http://localhost:9000/Austin-TX-self-storage/Storage-Usa-143177.html?sftest=on" }, "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.162 Safari/537.36" }, "event": "modal open", "integrations": {}, "messageId": "ajs-332ad295f2cc55de07c369e303a96750", "originalTimestamp": "2018-03-20T16:38:12.443Z", "original_key": "sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1521417600000/1521471713790.216836cc3a73.1.11.1.03eaa7a2-f5ae-4574-aaae-06191678283e.gz", "projectId": "nQDzdrZI1K", "properties": { "Hit Timestamp": 1521563892442, "category": "missing category-oonFacilityPage", "env": "development", "isReact": true, "label": "missing label", "site_id": -1 }, "receivedAt": "2018-03-20T16:38:12.511Z", "sentAt": "2018-03-20T16:38:12.444Z", "timestamp": "2018-03-20T16:38:12.510Z", "type": "track", "userId": "f2f05832f6f41b16d23fe2e370f13b64", "version": 2 } - schema_attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "_origin": "string", "anonymousId": "string", "channel": "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", "event": "string", "messageId": "string", "originalTimestamp": "string", "original_key": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 256
- schema_scan_id: None
- updated: 2018-05-25 05:44:37
Schema Scans: 2
Last at 2020-01-17 10:09:57
-
Scan 2524032
- duration: 0:01:17.985933
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 316, "partitions_applied": false, "success": true } - id: 2524032
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2020-01-17/", "name": "dt", "type": "string", "value": "2020-01-17" }, "s3": { "bucket": "sfdl-segment-reactfoot-stage", "hive_path": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open", "key": "separated_dt/modal open/dt=2020-01-17/1579277206183.c1031d165a34.e4797d0.59eff416-3dcd-4b39-ba39-bf45dc4f041d.json.gz" }, "schema": { "name": "sfdl_stage_segment.reactfoot_modal_open", "type": "segment" } } - running: False
- schema_name_id: 256
- start_time: 2020-01-17 10:09:57
- success: True
- trace_id: 1947321588097941361
-
Scan 2084996
- duration: 0:00:51.764004
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 237, "partitions_applied": false, "success": true } - id: 2084996
- payload:
{ "datatype_dict": null, "file_format": "json", "partition": { "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2019-04-30/", "name": "dt", "type": "string", "value": "2019-04-30" }, "s3": { "bucket": "sfdl-segment-reactfoot-stage", "hive_path": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open", "key": "separated_dt/modal open/dt=2019-04-30/1556654218298.f38b02cc5633.9f83b95.f7fc4b35-faff-4862-8c97-8aaecb43fb15.json.gz" }, "schema": { "name": "sfdl_stage_segment.reactfoot_modal_open", "type": "segment" } } - running: False
- schema_name_id: 256
- start_time: 2019-04-30 15:00:07
- success: True
- trace_id: 11425816565999185492
- count: 4
- ddl:
[ "ALTER TABLE\n `sfdl_stage_segment.reactfoot_modal_open`\nADD\n\n\n PARTITION (dt='2021-01-20') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-20/'\n PARTITION (dt='2021-01-21') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-21/'\n PARTITION (dt='2021-01-22') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-22/'\n PARTITION (dt='2021-02-01') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-02-01/'\n;" ] - name: dt
- state:
[ { "info": { "id": 175517, "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-20/", "name": "dt", "value": "2021-01-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-01-20 17:17:02", "last_data": "2021-01-20 17:23:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 175604, "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-21/", "name": "dt", "value": "2021-01-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-01-21 09:11:08", "last_data": "2021-01-21 11:22:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 175643, "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-22/", "name": "dt", "value": "2021-01-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-01-21 19:20:24", "last_data": "2021-01-21 19:25:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 176687, "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-02-01/", "name": "dt", "value": "2021-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2021-02-01 17:31:23", "last_data": "2021-02-01 18:18:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_metadata.bundled": "", "_metadata.unbundled": " ", "_origin": "string", "anonymousId": "string", "channel": "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.locale": "string", "context.page.path": "string", "context.page.referrer": "string", "context.page.search": "string", "context.page.title": "string", "context.page.url": "string", "context.userAgent": "string", "event": "string", "integrations.library.name": "string", "integrations.library.version": "string", "integrations.page.path": "string", "integrations.page.referrer": "string", "integrations.page.search": "string", "integrations.page.title": "string", "integrations.page.url": "string", "messageId": "string", "originalTimestamp": "string", "original_key": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.category": "string", "properties.env": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2020-01-17 10:09:57
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_modal_open`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`_metadata`struct<`bundled`:array,`unbundled`:array >,`originalTimestamp`STRING,`context`struct<`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`search`:STRING,`url`:STRING,`title`:STRING>,`locale`:STRING,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>,`ip`:STRING>,`_origin`STRING,`original_key`STRING,`userId`STRING,`receivedAt`STRING,`version`STRING,`timestamp`STRING,`anonymousId`STRING,`messageId`STRING,`type`STRING,`event`STRING,`properties`struct<`env`:STRING,`isReact`:STRING,`category`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`label`:STRING>,`channel`STRING,`sentAt`STRING,`projectId`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-reactfoot-stage/separated_dt/modal open'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_modal_open`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_modal_open" }
- 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:03:29",
"disabled": false,
"format": "raw",
"id": 256,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_stage_segment",
"table": "reactfoot_modal_open"
},
"type": "segment"
},
"partition": {
"count": 4,
"ddl": [
"ALTER TABLE\n `sfdl_stage_segment.reactfoot_modal_open`\nADD\n\n\n PARTITION (dt='2021-01-20') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-20/'\n PARTITION (dt='2021-01-21') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-21/'\n PARTITION (dt='2021-01-22') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-22/'\n PARTITION (dt='2021-02-01') location 's3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-02-01/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 175517,
"location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-20/",
"name": "dt",
"value": "2021-01-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-01-20 17:17:02",
"last_data": "2021-01-20 17:23:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 175604,
"location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-21/",
"name": "dt",
"value": "2021-01-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-01-21 09:11:08",
"last_data": "2021-01-21 11:22:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 175643,
"location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-01-22/",
"name": "dt",
"value": "2021-01-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-01-21 19:20:24",
"last_data": "2021-01-21 19:25:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 176687,
"location": "s3://sfdl-segment-reactfoot-stage/separated_dt/modal open/dt=2021-02-01/",
"name": "dt",
"value": "2021-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2021-02-01 17:31:23",
"last_data": "2021-02-01 18:18:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_metadata.bundled": "",
"_metadata.unbundled": "",
"_origin": "string",
"anonymousId": "string",
"channel": "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.locale": "string",
"context.page.path": "string",
"context.page.referrer": "string",
"context.page.search": "string",
"context.page.title": "string",
"context.page.url": "string",
"context.userAgent": "string",
"event": "string",
"integrations.library.name": "string",
"integrations.library.version": "string",
"integrations.page.path": "string",
"integrations.page.referrer": "string",
"integrations.page.search": "string",
"integrations.page.title": "string",
"integrations.page.url": "string",
"messageId": "string",
"originalTimestamp": "string",
"original_key": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.category": "string",
"properties.env": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.site_id": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2020-01-17 10:09:57",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_modal_open`\n(\n`integrations`struct<`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`_metadata`struct<`bundled`:array,`unbundled`:array>,`originalTimestamp`STRING,`context`struct<`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`search`:STRING,`url`:STRING,`title`:STRING>,`locale`:STRING,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>,`ip`:STRING>,`_origin`STRING,`original_key`STRING,`userId`STRING,`receivedAt`STRING,`version`STRING,`timestamp`STRING,`anonymousId`STRING,`messageId`STRING,`type`STRING,`event`STRING,`properties`struct<`env`:STRING,`isReact`:STRING,`category`:STRING,`site_id`:STRING,`Hit_Timestamp`:STRING,`label`:STRING>,`channel`STRING,`sentAt`STRING,`projectId`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-reactfoot-stage/separated_dt/modal open'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_modal_open`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_modal_open"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}