Schema Info

Schema Name: sfdl_prod_segment.myfoot_statement_confirm

created: 2018-07-01 15:01:29
disabled: False
format: raw
id: 465
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 3

Version 693686

created: 2023-12-01 09:08:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.myfoot_statement_confirm`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.myfoot_statement_confirm`\n(\n`integrations`struct<`_empty_`:STRING>,`context`struct<`ip`:STRING,`locale`:STRING,`campaign`:struct<`medium`:STRING,`name`:STRING,`source`:STRING,`content`:STRING>,`timezone`:STRING,`userAgent`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`page`:struct<`path`:STRING,`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`event`STRING,`sentAt`STRING,`type`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`messageId`STRING,`version`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`projectId`STRING,`userId`STRING,`_origin`STRING,`channel`STRING,`receivedAt`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-myfoot-prod/separated_dt/statement_confirm'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.myfoot_statement_confirm"
]

hive_path: s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm
id: 693686
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "5b36a0ee4a4f97b4f84a0f22",
            "5b3699b2f4e88d7cceaa4df1"
        ],
        "unbundled": []
    },
    "_origin": "2023-12-01T15:08:28Z|s3://sfdl-segment-myfoot-prod/segment-logs/uT008VRSlp/1701388800000/1701443267374.events-archiver-480-41..5db2322f-af2e-439f-b8e0-7acbcd83625e.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "2612bb37-99e4-43ad-a670-905e715142d6",
    "channel": "client",
    "context": {
        "ip": "71.225.47.112",
        "library": {
            "name": "analytics.js",
            "version": "next-1.61.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/statement/view/338346",
            "referrer": "https://my.sparefoot.com/statement/list",
            "search": "",
            "title": "MySpareFoot",
            "url": "https://my.sparefoot.com/statement/view/338346"
        },
        "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 Edg/119.0.0.0",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Microsoft Edge",
                    "version": "119"
                },
                {
                    "brand": "Chromium",
                    "version": "119"
                },
                {
                    "brand": "Not?A_Brand",
                    "version": "24"
                }
            ],
            "mobile": false,
            "platform": "Windows"
        }
    },
    "event": "statement_confirm",
    "integrations": {},
    "messageId": "ajs-next-d2b7f7ebcdcb2af6a0743a7af64b3bf3",
    "originalTimestamp": "2023-12-01T15:07:49.682Z",
    "projectId": "uT008VRSlp",
    "properties": {},
    "receivedAt": "2023-12-01T15:07:43.055Z",
    "sentAt": "2023-12-01T15:07:49.697Z",
    "timestamp": "2023-12-01T15:07:43.040Z",
    "type": "track",
    "userId": "3090639",
    "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",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 465
schema_scan_id: 107039676
updated: 2023-12-01 09:09:39

Version 535811

created: 2023-06-09 08:50:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.myfoot_statement_confirm`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.myfoot_statement_confirm`\n(\n`type`STRING,`context`struct<`ip`:STRING,`campaign`:struct<`medium`:STRING,`name`:STRING,`source`:STRING,`content`:STRING>,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`search`:STRING,`title`:STRING,`referrer`:STRING,`url`:STRING,`path`:STRING>,`userAgent`:STRING,`locale`:STRING>,`timestamp`STRING,`originalTimestamp`STRING,`integrations`struct<`_empty_`:STRING>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`anonymousId`STRING,`messageId`STRING,`event`STRING,`receivedAt`STRING,`version`STRING,`sentAt`STRING,`userId`STRING,`_origin`STRING,`projectId`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.myfoot_statement_confirm"
]

hive_path: s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm
id: 535811
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "5b36a0ee4a4f97b4f84a0f22",
            "5b3699b2f4e88d7cceaa4df1"
        ],
        "unbundled": []
    },
    "_origin": "2023-06-09T13:49:52Z|s3://sfdl-segment-myfoot-prod/segment-logs/uT008VRSlp/1686268800000/1686318522253.events-archiver-480-54.8ebb200.dd9f5d30-227e-4151-a9a3-b0f96648f7f9.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "f3bf1ee2-3622-46a2-9625-06e61c4344dc",
    "channel": "client",
    "context": {
        "ip": "74.89.198.252",
        "library": {
            "name": "analytics.js",
            "version": "next-1.53.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/statement/view/328260",
            "referrer": "https://my.sparefoot.com/statement/list?utm_source=socketlabs&utm_medium=email&utm_campaign=statementready",
            "search": "",
            "title": "MySpareFoot",
            "url": "https://my.sparefoot.com/statement/view/328260"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.41",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Not.A/Brand",
                    "version": "8"
                },
                {
                    "brand": "Chromium",
                    "version": "114"
                },
                {
                    "brand": "Microsoft Edge",
                    "version": "114"
                }
            ],
            "mobile": false,
            "platform": "Windows"
        }
    },
    "event": "statement_confirm",
    "integrations": {},
    "messageId": "ajs-next-7a8caabd4588c8314cf06edc599d64e5",
    "originalTimestamp": "2023-06-09T13:26:30.803Z",
    "projectId": "uT008VRSlp",
    "properties": {},
    "receivedAt": "2023-06-09T13:26:30.492Z",
    "sentAt": "2023-06-09T13:26:30.815Z",
    "timestamp": "2023-06-09T13:26:30.480Z",
    "type": "track",
    "userId": "5031674",
    "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.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",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 465
schema_scan_id: 94686584
updated: 2023-06-09 08:51:15

Version 176072

created: 2020-11-10 14:21:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.myfoot_statement_confirm`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.myfoot_statement_confirm`\n(\n`messageId`STRING,`type`STRING,`integrations`struct<`_empty_`:STRING>,`channel`STRING,`version`STRING,`context`struct<`campaign`:struct<`medium`:STRING,`name`:STRING,`source`:STRING,`content`:STRING>,`userAgent`:STRING,`page`:struct<`path`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING,`search`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`ip`:STRING,`locale`:STRING>,`_origin`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`event`STRING,`timestamp`STRING,`originalTimestamp`STRING,`sentAt`STRING,`projectId`STRING,`anonymousId`STRING,`receivedAt`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-myfoot-prod/separated_dt/statement_confirm'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.myfoot_statement_confirm"
]

hive_path: s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm
id: 176072
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "unbundled": []
    },
    "_origin": "2020-11-10T20:21:05Z|s3://sfdl-segment-myfoot-prod/segment-logs/uT008VRSlp/1604966400000/1605039326783.f83d63fe07ed.fde281a.edaac553-0800-45fb-a6e1-cce389865243.gz|segment_separator:37",
    "anonymousId": "818b4114-4296-460d-97a0-5a000cc0ea7f",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "Online Tracking Link_ONLINE_TRACKING_LINK",
            "medium": "affiliate",
            "name": "357605",
            "source": "impact"
        },
        "ip": "75.151.43.169",
        "library": {
            "name": "analytics.js",
            "version": "4.0.4"
        },
        "locale": "en-US",
        "page": {
            "path": "/statement/view/263012",
            "referrer": "",
            "search": "?irgwc=1&tsid=impact&utm_source=impact&utm_medium=affiliate&utm_campaign=357605&click_id=QYiwnUQcuxyOWyIwUx0Mo3YlUkEzz5TJTRALWo0&utm_content=Online%20Tracking%20Link_ONLINE_TRACKING_LINK&ad_id=483123&campaign_id=8436&ad_size=&partner_name=YieldKit%20GmbH",
            "title": "MySpareFoot",
            "url": "https://my.sparefoot.com/statement/view/263012?irgwc=1&tsid=impact&utm_source=impact&utm_medium=affiliate&utm_campaign=357605&click_id=QYiwnUQcuxyOWyIwUx0Mo3YlUkEzz5TJTRALWo0&utm_content=Online%20Tracking%20Link_ONLINE_TRACKING_LINK&ad_id=483123&campaign_id=8436&ad_size=&partner_name=YieldKit%20GmbH"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.193 Safari/537.36"
    },
    "event": "statement_confirm",
    "integrations": {},
    "messageId": "ajs-b93af374862d108c2e402a38396889e9",
    "originalTimestamp": "2020-11-10T19:42:35.679Z",
    "projectId": "uT008VRSlp",
    "receivedAt": "2020-11-10T19:42:35.212Z",
    "sentAt": "2020-11-10T19:42:35.687Z",
    "timestamp": "2020-11-10T19:42:35.204Z",
    "type": "track",
    "userId": "1607885",
    "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.userAgent": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 465
schema_scan_id: 43580312
updated: 2020-11-10 14:24:31

Schema Scans: 3

Last at 2023-12-01 09:08:36

Scan 107039676

duration: 0:01:25.507103

exit_message:

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

id: 107039676

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2023-12-01/",
        "name": "dt",
        "type": "string",
        "value": "2023-12-01"
    },
    "s3": {
        "bucket": "sfdl-segment-myfoot-prod",
        "hive_path": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm",
        "key": "separated_dt/statement_confirm/dt=2023-12-01/1701443267374.events-archiver-480-41..5db2322f-af2e-439f-b8e0-7acbcd83625e.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.myfoot_statement_confirm",
        "type": "segment"
    }
}

running: False
schema_name_id: 465
start_time: 2023-12-01 09:08:36
success: True
trace_id: 18163569672020915040

Scan 94686584

duration: 0:01:53.065223

exit_message:

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

id: 94686584

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2023-06-09/",
        "name": "dt",
        "type": "string",
        "value": "2023-06-09"
    },
    "s3": {
        "bucket": "sfdl-segment-myfoot-prod",
        "hive_path": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm",
        "key": "separated_dt/statement_confirm/dt=2023-06-09/1686318522253.events-archiver-480-54.8ebb200.dd9f5d30-227e-4151-a9a3-b0f96648f7f9.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.myfoot_statement_confirm",
        "type": "segment"
    }
}

running: False
schema_name_id: 465
start_time: 2023-06-09 08:50:14
success: True
trace_id: 15991082919045359654

Scan 43580312

duration: 0:01:37.161526

exit_message:

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

id: 43580312

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "partition": {
        "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2020-11-10/",
        "name": "dt",
        "type": "string",
        "value": "2020-11-10"
    },
    "s3": {
        "bucket": "sfdl-segment-myfoot-prod",
        "hive_path": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm",
        "key": "separated_dt/statement_confirm/dt=2020-11-10/1605039326783.f83d63fe07ed.fde281a.edaac553-0800-45fb-a6e1-cce389865243.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.myfoot_statement_confirm",
        "type": "segment"
    }
}

running: False
schema_name_id: 465
start_time: 2020-11-10 14:21:06
success: True
trace_id: 13856546950420669536

Partitions:

count: 68

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_segment.myfoot_statement_confirm`\nADD\n\n\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-11/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-11/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-16/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-11/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-11/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-11/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-20/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-11/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 1599707,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-01/",
            "name": "dt",
            "value": "2025-11-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-01 12:47:56",
                "last_data": "2025-11-01 19:58:00"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1599978,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-02/",
            "name": "dt",
            "value": "2025-11-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-01 20:14:45",
                "last_data": "2025-11-02 19:12:42"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1600205,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-03/",
            "name": "dt",
            "value": "2025-11-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-02 19:19:30",
                "last_data": "2025-11-03 18:49:59"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1600439,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-04/",
            "name": "dt",
            "value": "2025-11-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-03 19:11:33",
                "last_data": "2025-11-04 18:55:28"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1600691,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-05/",
            "name": "dt",
            "value": "2025-11-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-04 19:14:40",
                "last_data": "2025-11-05 18:59:32"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1600931,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-06/",
            "name": "dt",
            "value": "2025-11-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-05 19:30:54",
                "last_data": "2025-11-06 17:50:17"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1601171,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-07/",
            "name": "dt",
            "value": "2025-11-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-06 19:27:03",
                "last_data": "2025-11-07 18:37:22"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1601443,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-08/",
            "name": "dt",
            "value": "2025-11-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-07 19:55:25",
                "last_data": "2025-11-08 19:04:58"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1601759,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-09/",
            "name": "dt",
            "value": "2025-11-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-09 09:41:39",
                "last_data": "2025-11-09 16:55:14"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1601913,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-10/",
            "name": "dt",
            "value": "2025-11-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-09 19:55:20",
                "last_data": "2025-11-10 18:19:17"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1602128,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-11/",
            "name": "dt",
            "value": "2025-11-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-11-10 19:10:35",
                "last_data": "2025-11-10 22:14:54"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1609758,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-01/",
            "name": "dt",
            "value": "2025-12-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-01 11:53:12",
                "last_data": "2025-12-01 18:49:40"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1609833,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-02/",
            "name": "dt",
            "value": "2025-12-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-01 19:04:34",
                "last_data": "2025-12-02 18:41:49"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1610068,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-03/",
            "name": "dt",
            "value": "2025-12-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-02 19:06:52",
                "last_data": "2025-12-03 18:34:11"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1610310,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-04/",
            "name": "dt",
            "value": "2025-12-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-03 19:11:59",
                "last_data": "2025-12-04 18:36:14"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1610544,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-05/",
            "name": "dt",
            "value": "2025-12-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-04 19:07:06",
                "last_data": "2025-12-05 17:34:57"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1611059,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-06/",
            "name": "dt",
            "value": "2025-12-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-05 19:04:36",
                "last_data": "2025-12-06 16:55:02"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1611306,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-07/",
            "name": "dt",
            "value": "2025-12-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-06 19:21:43",
                "last_data": "2025-12-07 18:42:52"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1611596,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-08/",
            "name": "dt",
            "value": "2025-12-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-08 07:53:27",
                "last_data": "2025-12-08 18:29:41"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1611765,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-09/",
            "name": "dt",
            "value": "2025-12-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-08 19:13:00",
                "last_data": "2025-12-09 18:16:55"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1612138,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-10/",
            "name": "dt",
            "value": "2025-12-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-09 18:58:27",
                "last_data": "2025-12-10 18:36:29"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1612460,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-11/",
            "name": "dt",
            "value": "2025-12-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-10 18:59:33",
                "last_data": "2025-12-11 09:12:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1616466,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-16/",
            "name": "dt",
            "value": "2025-12-16"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-12-16 17:26:04",
                "last_data": "2025-12-16 17:26:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1620005,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-01/",
            "name": "dt",
            "value": "2026-01-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-01 11:14:21",
                "last_data": "2026-01-01 18:46:48"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1620079,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-02/",
            "name": "dt",
            "value": "2026-01-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-01 19:04:57",
                "last_data": "2026-01-02 17:56:42"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1620306,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-03/",
            "name": "dt",
            "value": "2026-01-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-02 19:19:08",
                "last_data": "2026-01-03 18:47:02"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1620521,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-04/",
            "name": "dt",
            "value": "2026-01-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-03 19:35:22",
                "last_data": "2026-01-04 18:35:22"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1620733,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-05/",
            "name": "dt",
            "value": "2026-01-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-04 19:20:09",
                "last_data": "2026-01-05 18:17:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1620933,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-06/",
            "name": "dt",
            "value": "2026-01-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-05 18:56:19",
                "last_data": "2026-01-06 17:23:08"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1621161,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-07/",
            "name": "dt",
            "value": "2026-01-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-06 19:00:13",
                "last_data": "2026-01-07 18:05:41"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1621405,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-08/",
            "name": "dt",
            "value": "2026-01-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-07 20:02:14",
                "last_data": "2026-01-08 18:42:31"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1621626,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-09/",
            "name": "dt",
            "value": "2026-01-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-08 19:19:53",
                "last_data": "2026-01-09 18:51:40"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1621834,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-10/",
            "name": "dt",
            "value": "2026-01-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-09 19:38:06",
                "last_data": "2026-01-10 17:57:19"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1622067,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-11/",
            "name": "dt",
            "value": "2026-01-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-10 19:34:12",
                "last_data": "2026-01-11 00:28:51"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1629305,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-01/",
            "name": "dt",
            "value": "2026-02-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-01 11:28:37",
                "last_data": "2026-02-01 18:43:22"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1629370,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-02/",
            "name": "dt",
            "value": "2026-02-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-01 19:00:49",
                "last_data": "2026-02-02 18:53:19"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1629580,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-03/",
            "name": "dt",
            "value": "2026-02-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-02 18:54:29",
                "last_data": "2026-02-03 18:29:28"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1629869,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-04/",
            "name": "dt",
            "value": "2026-02-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-03 18:58:46",
                "last_data": "2026-02-04 18:48:11"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1630110,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-05/",
            "name": "dt",
            "value": "2026-02-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-04 19:17:00",
                "last_data": "2026-02-05 18:22:54"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1630312,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-06/",
            "name": "dt",
            "value": "2026-02-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-05 18:58:32",
                "last_data": "2026-02-06 18:15:32"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1630549,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-07/",
            "name": "dt",
            "value": "2026-02-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-06 21:02:56",
                "last_data": "2026-02-07 17:02:14"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1630752,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-08/",
            "name": "dt",
            "value": "2026-02-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-07 19:03:53",
                "last_data": "2026-02-08 16:58:22"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1630978,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-09/",
            "name": "dt",
            "value": "2026-02-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-08 20:16:23",
                "last_data": "2026-02-09 18:45:36"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1631168,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-10/",
            "name": "dt",
            "value": "2026-02-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-09 18:53:06",
                "last_data": "2026-02-10 18:18:11"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1631416,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-11/",
            "name": "dt",
            "value": "2026-02-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-02-10 19:05:17",
                "last_data": "2026-02-10 23:15:28"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1641481,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-01/",
            "name": "dt",
            "value": "2026-03-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-01 11:35:40",
                "last_data": "2026-03-01 18:39:00"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1641546,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-02/",
            "name": "dt",
            "value": "2026-03-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-01 19:02:32",
                "last_data": "2026-03-02 18:13:02"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1641752,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-03/",
            "name": "dt",
            "value": "2026-03-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-02 19:04:40",
                "last_data": "2026-03-03 18:36:03"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1641988,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-04/",
            "name": "dt",
            "value": "2026-03-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-03 19:02:57",
                "last_data": "2026-03-04 17:17:30"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1642226,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-05/",
            "name": "dt",
            "value": "2026-03-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-04 22:05:05",
                "last_data": "2026-03-05 17:56:18"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1642435,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-06/",
            "name": "dt",
            "value": "2026-03-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-05 19:06:54",
                "last_data": "2026-03-06 18:16:17"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1642653,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-07/",
            "name": "dt",
            "value": "2026-03-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-06 19:04:46",
                "last_data": "2026-03-07 18:45:45"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1642878,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-08/",
            "name": "dt",
            "value": "2026-03-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-07 21:35:24",
                "last_data": "2026-03-08 19:47:50"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1643181,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-09/",
            "name": "dt",
            "value": "2026-03-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-08 20:44:40",
                "last_data": "2026-03-09 19:46:00"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1643923,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-10/",
            "name": "dt",
            "value": "2026-03-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-09 19:58:13",
                "last_data": "2026-03-10 19:46:52"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1645004,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-11/",
            "name": "dt",
            "value": "2026-03-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-10 20:17:15",
                "last_data": "2026-03-11 00:48:51"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1648905,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-20/",
            "name": "dt",
            "value": "2026-03-20"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-03-20 18:27:42",
                "last_data": "2026-03-20 18:27:42"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1652143,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-01/",
            "name": "dt",
            "value": "2026-04-01"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-01 11:47:44",
                "last_data": "2026-04-01 19:39:53"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1652205,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-02/",
            "name": "dt",
            "value": "2026-04-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-01 19:55:37",
                "last_data": "2026-04-02 19:45:58"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1652593,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-03/",
            "name": "dt",
            "value": "2026-04-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-02 20:00:39",
                "last_data": "2026-04-03 19:47:25"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1652809,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-04/",
            "name": "dt",
            "value": "2026-04-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-03 20:00:33",
                "last_data": "2026-04-04 18:54:45"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1653029,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-05/",
            "name": "dt",
            "value": "2026-04-05"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-04 20:33:30",
                "last_data": "2026-04-05 18:05:47"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1656528,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-06/",
            "name": "dt",
            "value": "2026-04-06"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-05 20:07:25",
                "last_data": "2026-04-06 19:25:35"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1656750,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-07/",
            "name": "dt",
            "value": "2026-04-07"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-06 20:02:44",
                "last_data": "2026-04-07 18:34:49"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1656977,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-08/",
            "name": "dt",
            "value": "2026-04-08"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-07 19:57:15",
                "last_data": "2026-04-08 19:36:40"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1657377,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-09/",
            "name": "dt",
            "value": "2026-04-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-08 19:58:49",
                "last_data": "2026-04-09 19:35:12"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1657597,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-10/",
            "name": "dt",
            "value": "2026-04-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-09 20:01:23",
                "last_data": "2026-04-10 19:38:33"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1657820,
            "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-11/",
            "name": "dt",
            "value": "2026-04-11"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-04-10 20:01:59",
                "last_data": "2026-04-10 22:51:45"
            },
            "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.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",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2023-12-01 09:08:37

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.myfoot_statement_confirm`\n(\n`integrations`struct<`_empty_`:STRING>,`context`struct<`ip`:STRING,`locale`:STRING,`campaign`:struct<`medium`:STRING,`name`:STRING,`source`:STRING,`content`:STRING>,`timezone`:STRING,`userAgent`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`page`:struct<`path`:STRING,`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`event`STRING,`sentAt`STRING,`type`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`messageId`STRING,`version`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`projectId`STRING,`userId`STRING,`_origin`STRING,`channel`STRING,`receivedAt`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-myfoot-prod/separated_dt/statement_confirm'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.myfoot_statement_confirm`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.myfoot_statement_confirm"
}

Server:

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

Raw:

{
    "name": {
        "created": "2018-07-01 15:01:29",
        "disabled": false,
        "format": "raw",
        "id": 465,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "myfoot_statement_confirm"
        },
        "type": "segment"
    },
    "partition": {
        "count": 68,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.myfoot_statement_confirm`\nADD\n\n\n PARTITION (dt='2025-11-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-11/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-08/'\n PARTITION (dt='2025-12-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-09/'\n PARTITION (dt='2025-12-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-10/'\n PARTITION (dt='2025-12-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-11/'\n PARTITION (dt='2025-12-16') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-16/'\n PARTITION (dt='2026-01-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-01/'\n PARTITION (dt='2026-01-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-02/'\n PARTITION (dt='2026-01-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-03/'\n PARTITION (dt='2026-01-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-04/'\n PARTITION (dt='2026-01-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-05/'\n PARTITION (dt='2026-01-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-06/'\n PARTITION (dt='2026-01-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-07/'\n PARTITION (dt='2026-01-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-08/'\n PARTITION (dt='2026-01-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-09/'\n PARTITION (dt='2026-01-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-10/'\n PARTITION (dt='2026-01-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-11/'\n PARTITION (dt='2026-02-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-01/'\n PARTITION (dt='2026-02-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-02/'\n PARTITION (dt='2026-02-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-03/'\n PARTITION (dt='2026-02-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-04/'\n PARTITION (dt='2026-02-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-05/'\n PARTITION (dt='2026-02-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-06/'\n PARTITION (dt='2026-02-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-07/'\n PARTITION (dt='2026-02-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-08/'\n PARTITION (dt='2026-02-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-09/'\n PARTITION (dt='2026-02-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-10/'\n PARTITION (dt='2026-02-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-11/'\n PARTITION (dt='2026-03-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-01/'\n PARTITION (dt='2026-03-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-02/'\n PARTITION (dt='2026-03-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-03/'\n PARTITION (dt='2026-03-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-04/'\n PARTITION (dt='2026-03-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-05/'\n PARTITION (dt='2026-03-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-06/'\n PARTITION (dt='2026-03-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-07/'\n PARTITION (dt='2026-03-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-08/'\n PARTITION (dt='2026-03-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-09/'\n PARTITION (dt='2026-03-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-10/'\n PARTITION (dt='2026-03-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-11/'\n PARTITION (dt='2026-03-20') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-20/'\n PARTITION (dt='2026-04-01') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-01/'\n PARTITION (dt='2026-04-02') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-02/'\n PARTITION (dt='2026-04-03') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-03/'\n PARTITION (dt='2026-04-04') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-04/'\n PARTITION (dt='2026-04-05') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-05/'\n PARTITION (dt='2026-04-06') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-06/'\n PARTITION (dt='2026-04-07') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-07/'\n PARTITION (dt='2026-04-08') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-08/'\n PARTITION (dt='2026-04-09') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-09/'\n PARTITION (dt='2026-04-10') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-10/'\n PARTITION (dt='2026-04-11') location 's3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-11/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1599707,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-01/",
                    "name": "dt",
                    "value": "2025-11-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-01 12:47:56",
                        "last_data": "2025-11-01 19:58:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1599978,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-02/",
                    "name": "dt",
                    "value": "2025-11-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-01 20:14:45",
                        "last_data": "2025-11-02 19:12:42"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1600205,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-03/",
                    "name": "dt",
                    "value": "2025-11-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-02 19:19:30",
                        "last_data": "2025-11-03 18:49:59"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1600439,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-04/",
                    "name": "dt",
                    "value": "2025-11-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-03 19:11:33",
                        "last_data": "2025-11-04 18:55:28"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1600691,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-05/",
                    "name": "dt",
                    "value": "2025-11-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-04 19:14:40",
                        "last_data": "2025-11-05 18:59:32"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1600931,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-06/",
                    "name": "dt",
                    "value": "2025-11-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-05 19:30:54",
                        "last_data": "2025-11-06 17:50:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1601171,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-07/",
                    "name": "dt",
                    "value": "2025-11-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-06 19:27:03",
                        "last_data": "2025-11-07 18:37:22"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1601443,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-08/",
                    "name": "dt",
                    "value": "2025-11-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-07 19:55:25",
                        "last_data": "2025-11-08 19:04:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1601759,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-09/",
                    "name": "dt",
                    "value": "2025-11-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-09 09:41:39",
                        "last_data": "2025-11-09 16:55:14"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1601913,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-10/",
                    "name": "dt",
                    "value": "2025-11-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-09 19:55:20",
                        "last_data": "2025-11-10 18:19:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1602128,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-11-11/",
                    "name": "dt",
                    "value": "2025-11-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-11-10 19:10:35",
                        "last_data": "2025-11-10 22:14:54"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1609758,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-01/",
                    "name": "dt",
                    "value": "2025-12-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-01 11:53:12",
                        "last_data": "2025-12-01 18:49:40"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1609833,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-02/",
                    "name": "dt",
                    "value": "2025-12-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-01 19:04:34",
                        "last_data": "2025-12-02 18:41:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1610068,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-03/",
                    "name": "dt",
                    "value": "2025-12-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-02 19:06:52",
                        "last_data": "2025-12-03 18:34:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1610310,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-04/",
                    "name": "dt",
                    "value": "2025-12-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-03 19:11:59",
                        "last_data": "2025-12-04 18:36:14"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1610544,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-05/",
                    "name": "dt",
                    "value": "2025-12-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-04 19:07:06",
                        "last_data": "2025-12-05 17:34:57"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1611059,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-06/",
                    "name": "dt",
                    "value": "2025-12-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-05 19:04:36",
                        "last_data": "2025-12-06 16:55:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1611306,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-07/",
                    "name": "dt",
                    "value": "2025-12-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-06 19:21:43",
                        "last_data": "2025-12-07 18:42:52"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1611596,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-08/",
                    "name": "dt",
                    "value": "2025-12-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-08 07:53:27",
                        "last_data": "2025-12-08 18:29:41"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1611765,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-09/",
                    "name": "dt",
                    "value": "2025-12-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-08 19:13:00",
                        "last_data": "2025-12-09 18:16:55"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1612138,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-10/",
                    "name": "dt",
                    "value": "2025-12-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-09 18:58:27",
                        "last_data": "2025-12-10 18:36:29"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1612460,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-11/",
                    "name": "dt",
                    "value": "2025-12-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-10 18:59:33",
                        "last_data": "2025-12-11 09:12:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1616466,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2025-12-16/",
                    "name": "dt",
                    "value": "2025-12-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-12-16 17:26:04",
                        "last_data": "2025-12-16 17:26:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1620005,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-01/",
                    "name": "dt",
                    "value": "2026-01-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-01 11:14:21",
                        "last_data": "2026-01-01 18:46:48"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1620079,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-02/",
                    "name": "dt",
                    "value": "2026-01-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-01 19:04:57",
                        "last_data": "2026-01-02 17:56:42"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1620306,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-03/",
                    "name": "dt",
                    "value": "2026-01-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-02 19:19:08",
                        "last_data": "2026-01-03 18:47:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1620521,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-04/",
                    "name": "dt",
                    "value": "2026-01-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-03 19:35:22",
                        "last_data": "2026-01-04 18:35:22"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1620733,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-05/",
                    "name": "dt",
                    "value": "2026-01-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-04 19:20:09",
                        "last_data": "2026-01-05 18:17:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1620933,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-06/",
                    "name": "dt",
                    "value": "2026-01-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-05 18:56:19",
                        "last_data": "2026-01-06 17:23:08"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1621161,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-07/",
                    "name": "dt",
                    "value": "2026-01-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-06 19:00:13",
                        "last_data": "2026-01-07 18:05:41"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1621405,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-08/",
                    "name": "dt",
                    "value": "2026-01-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-07 20:02:14",
                        "last_data": "2026-01-08 18:42:31"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1621626,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-09/",
                    "name": "dt",
                    "value": "2026-01-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-08 19:19:53",
                        "last_data": "2026-01-09 18:51:40"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1621834,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-10/",
                    "name": "dt",
                    "value": "2026-01-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-09 19:38:06",
                        "last_data": "2026-01-10 17:57:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1622067,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-01-11/",
                    "name": "dt",
                    "value": "2026-01-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-10 19:34:12",
                        "last_data": "2026-01-11 00:28:51"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1629305,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-01/",
                    "name": "dt",
                    "value": "2026-02-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-01 11:28:37",
                        "last_data": "2026-02-01 18:43:22"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1629370,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-02/",
                    "name": "dt",
                    "value": "2026-02-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-01 19:00:49",
                        "last_data": "2026-02-02 18:53:19"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1629580,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-03/",
                    "name": "dt",
                    "value": "2026-02-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-02 18:54:29",
                        "last_data": "2026-02-03 18:29:28"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1629869,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-04/",
                    "name": "dt",
                    "value": "2026-02-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-03 18:58:46",
                        "last_data": "2026-02-04 18:48:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1630110,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-05/",
                    "name": "dt",
                    "value": "2026-02-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-04 19:17:00",
                        "last_data": "2026-02-05 18:22:54"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1630312,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-06/",
                    "name": "dt",
                    "value": "2026-02-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-05 18:58:32",
                        "last_data": "2026-02-06 18:15:32"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1630549,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-07/",
                    "name": "dt",
                    "value": "2026-02-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-06 21:02:56",
                        "last_data": "2026-02-07 17:02:14"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1630752,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-08/",
                    "name": "dt",
                    "value": "2026-02-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-07 19:03:53",
                        "last_data": "2026-02-08 16:58:22"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1630978,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-09/",
                    "name": "dt",
                    "value": "2026-02-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-08 20:16:23",
                        "last_data": "2026-02-09 18:45:36"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1631168,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-10/",
                    "name": "dt",
                    "value": "2026-02-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-09 18:53:06",
                        "last_data": "2026-02-10 18:18:11"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1631416,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-02-11/",
                    "name": "dt",
                    "value": "2026-02-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-02-10 19:05:17",
                        "last_data": "2026-02-10 23:15:28"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1641481,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-01/",
                    "name": "dt",
                    "value": "2026-03-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-01 11:35:40",
                        "last_data": "2026-03-01 18:39:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1641546,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-02/",
                    "name": "dt",
                    "value": "2026-03-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-01 19:02:32",
                        "last_data": "2026-03-02 18:13:02"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1641752,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-03/",
                    "name": "dt",
                    "value": "2026-03-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-02 19:04:40",
                        "last_data": "2026-03-03 18:36:03"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1641988,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-04/",
                    "name": "dt",
                    "value": "2026-03-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-03 19:02:57",
                        "last_data": "2026-03-04 17:17:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1642226,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-05/",
                    "name": "dt",
                    "value": "2026-03-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-04 22:05:05",
                        "last_data": "2026-03-05 17:56:18"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1642435,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-06/",
                    "name": "dt",
                    "value": "2026-03-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-05 19:06:54",
                        "last_data": "2026-03-06 18:16:17"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1642653,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-07/",
                    "name": "dt",
                    "value": "2026-03-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-06 19:04:46",
                        "last_data": "2026-03-07 18:45:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1642878,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-08/",
                    "name": "dt",
                    "value": "2026-03-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-07 21:35:24",
                        "last_data": "2026-03-08 19:47:50"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1643181,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-09/",
                    "name": "dt",
                    "value": "2026-03-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-08 20:44:40",
                        "last_data": "2026-03-09 19:46:00"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1643923,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-10/",
                    "name": "dt",
                    "value": "2026-03-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-09 19:58:13",
                        "last_data": "2026-03-10 19:46:52"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1645004,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-11/",
                    "name": "dt",
                    "value": "2026-03-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-10 20:17:15",
                        "last_data": "2026-03-11 00:48:51"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1648905,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-03-20/",
                    "name": "dt",
                    "value": "2026-03-20"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-03-20 18:27:42",
                        "last_data": "2026-03-20 18:27:42"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1652143,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-01/",
                    "name": "dt",
                    "value": "2026-04-01"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-01 11:47:44",
                        "last_data": "2026-04-01 19:39:53"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1652205,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-02/",
                    "name": "dt",
                    "value": "2026-04-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-01 19:55:37",
                        "last_data": "2026-04-02 19:45:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1652593,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-03/",
                    "name": "dt",
                    "value": "2026-04-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-02 20:00:39",
                        "last_data": "2026-04-03 19:47:25"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1652809,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-04/",
                    "name": "dt",
                    "value": "2026-04-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-03 20:00:33",
                        "last_data": "2026-04-04 18:54:45"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1653029,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-05/",
                    "name": "dt",
                    "value": "2026-04-05"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-04 20:33:30",
                        "last_data": "2026-04-05 18:05:47"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1656528,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-06/",
                    "name": "dt",
                    "value": "2026-04-06"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-05 20:07:25",
                        "last_data": "2026-04-06 19:25:35"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1656750,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-07/",
                    "name": "dt",
                    "value": "2026-04-07"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-06 20:02:44",
                        "last_data": "2026-04-07 18:34:49"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1656977,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-08/",
                    "name": "dt",
                    "value": "2026-04-08"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-07 19:57:15",
                        "last_data": "2026-04-08 19:36:40"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1657377,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-09/",
                    "name": "dt",
                    "value": "2026-04-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-08 19:58:49",
                        "last_data": "2026-04-09 19:35:12"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1657597,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-10/",
                    "name": "dt",
                    "value": "2026-04-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-09 20:01:23",
                        "last_data": "2026-04-10 19:38:33"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1657820,
                    "location": "s3://sfdl-segment-myfoot-prod/separated_dt/statement_confirm/dt=2026-04-11/",
                    "name": "dt",
                    "value": "2026-04-11"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-04-10 20:01:59",
                        "last_data": "2026-04-10 22:51:45"
                    },
                    "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.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",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2023-12-01 09:08:37",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.myfoot_statement_confirm`\n(\n`integrations`struct<`_empty_`:STRING>,`context`struct<`ip`:STRING,`locale`:STRING,`campaign`:struct<`medium`:STRING,`name`:STRING,`source`:STRING,`content`:STRING>,`timezone`:STRING,`userAgent`:STRING,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`page`:struct<`path`:STRING,`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>>,`event`STRING,`sentAt`STRING,`type`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`messageId`STRING,`version`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`projectId`STRING,`userId`STRING,`_origin`STRING,`channel`STRING,`receivedAt`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-myfoot-prod/separated_dt/statement_confirm'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.myfoot_statement_confirm`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.myfoot_statement_confirm"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}