Schema Info
Schema Name: sfdl_prod_segment.reactfoot_gtmextradata
- created: 2017-11-02 14:01:42
- disabled: False
- format: raw
- id: 126
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_prod_segment", "table": "reactfoot_gtmextradata" } - type: segment
Schema Versions: 3
-
Version 1256862
- created: 2025-04-07 23:58:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmextradata`\n(\n`integrations`struct<`Google_Analytics`:STRING>,`messageId`STRING,`type`STRING,`originalTimestamp`STRING,`sentAt`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`term`:STRING,`utm_content`:STRING,`conten`:STRING,`id`:STRING,`con`:STRING,`utm_medium`:STRING,`tm_source`:STRING,`medium`:STRING,`utm_source`:STRING,`so`:STRING,`utm_campaign`:STRING,`name`:STRING,`camp`:STRING,`m`:STRING>,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array,`unbundled`:array >,`properties`struct<`unit`:struct<`id`:STRING,`sizeText`:STRING,`price`:struct<`text`:STRING,`value`:STRING>>,`Hit_Timestamp`:STRING,`facility`:struct<`title`:STRING,`id`:STRING,`corporationType`:STRING>,`isReact`:STRING,`site_id`:STRING,`__cpLocation`:struct<`city`:STRING,`id`:STRING,`state`:STRING>,`env`:STRING,`booking`:struct<`omiPri`:STRING,`email`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`confirmationCode`:STRING,`npv`:STRING>,`pageType`:STRING,`location`:struct<`id`:STRING,`city`:STRING,`state`:STRING>,`contentId`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`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-prod/separated_dt/gtmExtraData'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData
- id: 1256862
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2025-04-08T04:57:26Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1744070400000/1744088234855.events-archiver-480-22..dc352b8e-e307-41ce-b754-35306caab4e0.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "afdc464f-3ae0-4a8a-a6b4-e9f7ad164ac4", "channel": "client", "context": { "campaign": { "content": "01302025_LAL_Reservers_OLD", "id": "120216509598370476_v2_s11", "medium": "paid", "name": "LM_SF_PROSP_CONVESION_WEB_V2", "source": "fb-SiteLink-1", "term": "120216509598700476", "tm_source": "facebook" }, "ip": "65.78.186.77", "library": { "name": "analytics.js", "version": "next-1.77.0" }, "locale": "en-US", "page": { "path": "/Rock-Hill-SC-self-storage.html", "referrer": "https://www.google.com/", "search": "", "title": "15 Cheap Self-Storage Units in Rock Hill, SC (From $19)", "url": "https://www.sparefoot.com/Rock-Hill-SC-self-storage.html" }, "timezone": "America/Los_Angeles", "userAgent": "Mozilla/5.0 (Linux; Android 14; SM-A156U Build/UP1A.231005.007; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/134.0.6998.170 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/506.1.0.74.27;IABMV/1;]", "userAgentData": { "brands": [ { "brand": "Samsung Internet", "version": "27.0" } ], "mobile": true, "platform": "Android" } }, "event": "gtmExtraData", "integrations": { "Google Analytics": false }, "messageId": "ajs-next-1744084791285-e69f4211-eece-4660-b768-baa5fc408776", "originalTimestamp": "2025-04-08T03:59:51.285Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1744084789609, "contentId": 4249, "env": "production", "facility": { "corporationType": "self-storage", "id": 237166, "title": "Storage Rentals of America - Carbondale - North Illinois Ave." }, "isReact": true, "location": { "city": "Rock Hill", "id": 23802153, "state": "SC" }, "pageType": "cityLandingPage", "site_id": -1 }, "receivedAt": "2025-04-08T03:59:52.331Z", "sentAt": "2025-04-08T03:59:51.714Z", "timestamp": "2025-04-08T03:59:51.902Z", "type": "track", "userId": "02f761ce9e473642b0069972b9766abe", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.camp": "string", "context.campaign.con": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.tm_source": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.__cpLocation.city": "string", "properties.__cpLocation.id": "string", "properties.__cpLocation.state": "string", "properties.booking.confirmationCode": "string", "properties.booking.email": "string", "properties.booking.npv": "string", "properties.booking.omiAttributes.facility": "string", "properties.booking.omiAttributes.organization": "string", "properties.booking.omiAttributes.provider": "string", "properties.booking.omiAttributes.reservation": "string", "properties.booking.omiAttributes.unit": "string", "properties.booking.omiPri": "string", "properties.contentId": "string", "properties.env": "string", "properties.facility.corporationType": "string", "properties.facility.id": "string", "properties.facility.title": "string", "properties.isReact": "string", "properties.location.city": "string", "properties.location.id": "string", "properties.location.state": "string", "properties.pageType": "string", "properties.site_id": "string", "properties.unit.id": "string", "properties.unit.price.text": "string", "properties.unit.price.value": "string", "properties.unit.sizeText": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 126
- schema_scan_id: 140187415
- updated: 2025-04-08 00:08:11
-
Version 1093145
- created: 2024-11-20 17:58:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmextradata`\n(\n`type`STRING,`integrations`struct<`Google_Analytics`:STRING>,`event`STRING,`userId`STRING,`anonymousId`STRING,`originalTimestamp`STRING,`_origin`STRING,`receivedAt`STRING,`timestamp`STRING,`messageId`STRING,`properties`struct<`isReact`:STRING,`env`:STRING,`unit`:struct<`id`:STRING,`sizeText`:STRING,`price`:struct<`text`:STRING,`value`:STRING>>,`contentId`:STRING,`facility`:struct<`title`:STRING,`corporationType`:STRING,`id`:STRING>,`pageType`:STRING,`booking`:struct<`omiPri`:STRING,`email`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`confirmationCode`:STRING,`npv`:STRING>,`Hit_Timestamp`:STRING,`site_id`:STRING,`location`:struct<`state`:STRING,`city`:STRING,`id`:STRING>,`__cpLocation`:struct<`city`:STRING,`id`:STRING,`state`:STRING>>,`sentAt`STRING,`version`STRING,`projectId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`context`struct<`ip`:STRING,`timezone`:STRING,`campaign`:struct<`source`:STRING,`medium`:STRING,`m`:STRING,`term`:STRING,`camp`:STRING,`utm_campaign`:STRING,`name`:STRING,`utm_content`:STRING,`so`:STRING,`utm_source`:STRING,`con`:STRING,`content`:STRING,`conten`:STRING,`id`:STRING,`utm_medium`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`url`:STRING,`referrer`:STRING,`search`:STRING>,`userAgent`:STRING,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`platform`:STRING,`brands`:array - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData
- id: 1093145
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2024-11-20T23:58:19Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1732060800000/1732147081901.events-archiver-480-33..bf789d38-bf2d-471d-8c6e-48d6160807ae.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "5313adb4-4a31-4499-ba67-2b42c33bb981", "channel": "client", "context": { "campaign": { "content": "Self Storage Interest", "id": "120212206740170476", "medium": "paid", "name": "SF Facebook|Storage Interest Audience", "source": "facebook", "term": "120212206740160476" }, "ip": "2600:1012:b063:16bc:44d1:ad2:595c:58e5", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-US", "page": { "path": "/Garden-Grove-CA-self-storage.html", "referrer": "https://www.google.com/", "search": "", "title": "15 Cheap Self-Storage Units in Garden Grove, CA (From $19)", "url": "https://www.sparefoot.com/Garden-Grove-CA-self-storage.html" }, "timezone": "America/Los_Angeles", "userAgent": "Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.6778.69 Mobile Safari/537.36 (compatible; AdsBot-Google-Mobile; +http://www.google.com/mobile/adsbot.html)", "userAgentData": { "brands": [ { "brand": "Not_A Brand", "version": "24" } ], "mobile": true, "platform": "Android" } }, "event": "gtmExtraData", "integrations": { "Google Analytics": false }, "messageId": "ajs-next-1732143962616-f0814202-8de2-4da8-abd2-bec2fd921aa5", "originalTimestamp": "2024-11-20T23:06:02.616Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1732143961963, "contentId": 4104, "env": "production", "facility": { "corporationType": "self-storage", "id": 220357, "title": "Midgard Self Storage - Savannah" }, "isReact": true, "location": { "city": "Garden Grove", "id": "23801825", "state": "CA" }, "pageType": "cityLandingPage", "site_id": -1 }, "receivedAt": "2024-11-20T23:06:03.361Z", "sentAt": "2024-11-20T23:06:02.648Z", "timestamp": "2024-11-20T23:06:03.329Z", "type": "track", "userId": "08d546226e42be0268f6c7e7b8872c1d", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.camp": "string", "context.campaign.con": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.__cpLocation.city": "string", "properties.__cpLocation.id": "string", "properties.__cpLocation.state": "string", "properties.booking.confirmationCode": "string", "properties.booking.email": "string", "properties.booking.npv": "string", "properties.booking.omiAttributes.facility": "string", "properties.booking.omiAttributes.organization": "string", "properties.booking.omiAttributes.provider": "string", "properties.booking.omiAttributes.reservation": "string", "properties.booking.omiAttributes.unit": "string", "properties.booking.omiPri": "string", "properties.contentId": "string", "properties.env": "string", "properties.facility.corporationType": "string", "properties.facility.id": "string", "properties.facility.title": "string", "properties.isReact": "string", "properties.location.city": "string", "properties.location.id": "string", "properties.location.state": "string", "properties.pageType": "string", "properties.site_id": "string", "properties.unit.id": "string", "properties.unit.price.text": "string", "properties.unit.price.value": "string", "properties.unit.sizeText": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 126
- schema_scan_id: 132037298
- updated: 2024-11-20 18:07:34
-
Version 1008864
- created: 2024-09-08 11:56:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmextradata`\n(\n`event`STRING,`sentAt`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`con`:STRING,`name`:STRING,`utm_content`:STRING,`so`:STRING,`utm_campaign`:STRING,`m`:STRING,`utm_source`:STRING,`camp`:STRING,`utm_medium`:STRING,`medium`:STRING,`source`:STRING,`content`:STRING,`conten`:STRING,`term`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING>,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`_origin`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData'\n", "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata" ] - hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData
- id: 1008864
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "59c55a4597f7a100011813be", "59c13c7c1386430001b3c90e" ], "unbundled": [] }, "_origin": "2024-09-08T16:56:11Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1725753600000/1725814494660.events-archiver-480-10..a49a598c-f2a6-42e1-93b5-e64c53752d51.gz|analytics-segment-separator-prod:$LATEST", "anonymousId": "2da14556-aba1-4c5f-9d9d-824d03cc4529", "channel": "client", "context": { "campaign": { "conten": "", "medium": "paidsearch", "name": "pro_national_nogeo_noproduct_dynamic", "source": "bing" }, "ip": "2600:100b:b01a:abcd:ac1d:508a:a208:6ec2", "library": { "name": "analytics.js", "version": "next-1.72.1" }, "locale": "en-US", "page": { "path": "/Springdale-AR-self-storage/climate-controlled.html", "referrer": "https://www.google.com/", "search": "?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=48255061618&cpgnid=611394405&ptaid=dsa-663064472388&mkwid=s60t5EyoY|pcrid|271766730672|pkw||pmt||pdv|m|pgrid|48255061618|cpgnid|611394405|ptaid|dsa-663064472388|adext|&gad_source=1&gclid=Cj0KCQjw8--2BhCHARIsAF_w1gyaIOJZLaIVOMT-kvO_oH-Dty0IJLe9js1tG2AYJ-gcavJcTcqkAFEaAnnxEALw_wcB", "title": "15 Best Climate Controlled Storage Units in Springdale, AR", "url": "https://www.sparefoot.com/Springdale-AR-self-storage/climate-controlled.html?tsid=google-ppc&utm_source=google&utm_medium=paidsearch&utm_campaign=SF+Google%7CGeneral%7CDynamic&pdv=m&pgrid=48255061618&cpgnid=611394405&ptaid=dsa-663064472388&mkwid=s60t5EyoY|pcrid|271766730672|pkw||pmt||pdv|m|pgrid|48255061618|cpgnid|611394405|ptaid|dsa-663064472388|adext|&gad_source=1&gclid=Cj0KCQjw8--2BhCHARIsAF_w1gyaIOJZLaIVOMT-kvO_oH-Dty0IJLe9js1tG2AYJ-gcavJcTcqkAFEaAnnxEALw_wcB" }, "timezone": "America/Chicago", "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Mobile Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "127" } ], "mobile": true, "platform": "Android" } }, "event": "gtmExtraData", "integrations": { "Google Analytics": false }, "messageId": "ajs-next-1725810972772-9932ee39-8905-441f-84a5-edc84254b2ed", "originalTimestamp": "2024-09-08T15:56:12.772Z", "projectId": "a0wkEvFBBK", "properties": { "Hit Timestamp": 1725810972105, "contentId": 290344, "env": "production", "facility": { "corporationType": "self-storage", "id": 203419, "title": "Rental Centers of America" }, "isReact": true, "location": { "city": "Springdale", "id": "23802147", "state": "AR" }, "pageType": "amenityLandingPage", "site_id": -1 }, "receivedAt": "2024-09-08T15:56:13.126Z", "sentAt": "2024-09-08T15:56:12.812Z", "timestamp": "2024-09-08T15:56:13.086Z", "type": "track", "userId": "3f45c8eaa30eca82f0534442ee90e2d8", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.camp": "string", "context.campaign.con": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.__cpLocation.city": "string", "properties.__cpLocation.id": "string", "properties.__cpLocation.state": "string", "properties.booking.confirmationCode": "string", "properties.booking.email": "string", "properties.booking.npv": "string", "properties.booking.omiAttributes.facility": "string", "properties.booking.omiAttributes.organization": "string", "properties.booking.omiAttributes.provider": "string", "properties.booking.omiAttributes.reservation": "string", "properties.booking.omiAttributes.unit": "string", "properties.booking.omiPri": "string", "properties.contentId": "string", "properties.env": "string", "properties.facility.corporationType": "string", "properties.facility.id": "string", "properties.facility.title": "string", "properties.isReact": "string", "properties.location.city": "string", "properties.location.id": "string", "properties.location.state": "string", "properties.pageType": "string", "properties.site_id": "string", "properties.unit.id": "string", "properties.unit.price.text": "string", "properties.unit.price.value": "string", "properties.unit.sizeText": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 126
- schema_scan_id: 126943463
- updated: 2024-09-08 12:04:50
Schema Scans: 3
Last at 2025-04-07 23:58:28
-
Scan 140187415
- duration: 0:04:45.594271
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2753, "partitions_applied": false, "success": true } - id: 140187415
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-04-08/", "name": "dt", "type": "string", "value": "2025-04-08" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData", "key": "separated_dt/gtmExtraData/dt=2025-04-08/1744088234855.events-archiver-480-22..dc352b8e-e307-41ce-b754-35306caab4e0.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_gtmExtraData", "type": "segment" } } - running: False
- schema_name_id: 126
- start_time: 2025-04-07 23:58:28
- success: True
- trace_id: 12671846170763594694
-
Scan 132037298
- duration: 0:09:03.105361
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 2614, "partitions_applied": false, "success": true } - id: 132037298
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2024-11-20/", "name": "dt", "type": "string", "value": "2024-11-20" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData", "key": "separated_dt/gtmExtraData/dt=2024-11-20/1732147081901.events-archiver-480-33..bf789d38-bf2d-471d-8c6e-48d6160807ae.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_gtmExtraData", "type": "segment" } } - running: False
- schema_name_id: 126
- start_time: 2024-11-20 17:58:40
- success: True
- trace_id: 10900791687669758770
-
Scan 126943463
- duration: 0:00:51.399743
- exit_message:
{ "exception": "failed to apply schema `Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.reactfoot_gtmextradata`\\n(\\n`event`STRING,`sentAt`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`con`:STRING,`name`:STRING,`utm_content`:STRING,`so`:STRING,`utm_campaign`:STRING,`m`:STRING,`utm_source`:STRING,`camp`:STRING,`utm_medium`:STRING,`medium`:STRING,`source`:STRING,`content`:STRING,`conten`:STRING,`term`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING>,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array,`unbundled`:array >,`_origin`STRING\\n)\\nPARTITIONED BY (dt string)\\nROW FORMAT SERDE\\n'org.openx.data.jsonserde.JsonSerDe'\\n \\nSTORED AS INPUTFORMAT\\n 'org.apache.hadoop.mapred.TextInputFormat'\\nOUTPUTFORMAT\\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\\nLOCATION\\n 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata']\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/table_generator.py\", line 24, in apply_latest_version\n self.runner.run_multi_query(schema_version.ddl, timeout=DDLQueueWorker.TIMEOUT)\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 133, in run_multi_query\n result = self.run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 51, in run_single_query\n return self._run_single_query(query, timeout, database)\n ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 120, in _run_single_query\n raise e\n File \"/usr/local/lib/python3.12/site-packages/stodl/athena_runner/runner.py\", line 103, in _run_single_query\n raise AthenaRunnerQueryException('Query failed: {} `{}`'.format(info['QueryExecution']['Status']['StateChangeReason'], query))\nstodl.athena_runner.exceptions.AthenaRunnerQueryException: Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata`\n\nDuring handling of the above exception, another exception occurred:\n\nTraceback (most recent call last):\n File \"/schema_manager/schema_generator/schema_scanner.py\", line 102, in scan\n response = service.run()\n ^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/process_hive_table.py\", line 98, in run\n response['ddl_changed'] = table_generator.run()\n ^^^^^^^^^^^^^^^^^^^^^\n File \"/schema_manager/schema_generator/table_generator.py\", line 35, in run\n self.apply_latest_version()\n File \"/schema_manager/schema_generator/table_generator.py\", line 26, in apply_latest_version\n raise Exception('failed to apply schema `{}`: {}'.format(e, schema_version.ddl))\nException: failed to apply schema `Query failed: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask `MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.reactfoot_gtmextradata`\\n(\\n`event`STRING,`sentAt`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`con`:STRING,`name`:STRING,`utm_content`:STRING,`so`:STRING,`utm_campaign`:STRING,`m`:STRING,`utm_source`:STRING,`camp`:STRING,`utm_medium`:STRING,`medium`:STRING,`source`:STRING,`content`:STRING,`conten`:STRING,`term`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING>,`locale`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array ,`unbundled`:array >,`_origin`STRING\\n)\\nPARTITIONED BY (dt string)\\nROW FORMAT SERDE\\n'org.openx.data.jsonserde.JsonSerDe'\\n \\nSTORED AS INPUTFORMAT\\n 'org.apache.hadoop.mapred.TextInputFormat'\\nOUTPUTFORMAT\\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\\nLOCATION\\n 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata']\n: Expecting value: line 1 column 1 (char 0)" } - id: 126943463
- payload:
{ "datatype_dict": null, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2024-09-08/", "name": "dt", "type": "string", "value": "2024-09-08" }, "s3": { "bucket": "sfdl-segment-reactfoot-prod", "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData", "key": "separated_dt/gtmExtraData/dt=2024-09-08/1725814494660.events-archiver-480-10..a49a598c-f2a6-42e1-93b5-e64c53752d51.json.gz" }, "schema": { "name": "sfdl_prod_segment.reactfoot_gtmExtraData", "type": "segment" } } - running: False
- schema_name_id: 126
- start_time: 2024-09-08 11:56:34
- success: False
- trace_id: 10133254650031303926
- count: 27
- ddl:
[ "ALTER TABLE\n `sfdl_prod_segment.reactfoot_gtmextradata`\nADD\n\n\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-20/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-23/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-28/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-03/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-15/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-30/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-04/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-12/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-14/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-20/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-29/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-04/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-07/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-14/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-16/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-19/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-03/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-10/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-13/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-17/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-02/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-15/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-25/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-28/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-04-03/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1596774, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 09:47:41", "last_data": "2025-10-20 09:47:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1597469, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 07:11:02", "last_data": "2025-10-23 07:11:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1598759, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 11:11:26", "last_data": "2025-10-28 11:19:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1600372, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 11:18:02", "last_data": "2025-11-03 17:58:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1603273, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 13:53:51", "last_data": "2025-11-15 13:56:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1609370, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-29 19:58:14", "last_data": "2025-11-29 19:58:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1610327, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 20:01:32", "last_data": "2025-12-03 20:01:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612503, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-11/", "name": "dt", "value": "2025-12-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-10 20:07:32", "last_data": "2025-12-10 20:07:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1612760, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-12/", "name": "dt", "value": "2025-12-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-11 22:51:33", "last_data": "2025-12-12 14:56:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1613282, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-14/", "name": "dt", "value": "2025-12-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-13 19:10:18", "last_data": "2025-12-13 19:10:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1617347, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-20/", "name": "dt", "value": "2025-12-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-20 13:00:58", "last_data": "2025-12-20 13:07:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1619244, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-29/", "name": "dt", "value": "2025-12-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-29 06:54:35", "last_data": "2025-12-29 06:54:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1620572, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-04/", "name": "dt", "value": "2026-01-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-04 08:00:23", "last_data": "2026-01-04 08:00:23" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1621179, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-07/", "name": "dt", "value": "2026-01-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-06 19:59:29", "last_data": "2026-01-06 19:59:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1622893, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-14/", "name": "dt", "value": "2026-01-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-14 06:43:38", "last_data": "2026-01-14 06:43:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1623353, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-16/", "name": "dt", "value": "2026-01-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-16 01:58:42", "last_data": "2026-01-16 01:58:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1626278, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-19/", "name": "dt", "value": "2026-01-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-01-18 18:55:02", "last_data": "2026-01-18 18:55:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1629810, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-03/", "name": "dt", "value": "2026-02-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-03 16:01:17", "last_data": "2026-02-03 16:01:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631347, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-10/", "name": "dt", "value": "2026-02-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-10 11:55:39", "last_data": "2026-02-10 11:55:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631886, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-12/", "name": "dt", "value": "2026-02-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 14:33:46", "last_data": "2026-02-12 14:33:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1631970, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-13/", "name": "dt", "value": "2026-02-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-12 20:56:42", "last_data": "2026-02-12 20:56:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1635185, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-17/", "name": "dt", "value": "2026-02-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-02-17 11:02:13", "last_data": "2026-02-17 11:02:13" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1641685, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-02/", "name": "dt", "value": "2026-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-02 14:48:23", "last_data": "2026-03-02 14:51:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1645996, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-15/", "name": "dt", "value": "2026-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-15 10:00:52", "last_data": "2026-03-15 10:00:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1649957, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-25/", "name": "dt", "value": "2026-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-24 21:59:44", "last_data": "2026-03-24 21:59:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1650770, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-28/", "name": "dt", "value": "2026-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-03-28 13:55:43", "last_data": "2026-03-28 13:55:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 1652737, "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-04-03/", "name": "dt", "value": "2026-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2026-04-03 12:55:07", "last_data": "2026-04-03 13:01:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.amp.id": "string", "context.campaign.camp": "string", "context.campaign.con": "string", "context.campaign.conten": "string", "context.campaign.content": "string", "context.campaign.id": "string", "context.campaign.m": "string", "context.campaign.medium": "string", "context.campaign.name": "string", "context.campaign.so": "string", "context.campaign.source": "string", "context.campaign.term": "string", "context.campaign.tm_source": "string", "context.campaign.utm_campaign": "string", "context.campaign.utm_content": "string", "context.campaign.utm_medium": "string", "context.campaign.utm_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.timezone": "string", "context.userAgent": "string", "context.userAgentData.brands": [ { "brand": "string", "version": "string" } ], "context.userAgentData.mobile": "string", "context.userAgentData.platform": "string", "event": "string", "integrations.Google_Analytics": "string", "messageId": "string", "originalTimestamp": "string", "projectId": "string", "properties.Hit_Timestamp": "string", "properties.__cpLocation.city": "string", "properties.__cpLocation.id": "string", "properties.__cpLocation.state": "string", "properties.booking.confirmationCode": "string", "properties.booking.email": "string", "properties.booking.npv": "string", "properties.booking.omiAttributes.facility": "string", "properties.booking.omiAttributes.organization": "string", "properties.booking.omiAttributes.provider": "string", "properties.booking.omiAttributes.reservation": "string", "properties.booking.omiAttributes.unit": "string", "properties.booking.omiPri": "string", "properties.contentId": "string", "properties.env": "string", "properties.facility.corporationType": "string", "properties.facility.id": "string", "properties.facility.title": "string", "properties.isReact": "string", "properties.location.city": "string", "properties.location.id": "string", "properties.location.state": "string", "properties.pageType": "string", "properties.site_id": "string", "properties.unit.id": "string", "properties.unit.price.text": "string", "properties.unit.price.value": "string", "properties.unit.sizeText": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2025-04-07 23:58:30
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmextradata`\n(\n`integrations`struct<`Google_Analytics`:STRING>,`messageId`STRING,`type`STRING,`originalTimestamp`STRING,`sentAt`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`term`:STRING,`utm_content`:STRING,`conten`:STRING,`id`:STRING,`con`:STRING,`utm_medium`:STRING,`tm_source`:STRING,`medium`:STRING,`utm_source`:STRING,`so`:STRING,`utm_campaign`:STRING,`name`:STRING,`camp`:STRING,`m`:STRING>,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array,`unbundled`:array >,`properties`struct<`unit`:struct<`id`:STRING,`sizeText`:STRING,`price`:struct<`text`:STRING,`value`:STRING>>,`Hit_Timestamp`:STRING,`facility`:struct<`title`:STRING,`id`:STRING,`corporationType`:STRING>,`isReact`:STRING,`site_id`:STRING,`__cpLocation`:struct<`city`:STRING,`id`:STRING,`state`:STRING>,`env`:STRING,`booking`:struct<`omiPri`:STRING,`email`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`confirmationCode`:STRING,`npv`:STRING>,`pageType`:STRING,`location`:struct<`id`:STRING,`city`:STRING,`state`:STRING>,`contentId`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`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-prod/separated_dt/gtmExtraData'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2017-11-02 14:01:42",
"disabled": false,
"format": "raw",
"id": 126,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_prod_segment",
"table": "reactfoot_gtmextradata"
},
"type": "segment"
},
"partition": {
"count": 27,
"ddl": [
"ALTER TABLE\n `sfdl_prod_segment.reactfoot_gtmextradata`\nADD\n\n\n PARTITION (dt='2025-10-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-20/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-23/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-28/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-03/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-15/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-30/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-04/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-11/'\n PARTITION (dt='2025-12-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-12/'\n PARTITION (dt='2025-12-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-14/'\n PARTITION (dt='2025-12-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-20/'\n PARTITION (dt='2025-12-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-29/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-04/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-07/'\n PARTITION (dt='2026-01-14') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-14/'\n PARTITION (dt='2026-01-16') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-16/'\n PARTITION (dt='2026-01-19') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-19/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-03/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-10/'\n PARTITION (dt='2026-02-12') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-12/'\n PARTITION (dt='2026-02-13') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-13/'\n PARTITION (dt='2026-02-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-17/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-02/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-15/'\n PARTITION (dt='2026-03-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-25/'\n PARTITION (dt='2026-03-28') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-28/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-04-03/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1596774,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 09:47:41",
"last_data": "2025-10-20 09:47:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1597469,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 07:11:02",
"last_data": "2025-10-23 07:11:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1598759,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 11:11:26",
"last_data": "2025-10-28 11:19:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1600372,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 11:18:02",
"last_data": "2025-11-03 17:58:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1603273,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 13:53:51",
"last_data": "2025-11-15 13:56:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1609370,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-29 19:58:14",
"last_data": "2025-11-29 19:58:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1610327,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 20:01:32",
"last_data": "2025-12-03 20:01:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612503,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-11/",
"name": "dt",
"value": "2025-12-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-10 20:07:32",
"last_data": "2025-12-10 20:07:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1612760,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-12/",
"name": "dt",
"value": "2025-12-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-11 22:51:33",
"last_data": "2025-12-12 14:56:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1613282,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-14/",
"name": "dt",
"value": "2025-12-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-13 19:10:18",
"last_data": "2025-12-13 19:10:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1617347,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-20/",
"name": "dt",
"value": "2025-12-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-20 13:00:58",
"last_data": "2025-12-20 13:07:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1619244,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2025-12-29/",
"name": "dt",
"value": "2025-12-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-29 06:54:35",
"last_data": "2025-12-29 06:54:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1620572,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-04/",
"name": "dt",
"value": "2026-01-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-04 08:00:23",
"last_data": "2026-01-04 08:00:23"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1621179,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-07/",
"name": "dt",
"value": "2026-01-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-06 19:59:29",
"last_data": "2026-01-06 19:59:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1622893,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-14/",
"name": "dt",
"value": "2026-01-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-14 06:43:38",
"last_data": "2026-01-14 06:43:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1623353,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-16/",
"name": "dt",
"value": "2026-01-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-16 01:58:42",
"last_data": "2026-01-16 01:58:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1626278,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-01-19/",
"name": "dt",
"value": "2026-01-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-01-18 18:55:02",
"last_data": "2026-01-18 18:55:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1629810,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-03/",
"name": "dt",
"value": "2026-02-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-03 16:01:17",
"last_data": "2026-02-03 16:01:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631347,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-10/",
"name": "dt",
"value": "2026-02-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-10 11:55:39",
"last_data": "2026-02-10 11:55:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631886,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-12/",
"name": "dt",
"value": "2026-02-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 14:33:46",
"last_data": "2026-02-12 14:33:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1631970,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-13/",
"name": "dt",
"value": "2026-02-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-12 20:56:42",
"last_data": "2026-02-12 20:56:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1635185,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-02-17/",
"name": "dt",
"value": "2026-02-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-02-17 11:02:13",
"last_data": "2026-02-17 11:02:13"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1641685,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-02/",
"name": "dt",
"value": "2026-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-02 14:48:23",
"last_data": "2026-03-02 14:51:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1645996,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-15/",
"name": "dt",
"value": "2026-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-15 10:00:52",
"last_data": "2026-03-15 10:00:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1649957,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-25/",
"name": "dt",
"value": "2026-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-24 21:59:44",
"last_data": "2026-03-24 21:59:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1650770,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-03-28/",
"name": "dt",
"value": "2026-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-03-28 13:55:43",
"last_data": "2026-03-28 13:55:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 1652737,
"location": "s3://sfdl-segment-reactfoot-prod/separated_dt/gtmExtraData/dt=2026-04-03/",
"name": "dt",
"value": "2026-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2026-04-03 12:55:07",
"last_data": "2026-04-03 13:01:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"anonymousId": "string",
"channel": "string",
"context.amp.id": "string",
"context.campaign.camp": "string",
"context.campaign.con": "string",
"context.campaign.conten": "string",
"context.campaign.content": "string",
"context.campaign.id": "string",
"context.campaign.m": "string",
"context.campaign.medium": "string",
"context.campaign.name": "string",
"context.campaign.so": "string",
"context.campaign.source": "string",
"context.campaign.term": "string",
"context.campaign.tm_source": "string",
"context.campaign.utm_campaign": "string",
"context.campaign.utm_content": "string",
"context.campaign.utm_medium": "string",
"context.campaign.utm_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.timezone": "string",
"context.userAgent": "string",
"context.userAgentData.brands": [
{
"brand": "string",
"version": "string"
}
],
"context.userAgentData.mobile": "string",
"context.userAgentData.platform": "string",
"event": "string",
"integrations.Google_Analytics": "string",
"messageId": "string",
"originalTimestamp": "string",
"projectId": "string",
"properties.Hit_Timestamp": "string",
"properties.__cpLocation.city": "string",
"properties.__cpLocation.id": "string",
"properties.__cpLocation.state": "string",
"properties.booking.confirmationCode": "string",
"properties.booking.email": "string",
"properties.booking.npv": "string",
"properties.booking.omiAttributes.facility": "string",
"properties.booking.omiAttributes.organization": "string",
"properties.booking.omiAttributes.provider": "string",
"properties.booking.omiAttributes.reservation": "string",
"properties.booking.omiAttributes.unit": "string",
"properties.booking.omiPri": "string",
"properties.contentId": "string",
"properties.env": "string",
"properties.facility.corporationType": "string",
"properties.facility.id": "string",
"properties.facility.title": "string",
"properties.isReact": "string",
"properties.location.city": "string",
"properties.location.id": "string",
"properties.location.state": "string",
"properties.pageType": "string",
"properties.site_id": "string",
"properties.unit.id": "string",
"properties.unit.price.text": "string",
"properties.unit.price.value": "string",
"properties.unit.sizeText": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2025-04-07 23:58:30",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_gtmextradata`\n(\n`integrations`struct<`Google_Analytics`:STRING>,`messageId`STRING,`type`STRING,`originalTimestamp`STRING,`sentAt`STRING,`timestamp`STRING,`_origin`STRING,`context`struct<`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`content`:STRING,`source`:STRING,`term`:STRING,`utm_content`:STRING,`conten`:STRING,`id`:STRING,`con`:STRING,`utm_medium`:STRING,`tm_source`:STRING,`medium`:STRING,`utm_source`:STRING,`so`:STRING,`utm_campaign`:STRING,`name`:STRING,`camp`:STRING,`m`:STRING>,`locale`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`timezone`:STRING,`page`:struct<`title`:STRING,`search`:STRING,`referrer`:STRING,`path`:STRING,`url`:STRING>,`ip`:STRING,`userAgent`:STRING>,`version`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`properties`struct<`unit`:struct<`id`:STRING,`sizeText`:STRING,`price`:struct<`text`:STRING,`value`:STRING>>,`Hit_Timestamp`:STRING,`facility`:struct<`title`:STRING,`id`:STRING,`corporationType`:STRING>,`isReact`:STRING,`site_id`:STRING,`__cpLocation`:struct<`city`:STRING,`id`:STRING,`state`:STRING>,`env`:STRING,`booking`:struct<`omiPri`:STRING,`email`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`confirmationCode`:STRING,`npv`:STRING>,`pageType`:STRING,`location`:struct<`id`:STRING,`city`:STRING,`state`:STRING>,`contentId`:STRING>,`projectId`STRING,`receivedAt`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`channel`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-prod/separated_dt/gtmExtraData'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_gtmextradata`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_gtmextradata"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}