Schema Info

Schema Name: sfdl_prod_segment.reactfoot_omi_hero_impression

created: 2024-08-15 11:46:24
disabled: False
format: raw
id: 1983
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 3

Version 1137100

created: 2024-12-26 06:02:16

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression
id: 1137100
processed: 1

raw_data:

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-12-26T12:01:40Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1735171200000/1735214477191.events-archiver-480-36..1eb90a78-4070-49c7-a654-023934d9392e.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "ffb1563d-3f3c-441a-b7ab-375f177dd34a",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "Non Reservers| 30 Days",
            "id": "120211029826580476",
            "medium": "paid",
            "name": "SF Facebook|General|Remarketing",
            "source": "facebook",
            "term": "120211029826540476"
        },
        "ip": "2603:8080:2900:38b5:85e:8d13:e4f6:dc0a",
        "library": {
            "name": "analytics.js",
            "version": "next-1.76.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/reservation/confirmation/W9QQA97A6",
            "referrer": "",
            "search": "?fbclid=IwY2xjawHaJKBleHRuA2FlbQEwAGFkaWQBqxNMlm3MTAEdhxK-TLZy-wSeYwEN_hDy0yWFRoJtYwiEV9ZaMT5Ir_vHwc_k9Mtnhvxq_aem_PHV48UG4iA2T9YuAesQpjw&utm_source=facebook&utm_medium=paid&utm_campaign=SF%20Facebook%7CGeneral%7CRemarketing&utm_term=120211029826540476&utm_content=Non%20Reservers%7C%2030%20Days&utm_id=120211029826580476",
            "title": "Public Storage - Austin - 8101 N Lamar Blvd | 8101 N Lamar Blvd | SpareFoot",
            "url": "https://www.sparefoot.com/reservation/confirmation/W9QQA97A6?fbclid=IwY2xjawHaJKBleHRuA2FlbQEwAGFkaWQBqxNMlm3MTAEdhxK-TLZy-wSeYwEN_hDy0yWFRoJtYwiEV9ZaMT5Ir_vHwc_k9Mtnhvxq_aem_PHV48UG4iA2T9YuAesQpjw&utm_source=facebook&utm_medium=paid&utm_campaign=SF%20Facebook%7CGeneral%7CRemarketing&utm_term=120211029826540476&utm_content=Non%20Reservers%7C%2030%20Days&utm_id=120211029826580476"
        },
        "timezone": "America/Chicago",
        "userAgent": "Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Google Chrome",
                    "version": "131"
                },
                {
                    "brand": "Chromium",
                    "version": "131"
                },
                {
                    "brand": "Not_A Brand",
                    "version": "24"
                }
            ],
            "mobile": true,
            "platform": "Android"
        }
    },
    "event": "omi_hero_impression",
    "integrations": {},
    "messageId": "ajs-next-1735214419069-177dd34a-ae96-40f7-ae29-f347109d206c",
    "originalTimestamp": "2024-12-26T12:00:19.069Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1735214419069,
        "category": "Omi hero rendered-confirmationPage",
        "env": "production",
        "isReact": true,
        "label": "omi hero impression",
        "site_id": -1
    },
    "receivedAt": "2024-12-26T12:00:19.138Z",
    "sentAt": "2024-12-26T12:00:19.079Z",
    "timestamp": "2024-12-26T12:00:19.128Z",
    "type": "track",
    "userId": "adb8660f35cd8df26c71c9f8f2ff254d",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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.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.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 1983
schema_scan_id: 134232916
updated: 2024-12-26 06:02:32

Version 996172

created: 2024-08-28 09:34:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_omi_hero_impression`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_omi_hero_impression`\n(\n`timestamp`STRING,`anonymousId`STRING,`context`struct<`locale`:STRING,`page`:struct<`url`:STRING,`search`:STRING,`title`:STRING,`referrer`:STRING,`path`:STRING>,`userAgent`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>,`campaign`:struct<`source`:STRING,`name`:STRING,`content`:STRING,`medium`:STRING,`term`:STRING>,`timezone`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`ip`:STRING>,`receivedAt`STRING,`type`STRING,`event`STRING,`sentAt`STRING,`messageId`STRING,`_origin`STRING,`originalTimestamp`STRING,`userId`STRING,`version`STRING,`properties`struct<`label`:STRING,`category`:STRING,`isReact`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`site_id`:STRING>,`projectId`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/omi_hero_impression'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_omi_hero_impression"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression
id: 996172
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-08-28T14:33:46Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1724803200000/1724855585441.events-archiver-480-5..be2ef768-f211-41a2-938b-267c365b7f33.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "f8165810-78cc-40ee-91d3-497370cb6e94",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "Non Reservers| 30 Days",
            "medium": "paid",
            "name": "SF Facebook|General|Remarketing",
            "source": "facebook",
            "term": "120211029826540476"
        },
        "ip": "2a09:bac2:61c9:1846::26b:39",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/reservation/confirmation/SD56SX3AN",
            "referrer": "",
            "search": "?utm_source=facebook&utm_medium=paid&utm_campaign=SF+Facebook%7CGeneral%7CRemarketing&utm_content=Non+Reservers%7C+30+Days&utm_term=120211029826540476",
            "title": "StorQuest - Paramount / Rosecrans | 7540 Rosecrans Avenue | SpareFoot",
            "url": "https://www.sparefoot.com/reservation/confirmation/SD56SX3AN?utm_source=facebook&utm_medium=paid&utm_campaign=SF+Facebook%7CGeneral%7CRemarketing&utm_content=Non+Reservers%7C+30+Days&utm_term=120211029826540476"
        },
        "timezone": "America/Los_Angeles",
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 18_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.0 Mobile/15E148 Safari/604.1"
    },
    "event": "omi_hero_impression",
    "integrations": {},
    "messageId": "ajs-next-1724853804492-c4a8a4df-bb60-47cd-b9d3-8c1c7a02a87b",
    "originalTimestamp": "2024-08-28T14:03:24.492Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1724853804492,
        "category": "Omi hero rendered-confirmationPage",
        "env": "production",
        "isReact": true,
        "label": "omi hero impression",
        "site_id": -1
    },
    "receivedAt": "2024-08-28T14:03:24.838Z",
    "sentAt": "2024-08-28T14:03:24.494Z",
    "timestamp": "2024-08-28T14:03:24.836Z",
    "type": "track",
    "userId": "21ba3cc03ef6e7db60fc9a7420c5207e",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 1983
schema_scan_id: 126156300
updated: 2024-08-28 09:34:21

Version 983224

created: 2024-08-17 12:57:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_omi_hero_impression`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_omi_hero_impression`\n(\n`event`STRING,`projectId`STRING,`channel`STRING,`sentAt`STRING,`messageId`STRING,`version`STRING,`type`STRING,`properties`struct<`isReact`:STRING,`category`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`label`:STRING,`site_id`:STRING>,`context`struct<`userAgent`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`page`:struct<`referrer`:STRING,`path`:STRING,`title`:STRING,`search`:STRING,`url`:STRING>,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>,`locale`:STRING,`timezone`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`_origin`STRING,`receivedAt`STRING,`userId`STRING,`timestamp`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/omi_hero_impression'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_omi_hero_impression"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression
id: 983224
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2024-08-17T17:55:44Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1723852800000/1723917325513.events-archiver-480-57..f6733cb6-691c-4b67-8298-564b60112cb1.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "2ca7f626-4332-49ad-a993-29176b5b957b",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "mic_1",
            "medium": "email_transa",
            "name": "post_res"
        },
        "ip": "2600:1700:aa80:90b0:690f:e57d:ae80:bd31",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/reservation/confirmation/ZF7DUWS39",
            "referrer": "",
            "search": "?rsrc=PostMoveIn&utm_medium=email_transa&utm_content=mic_1&utm_campaign=post_res",
            "title": "Hwy 54 Self Storage & RV Parking | 11707 Dyer Street | SpareFoot",
            "url": "https://www.sparefoot.com/reservation/confirmation/ZF7DUWS39?rsrc=PostMoveIn&utm_medium=email_transa&utm_content=mic_1&utm_campaign=post_res"
        },
        "timezone": "America/Denver",
        "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": "Not)A;Brand",
                    "version": "99"
                },
                {
                    "brand": "Google Chrome",
                    "version": "127"
                },
                {
                    "brand": "Chromium",
                    "version": "127"
                }
            ],
            "mobile": true,
            "platform": "Android"
        }
    },
    "event": "omi_hero_impression",
    "integrations": {},
    "messageId": "ajs-next-1723917272614-84c43bdf-5982-4f6b-82df-f73aa04ec463",
    "originalTimestamp": "2024-08-17T17:54:32.614Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1723917272614,
        "category": "Omi hero rendered-confirmationPage",
        "env": "production",
        "isReact": true,
        "label": "omi hero impression",
        "site_id": -1
    },
    "receivedAt": "2024-08-17T17:54:32.946Z",
    "sentAt": "2024-08-17T17:54:32.621Z",
    "timestamp": "2024-08-17T17:54:32.939Z",
    "type": "track",
    "userId": "db18fc63cf580edc5873f2b6e14b652b",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.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.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 1983
schema_scan_id: 125396642
updated: 2024-08-17 12:57:30

Schema Scans: 3

Last at 2024-12-26 06:02:14

Scan 134232916

duration: 0:00:22.396920

exit_message:

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

id: 134232916

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2024-12-26/",
        "name": "dt",
        "type": "string",
        "value": "2024-12-26"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression",
        "key": "separated_dt/omi_hero_impression/dt=2024-12-26/1735214477191.events-archiver-480-36..1eb90a78-4070-49c7-a654-023934d9392e.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_omi_hero_impression",
        "type": "segment"
    }
}

running: False
schema_name_id: 1983
start_time: 2024-12-26 06:02:14
success: True
trace_id: 12891177956671019410

Scan 126156300

duration: 0:00:17.839373

exit_message:

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

id: 126156300

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2024-08-28/",
        "name": "dt",
        "type": "string",
        "value": "2024-08-28"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression",
        "key": "separated_dt/omi_hero_impression/dt=2024-08-28/1724855585441.events-archiver-480-5..be2ef768-f211-41a2-938b-267c365b7f33.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_omi_hero_impression",
        "type": "segment"
    }
}

running: False
schema_name_id: 1983
start_time: 2024-08-28 09:34:07
success: True
trace_id: 12065160967422558484

Scan 125396642

duration: 0:00:15.295509

exit_message:

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

id: 125396642

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2024-08-17/",
        "name": "dt",
        "type": "string",
        "value": "2024-08-17"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression",
        "key": "separated_dt/omi_hero_impression/dt=2024-08-17/1723917325513.events-archiver-480-57..f6733cb6-691c-4b67-8298-564b60112cb1.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_omi_hero_impression",
        "type": "segment"
    }
}

running: False
schema_name_id: 1983
start_time: 2024-08-17 12:57:11
success: True
trace_id: 5571468067462775604

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_omi_hero_impression`\nADD\n\n\n PARTITION (dt='2025-04-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-20/'\n PARTITION (dt='2025-04-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-26/'\n PARTITION (dt='2025-08-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-08-31/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 1489669,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-20/",
            "name": "dt",
            "value": "2025-04-20"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-20 13:51:57",
                "last_data": "2025-04-20 13:51:57"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1491368,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-26/",
            "name": "dt",
            "value": "2025-04-26"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-26 09:57:48",
                "last_data": "2025-04-26 09:57:48"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1547314,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-08-31/",
            "name": "dt",
            "value": "2025-08-31"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-08-31 11:58:44",
                "last_data": "2025-08-31 11:58:44"
            },
            "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.campaign.content": "string",
    "context.campaign.id": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "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.category": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2024-12-26 06:02:16

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_omi_hero_impression`\n(\n`projectId`STRING,`version`STRING,`type`STRING,`messageId`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`userAgent`:STRING,`locale`:STRING,`campaign`:struct<`id`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING,`content`:STRING,`term`:STRING>,`timezone`:STRING,`page`:struct<`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING,`search`:STRING>>,`channel`STRING,`properties`struct<`category`:STRING,`isReact`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`label`:STRING,`site_id`:STRING>,`event`STRING,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`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/omi_hero_impression'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_omi_hero_impression`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_omi_hero_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": "2024-08-15 11:46:24",
        "disabled": false,
        "format": "raw",
        "id": 1983,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "reactfoot_omi_hero_impression"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_omi_hero_impression`\nADD\n\n\n PARTITION (dt='2025-04-20') location 's3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-20/'\n PARTITION (dt='2025-04-26') location 's3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-26/'\n PARTITION (dt='2025-08-31') location 's3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-08-31/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1489669,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-20/",
                    "name": "dt",
                    "value": "2025-04-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-20 13:51:57",
                        "last_data": "2025-04-20 13:51:57"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1491368,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-04-26/",
                    "name": "dt",
                    "value": "2025-04-26"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-26 09:57:48",
                        "last_data": "2025-04-26 09:57:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1547314,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/omi_hero_impression/dt=2025-08-31/",
                    "name": "dt",
                    "value": "2025-08-31"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-08-31 11:58:44",
                        "last_data": "2025-08-31 11:58:44"
                    },
                    "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.campaign.content": "string",
            "context.campaign.id": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.campaign.term": "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.category": "string",
            "properties.env": "string",
            "properties.isReact": "string",
            "properties.label": "string",
            "properties.site_id": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2024-12-26 06:02:16",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_omi_hero_impression`\n(\n`projectId`STRING,`version`STRING,`type`STRING,`messageId`STRING,`sentAt`STRING,`context`struct<`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`brands`:array>,`platform`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`userAgent`:STRING,`locale`:STRING,`campaign`:struct<`id`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING,`content`:STRING,`term`:STRING>,`timezone`:STRING,`page`:struct<`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING,`search`:STRING>>,`channel`STRING,`properties`struct<`category`:STRING,`isReact`:STRING,`env`:STRING,`Hit_Timestamp`:STRING,`label`:STRING,`site_id`:STRING>,`event`STRING,`anonymousId`STRING,`originalTimestamp`STRING,`receivedAt`STRING,`_origin`STRING,`userId`STRING,`timestamp`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/omi_hero_impression'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_omi_hero_impression`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_omi_hero_impression"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}