Schema Info

Schema Name: sfdl_prod_segment.reactfoot_pty_facility_card_impression

created: 2020-12-14 09:12:10
disabled: False
format: raw
id: 814
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_prod_segment",
    "table": "reactfoot_pty_facility_card_impression"
}

type: segment

Schema Versions: 3

Version 1096515

created: 2024-11-23 09:48:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\n(\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`name`:STRING,`utm_content`:STRING,`id`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`utm_medium`:STRING,`content`:STRING,`source`: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>,`platform`:STRING>,`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING>,`properties`struct<`facility_id`:STRING,`isReact`:STRING,`delay`:STRING,`rank`:STRING,`env`:STRING,`label`:STRING,`Hit_Timestamp`:STRING,`searchId`:STRING,`search_id`:STRING,`index`:STRING,`cardType`:STRING,`category`:STRING,`in_network`:STRING,`visible_threshold`:STRING,`site_id`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`timestamp`STRING,`userId`STRING,`_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/pty_facility_card_impression'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression
id: 1096515
processed: 1

raw_data:

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-11-23T15:48:48Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1732320000000/1732376900384.events-archiver-480-39..68d61bb9-cb9e-426f-9caa-edb5253c6781.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "37c60440-7fed-4f3d-aec6-5553b11f1aea",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "Self Storage Interest",
            "id": "120212206740170476",
            "medium": "paid",
            "name": "SF Facebook|Storage Interest Audience",
            "source": "facebook",
            "term": "120212206740160476"
        },
        "ip": "54.190.186.224",
        "library": {
            "name": "analytics.js",
            "version": "next-1.76.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Hemet-CA-self-storage.html",
            "referrer": "",
            "search": "?location=92545&informedSearch=true&utm_source=facebook&utm_medium=paid&utm_campaign=SF+Facebook%7CStorage+Interest+Audience&utm_content=Self+Storage+Interest&utm_id=120212206740170476&utm_term=120212206740160476",
            "title": "15 Cheap Self-Storage Units in Hemet, CA (From $19)",
            "url": "https://www.sparefoot.com/Hemet-CA-self-storage.html?location=92545&informedSearch=true&utm_source=facebook&utm_medium=paid&utm_campaign=SF+Facebook%7CStorage+Interest+Audience&utm_content=Self+Storage+Interest&utm_id=120212206740170476&utm_term=120212206740160476"
        },
        "timezone": "America/Los_Angeles",
        "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Mobile Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Chromium",
                    "version": "130"
                },
                {
                    "brand": "Google Chrome",
                    "version": "130"
                },
                {
                    "brand": "Not?A_Brand",
                    "version": "99"
                }
            ],
            "mobile": true,
            "platform": "Android"
        }
    },
    "event": "pty_facility_card_impression",
    "integrations": {},
    "messageId": "ajs-next-1732373382241-37265cd6-9de0-4b92-87ee-ea96e31fd5bb",
    "originalTimestamp": "2024-11-23T14:49:42.241Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1732373382240,
        "cardType": "topYielderCard",
        "category": "facility list-cityLandingPage",
        "delay": 1000,
        "env": "production",
        "facility_id": 231073,
        "in_network": true,
        "index": 1,
        "isReact": true,
        "label": "pty-facility card",
        "rank": 1,
        "searchId": "e5ce674144a9d11e11.60951778",
        "search_id": "e5ce674144a9d11e11.60951778",
        "site_id": -1,
        "visible_threshold": 70
    },
    "receivedAt": "2024-11-23T14:49:42.697Z",
    "sentAt": "2024-11-23T14:49:42.248Z",
    "timestamp": "2024-11-23T14:49:42.690Z",
    "type": "track",
    "userId": "7345bcb7401b9811b19841ddbf4b50c4",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.conten": "string",
    "context.campaign.content": "string",
    "context.campaign.id": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.cardType": "string",
    "properties.category": "string",
    "properties.delay": "string",
    "properties.env": "string",
    "properties.facility_id": "string",
    "properties.in_network": "string",
    "properties.index": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.rank": "string",
    "properties.searchId": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.visible_threshold": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 814
schema_scan_id: 132217023
updated: 2024-11-23 09:54:05

Version 962541

created: 2024-07-30 17:53:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\n(\n`channel`STRING,`_origin`STRING,`type`STRING,`sentAt`STRING,`projectId`STRING,`context`struct<`locale`:STRING,`campaign`:struct<`name`:STRING,`utm_source`:STRING,`utm_content`:STRING,`term`:STRING,`utm_medium`:STRING,`medium`:STRING,`conten`:STRING,`utm_campaign`:STRING,`source`:STRING,`content`:STRING>,`timezone`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgent`:STRING,`amp`:struct<`id`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`search`:STRING,`url`:STRING,`referrer`:STRING>,`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>>,`event`STRING,`anonymousId`STRING,`timestamp`STRING,`receivedAt`STRING,`originalTimestamp`STRING,`properties`struct<`in_network`:STRING,`site_id`:STRING,`delay`:STRING,`index`:STRING,`visible_threshold`:STRING,`category`:STRING,`isReact`:STRING,`searchId`:STRING,`search_id`:STRING,`label`:STRING,`facility_id`:STRING,`Hit_Timestamp`:STRING,`cardType`:STRING,`rank`:STRING,`env`:STRING>,`userId`STRING,`version`STRING,`messageId`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/pty_facility_card_impression'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression
id: 962541
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-07-30T22:52:52Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1722297600000/1722379897160.events-archiver-480-10..0bd6e87a-08b9-4f8e-b4db-e80d94e698e5.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "cae59748-9efb-4f53-b61b-37c40cc24c37",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "",
            "medium": "paidsearch",
            "name": "pro_national_nogeo_noproduct_dynamic",
            "source": "bing",
            "term": "sparefoot"
        },
        "ip": "71.31.96.153",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/Fort-Myers-FL-self-storage/rv-storage.html",
            "referrer": "https://search.yahoo.com/",
            "search": "?tsid=bing-ppc&cid=pro_national_nogeo_noproduct_dynamic&utm_source=bing&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=45112&iloc=45372&mkwid=0tUTQ06e|pcrid|76759736644199|pkw|sparefoot|pmt|bb|pdv|m|pgrid|1228154634946515|ptaid|dat-2328559469250676:loc-190&pgrid=1228154634946515&ptaid=dat-2328559469250676:loc-190&msclkid=989bff4fa256151232bc99e6c2a7f0a4&utm_term=sparefoot",
            "title": "10 Cheap RV Storage Facilities Near Fort Myers, FL on Sparefoot",
            "url": "https://www.sparefoot.com/Fort-Myers-FL-self-storage/rv-storage.html?tsid=bing-ppc&cid=pro_national_nogeo_noproduct_dynamic&utm_source=bing&utm_medium=paidsearch&utm_campaign=pro_national_nogeo_noproduct_dynamic&utm_content=&ploc=45112&iloc=45372&mkwid=0tUTQ06e|pcrid|76759736644199|pkw|sparefoot|pmt|bb|pdv|m|pgrid|1228154634946515|ptaid|dat-2328559469250676:loc-190&pgrid=1228154634946515&ptaid=dat-2328559469250676:loc-190&msclkid=989bff4fa256151232bc99e6c2a7f0a4&utm_term=sparefoot"
        },
        "timezone": "America/New_York",
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Not=A?Brand",
                    "version": "99"
                }
            ],
            "mobile": false,
            "platform": "Windows"
        }
    },
    "event": "pty_facility_card_impression",
    "integrations": {},
    "messageId": "ajs-next-1722376451265-448a4520-427d-4907-8065-ccfd256be06f",
    "originalTimestamp": "2024-07-30T21:54:11.265Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1722376451265,
        "cardType": "topYielderCard",
        "category": "facility list-vehicleLandingPage",
        "delay": 1000,
        "env": "production",
        "facility_id": 221282,
        "in_network": true,
        "isReact": true,
        "label": "pty-facility card",
        "searchId": "ee0a66a960f4c7bb49.99031243",
        "search_id": "ee0a66a960f4c7bb49.99031243",
        "site_id": -1,
        "visible_threshold": 70
    },
    "receivedAt": "2024-07-30T21:54:11.604Z",
    "sentAt": "2024-07-30T21:54:11.270Z",
    "timestamp": "2024-07-30T21:54:11.599Z",
    "type": "track",
    "userId": "093fac9fbb427b0a91c2d1e7c0694a93",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.conten": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.cardType": "string",
    "properties.category": "string",
    "properties.delay": "string",
    "properties.env": "string",
    "properties.facility_id": "string",
    "properties.in_network": "string",
    "properties.index": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.rank": "string",
    "properties.searchId": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.visible_threshold": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 814
schema_scan_id: 124132342
updated: 2024-07-30 17:54:43

Version 677162

created: 2023-11-16 17:06:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\n(\n`type`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`anonymousId`STRING,`messageId`STRING,`event`STRING,`version`STRING,`properties`struct<`category`:STRING,`search_id`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING,`index`:STRING,`env`:STRING,`in_network`:STRING,`cardType`:STRING,`searchId`:STRING,`isReact`:STRING,`facility_id`:STRING,`delay`:STRING,`label`:STRING,`visible_threshold`:STRING,`rank`:STRING>,`context`struct<`campaign`:struct<`utm_campaign`:STRING,`name`:STRING,`utm_medium`:STRING,`utm_content`:STRING,`utm_source`:STRING,`conten`:STRING,`medium`:STRING,`source`:STRING,`content`:STRING>,`page`:struct<`title`:STRING,`path`:STRING,`referrer`:STRING,`url`:STRING,`search`:STRING>,`ip`:STRING,`userAgentData`:struct<`brands`:array>,`platform`:STRING,`mobile`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`timezone`:STRING,`amp`:struct<`id`:STRING>,`locale`:STRING,`userAgent`:STRING>,`timestamp`STRING,`sentAt`STRING,`projectId`STRING,`channel`STRING,`_origin`STRING,`userId`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/pty_facility_card_impression'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression
id: 677162
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2023-11-16T22:57:43Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1700092800000/1700175429163.events-archiver-480-21..984013d9-01b9-45a9-b4ab-608831676526.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "1a483d93-3653-4ed0-8d36-bdbe55010acb",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "159.118.149.249",
        "library": {
            "name": "analytics.js",
            "version": "next-1.55.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Indianapolis-IN-self-storage/car-storage.html",
            "referrer": "https://www.google.com/",
            "search": "",
            "title": "10 Cheap Car Storage Units & Vehicle Parking Indianapolis, IN",
            "url": "https://www.sparefoot.com/Indianapolis-IN-self-storage/car-storage.html"
        },
        "timezone": "America/New_York",
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Google Chrome",
                    "version": "119"
                },
                {
                    "brand": "Chromium",
                    "version": "119"
                },
                {
                    "brand": "Not?A_Brand",
                    "version": "24"
                }
            ],
            "mobile": false,
            "platform": "Windows"
        }
    },
    "event": "pty_facility_card_impression",
    "integrations": {},
    "messageId": "ajs-next-5b943dbab041eb23c682a421608f5e55",
    "originalTimestamp": "2023-11-16T22:03:43.327Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1700172223325,
        "cardType": "topYielderCard",
        "category": "facility list-vehicleLandingPage",
        "delay": 1000,
        "env": "production",
        "facility_id": 215784,
        "in_network": true,
        "isReact": true,
        "label": "pty-facility card",
        "searchId": "a248655691b6b33cb4.81434021",
        "search_id": "a248655691b6b33cb4.81434021",
        "site_id": -1,
        "visible_threshold": 70
    },
    "receivedAt": "2023-11-16T22:03:43.649Z",
    "sentAt": "2023-11-16T22:03:43.339Z",
    "timestamp": "2023-11-16T22:03:43.637Z",
    "type": "track",
    "userId": "341c7595af2b33ad3d1d2b52c019ac46",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.conten": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.cardType": "string",
    "properties.category": "string",
    "properties.delay": "string",
    "properties.env": "string",
    "properties.facility_id": "string",
    "properties.in_network": "string",
    "properties.index": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.rank": "string",
    "properties.searchId": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.visible_threshold": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 814
schema_scan_id: 106050139
updated: 2023-11-16 17:19:19

Schema Scans: 3

Last at 2024-11-23 09:48:58

Scan 132217023

duration: 0:00:38.400949

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_pty_facility_card_impression``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\\n(\\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`name`:STRING,`utm_content`:STRING,`id`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`utm_medium`:STRING,`content`:STRING,`source`: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>,`platform`:STRING>,`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING>,`properties`struct<`facility_id`:STRING,`isReact`:STRING,`delay`:STRING,`rank`:STRING,`env`:STRING,`label`:STRING,`Hit_Timestamp`:STRING,`searchId`:STRING,`search_id`:STRING,`index`:STRING,`cardType`:STRING,`category`:STRING,`in_network`:STRING,`visible_threshold`:STRING,`site_id`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`timestamp`STRING,`userId`STRING,`_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/pty_facility_card_impression'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression']\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_pty_facility_card_impression`\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_pty_facility_card_impression``: ['CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`', 'DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`', \"CREATE EXTERNAL TABLE IF NOT EXISTS\\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\\n(\\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`name`:STRING,`utm_content`:STRING,`id`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`utm_medium`:STRING,`content`:STRING,`source`: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>,`platform`:STRING>,`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING>,`properties`struct<`facility_id`:STRING,`isReact`:STRING,`delay`:STRING,`rank`:STRING,`env`:STRING,`label`:STRING,`Hit_Timestamp`:STRING,`searchId`:STRING,`search_id`:STRING,`index`:STRING,`cardType`:STRING,`category`:STRING,`in_network`:STRING,`visible_threshold`:STRING,`site_id`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`timestamp`STRING,`userId`STRING,`_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/pty_facility_card_impression'\\n\", 'MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression']\n: Expecting value: line 1 column 1 (char 0)"
}

id: 132217023

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2024-11-23/",
        "name": "dt",
        "type": "string",
        "value": "2024-11-23"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression",
        "key": "separated_dt/pty_facility_card_impression/dt=2024-11-23/1732376900384.events-archiver-480-39..68d61bb9-cb9e-426f-9caa-edb5253c6781.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_pty_facility_card_impression",
        "type": "segment"
    }
}

running: False
schema_name_id: 814
start_time: 2024-11-23 09:48:58
success: False
trace_id: 6460521355667624744

Scan 124132342

duration: 0:00:41.196903

exit_message:

{
    "exception": "Query failed: FAILED: SemanticException [Error 10001]: Table not found sfdl_prod_segment.reactfoot_pty_facility_card_impression `SHOW PARTITIONS `sfdl_prod_segment.reactfoot_pty_facility_card_impression``\nTraceback (most recent call last):\n  File \"/schema_manager/schema_generator/schema_scanner.py\", line 102, in scan\n    response = service.run()\n  File \"/schema_manager/schema_generator/process_hive_table.py\", line 105, in run\n    response['ingested_partitions'] = pi.run()  # *total* current number of partitions in the table\n  File \"/schema_manager/schema_manager/service/partition_ingester.py\", line 17, in run\n    result = self.runner.run_single_query(ddl, timeout=ATHENA_TIMEOUT)\n  File \"/src/athena-runner/athena_runner/runner.py\", line 51, in run_single_query\n    return self._run_single_query(query, timeout, database)\n  File \"/src/athena-runner/athena_runner/runner.py\", line 120, in _run_single_query\n    raise e\n  File \"/src/athena-runner/athena_runner/runner.py\", line 103, in _run_single_query\n    raise AthenaRunnerQueryException('Query failed: {} `{}`'.format(info['QueryExecution']['Status']['StateChangeReason'], query))\nathena_runner.exceptions.AthenaRunnerQueryException: Query failed: FAILED: SemanticException [Error 10001]: Table not found sfdl_prod_segment.reactfoot_pty_facility_card_impression `SHOW PARTITIONS `sfdl_prod_segment.reactfoot_pty_facility_card_impression``\n: Expecting value: line 1 column 1 (char 0)"
}

id: 124132342

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2024-07-30/",
        "name": "dt",
        "type": "string",
        "value": "2024-07-30"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression",
        "key": "separated_dt/pty_facility_card_impression/dt=2024-07-30/1722379897160.events-archiver-480-10..0bd6e87a-08b9-4f8e-b4db-e80d94e698e5.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_pty_facility_card_impression",
        "type": "segment"
    }
}

running: False
schema_name_id: 814
start_time: 2024-07-30 17:53:34
success: False
trace_id: 13617629208773654775

Scan 106050139

duration: 0:07:42.215378

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 1068,
    "partitions_applied": false,
    "success": true
}

id: 106050139

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2023-11-16/",
        "name": "dt",
        "type": "string",
        "value": "2023-11-16"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression",
        "key": "separated_dt/pty_facility_card_impression/dt=2023-11-16/1700175429163.events-archiver-480-21..984013d9-01b9-45a9-b4ab-608831676526.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_pty_facility_card_impression",
        "type": "segment"
    }
}

running: False
schema_name_id: 814
start_time: 2023-11-16 17:06:32
success: True
trace_id: 3145305121549723877

Partitions:

count: 6

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_pty_facility_card_impression`\nADD\n\n\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-02/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-27/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-12-17/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-02-25/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-11/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-15/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 1600137,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-02/",
            "name": "dt",
            "value": "2025-11-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-02 14:05:35",
                "last_data": "2025-11-02 14:13:35"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1608701,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-27/",
            "name": "dt",
            "value": "2025-11-27"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-27 01:04:26",
                "last_data": "2025-11-27 01:04:26"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1616547,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-12-17/",
            "name": "dt",
            "value": "2025-12-17"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-16 22:13:20",
                "last_data": "2025-12-16 22:13:20"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1637099,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-02-25/",
            "name": "dt",
            "value": "2026-02-25"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-25 11:31:51",
                "last_data": "2026-02-25 11:31:51"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1645142,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-11/",
            "name": "dt",
            "value": "2026-03-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-11 10:56:00",
                "last_data": "2026-03-11 10:56:00"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1645994,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-15/",
            "name": "dt",
            "value": "2026-03-15"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-15 09:47:58",
                "last_data": "2026-03-15 09:47:58"
            },
            "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.conten": "string",
    "context.campaign.content": "string",
    "context.campaign.id": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "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",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.cardType": "string",
    "properties.category": "string",
    "properties.delay": "string",
    "properties.env": "string",
    "properties.facility_id": "string",
    "properties.in_network": "string",
    "properties.index": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.rank": "string",
    "properties.searchId": "string",
    "properties.search_id": "string",
    "properties.site_id": "string",
    "properties.visible_threshold": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2024-11-23 09:48:59

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\n(\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`name`:STRING,`utm_content`:STRING,`id`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`utm_medium`:STRING,`content`:STRING,`source`: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>,`platform`:STRING>,`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING>,`properties`struct<`facility_id`:STRING,`isReact`:STRING,`delay`:STRING,`rank`:STRING,`env`:STRING,`label`:STRING,`Hit_Timestamp`:STRING,`searchId`:STRING,`search_id`:STRING,`index`:STRING,`cardType`:STRING,`category`:STRING,`in_network`:STRING,`visible_threshold`:STRING,`site_id`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`timestamp`STRING,`userId`STRING,`_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/pty_facility_card_impression'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2020-12-14 09:12:10",
        "disabled": false,
        "format": "raw",
        "id": 814,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "reactfoot_pty_facility_card_impression"
        },
        "type": "segment"
    },
    "partition": {
        "count": 6,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_pty_facility_card_impression`\nADD\n\n\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-02/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-27/'\n PARTITION (dt='2025-12-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-12-17/'\n PARTITION (dt='2026-02-25') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-02-25/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-11/'\n PARTITION (dt='2026-03-15') location 's3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-15/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1600137,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-02/",
                    "name": "dt",
                    "value": "2025-11-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-02 14:05:35",
                        "last_data": "2025-11-02 14:13:35"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1608701,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-11-27/",
                    "name": "dt",
                    "value": "2025-11-27"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-27 01:04:26",
                        "last_data": "2025-11-27 01:04:26"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1616547,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2025-12-17/",
                    "name": "dt",
                    "value": "2025-12-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-16 22:13:20",
                        "last_data": "2025-12-16 22:13:20"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1637099,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-02-25/",
                    "name": "dt",
                    "value": "2026-02-25"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-25 11:31:51",
                        "last_data": "2026-02-25 11:31:51"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1645142,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-11/",
                    "name": "dt",
                    "value": "2026-03-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-11 10:56:00",
                        "last_data": "2026-03-11 10:56:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1645994,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/pty_facility_card_impression/dt=2026-03-15/",
                    "name": "dt",
                    "value": "2026-03-15"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-15 09:47:58",
                        "last_data": "2026-03-15 09:47:58"
                    },
                    "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.conten": "string",
            "context.campaign.content": "string",
            "context.campaign.id": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "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",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.cardType": "string",
            "properties.category": "string",
            "properties.delay": "string",
            "properties.env": "string",
            "properties.facility_id": "string",
            "properties.in_network": "string",
            "properties.index": "string",
            "properties.isReact": "string",
            "properties.label": "string",
            "properties.rank": "string",
            "properties.searchId": "string",
            "properties.search_id": "string",
            "properties.site_id": "string",
            "properties.visible_threshold": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2024-11-23 09:48:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_pty_facility_card_impression`\n(\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`context`struct<`userAgent`:STRING,`campaign`:struct<`name`:STRING,`utm_content`:STRING,`id`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`utm_medium`:STRING,`content`:STRING,`source`: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>,`platform`:STRING>,`amp`:struct<`id`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING>,`properties`struct<`facility_id`:STRING,`isReact`:STRING,`delay`:STRING,`rank`:STRING,`env`:STRING,`label`:STRING,`Hit_Timestamp`:STRING,`searchId`:STRING,`search_id`:STRING,`index`:STRING,`cardType`:STRING,`category`:STRING,`in_network`:STRING,`visible_threshold`:STRING,`site_id`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`timestamp`STRING,`userId`STRING,`_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/pty_facility_card_impression'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_pty_facility_card_impression`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_pty_facility_card_impression"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}