Schema Info

Schema Name: sfdl_prod_segment.reactfoot_submit

created: 2017-11-02 14:03:58
disabled: False
format: raw
id: 138
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 3

Version 677174

created: 2023-11-16 17:31:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_submit`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_submit`\n(\n`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>>,`context`struct<`userAgent`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`page`:struct<`path`:STRING,`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`campaign`:struct<`utm_medium`:STRING,`term`:STRING,`content`:STRING,`name`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`source`:STRING>,`timezone`:STRING,`locale`:STRING,`amp`:struct<`id`: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,`properties`struct<`site_id`:STRING,`chatbot`:STRING,`label`:STRING,`searchId`:STRING,`category`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`extra`:struct<`unitNumber`:STRING,`complete`:STRING,`bidAmount`:STRING,`unitId`:STRING,`estimatedRevenue`:STRING,`termsVersion`:STRING,`phoneChangedNumber`:STRING,`trafficSourceId`:STRING,`callCenter`:STRING,`bookingWidget`:STRING,`reviewStatus`:STRING,`confirmationCode`:STRING,`rebateProcessed`:STRING,`email`:STRING,`resaleRate`:STRING,`bookingAgent`:STRING,`apiLeadId`:STRING,`monthlyInsurance`:STRING,`bookingState`:STRING,`hotLead`:STRING,`corrected`:STRING,`phoneVerified`:STRING,`hasContactlessMoveins`:STRING,`apiUnitId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`unitType`:STRING,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>>,`price`:struct<`meta`:STRING>,`id`:STRING,`amenities`:array,`reservation_days`:STRING>,`disputeReason`:STRING,`bookingAgentId`:STRING,`alternateFirstNames`:array,`affiliateId`:STRING,`bookingType`:STRING,`sessionId`:STRING,`read`:STRING,`typeOfListing`:STRING,`phone`:STRING,`phoneFacilityTransfer`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`centershiftAccountId`:STRING,`payoutBatchId`:STRING,`npv`:STRING,`firstName`:STRING,`apiCustId`:STRING,`facilitylocation`:struct<`address1`:STRING,`address2`:STRING,`state`:STRING,`zip`:STRING,`country`:STRING,`city`:STRING>,`price`:STRING,`commission`:STRING,`duplicateOf`:STRING,`sizeH`:STRING,`customerNotes`:STRING,`companyCode`:STRING,`AAAMemberNumber`:STRING,`promo`:STRING,`sitePhone`:STRING,`lastName`:STRING,`visitId`:STRING,`alternateEmails`:array,`timestamp`:STRING,`phoneStatus`:STRING,`facilityTenantId`:STRING,`moveIn`:STRING,`alternatePhones`:array,`movedIn`:STRING,`alternateLastNames`:array,`actualW`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`message`:STRING,`invoiceId`:STRING,`facilityName`:STRING,`actualD`:STRING,`eVisitId`:STRING,`callCenterNotes`:STRING,`eSignType`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`statementId`:STRING,`canceled`:STRING,`userId`:STRING,`hasOnlineMoveIns`:STRING,`promoCode`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`totalPaid`:STRING,`referrerId`:STRING,`pickupTime`:STRING,`contacted`:STRING,`unit`:struct<`unitIds`:array>,`emailHash`:STRING,`bidType`:STRING,`free`:STRING,`experiments`:struct<`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11616_homepage_updates`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11292_confirmation_page_hero`:STRING>,`moveOut`:STRING,`matchScore`:STRING,`moveInOriginal`:STRING,`modifiedDtm`:STRING,`siteId`:STRING,`sizeW`:STRING,`onlineMoveInUrl`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`matchReasons`:STRING,`facilityId`:STRING,`baseBid`:STRING,`depositPaid`:STRING,`sizeD`:STRING,`searchWeightId`:STRING,`facilityTenant`:STRING,`autoState`:STRING>,`env`:STRING>\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/submit'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_submit"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/submit
id: 677174
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2023-11-16T23:07:57Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1700092800000/1700175982960.events-archiver-480-25..cc3cd985-9d32-4339-98bf-a0c1dea52a4a.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "b0b001bf-118a-4390-bab0-79fde5b3fdbb",
    "channel": "client",
    "context": {
        "campaign": {
            "content": "mic_1",
            "medium": "email_transa",
            "name": "post_res"
        },
        "ip": "2603:8001:8a02:1485:162:390:e03c:8085",
        "library": {
            "name": "analytics.js",
            "version": "next-1.61.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/unsubscribe.html",
            "referrer": "",
            "search": "?utm_medium=email_transa&utm_content=mic_1&utm_campaign=post_res",
            "title": "Unsubscribe | SpareFoot",
            "url": "https://www.sparefoot.com/unsubscribe.html?utm_medium=email_transa&utm_content=mic_1&utm_campaign=post_res"
        },
        "timezone": "America/Los_Angeles",
        "userAgent": "Mozilla/5.0 (iPhone; CPU iPhone OS 17_0_2 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.0 Mobile/15E148 Safari/604.1"
    },
    "event": "submit",
    "integrations": {},
    "messageId": "ajs-next-722531adf35c1c267cd946aa890de0ee",
    "originalTimestamp": "2023-11-16T23:01:59.304Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1700175719303,
        "category": "unsubscribe form-unsubscribePage",
        "env": "production",
        "isReact": true,
        "label": "unsubscribe form-fail-unsubscribe",
        "site_id": -1
    },
    "receivedAt": "2023-11-16T23:01:59.712Z",
    "sentAt": "2023-11-16T23:01:59.318Z",
    "timestamp": "2023-11-16T23:01:59.698Z",
    "type": "track",
    "userId": "8421fc91805abb3b62f4c9b64a4ab172",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.campaign.utm_campaign": "string",
    "context.campaign.utm_medium": "string",
    "context.campaign.utm_source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.env": "string",
    "properties.extra.AAAMemberNumber": "string",
    "properties.extra.account.accountId": "string",
    "properties.extra.account.hasOnlineMoveIns": "string",
    "properties.extra.actualD": "string",
    "properties.extra.actualW": "string",
    "properties.extra.affiliateId": "string",
    "properties.extra.alternateEmails": [
        "string"
    ],
    "properties.extra.alternateFirstNames": [
        "string"
    ],
    "properties.extra.alternateLastNames": [
        "string"
    ],
    "properties.extra.alternatePhones": [
        "string"
    ],
    "properties.extra.apiCustId": "string",
    "properties.extra.apiLeadId": "string",
    "properties.extra.apiUnitId": "string",
    "properties.extra.autoState": "string",
    "properties.extra.baseBid": "string",
    "properties.extra.bidAmount": "string",
    "properties.extra.bidType": "string",
    "properties.extra.bookedUnit.amenities": [
        "string"
    ],
    "properties.extra.bookedUnit.description.physical.height": "string",
    "properties.extra.bookedUnit.description.physical.length": "string",
    "properties.extra.bookedUnit.description.physical.width": "string",
    "properties.extra.bookedUnit.description.vehicle.only": "string",
    "properties.extra.bookedUnit.description.vehicle.permitted": "string",
    "properties.extra.bookedUnit.description.vehicle.warehouse": "string",
    "properties.extra.bookedUnit.id": "string",
    "properties.extra.bookedUnit.price.meta": "string",
    "properties.extra.bookedUnit.promotion": "string",
    "properties.extra.bookedUnit.reservation_days": "string",
    "properties.extra.bookedUnit.unitType": "string",
    "properties.extra.bookingAgent": "string",
    "properties.extra.bookingAgentId": "string",
    "properties.extra.bookingState": "string",
    "properties.extra.bookingType": "string",
    "properties.extra.bookingWidget": "string",
    "properties.extra.callCenter": "string",
    "properties.extra.callCenterNotes": "string",
    "properties.extra.callCenterTransfer": "string",
    "properties.extra.callerIdPhone": "string",
    "properties.extra.canceled": "string",
    "properties.extra.centershiftAccountId": "string",
    "properties.extra.commission": "string",
    "properties.extra.companyCode": "string",
    "properties.extra.complete": "string",
    "properties.extra.confirmationCode": "string",
    "properties.extra.contacted": "string",
    "properties.extra.corrected": "string",
    "properties.extra.customerNotes": "string",
    "properties.extra.depositPaid": "string",
    "properties.extra.disputeReason": "string",
    "properties.extra.duplicateOf": "string",
    "properties.extra.eSignType": "string",
    "properties.extra.eVisitId": "string",
    "properties.extra.email": "string",
    "properties.extra.emailHash": "string",
    "properties.extra.estimatedRevenue": "string",
    "properties.extra.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.extra.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.extra.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.extra.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.extra.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.extra.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.extra.experiments.sf_11349_sfdc_omi": "string",
    "properties.extra.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.extra.experiments.sf_11616_homepage_updates": "string",
    "properties.extra.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.extra.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.extra.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.extra.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.extra.experiments.sf_omi_mfe_embed": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.facilityName": "string",
    "properties.extra.facilityPhone": "string",
    "properties.extra.facilityTenant": "string",
    "properties.extra.facilityTenantId": "string",
    "properties.extra.facility__cpLocation.address1": "string",
    "properties.extra.facility__cpLocation.address2": "string",
    "properties.extra.facility__cpLocation.city": "string",
    "properties.extra.facility__cpLocation.country": "string",
    "properties.extra.facility__cpLocation.state": "string",
    "properties.extra.facility__cpLocation.zip": "string",
    "properties.extra.facilitylocation.address1": "string",
    "properties.extra.facilitylocation.address2": "string",
    "properties.extra.facilitylocation.city": "string",
    "properties.extra.facilitylocation.country": "string",
    "properties.extra.facilitylocation.state": "string",
    "properties.extra.facilitylocation.zip": "string",
    "properties.extra.firstName": "string",
    "properties.extra.free": "string",
    "properties.extra.hasContactlessMoveins": "string",
    "properties.extra.hasOnlineMoveIns": "string",
    "properties.extra.hostedWebsite": "string",
    "properties.extra.hotLead": "string",
    "properties.extra.invoiceId": "string",
    "properties.extra.lastName": "string",
    "properties.extra.listingWantId": "string",
    "properties.extra.matchReasons": "string",
    "properties.extra.matchScore": "string",
    "properties.extra.message": "string",
    "properties.extra.modifiedDtm": "string",
    "properties.extra.monthlyInsurance": "string",
    "properties.extra.moveIn": "string",
    "properties.extra.moveInActual": "string",
    "properties.extra.moveInOriginal": "string",
    "properties.extra.moveOut": "string",
    "properties.extra.movedIn": "string",
    "properties.extra.npv": "string",
    "properties.extra.onlineMoveInUrl": "string",
    "properties.extra.payoutBatchId": "string",
    "properties.extra.phone": "string",
    "properties.extra.phoneChangedNumber": "string",
    "properties.extra.phoneFacilityTransfer": "string",
    "properties.extra.phoneStatus": "string",
    "properties.extra.phoneVerified": "string",
    "properties.extra.pickupTime": "string",
    "properties.extra.price": "string",
    "properties.extra.promo": "string",
    "properties.extra.promoCode": "string",
    "properties.extra.read": "string",
    "properties.extra.rebateProcessed": "string",
    "properties.extra.referrerId": "string",
    "properties.extra.resaleRate": "string",
    "properties.extra.reviewStatus": "string",
    "properties.extra.searchWeightId": "string",
    "properties.extra.searchWeightTestId": "string",
    "properties.extra.sessionId": "string",
    "properties.extra.siteId": "string",
    "properties.extra.sitePhone": "string",
    "properties.extra.sizeD": "string",
    "properties.extra.sizeH": "string",
    "properties.extra.sizeW": "string",
    "properties.extra.statementId": "string",
    "properties.extra.termsVersion": "string",
    "properties.extra.timestamp": "string",
    "properties.extra.totalPaid": "string",
    "properties.extra.trafficSourceId": "string",
    "properties.extra.typeOfListing": "string",
    "properties.extra.unit.unitIds": [
        "string"
    ],
    "properties.extra.unitId": "string",
    "properties.extra.unitNumber": "string",
    "properties.extra.userId": "string",
    "properties.extra.visitId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.searchId": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 138
schema_scan_id: 106050621
updated: 2023-11-16 17:40:45

Version 535608

created: 2023-06-09 04:45:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_submit`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_submit`\n(\n`userId`STRING,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>>,`originalTimestamp`STRING,`type`STRING,`channel`STRING,`receivedAt`STRING,`version`STRING,`event`STRING,`_origin`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`projectId`STRING,`sentAt`STRING,`context`struct<`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`amp`:struct<`id`:STRING>,`page`:struct<`path`:STRING,`referrer`:STRING,`search`:STRING,`title`:STRING,`url`:STRING>,`campaign`:struct<`utm_medium`:STRING,`utm_source`:STRING,`medium`:STRING,`term`:STRING,`utm_campaign`:STRING,`source`:STRING,`content`:STRING,`name`:STRING>,`userAgent`:STRING,`library`:struct<`name`:STRING,`version`:STRING>,`ip`:STRING>,`properties`struct<`env`:STRING,`extra`:struct<`unitNumber`:STRING,`complete`:STRING,`bidAmount`:STRING,`unitId`:STRING,`estimatedRevenue`:STRING,`termsVersion`:STRING,`phoneChangedNumber`:STRING,`trafficSourceId`:STRING,`callCenter`:STRING,`bookingWidget`:STRING,`reviewStatus`:STRING,`confirmationCode`:STRING,`rebateProcessed`:STRING,`email`:STRING,`resaleRate`:STRING,`bookingAgent`:STRING,`apiLeadId`:STRING,`monthlyInsurance`:STRING,`bookingState`:STRING,`hotLead`:STRING,`corrected`:STRING,`phoneVerified`:STRING,`hasContactlessMoveins`:STRING,`apiUnitId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`unitType`:STRING,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>>,`price`:struct<`meta`:STRING>,`id`:STRING,`amenities`:array,`reservation_days`:STRING>,`disputeReason`:STRING,`bookingAgentId`:STRING,`alternateFirstNames`:array,`affiliateId`:STRING,`bookingType`:STRING,`sessionId`:STRING,`read`:STRING,`typeOfListing`:STRING,`phone`:STRING,`phoneFacilityTransfer`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`centershiftAccountId`:STRING,`payoutBatchId`:STRING,`npv`:STRING,`firstName`:STRING,`apiCustId`:STRING,`facilitylocation`:struct<`address1`:STRING,`address2`:STRING,`state`:STRING,`zip`:STRING,`country`:STRING,`city`:STRING>,`price`:STRING,`commission`:STRING,`duplicateOf`:STRING,`sizeH`:STRING,`customerNotes`:STRING,`companyCode`:STRING,`AAAMemberNumber`:STRING,`promo`:STRING,`sitePhone`:STRING,`lastName`:STRING,`visitId`:STRING,`alternateEmails`:array,`timestamp`:STRING,`phoneStatus`:STRING,`facilityTenantId`:STRING,`moveIn`:STRING,`alternatePhones`:array,`movedIn`:STRING,`alternateLastNames`:array,`actualW`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`message`:STRING,`invoiceId`:STRING,`facilityName`:STRING,`actualD`:STRING,`eVisitId`:STRING,`callCenterNotes`:STRING,`eSignType`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`statementId`:STRING,`canceled`:STRING,`userId`:STRING,`hasOnlineMoveIns`:STRING,`promoCode`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`totalPaid`:STRING,`referrerId`:STRING,`pickupTime`:STRING,`contacted`:STRING,`unit`:struct<`unitIds`:array>,`emailHash`:STRING,`bidType`:STRING,`free`:STRING,`experiments`:struct<`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11616_homepage_updates`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11292_confirmation_page_hero`:STRING>,`moveOut`:STRING,`matchScore`:STRING,`moveInOriginal`:STRING,`modifiedDtm`:STRING,`siteId`:STRING,`sizeW`:STRING,`onlineMoveInUrl`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`matchReasons`:STRING,`facilityId`:STRING,`baseBid`:STRING,`depositPaid`:STRING,`sizeD`:STRING,`searchWeightId`:STRING,`facilityTenant`:STRING,`autoState`:STRING>,`searchId`:STRING,`category`:STRING,`label`:STRING,`isReact`:STRING,`site_id`:STRING,`chatbot`:STRING,`Hit_Timestamp`:STRING>,`anonymousId`STRING,`timestamp`STRING,`messageId`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/submit'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_submit"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/submit
id: 535608
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2023-06-09T09:45:24Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1686268800000/1686303861877.events-archiver-480-51.8ebb200.c45664f7-0e1e-4ba6-b5ab-e6ad22d7463f.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "a3ddca05-9aa0-4286-a54c-da772a7361c5",
    "channel": "client",
    "context": {
        "ip": "2607:fb90:8fa0:229c:ac39:31f7:6877:6560",
        "library": {
            "name": "analytics.js",
            "version": "next-1.53.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/reservation/confirmation/JZSM6X4TD",
            "referrer": "https://www.sparefoot.com/Duarte-CA-self-storage/Mt-Olive-Storage-154955.html?searchType=vehicle",
            "search": "",
            "title": "Mt. Olive Storage | 1500 Crestfield Drive | SpareFoot",
            "url": "https://www.sparefoot.com/reservation/confirmation/JZSM6X4TD"
        },
        "userAgent": "Mozilla/5.0 (Linux; Android 13; SM-A146U) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Mobile Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Chromium",
                    "version": "106"
                },
                {
                    "brand": "Google Chrome",
                    "version": "106"
                },
                {
                    "brand": "Not;A=Brand",
                    "version": "99"
                }
            ],
            "mobile": true,
            "platform": "Android"
        }
    },
    "event": "submit",
    "integrations": {},
    "messageId": "ajs-next-bcfce3d23531b5f2e9b3f72cf50321ae",
    "originalTimestamp": "2023-06-09T09:17:45.235Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1686302265223,
        "category": "update move in form-confirmationPage",
        "env": "production",
        "isReact": true,
        "label": "fail-booking-move-in",
        "site_id": -1
    },
    "receivedAt": "2023-06-09T09:17:45.646Z",
    "sentAt": "2023-06-09T09:17:45.288Z",
    "timestamp": "2023-06-09T09:17:45.593Z",
    "type": "track",
    "userId": "73eeafc0abd61c1612ae7a8481f55298",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.campaign.utm_campaign": "string",
    "context.campaign.utm_medium": "string",
    "context.campaign.utm_source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.env": "string",
    "properties.extra.AAAMemberNumber": "string",
    "properties.extra.account.accountId": "string",
    "properties.extra.account.hasOnlineMoveIns": "string",
    "properties.extra.actualD": "string",
    "properties.extra.actualW": "string",
    "properties.extra.affiliateId": "string",
    "properties.extra.alternateEmails": [
        "string"
    ],
    "properties.extra.alternateFirstNames": [
        "string"
    ],
    "properties.extra.alternateLastNames": [
        "string"
    ],
    "properties.extra.alternatePhones": [
        "string"
    ],
    "properties.extra.apiCustId": "string",
    "properties.extra.apiLeadId": "string",
    "properties.extra.apiUnitId": "string",
    "properties.extra.autoState": "string",
    "properties.extra.baseBid": "string",
    "properties.extra.bidAmount": "string",
    "properties.extra.bidType": "string",
    "properties.extra.bookedUnit.amenities": [
        "string"
    ],
    "properties.extra.bookedUnit.description.physical.height": "string",
    "properties.extra.bookedUnit.description.physical.length": "string",
    "properties.extra.bookedUnit.description.physical.width": "string",
    "properties.extra.bookedUnit.description.vehicle.only": "string",
    "properties.extra.bookedUnit.description.vehicle.permitted": "string",
    "properties.extra.bookedUnit.description.vehicle.warehouse": "string",
    "properties.extra.bookedUnit.id": "string",
    "properties.extra.bookedUnit.price.meta": "string",
    "properties.extra.bookedUnit.promotion": "string",
    "properties.extra.bookedUnit.reservation_days": "string",
    "properties.extra.bookedUnit.unitType": "string",
    "properties.extra.bookingAgent": "string",
    "properties.extra.bookingAgentId": "string",
    "properties.extra.bookingState": "string",
    "properties.extra.bookingType": "string",
    "properties.extra.bookingWidget": "string",
    "properties.extra.callCenter": "string",
    "properties.extra.callCenterNotes": "string",
    "properties.extra.callCenterTransfer": "string",
    "properties.extra.callerIdPhone": "string",
    "properties.extra.canceled": "string",
    "properties.extra.centershiftAccountId": "string",
    "properties.extra.commission": "string",
    "properties.extra.companyCode": "string",
    "properties.extra.complete": "string",
    "properties.extra.confirmationCode": "string",
    "properties.extra.contacted": "string",
    "properties.extra.corrected": "string",
    "properties.extra.customerNotes": "string",
    "properties.extra.depositPaid": "string",
    "properties.extra.disputeReason": "string",
    "properties.extra.duplicateOf": "string",
    "properties.extra.eSignType": "string",
    "properties.extra.eVisitId": "string",
    "properties.extra.email": "string",
    "properties.extra.emailHash": "string",
    "properties.extra.estimatedRevenue": "string",
    "properties.extra.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.extra.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.extra.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.extra.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.extra.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.extra.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.extra.experiments.sf_11349_sfdc_omi": "string",
    "properties.extra.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.extra.experiments.sf_11616_homepage_updates": "string",
    "properties.extra.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.extra.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.extra.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.extra.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.extra.experiments.sf_omi_mfe_embed": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.facilityName": "string",
    "properties.extra.facilityPhone": "string",
    "properties.extra.facilityTenant": "string",
    "properties.extra.facilityTenantId": "string",
    "properties.extra.facility__cpLocation.address1": "string",
    "properties.extra.facility__cpLocation.address2": "string",
    "properties.extra.facility__cpLocation.city": "string",
    "properties.extra.facility__cpLocation.country": "string",
    "properties.extra.facility__cpLocation.state": "string",
    "properties.extra.facility__cpLocation.zip": "string",
    "properties.extra.facilitylocation.address1": "string",
    "properties.extra.facilitylocation.address2": "string",
    "properties.extra.facilitylocation.city": "string",
    "properties.extra.facilitylocation.country": "string",
    "properties.extra.facilitylocation.state": "string",
    "properties.extra.facilitylocation.zip": "string",
    "properties.extra.firstName": "string",
    "properties.extra.free": "string",
    "properties.extra.hasContactlessMoveins": "string",
    "properties.extra.hasOnlineMoveIns": "string",
    "properties.extra.hostedWebsite": "string",
    "properties.extra.hotLead": "string",
    "properties.extra.invoiceId": "string",
    "properties.extra.lastName": "string",
    "properties.extra.listingWantId": "string",
    "properties.extra.matchReasons": "string",
    "properties.extra.matchScore": "string",
    "properties.extra.message": "string",
    "properties.extra.modifiedDtm": "string",
    "properties.extra.monthlyInsurance": "string",
    "properties.extra.moveIn": "string",
    "properties.extra.moveInActual": "string",
    "properties.extra.moveInOriginal": "string",
    "properties.extra.moveOut": "string",
    "properties.extra.movedIn": "string",
    "properties.extra.npv": "string",
    "properties.extra.onlineMoveInUrl": "string",
    "properties.extra.payoutBatchId": "string",
    "properties.extra.phone": "string",
    "properties.extra.phoneChangedNumber": "string",
    "properties.extra.phoneFacilityTransfer": "string",
    "properties.extra.phoneStatus": "string",
    "properties.extra.phoneVerified": "string",
    "properties.extra.pickupTime": "string",
    "properties.extra.price": "string",
    "properties.extra.promo": "string",
    "properties.extra.promoCode": "string",
    "properties.extra.read": "string",
    "properties.extra.rebateProcessed": "string",
    "properties.extra.referrerId": "string",
    "properties.extra.resaleRate": "string",
    "properties.extra.reviewStatus": "string",
    "properties.extra.searchWeightId": "string",
    "properties.extra.searchWeightTestId": "string",
    "properties.extra.sessionId": "string",
    "properties.extra.siteId": "string",
    "properties.extra.sitePhone": "string",
    "properties.extra.sizeD": "string",
    "properties.extra.sizeH": "string",
    "properties.extra.sizeW": "string",
    "properties.extra.statementId": "string",
    "properties.extra.termsVersion": "string",
    "properties.extra.timestamp": "string",
    "properties.extra.totalPaid": "string",
    "properties.extra.trafficSourceId": "string",
    "properties.extra.typeOfListing": "string",
    "properties.extra.unit.unitIds": [
        "string"
    ],
    "properties.extra.unitId": "string",
    "properties.extra.unitNumber": "string",
    "properties.extra.userId": "string",
    "properties.extra.visitId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.searchId": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 138
schema_scan_id: 94675935
updated: 2023-06-09 04:49:06

Version 505390

created: 2023-05-03 10:21:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_submit`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_submit`\n(\n`type`STRING,`context`struct<`ip`:STRING,`campaign`:struct<`utm_medium`:STRING,`utm_source`:STRING,`medium`:STRING,`term`:STRING,`utm_campaign`:STRING,`source`:STRING,`content`:STRING,`name`:STRING>,`amp`:struct<`id`:STRING>,`library`:struct<`name`:STRING,`version`:STRING>,`page`:struct<`search`:STRING,`title`:STRING,`referrer`:STRING,`url`:STRING,`path`:STRING>,`userAgent`:STRING,`locale`:STRING>,`originalTimestamp`STRING,`timestamp`STRING,`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>>,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`projectId`STRING,`anonymousId`STRING,`messageId`STRING,`properties`struct<`Hit_Timestamp`:STRING,`label`:STRING,`category`:STRING,`site_id`:STRING,`extra`:struct<`unitNumber`:STRING,`complete`:STRING,`bidAmount`:STRING,`unitId`:STRING,`estimatedRevenue`:STRING,`termsVersion`:STRING,`phoneChangedNumber`:STRING,`trafficSourceId`:STRING,`callCenter`:STRING,`bookingWidget`:STRING,`reviewStatus`:STRING,`confirmationCode`:STRING,`rebateProcessed`:STRING,`email`:STRING,`resaleRate`:STRING,`bookingAgent`:STRING,`apiLeadId`:STRING,`monthlyInsurance`:STRING,`bookingState`:STRING,`hotLead`:STRING,`corrected`:STRING,`phoneVerified`:STRING,`hasContactlessMoveins`:STRING,`apiUnitId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`unitType`:STRING,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>>,`price`:struct<`meta`:STRING>,`id`:STRING,`amenities`:array,`reservation_days`:STRING>,`disputeReason`:STRING,`bookingAgentId`:STRING,`alternateFirstNames`:array,`affiliateId`:STRING,`bookingType`:STRING,`sessionId`:STRING,`read`:STRING,`typeOfListing`:STRING,`phone`:STRING,`phoneFacilityTransfer`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`centershiftAccountId`:STRING,`payoutBatchId`:STRING,`npv`:STRING,`firstName`:STRING,`apiCustId`:STRING,`facilitylocation`:struct<`address1`:STRING,`address2`:STRING,`state`:STRING,`zip`:STRING,`country`:STRING,`city`:STRING>,`price`:STRING,`commission`:STRING,`duplicateOf`:STRING,`sizeH`:STRING,`customerNotes`:STRING,`companyCode`:STRING,`AAAMemberNumber`:STRING,`promo`:STRING,`sitePhone`:STRING,`lastName`:STRING,`visitId`:STRING,`alternateEmails`:array,`timestamp`:STRING,`phoneStatus`:STRING,`facilityTenantId`:STRING,`moveIn`:STRING,`alternatePhones`:array,`movedIn`:STRING,`alternateLastNames`:array,`actualW`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`message`:STRING,`invoiceId`:STRING,`facilityName`:STRING,`actualD`:STRING,`eVisitId`:STRING,`callCenterNotes`:STRING,`eSignType`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`statementId`:STRING,`canceled`:STRING,`userId`:STRING,`hasOnlineMoveIns`:STRING,`promoCode`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`totalPaid`:STRING,`referrerId`:STRING,`pickupTime`:STRING,`contacted`:STRING,`unit`:struct<`unitIds`:array>,`emailHash`:STRING,`bidType`:STRING,`free`:STRING,`experiments`:struct<`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11616_homepage_updates`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11292_confirmation_page_hero`:STRING>,`moveOut`:STRING,`matchScore`:STRING,`moveInOriginal`:STRING,`modifiedDtm`:STRING,`siteId`:STRING,`sizeW`:STRING,`onlineMoveInUrl`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`matchReasons`:STRING,`facilityId`:STRING,`baseBid`:STRING,`depositPaid`:STRING,`sizeD`:STRING,`searchWeightId`:STRING,`facilityTenant`:STRING,`autoState`:STRING>,`isReact`:STRING,`searchId`:STRING,`env`:STRING,`chatbot`:STRING>,`event`STRING,`receivedAt`STRING,`sentAt`STRING,`userId`STRING,`_origin`STRING,`version`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/submit'\n",
    "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_submit"
]

hive_path: s3://sfdl-segment-reactfoot-prod/separated_dt/submit
id: 505390
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c55a4597f7a100011813be",
            "59c13c7c1386430001b3c90e"
        ],
        "unbundled": []
    },
    "_origin": "2023-05-03T15:21:11Z|s3://sfdl-segment-reactfoot-prod/segment-logs/a0wkEvFBBK/1683072000000/1683127233526.events-archiver-480-13.8ebb200.9309089b-d70d-49d7-8f1e-f5be0c6e454e.gz|analytics-segment-separator-prod:$LATEST",
    "anonymousId": "84e6d77c-8f57-494e-a2a3-dc933747f24f",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "165.190.89.172",
        "library": {
            "name": "analytics.js",
            "version": "next-1.51.6"
        },
        "locale": "en-US",
        "page": {
            "path": "/review.html",
            "referrer": "https://www.sparefoot.com/reservation/confirm-move-in/426QFB8AA?email_token=97287aca477b29d70155336c8ab67b97bdac95d7&utm_medium=email_transa&utm_content=mic_1&utm_campaign=post_res",
            "search": "?confirmation_code=426QFB8AA&email_token=97287aca477b29d70155336c8ab67b97bdac95d7",
            "title": "",
            "url": "https://www.sparefoot.com/review.html?confirmation_code=426QFB8AA&email_token=97287aca477b29d70155336c8ab67b97bdac95d7"
        },
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36"
    },
    "event": "submit",
    "integrations": {},
    "messageId": "ajs-next-95dc90c3b402f21c904e986e4f8e95ff",
    "originalTimestamp": "2023-05-03T14:43:08.846Z",
    "projectId": "a0wkEvFBBK",
    "properties": {
        "Hit Timestamp": 1683127109824,
        "category": "reservation form interactions-facilityPage",
        "env": "production",
        "extra": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": "7760",
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": null,
            "apiLeadId": null,
            "apiUnitId": null,
            "autoState": null,
            "baseBid": "1.25",
            "bidAmount": "625.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "Climate Controlled",
                    "Interior"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "100.00",
                        "width": "100.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": "21759653",
                "price": {
                    "meta": "500.00"
                },
                "promotion": "",
                "reservation_days": "60",
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": "0",
            "callCenter": "0",
            "callCenterNotes": "[2023-05-03 10:18am] Booking 100' x 100' unit $500.00 (Climate Controlled, Interior) on website (SpareFoot.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": "0.00",
            "companyCode": "(DO NOT HIDE)",
            "complete": "1",
            "confirmationCode": "8MTSDCM74",
            "contacted": "0",
            "corrected": "0",
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": "VGSWDT3N9",
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "estimatedRevenue": 164.5,
            "experiments": {
                "sf_11292_confirmation_page_hero": "variation",
                "sf_11349_sfdc_omi": "inactive",
                "sf_11464_neighbordotcom_cpc_ad": "inactive",
                "sf_11786_sfdc_omi_redesign": "inactive",
                "sf_11825_sfdc_new_datepicker": "variation",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": "204142",
            "facilityName": "Sparefoot Engineering Demo - 20210322",
            "facilityPhone": "5555555555",
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "B Street",
                "address2": "",
                "city": "Perryville",
                "country": "",
                "state": "AK",
                "zip": "99648"
            },
            "firstName": "Test",
            "free": "0",
            "hasContactlessMoveins": false,
            "hasOnlineMoveIns": false,
            "hostedWebsite": "0",
            "hotLead": null,
            "invoiceId": null,
            "lastName": "Test",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2023-05-03 10:18:29",
            "monthlyInsurance": null,
            "moveIn": "2023-05-04",
            "moveInActual": null,
            "moveInOriginal": "2023-05-04",
            "moveOut": null,
            "movedIn": "0",
            "npv": "625.00",
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "5555555555",
            "phoneChangedNumber": "0",
            "phoneFacilityTransfer": "0",
            "phoneStatus": null,
            "phoneVerified": "0",
            "pickupTime": null,
            "price": "500.00",
            "promo": "",
            "promoCode": null,
            "read": "0",
            "rebateProcessed": "0",
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": "-1",
            "sitePhone": null,
            "sizeD": "100.00",
            "sizeH": null,
            "sizeW": "100.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2023-05-03 10:18:29",
            "totalPaid": null,
            "trafficSourceId": "__Direct",
            "typeOfListing": "2",
            "unit": {
                "unitIds": [
                    "21759653"
                ]
            },
            "unitId": "21759653",
            "unitNumber": null,
            "userId": "1253",
            "visitId": null
        },
        "isReact": true,
        "label": "fail-review-form",
        "site_id": -1
    },
    "receivedAt": "2023-05-03T14:40:05.835Z",
    "sentAt": "2023-05-03T14:43:08.869Z",
    "timestamp": "2023-05-03T14:40:05.812Z",
    "type": "track",
    "userId": "910408d84ad086ec8d78ac50834c60d1",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.campaign.utm_campaign": "string",
    "context.campaign.utm_medium": "string",
    "context.campaign.utm_source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "event": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.env": "string",
    "properties.extra.AAAMemberNumber": "string",
    "properties.extra.account.accountId": "string",
    "properties.extra.account.hasOnlineMoveIns": "string",
    "properties.extra.actualD": "string",
    "properties.extra.actualW": "string",
    "properties.extra.affiliateId": "string",
    "properties.extra.alternateEmails": [
        "string"
    ],
    "properties.extra.alternateFirstNames": [
        "string"
    ],
    "properties.extra.alternateLastNames": [
        "string"
    ],
    "properties.extra.alternatePhones": [
        "string"
    ],
    "properties.extra.apiCustId": "string",
    "properties.extra.apiLeadId": "string",
    "properties.extra.apiUnitId": "string",
    "properties.extra.autoState": "string",
    "properties.extra.baseBid": "string",
    "properties.extra.bidAmount": "string",
    "properties.extra.bidType": "string",
    "properties.extra.bookedUnit.amenities": [
        "string"
    ],
    "properties.extra.bookedUnit.description.physical.height": "string",
    "properties.extra.bookedUnit.description.physical.length": "string",
    "properties.extra.bookedUnit.description.physical.width": "string",
    "properties.extra.bookedUnit.description.vehicle.only": "string",
    "properties.extra.bookedUnit.description.vehicle.permitted": "string",
    "properties.extra.bookedUnit.description.vehicle.warehouse": "string",
    "properties.extra.bookedUnit.id": "string",
    "properties.extra.bookedUnit.price.meta": "string",
    "properties.extra.bookedUnit.promotion": "string",
    "properties.extra.bookedUnit.reservation_days": "string",
    "properties.extra.bookedUnit.unitType": "string",
    "properties.extra.bookingAgent": "string",
    "properties.extra.bookingAgentId": "string",
    "properties.extra.bookingState": "string",
    "properties.extra.bookingType": "string",
    "properties.extra.bookingWidget": "string",
    "properties.extra.callCenter": "string",
    "properties.extra.callCenterNotes": "string",
    "properties.extra.callCenterTransfer": "string",
    "properties.extra.callerIdPhone": "string",
    "properties.extra.canceled": "string",
    "properties.extra.centershiftAccountId": "string",
    "properties.extra.commission": "string",
    "properties.extra.companyCode": "string",
    "properties.extra.complete": "string",
    "properties.extra.confirmationCode": "string",
    "properties.extra.contacted": "string",
    "properties.extra.corrected": "string",
    "properties.extra.customerNotes": "string",
    "properties.extra.depositPaid": "string",
    "properties.extra.disputeReason": "string",
    "properties.extra.duplicateOf": "string",
    "properties.extra.eSignType": "string",
    "properties.extra.eVisitId": "string",
    "properties.extra.email": "string",
    "properties.extra.emailHash": "string",
    "properties.extra.estimatedRevenue": "string",
    "properties.extra.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.extra.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.extra.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.extra.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.extra.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.extra.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.extra.experiments.sf_11349_sfdc_omi": "string",
    "properties.extra.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.extra.experiments.sf_11616_homepage_updates": "string",
    "properties.extra.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.extra.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.extra.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.extra.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.extra.experiments.sf_omi_mfe_embed": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.facilityName": "string",
    "properties.extra.facilityPhone": "string",
    "properties.extra.facilityTenant": "string",
    "properties.extra.facilityTenantId": "string",
    "properties.extra.facility__cpLocation.address1": "string",
    "properties.extra.facility__cpLocation.address2": "string",
    "properties.extra.facility__cpLocation.city": "string",
    "properties.extra.facility__cpLocation.country": "string",
    "properties.extra.facility__cpLocation.state": "string",
    "properties.extra.facility__cpLocation.zip": "string",
    "properties.extra.facilitylocation.address1": "string",
    "properties.extra.facilitylocation.address2": "string",
    "properties.extra.facilitylocation.city": "string",
    "properties.extra.facilitylocation.country": "string",
    "properties.extra.facilitylocation.state": "string",
    "properties.extra.facilitylocation.zip": "string",
    "properties.extra.firstName": "string",
    "properties.extra.free": "string",
    "properties.extra.hasContactlessMoveins": "string",
    "properties.extra.hasOnlineMoveIns": "string",
    "properties.extra.hostedWebsite": "string",
    "properties.extra.hotLead": "string",
    "properties.extra.invoiceId": "string",
    "properties.extra.lastName": "string",
    "properties.extra.listingWantId": "string",
    "properties.extra.matchReasons": "string",
    "properties.extra.matchScore": "string",
    "properties.extra.message": "string",
    "properties.extra.modifiedDtm": "string",
    "properties.extra.monthlyInsurance": "string",
    "properties.extra.moveIn": "string",
    "properties.extra.moveInActual": "string",
    "properties.extra.moveInOriginal": "string",
    "properties.extra.moveOut": "string",
    "properties.extra.movedIn": "string",
    "properties.extra.npv": "string",
    "properties.extra.onlineMoveInUrl": "string",
    "properties.extra.payoutBatchId": "string",
    "properties.extra.phone": "string",
    "properties.extra.phoneChangedNumber": "string",
    "properties.extra.phoneFacilityTransfer": "string",
    "properties.extra.phoneStatus": "string",
    "properties.extra.phoneVerified": "string",
    "properties.extra.pickupTime": "string",
    "properties.extra.price": "string",
    "properties.extra.promo": "string",
    "properties.extra.promoCode": "string",
    "properties.extra.read": "string",
    "properties.extra.rebateProcessed": "string",
    "properties.extra.referrerId": "string",
    "properties.extra.resaleRate": "string",
    "properties.extra.reviewStatus": "string",
    "properties.extra.searchWeightId": "string",
    "properties.extra.searchWeightTestId": "string",
    "properties.extra.sessionId": "string",
    "properties.extra.siteId": "string",
    "properties.extra.sitePhone": "string",
    "properties.extra.sizeD": "string",
    "properties.extra.sizeH": "string",
    "properties.extra.sizeW": "string",
    "properties.extra.statementId": "string",
    "properties.extra.termsVersion": "string",
    "properties.extra.timestamp": "string",
    "properties.extra.totalPaid": "string",
    "properties.extra.trafficSourceId": "string",
    "properties.extra.typeOfListing": "string",
    "properties.extra.unit.unitIds": [
        "string"
    ],
    "properties.extra.unitId": "string",
    "properties.extra.unitNumber": "string",
    "properties.extra.userId": "string",
    "properties.extra.visitId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.searchId": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 138
schema_scan_id: 92055447
updated: 2023-05-03 10:35:55

Schema Scans: 3

Last at 2023-11-16 17:31:07

Scan 106050621

duration: 0:12:59.565736

exit_message:

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

id: 106050621

payload:

{
    "datatype_dict": {
        "dt": "date",
        "originaltimestamp": "timestamp_iso8601",
        "properties.facilityId": "bigint",
        "receivedAt": "timestamp_iso8601",
        "sentat": "timestamp_iso8601",
        "timestamp": "timestamp_iso8601"
    },
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2023-11-16/",
        "name": "dt",
        "type": "string",
        "value": "2023-11-16"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit",
        "key": "separated_dt/submit/dt=2023-11-16/1700175982960.events-archiver-480-25..cc3cd985-9d32-4339-98bf-a0c1dea52a4a.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_submit",
        "type": "segment"
    }
}

running: False
schema_name_id: 138
start_time: 2023-11-16 17:31:07
success: True
trace_id: 16804326667133898779

Scan 94675935

duration: 0:04:05.421310

exit_message:

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

id: 94675935

payload:

{
    "datatype_dict": {
        "dt": "date",
        "originaltimestamp": "timestamp_iso8601",
        "properties.facilityId": "bigint",
        "receivedAt": "timestamp_iso8601",
        "sentat": "timestamp_iso8601",
        "timestamp": "timestamp_iso8601"
    },
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2023-06-09/",
        "name": "dt",
        "type": "string",
        "value": "2023-06-09"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit",
        "key": "separated_dt/submit/dt=2023-06-09/1686303861877.events-archiver-480-51.8ebb200.c45664f7-0e1e-4ba6-b5ab-e6ad22d7463f.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_submit",
        "type": "segment"
    }
}

running: False
schema_name_id: 138
start_time: 2023-06-09 04:45:48
success: True
trace_id: 15916355170479439659

Scan 92055447

duration: 0:04:01.556081

exit_message:

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

id: 92055447

payload:

{
    "datatype_dict": {
        "dt": "date",
        "originaltimestamp": "timestamp_iso8601",
        "properties.facilityId": "bigint",
        "receivedAt": "timestamp_iso8601",
        "sentat": "timestamp_iso8601",
        "timestamp": "timestamp_iso8601"
    },
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2023-05-03/",
        "name": "dt",
        "type": "string",
        "value": "2023-05-03"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-prod",
        "hive_path": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit",
        "key": "separated_dt/submit/dt=2023-05-03/1683127233526.events-archiver-480-13.8ebb200.9309089b-d70d-49d7-8f1e-f5be0c6e454e.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_segment.reactfoot_submit",
        "type": "segment"
    }
}

running: False
schema_name_id: 138
start_time: 2023-05-03 10:21:35
success: True
trace_id: 6660999541016857649

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_submit`\nADD\n\n\n PARTITION (dt='2025-04-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-04-17/'\n PARTITION (dt='2025-09-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-09-02/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2026-01-29/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 1488254,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-04-17/",
            "name": "dt",
            "value": "2025-04-17"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-04-16 19:51:06",
                "last_data": "2025-04-17 17:24:55"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1547825,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-09-02/",
            "name": "dt",
            "value": "2025-09-02"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-09-02 15:52:44",
                "last_data": "2025-09-02 15:56:44"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 1628647,
            "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2026-01-29/",
            "name": "dt",
            "value": "2026-01-29"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2026-01-29 16:51:35",
                "last_data": "2026-01-29 16:51:35"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.amp.id": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.campaign.term": "string",
    "context.campaign.utm_campaign": "string",
    "context.campaign.utm_medium": "string",
    "context.campaign.utm_source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "integrations.campaign.medium": "string",
    "integrations.campaign.name": "string",
    "integrations.campaign.source": "string",
    "integrations.library.name": "string",
    "integrations.library.version": "string",
    "integrations.page.path": "string",
    "integrations.page.referrer": "string",
    "integrations.page.search": "string",
    "integrations.page.title": "string",
    "integrations.page.url": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.env": "string",
    "properties.extra.AAAMemberNumber": "string",
    "properties.extra.account.accountId": "string",
    "properties.extra.account.hasOnlineMoveIns": "string",
    "properties.extra.actualD": "string",
    "properties.extra.actualW": "string",
    "properties.extra.affiliateId": "string",
    "properties.extra.alternateEmails": [
        "string"
    ],
    "properties.extra.alternateFirstNames": [
        "string"
    ],
    "properties.extra.alternateLastNames": [
        "string"
    ],
    "properties.extra.alternatePhones": [
        "string"
    ],
    "properties.extra.apiCustId": "string",
    "properties.extra.apiLeadId": "string",
    "properties.extra.apiUnitId": "string",
    "properties.extra.autoState": "string",
    "properties.extra.baseBid": "string",
    "properties.extra.bidAmount": "string",
    "properties.extra.bidType": "string",
    "properties.extra.bookedUnit.amenities": [
        "string"
    ],
    "properties.extra.bookedUnit.description.physical.height": "string",
    "properties.extra.bookedUnit.description.physical.length": "string",
    "properties.extra.bookedUnit.description.physical.width": "string",
    "properties.extra.bookedUnit.description.vehicle.only": "string",
    "properties.extra.bookedUnit.description.vehicle.permitted": "string",
    "properties.extra.bookedUnit.description.vehicle.warehouse": "string",
    "properties.extra.bookedUnit.id": "string",
    "properties.extra.bookedUnit.price.meta": "string",
    "properties.extra.bookedUnit.promotion": "string",
    "properties.extra.bookedUnit.reservation_days": "string",
    "properties.extra.bookedUnit.unitType": "string",
    "properties.extra.bookingAgent": "string",
    "properties.extra.bookingAgentId": "string",
    "properties.extra.bookingState": "string",
    "properties.extra.bookingType": "string",
    "properties.extra.bookingWidget": "string",
    "properties.extra.callCenter": "string",
    "properties.extra.callCenterNotes": "string",
    "properties.extra.callCenterTransfer": "string",
    "properties.extra.callerIdPhone": "string",
    "properties.extra.canceled": "string",
    "properties.extra.centershiftAccountId": "string",
    "properties.extra.commission": "string",
    "properties.extra.companyCode": "string",
    "properties.extra.complete": "string",
    "properties.extra.confirmationCode": "string",
    "properties.extra.contacted": "string",
    "properties.extra.corrected": "string",
    "properties.extra.customerNotes": "string",
    "properties.extra.depositPaid": "string",
    "properties.extra.disputeReason": "string",
    "properties.extra.duplicateOf": "string",
    "properties.extra.eSignType": "string",
    "properties.extra.eVisitId": "string",
    "properties.extra.email": "string",
    "properties.extra.emailHash": "string",
    "properties.extra.estimatedRevenue": "string",
    "properties.extra.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.extra.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.extra.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.extra.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.extra.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.extra.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.extra.experiments.sf_11349_sfdc_omi": "string",
    "properties.extra.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.extra.experiments.sf_11616_homepage_updates": "string",
    "properties.extra.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.extra.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.extra.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.extra.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.extra.experiments.sf_omi_mfe_embed": "string",
    "properties.extra.facilityId": "string",
    "properties.extra.facilityName": "string",
    "properties.extra.facilityPhone": "string",
    "properties.extra.facilityTenant": "string",
    "properties.extra.facilityTenantId": "string",
    "properties.extra.facility__cpLocation.address1": "string",
    "properties.extra.facility__cpLocation.address2": "string",
    "properties.extra.facility__cpLocation.city": "string",
    "properties.extra.facility__cpLocation.country": "string",
    "properties.extra.facility__cpLocation.state": "string",
    "properties.extra.facility__cpLocation.zip": "string",
    "properties.extra.facilitylocation.address1": "string",
    "properties.extra.facilitylocation.address2": "string",
    "properties.extra.facilitylocation.city": "string",
    "properties.extra.facilitylocation.country": "string",
    "properties.extra.facilitylocation.state": "string",
    "properties.extra.facilitylocation.zip": "string",
    "properties.extra.firstName": "string",
    "properties.extra.free": "string",
    "properties.extra.hasContactlessMoveins": "string",
    "properties.extra.hasOnlineMoveIns": "string",
    "properties.extra.hostedWebsite": "string",
    "properties.extra.hotLead": "string",
    "properties.extra.invoiceId": "string",
    "properties.extra.lastName": "string",
    "properties.extra.listingWantId": "string",
    "properties.extra.matchReasons": "string",
    "properties.extra.matchScore": "string",
    "properties.extra.message": "string",
    "properties.extra.modifiedDtm": "string",
    "properties.extra.monthlyInsurance": "string",
    "properties.extra.moveIn": "string",
    "properties.extra.moveInActual": "string",
    "properties.extra.moveInOriginal": "string",
    "properties.extra.moveOut": "string",
    "properties.extra.movedIn": "string",
    "properties.extra.npv": "string",
    "properties.extra.onlineMoveInUrl": "string",
    "properties.extra.payoutBatchId": "string",
    "properties.extra.phone": "string",
    "properties.extra.phoneChangedNumber": "string",
    "properties.extra.phoneFacilityTransfer": "string",
    "properties.extra.phoneStatus": "string",
    "properties.extra.phoneVerified": "string",
    "properties.extra.pickupTime": "string",
    "properties.extra.price": "string",
    "properties.extra.promo": "string",
    "properties.extra.promoCode": "string",
    "properties.extra.read": "string",
    "properties.extra.rebateProcessed": "string",
    "properties.extra.referrerId": "string",
    "properties.extra.resaleRate": "string",
    "properties.extra.reviewStatus": "string",
    "properties.extra.searchWeightId": "string",
    "properties.extra.searchWeightTestId": "string",
    "properties.extra.sessionId": "string",
    "properties.extra.siteId": "string",
    "properties.extra.sitePhone": "string",
    "properties.extra.sizeD": "string",
    "properties.extra.sizeH": "string",
    "properties.extra.sizeW": "string",
    "properties.extra.statementId": "string",
    "properties.extra.termsVersion": "string",
    "properties.extra.timestamp": "string",
    "properties.extra.totalPaid": "string",
    "properties.extra.trafficSourceId": "string",
    "properties.extra.typeOfListing": "string",
    "properties.extra.unit.unitIds": [
        "string"
    ],
    "properties.extra.unitId": "string",
    "properties.extra.unitNumber": "string",
    "properties.extra.userId": "string",
    "properties.extra.visitId": "string",
    "properties.isReact": "string",
    "properties.label": "string",
    "properties.searchId": "string",
    "properties.site_id": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2023-11-16 17:31:11

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_submit`\n(\n`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>>,`context`struct<`userAgent`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`page`:struct<`path`:STRING,`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`campaign`:struct<`utm_medium`:STRING,`term`:STRING,`content`:STRING,`name`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`source`:STRING>,`timezone`:STRING,`locale`:STRING,`amp`:struct<`id`: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,`properties`struct<`site_id`:STRING,`chatbot`:STRING,`label`:STRING,`searchId`:STRING,`category`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`extra`:struct<`unitNumber`:STRING,`complete`:STRING,`bidAmount`:STRING,`unitId`:STRING,`estimatedRevenue`:STRING,`termsVersion`:STRING,`phoneChangedNumber`:STRING,`trafficSourceId`:STRING,`callCenter`:STRING,`bookingWidget`:STRING,`reviewStatus`:STRING,`confirmationCode`:STRING,`rebateProcessed`:STRING,`email`:STRING,`resaleRate`:STRING,`bookingAgent`:STRING,`apiLeadId`:STRING,`monthlyInsurance`:STRING,`bookingState`:STRING,`hotLead`:STRING,`corrected`:STRING,`phoneVerified`:STRING,`hasContactlessMoveins`:STRING,`apiUnitId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`unitType`:STRING,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>>,`price`:struct<`meta`:STRING>,`id`:STRING,`amenities`:array,`reservation_days`:STRING>,`disputeReason`:STRING,`bookingAgentId`:STRING,`alternateFirstNames`:array,`affiliateId`:STRING,`bookingType`:STRING,`sessionId`:STRING,`read`:STRING,`typeOfListing`:STRING,`phone`:STRING,`phoneFacilityTransfer`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`centershiftAccountId`:STRING,`payoutBatchId`:STRING,`npv`:STRING,`firstName`:STRING,`apiCustId`:STRING,`facilitylocation`:struct<`address1`:STRING,`address2`:STRING,`state`:STRING,`zip`:STRING,`country`:STRING,`city`:STRING>,`price`:STRING,`commission`:STRING,`duplicateOf`:STRING,`sizeH`:STRING,`customerNotes`:STRING,`companyCode`:STRING,`AAAMemberNumber`:STRING,`promo`:STRING,`sitePhone`:STRING,`lastName`:STRING,`visitId`:STRING,`alternateEmails`:array,`timestamp`:STRING,`phoneStatus`:STRING,`facilityTenantId`:STRING,`moveIn`:STRING,`alternatePhones`:array,`movedIn`:STRING,`alternateLastNames`:array,`actualW`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`message`:STRING,`invoiceId`:STRING,`facilityName`:STRING,`actualD`:STRING,`eVisitId`:STRING,`callCenterNotes`:STRING,`eSignType`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`statementId`:STRING,`canceled`:STRING,`userId`:STRING,`hasOnlineMoveIns`:STRING,`promoCode`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`totalPaid`:STRING,`referrerId`:STRING,`pickupTime`:STRING,`contacted`:STRING,`unit`:struct<`unitIds`:array>,`emailHash`:STRING,`bidType`:STRING,`free`:STRING,`experiments`:struct<`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11616_homepage_updates`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11292_confirmation_page_hero`:STRING>,`moveOut`:STRING,`matchScore`:STRING,`moveInOriginal`:STRING,`modifiedDtm`:STRING,`siteId`:STRING,`sizeW`:STRING,`onlineMoveInUrl`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`matchReasons`:STRING,`facilityId`:STRING,`baseBid`:STRING,`depositPaid`:STRING,`sizeD`:STRING,`searchWeightId`:STRING,`facilityTenant`:STRING,`autoState`:STRING>,`env`:STRING>\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/submit'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_submit`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_submit"
}

Server:

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

Raw:

{
    "name": {
        "created": "2017-11-02 14:03:58",
        "disabled": false,
        "format": "raw",
        "id": 138,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_prod_segment",
            "table": "reactfoot_submit"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_prod_segment.reactfoot_submit`\nADD\n\n\n PARTITION (dt='2025-04-17') location 's3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-04-17/'\n PARTITION (dt='2025-09-02') location 's3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-09-02/'\n PARTITION (dt='2026-01-29') location 's3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2026-01-29/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 1488254,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-04-17/",
                    "name": "dt",
                    "value": "2025-04-17"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-04-16 19:51:06",
                        "last_data": "2025-04-17 17:24:55"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1547825,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2025-09-02/",
                    "name": "dt",
                    "value": "2025-09-02"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-09-02 15:52:44",
                        "last_data": "2025-09-02 15:56:44"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 1628647,
                    "location": "s3://sfdl-segment-reactfoot-prod/separated_dt/submit/dt=2026-01-29/",
                    "name": "dt",
                    "value": "2026-01-29"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2026-01-29 16:51:35",
                        "last_data": "2026-01-29 16:51:35"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "anonymousId": "string",
            "channel": "string",
            "context.amp.id": "string",
            "context.campaign.content": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.campaign.term": "string",
            "context.campaign.utm_campaign": "string",
            "context.campaign.utm_medium": "string",
            "context.campaign.utm_source": "string",
            "context.ip": "string",
            "context.library.name": "string",
            "context.library.version": "string",
            "context.locale": "string",
            "context.page.path": "string",
            "context.page.referrer": "string",
            "context.page.search": "string",
            "context.page.title": "string",
            "context.page.url": "string",
            "context.timezone": "string",
            "context.userAgent": "string",
            "context.userAgentData.brands": [
                {
                    "brand": "string",
                    "version": "string"
                }
            ],
            "context.userAgentData.mobile": "string",
            "context.userAgentData.platform": "string",
            "event": "string",
            "integrations.campaign.medium": "string",
            "integrations.campaign.name": "string",
            "integrations.campaign.source": "string",
            "integrations.library.name": "string",
            "integrations.library.version": "string",
            "integrations.page.path": "string",
            "integrations.page.referrer": "string",
            "integrations.page.search": "string",
            "integrations.page.title": "string",
            "integrations.page.url": "string",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.category": "string",
            "properties.chatbot": "string",
            "properties.env": "string",
            "properties.extra.AAAMemberNumber": "string",
            "properties.extra.account.accountId": "string",
            "properties.extra.account.hasOnlineMoveIns": "string",
            "properties.extra.actualD": "string",
            "properties.extra.actualW": "string",
            "properties.extra.affiliateId": "string",
            "properties.extra.alternateEmails": [
                "string"
            ],
            "properties.extra.alternateFirstNames": [
                "string"
            ],
            "properties.extra.alternateLastNames": [
                "string"
            ],
            "properties.extra.alternatePhones": [
                "string"
            ],
            "properties.extra.apiCustId": "string",
            "properties.extra.apiLeadId": "string",
            "properties.extra.apiUnitId": "string",
            "properties.extra.autoState": "string",
            "properties.extra.baseBid": "string",
            "properties.extra.bidAmount": "string",
            "properties.extra.bidType": "string",
            "properties.extra.bookedUnit.amenities": [
                "string"
            ],
            "properties.extra.bookedUnit.description.physical.height": "string",
            "properties.extra.bookedUnit.description.physical.length": "string",
            "properties.extra.bookedUnit.description.physical.width": "string",
            "properties.extra.bookedUnit.description.vehicle.only": "string",
            "properties.extra.bookedUnit.description.vehicle.permitted": "string",
            "properties.extra.bookedUnit.description.vehicle.warehouse": "string",
            "properties.extra.bookedUnit.id": "string",
            "properties.extra.bookedUnit.price.meta": "string",
            "properties.extra.bookedUnit.promotion": "string",
            "properties.extra.bookedUnit.reservation_days": "string",
            "properties.extra.bookedUnit.unitType": "string",
            "properties.extra.bookingAgent": "string",
            "properties.extra.bookingAgentId": "string",
            "properties.extra.bookingState": "string",
            "properties.extra.bookingType": "string",
            "properties.extra.bookingWidget": "string",
            "properties.extra.callCenter": "string",
            "properties.extra.callCenterNotes": "string",
            "properties.extra.callCenterTransfer": "string",
            "properties.extra.callerIdPhone": "string",
            "properties.extra.canceled": "string",
            "properties.extra.centershiftAccountId": "string",
            "properties.extra.commission": "string",
            "properties.extra.companyCode": "string",
            "properties.extra.complete": "string",
            "properties.extra.confirmationCode": "string",
            "properties.extra.contacted": "string",
            "properties.extra.corrected": "string",
            "properties.extra.customerNotes": "string",
            "properties.extra.depositPaid": "string",
            "properties.extra.disputeReason": "string",
            "properties.extra.duplicateOf": "string",
            "properties.extra.eSignType": "string",
            "properties.extra.eVisitId": "string",
            "properties.extra.email": "string",
            "properties.extra.emailHash": "string",
            "properties.extra.estimatedRevenue": "string",
            "properties.extra.experiments.sf_10104_sfdc_confirmation_cta": "string",
            "properties.extra.experiments.sf_10757_sfdc_chatbot": "string",
            "properties.extra.experiments.sf_10841_sfdc_platform_x_integration": "string",
            "properties.extra.experiments.sf_10867_sfdc_smaller_informed_search": "string",
            "properties.extra.experiments.sf_11267_sticky_search_clp_hero": "string",
            "properties.extra.experiments.sf_11292_confirmation_page_hero": "string",
            "properties.extra.experiments.sf_11349_sfdc_omi": "string",
            "properties.extra.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
            "properties.extra.experiments.sf_11616_homepage_updates": "string",
            "properties.extra.experiments.sf_11786_sfdc_omi_redesign": "string",
            "properties.extra.experiments.sf_11825_sfdc_new_datepicker": "string",
            "properties.extra.experiments.sf_9431_sfdc_vip_large_card": "string",
            "properties.extra.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
            "properties.extra.experiments.sf_omi_mfe_embed": "string",
            "properties.extra.facilityId": "string",
            "properties.extra.facilityName": "string",
            "properties.extra.facilityPhone": "string",
            "properties.extra.facilityTenant": "string",
            "properties.extra.facilityTenantId": "string",
            "properties.extra.facility__cpLocation.address1": "string",
            "properties.extra.facility__cpLocation.address2": "string",
            "properties.extra.facility__cpLocation.city": "string",
            "properties.extra.facility__cpLocation.country": "string",
            "properties.extra.facility__cpLocation.state": "string",
            "properties.extra.facility__cpLocation.zip": "string",
            "properties.extra.facilitylocation.address1": "string",
            "properties.extra.facilitylocation.address2": "string",
            "properties.extra.facilitylocation.city": "string",
            "properties.extra.facilitylocation.country": "string",
            "properties.extra.facilitylocation.state": "string",
            "properties.extra.facilitylocation.zip": "string",
            "properties.extra.firstName": "string",
            "properties.extra.free": "string",
            "properties.extra.hasContactlessMoveins": "string",
            "properties.extra.hasOnlineMoveIns": "string",
            "properties.extra.hostedWebsite": "string",
            "properties.extra.hotLead": "string",
            "properties.extra.invoiceId": "string",
            "properties.extra.lastName": "string",
            "properties.extra.listingWantId": "string",
            "properties.extra.matchReasons": "string",
            "properties.extra.matchScore": "string",
            "properties.extra.message": "string",
            "properties.extra.modifiedDtm": "string",
            "properties.extra.monthlyInsurance": "string",
            "properties.extra.moveIn": "string",
            "properties.extra.moveInActual": "string",
            "properties.extra.moveInOriginal": "string",
            "properties.extra.moveOut": "string",
            "properties.extra.movedIn": "string",
            "properties.extra.npv": "string",
            "properties.extra.onlineMoveInUrl": "string",
            "properties.extra.payoutBatchId": "string",
            "properties.extra.phone": "string",
            "properties.extra.phoneChangedNumber": "string",
            "properties.extra.phoneFacilityTransfer": "string",
            "properties.extra.phoneStatus": "string",
            "properties.extra.phoneVerified": "string",
            "properties.extra.pickupTime": "string",
            "properties.extra.price": "string",
            "properties.extra.promo": "string",
            "properties.extra.promoCode": "string",
            "properties.extra.read": "string",
            "properties.extra.rebateProcessed": "string",
            "properties.extra.referrerId": "string",
            "properties.extra.resaleRate": "string",
            "properties.extra.reviewStatus": "string",
            "properties.extra.searchWeightId": "string",
            "properties.extra.searchWeightTestId": "string",
            "properties.extra.sessionId": "string",
            "properties.extra.siteId": "string",
            "properties.extra.sitePhone": "string",
            "properties.extra.sizeD": "string",
            "properties.extra.sizeH": "string",
            "properties.extra.sizeW": "string",
            "properties.extra.statementId": "string",
            "properties.extra.termsVersion": "string",
            "properties.extra.timestamp": "string",
            "properties.extra.totalPaid": "string",
            "properties.extra.trafficSourceId": "string",
            "properties.extra.typeOfListing": "string",
            "properties.extra.unit.unitIds": [
                "string"
            ],
            "properties.extra.unitId": "string",
            "properties.extra.unitNumber": "string",
            "properties.extra.userId": "string",
            "properties.extra.visitId": "string",
            "properties.isReact": "string",
            "properties.label": "string",
            "properties.searchId": "string",
            "properties.site_id": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2023-11-16 17:31:11",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_segment.reactfoot_submit`\n(\n`integrations`struct<`library`:struct<`version`:STRING,`name`:STRING>,`page`:struct<`url`:STRING,`path`:STRING,`search`:STRING,`referrer`:STRING,`title`:STRING>,`campaign`:struct<`source`:STRING,`medium`:STRING,`name`:STRING>>,`context`struct<`userAgent`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`page`:struct<`path`:STRING,`search`:STRING,`referrer`:STRING,`url`:STRING,`title`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`ip`:STRING,`campaign`:struct<`utm_medium`:STRING,`term`:STRING,`content`:STRING,`name`:STRING,`utm_campaign`:STRING,`utm_source`:STRING,`medium`:STRING,`source`:STRING>,`timezone`:STRING,`locale`:STRING,`amp`:struct<`id`: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,`properties`struct<`site_id`:STRING,`chatbot`:STRING,`label`:STRING,`searchId`:STRING,`category`:STRING,`Hit_Timestamp`:STRING,`isReact`:STRING,`extra`:struct<`unitNumber`:STRING,`complete`:STRING,`bidAmount`:STRING,`unitId`:STRING,`estimatedRevenue`:STRING,`termsVersion`:STRING,`phoneChangedNumber`:STRING,`trafficSourceId`:STRING,`callCenter`:STRING,`bookingWidget`:STRING,`reviewStatus`:STRING,`confirmationCode`:STRING,`rebateProcessed`:STRING,`email`:STRING,`resaleRate`:STRING,`bookingAgent`:STRING,`apiLeadId`:STRING,`monthlyInsurance`:STRING,`bookingState`:STRING,`hotLead`:STRING,`corrected`:STRING,`phoneVerified`:STRING,`hasContactlessMoveins`:STRING,`apiUnitId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`unitType`:STRING,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>>,`price`:struct<`meta`:STRING>,`id`:STRING,`amenities`:array,`reservation_days`:STRING>,`disputeReason`:STRING,`bookingAgentId`:STRING,`alternateFirstNames`:array,`affiliateId`:STRING,`bookingType`:STRING,`sessionId`:STRING,`read`:STRING,`typeOfListing`:STRING,`phone`:STRING,`phoneFacilityTransfer`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`centershiftAccountId`:STRING,`payoutBatchId`:STRING,`npv`:STRING,`firstName`:STRING,`apiCustId`:STRING,`facilitylocation`:struct<`address1`:STRING,`address2`:STRING,`state`:STRING,`zip`:STRING,`country`:STRING,`city`:STRING>,`price`:STRING,`commission`:STRING,`duplicateOf`:STRING,`sizeH`:STRING,`customerNotes`:STRING,`companyCode`:STRING,`AAAMemberNumber`:STRING,`promo`:STRING,`sitePhone`:STRING,`lastName`:STRING,`visitId`:STRING,`alternateEmails`:array,`timestamp`:STRING,`phoneStatus`:STRING,`facilityTenantId`:STRING,`moveIn`:STRING,`alternatePhones`:array,`movedIn`:STRING,`alternateLastNames`:array,`actualW`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`facilityPhone`:STRING,`message`:STRING,`invoiceId`:STRING,`facilityName`:STRING,`actualD`:STRING,`eVisitId`:STRING,`callCenterNotes`:STRING,`eSignType`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`statementId`:STRING,`canceled`:STRING,`userId`:STRING,`hasOnlineMoveIns`:STRING,`promoCode`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`totalPaid`:STRING,`referrerId`:STRING,`pickupTime`:STRING,`contacted`:STRING,`unit`:struct<`unitIds`:array>,`emailHash`:STRING,`bidType`:STRING,`free`:STRING,`experiments`:struct<`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11616_homepage_updates`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11292_confirmation_page_hero`:STRING>,`moveOut`:STRING,`matchScore`:STRING,`moveInOriginal`:STRING,`modifiedDtm`:STRING,`siteId`:STRING,`sizeW`:STRING,`onlineMoveInUrl`:STRING,`facility__cpLocation`:struct<`address1`:STRING,`address2`:STRING,`city`:STRING,`country`:STRING,`state`:STRING,`zip`:STRING>,`matchReasons`:STRING,`facilityId`:STRING,`baseBid`:STRING,`depositPaid`:STRING,`sizeD`:STRING,`searchWeightId`:STRING,`facilityTenant`:STRING,`autoState`:STRING>,`env`:STRING>\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-prod/separated_dt/submit'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_segment.reactfoot_submit`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_segment.reactfoot_submit"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}