Schema Info

Schema Name: sfdl_dev_segment.reactfoot_submit

created: 2017-10-02 15:04:22
disabled: False
format: raw
id: 434
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 3

Version 4700448

created: 2024-01-10 09:50:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_submit`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_submit`\n(\n`type`STRING,`version`STRING,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`timestamp`STRING,`integrations`struct<`_empty_`:STRING>,`_origin`STRING,`properties`struct<`images`:array,`searchId`:STRING,`showLocalPhones`:STRING,`site_id`:STRING,`irmFacility`:STRING,`staticMapUrlLarge`:STRING,`promotion`:STRING,`isSelfStorage`:STRING,`imageDetails`:array>,`reviewMetadata`:struct<`count`:STRING,`cons`:array,`average`:STRING,`ratingCounts`:array>,`pros`:array>,`recommendedCount`:STRING>,`messaging`:struct<`amexActive`:STRING,`isUrgent`:STRING,`isOpenNow`:STRING,`isAaaEligible`:STRING,`hasPenskeTruck`:STRING,`isOrWillBeOpen`:STRING>,`staticMapUrl`:STRING,`isOutOfNetwork`:STRING,`isReact`:STRING,`tos`:STRING,`location`:struct<`city`:STRING,`streetView`:struct<`active`:STRING,`image`:STRING,`yaw`:STRING,`zoom`:STRING,`pitch`:STRING>,`zip`:STRING,`country`:STRING,`fullState`:STRING,`state`:STRING,`longitude`:STRING,`streetAddress`:STRING,`text`:STRING,`latitude`:STRING,`id`:STRING,`subLocality`:STRING>,`amenities`:struct<`acceptedCreditCards`:array>,`label`:STRING,`isActive`:STRING,`category`:STRING,`units`:array,`nearby`:struct<`facilities`:array>,`closures`:array,`extra`:struct<`lastName`:STRING,`bidAmount`:STRING,`omiPri`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`AAAMemberNumber`:STRING,`moveIn`:STRING,`promoCode`:STRING,`bookedUnit`:struct<`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array,`promotion`:STRING,`description`:struct<`physical`:struct<`length`:STRING,`width`:STRING,`height`:STRING>,`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>>,`reservation_days`:STRING,`id`:STRING>,`apiLeadId`:STRING,`matchReasons`:STRING,`bookingAgentId`:STRING,`apiCustId`:STRING,`movedIn`:STRING,`userId`:STRING,`duplicateOf`:STRING,`autoState`:STRING,`email`:STRING,`pickupTime`:STRING,`searchWeightTestId`:STRING,`hasOnlineMoveIns`:STRING,`payoutBatchId`:STRING,`moveOut`:STRING,`estimatedRevenue`:STRING,`onlineMoveInUrl`:STRING,`actualD`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`facilityId`:STRING,`bookingType`:STRING,`matchScore`:STRING,`callCenter`:STRING,`phone`:STRING,`npv`:STRING,`rebateProcessed`:STRING,`totalPaid`:STRING,`bookingState`:STRING,`depositPaid`:STRING,`omiFlowEnabled`:STRING,`phoneFacilityTransfer`:STRING,`callCenterTransfer`:STRING,`facilityName`:STRING,`hotLead`:STRING,`bidType`:STRING,`facilitylocation`:struct<`address1`:STRING,`city`:STRING,`country`:STRING,`zip`:STRING,`address2`:STRING,`state`:STRING>,`complete`:STRING,`sessionId`:STRING,`unitId`:STRING,`resaleRate`:STRING,`invoiceId`:STRING,`free`:STRING,`confirmationCode`:STRING,`price`:STRING,`unit`:struct<`unitIds`:array>,`monthlyInsurance`:STRING,`referrerId`:STRING,`trafficSourceId`:STRING,`typeOfListing`:STRING,`emailHash`:STRING,`hasContactlessMoveins`:STRING,`sizeH`:STRING,`facilityTenant`:STRING,`promo`:STRING,`alternateLastNames`:array,`phoneVerified`:STRING,`facilityTenantId`:STRING,`sizeD`:STRING,`actualW`:STRING,`statementId`:STRING,`read`:STRING,`termsVersion`:STRING,`callerIdPhone`:STRING,`contacted`:STRING,`firstName`:STRING,`facilityPhone`:STRING,`hostedWebsite`:STRING,`modifiedDtm`:STRING,`message`:STRING,`bookingWidget`:STRING,`alternatePhones`:array,`experiments`:struct<`sf_omi_mfe_embed`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11616_homepage_updates`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING>,`alternateEmails`:array,`timestamp`:STRING,`sizeW`:STRING,`phoneStatus`:STRING,`commission`:STRING,`centershiftAccountId`:STRING,`apiUnitId`:STRING,`eVisitId`:STRING,`corrected`:STRING,`reviewStatus`:STRING,`eSignType`:STRING,`searchWeightId`:STRING,`siteId`:STRING,`unitNumber`:STRING,`visitId`:STRING,`alternateFirstNames`:array,`omiCompleted`:STRING,`affiliateId`:STRING,`sitePhone`:STRING,`bookingAgent`:STRING,`phoneChangedNumber`:STRING,`companyCode`:STRING,`moveInOriginal`:STRING,`baseBid`:STRING,`canceled`:STRING,`disputeReason`:STRING,`customerNotes`:STRING,`callCenterNotes`:STRING>,`chatbot`:STRING,`groupedAmenities`:struct<`premium`:struct<`items`:struct<`propane`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`generalMaintenance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`detailing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`ice`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`water`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`washStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`airPump`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vacuum`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fuel`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`inspections`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`dumpStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`billing`:struct<`items`:struct<`chargeDate`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`cashAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`creditCardsAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`autoPay`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`securityDeposit`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`emailInvoicing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`checksAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`administration`:struct<`items`:struct<`bilingualManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`acceptTenantMail`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`adminFee`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`access`:struct<`items`:struct<`truckAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`handcarts`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`kiosk`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`egateAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`elevator`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`discounts`:struct<`items`:struct<`seniorDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`militaryDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`studentDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`other`:struct<`items`:struct<`paperworkRemotely`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`bandPracticeAllowed`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`moving`:struct<`items`:struct<`truckRentalAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`movingSupplies`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`freeTruckRental`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`vehicle`:struct<`items`:struct<`vehicleRequiresInsurance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresTitle`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresRegistration`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleMustBeRunning`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`security`:struct<`items`:struct<`residentManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fenced`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`surveillance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`insurance`:struct<`items`:struct<`homeInsuranceAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceRequired`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>>,`name`:STRING,`serviceArea`:STRING,`jordanProp`:STRING,`description`:STRING,`phone`:STRING,`fees`:struct<`admin`:struct<`text`:STRING,`value`:STRING>,`deposit`:struct<`hasDeposit`:STRING,`text`:STRING,`percent`:STRING,`isRefundable`:STRING,`value`:STRING>,`insurance`:STRING>,`reviews`:array>,`utcOffset`:STRING,`month`:STRING,`isValidDate`:STRING,`isValidTime`:STRING,`year`:STRING,`dayOfWeekText`:STRING,`day`:STRING,`minute`:STRING,`second`:STRING>,`title`:STRING,`ratingDetails`:struct<`ratingService`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingPrice`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingCleanliness`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>>,`nickname`:STRING,`message`:STRING,`ratingRecommended`:STRING>>,`corporation`:struct<`sourceId`:STRING,`type`:STRING,`id`:STRING>,`url`:struct<`website`:STRING,`city`:STRING,`state`:STRING,`facility`:STRING>,`inNetwork`:STRING,`website`:STRING,`isFullServiceStandalone`:STRING,`hours`:struct<`access`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>>,`office`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>,`meta`:STRING>>,`irmMarket`:STRING,`env`:STRING,`id`:STRING,`Hit_Timestamp`:STRING>,`userId`STRING,`sentAt`STRING,`messageId`STRING,`event`STRING,`projectId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`context`struct<`ip`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING>,`userAgent`:STRING,`timezone`:STRING,`locale`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`library`:struct<`version`:STRING,`name`:STRING>>,`receivedAt`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/submit'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_submit"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/submit
id: 4700448
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c552c7d935bd0001b8729c",
            "59c13cfcc84de40001a9cdcc"
        ],
        "unbundled": []
    },
    "_origin": "2024-01-10T15:50:42Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1704844800000/1704901657096.events-archiver-480-30..369d93d3-2a3b-4e01-8515-ee955f1a78e5.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "3864f685-2737-42b3-b143-eaeb8f94f914",
    "channel": "client",
    "context": {
        "ip": "54.175.218.140",
        "library": {
            "name": "analytics.js",
            "version": "next-1.62.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage/SiteLink-Demo-Facility-105463.html",
            "referrer": "http://localhost:9000/search.html?location=perryvillle%2C%20alaska",
            "search": "",
            "title": "SiteLink Demo Facility | 403 Brooks Road | SpareFoot",
            "url": "http://localhost:9000/Perryville-AK-self-storage/SiteLink-Demo-Facility-105463.html"
        },
        "timezone": "America/Mexico_City",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Not_A Brand",
                    "version": "8"
                },
                {
                    "brand": "Chromium",
                    "version": "120"
                },
                {
                    "brand": "Google Chrome",
                    "version": "120"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "submit",
    "integrations": {},
    "messageId": "ajs-next-e8d0eb21d30e8e4a187c3b5f2f74ff9f",
    "originalTimestamp": "2024-01-10T15:32:48.835Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1704900768834,
        "category": "reservation form interactions-facilityPage",
        "env": "development",
        "extra": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 2318,
                "hasOnlineMoveIns": true
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "Storage.com",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "491016",
            "apiLeadId": "216914",
            "apiUnitId": "33375",
            "autoState": null,
            "baseBid": "2.50",
            "bidAmount": "1942.50",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "1st Floor",
                    "9' Ceiling",
                    "Outdoor Access"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "5.00",
                        "width": "5.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 15416136,
                "price": {
                    "meta": "505.05"
                },
                "promotion": "Free 1 Months Rent - P2",
                "reservation_days": 60,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-01-10 9:32am] Booking 5' x 5' unit $505.05 (1st Floor, 9' Ceiling, Outdoor Access) Promo: Free 1 Months Rent - P2 on website (Storage.com)\n[2024-01-10 9:32am] SL Reference ID: 765667",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": null,
            "companyCode": null,
            "complete": 1,
            "confirmationCode": "JG3FVED8S",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": "NVSFHKEN2",
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "estimatedRevenue": null,
            "experiments": {
                "sf_11292_confirmation_page_hero": "variation",
                "sf_11349_sfdc_omi": "control",
                "sf_11464_neighbordotcom_cpc_ad": "variation",
                "sf_11786_sfdc_omi_redesign": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "variation",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 105463,
            "facilityName": "SiteLink Demo Facility",
            "facilityPhone": 5127056208,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "403 Brooks Road",
                "address2": "",
                "city": "Perryville",
                "country": "",
                "state": "AK",
                "zip": "99648"
            },
            "firstName": "test",
            "free": 0,
            "hasContactlessMoveins": true,
            "hasOnlineMoveIns": true,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "test",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-01-10 09:32:48",
            "monthlyInsurance": null,
            "moveIn": "2024-01-11",
            "moveInActual": null,
            "moveInOriginal": "2024-01-11",
            "moveOut": null,
            "movedIn": 0,
            "npv": "1942.50",
            "omiCompleted": false,
            "omiFlowEnabled": true,
            "omiPri": "pal:reservation:sl:CSPFT;LTRAIN;216914",
            "onlineMoveInUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?ep=PIohUNkQ3b76qL6WCojInHbzWv9BaiPQZciyrMX5wU9YlQp%2bkkziwYQr6LCPvZWPCUxsYJMNdYwHoaK5tM30jc6Ai%2fEeNOUNiZS0wCptHHkyQfmm79VIXvc9pe53nTz8FWo1j%2fOkRoRvsNMxMZVH6n7aj6GIf%2fzyQcAmlc3plek%3d",
            "payoutBatchId": null,
            "phone": "5555555555",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "505.05",
            "promo": "Free 1 Months Rent - P2",
            "promoCode": null,
            "read": 0,
            "rebateProcessed": 0,
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": 424,
            "sitePhone": null,
            "sizeD": "5.00",
            "sizeH": null,
            "sizeW": "5.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-01-10 09:32:47",
            "totalPaid": null,
            "trafficSourceId": null,
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "15416102",
                    "15416111",
                    "15416123",
                    "15416136",
                    "15416168",
                    "15416190",
                    "15416209",
                    "15416235",
                    "15416250",
                    "15416265",
                    "15416282",
                    "15416301",
                    "15416314",
                    "15416349",
                    "15416377",
                    "15416555",
                    "15416597",
                    "15416633",
                    "15416666",
                    "15416684",
                    "15416731",
                    "15416743",
                    "15416770",
                    "15416792",
                    "15416801",
                    "16420926"
                ]
            },
            "unitId": 15416136,
            "unitNumber": "303",
            "userId": 1253,
            "visitId": null
        },
        "isReact": true,
        "label": "filterable units-reservation form-success-web-storage-5x5",
        "site_id": -1
    },
    "receivedAt": "2024-01-10T15:32:49.552Z",
    "sentAt": "2024-01-10T15:32:48.925Z",
    "timestamp": "2024-01-10T15:32:49.462Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.amenities.acceptedCreditCards": [
        "string"
    ],
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.closures": [
        "string"
    ],
    "properties.corporation.id": "string",
    "properties.corporation.sourceId": "string",
    "properties.corporation.type": "string",
    "properties.description": "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_12289_sfdc_holiday_messaging": "string",
    "properties.extra.experiments.sf_12496_sfdc_clp_unitcardrefresh": "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.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.omiCompleted": "string",
    "properties.extra.omiFlowEnabled": "string",
    "properties.extra.omiPri": "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.fees.admin.text": "string",
    "properties.fees.admin.value": "string",
    "properties.fees.deposit.hasDeposit": "string",
    "properties.fees.deposit.isRefundable": "string",
    "properties.fees.deposit.percent": "string",
    "properties.fees.deposit.text": "string",
    "properties.fees.deposit.value": "string",
    "properties.fees.insurance": "string",
    "properties.groupedAmenities.access.items.egateAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.egateAccess.label": "string",
    "properties.groupedAmenities.access.items.egateAccess.showAlways": "string",
    "properties.groupedAmenities.access.items.elevator.hasAttribute": "string",
    "properties.groupedAmenities.access.items.elevator.label": "string",
    "properties.groupedAmenities.access.items.elevator.showAlways": "string",
    "properties.groupedAmenities.access.items.handcarts.hasAttribute": "string",
    "properties.groupedAmenities.access.items.handcarts.label": "string",
    "properties.groupedAmenities.access.items.handcarts.showAlways": "string",
    "properties.groupedAmenities.access.items.kiosk.hasAttribute": "string",
    "properties.groupedAmenities.access.items.kiosk.label": "string",
    "properties.groupedAmenities.access.items.kiosk.showAlways": "string",
    "properties.groupedAmenities.access.items.truckAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.truckAccess.label": "string",
    "properties.groupedAmenities.access.items.truckAccess.showAlways": "string",
    "properties.groupedAmenities.access.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.showAlways": "string",
    "properties.groupedAmenities.administration.items.adminFee.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.adminFee.label": "string",
    "properties.groupedAmenities.administration.items.adminFee.showAlways": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.label": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.showAlways": "string",
    "properties.groupedAmenities.administration.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.autoPay.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.showAlways": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.label": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.chargeDate.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.chargeDate.label": "string",
    "properties.groupedAmenities.billing.items.chargeDate.showAlways": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.label": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.label": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.label": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.showAlways": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.label": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.showAlways": "string",
    "properties.groupedAmenities.billing.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.showAlways": "string",
    "properties.groupedAmenities.insurance.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.showAlways": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.label": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.showAlways": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.label": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.showAlways": "string",
    "properties.groupedAmenities.moving.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.hasAttribute": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.showAlways": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.hasAttribute": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.label": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.showAlways": "string",
    "properties.groupedAmenities.other.label": "string",
    "properties.groupedAmenities.premium.items.airPump.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.airPump.label": "string",
    "properties.groupedAmenities.premium.items.airPump.showAlways": "string",
    "properties.groupedAmenities.premium.items.detailing.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.detailing.label": "string",
    "properties.groupedAmenities.premium.items.detailing.showAlways": "string",
    "properties.groupedAmenities.premium.items.dumpStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.dumpStation.label": "string",
    "properties.groupedAmenities.premium.items.dumpStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.fuel.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.fuel.label": "string",
    "properties.groupedAmenities.premium.items.fuel.showAlways": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.label": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.showAlways": "string",
    "properties.groupedAmenities.premium.items.ice.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.ice.label": "string",
    "properties.groupedAmenities.premium.items.ice.showAlways": "string",
    "properties.groupedAmenities.premium.items.inspections.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.inspections.label": "string",
    "properties.groupedAmenities.premium.items.inspections.showAlways": "string",
    "properties.groupedAmenities.premium.items.propane.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.propane.label": "string",
    "properties.groupedAmenities.premium.items.propane.showAlways": "string",
    "properties.groupedAmenities.premium.items.vacuum.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.vacuum.label": "string",
    "properties.groupedAmenities.premium.items.vacuum.showAlways": "string",
    "properties.groupedAmenities.premium.items.washStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.washStation.label": "string",
    "properties.groupedAmenities.premium.items.washStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.water.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.water.label": "string",
    "properties.groupedAmenities.premium.items.water.showAlways": "string",
    "properties.groupedAmenities.premium.label": "string",
    "properties.groupedAmenities.security.items.fenced.hasAttribute": "string",
    "properties.groupedAmenities.security.items.fenced.label": "string",
    "properties.groupedAmenities.security.items.fenced.showAlways": "string",
    "properties.groupedAmenities.security.items.residentManager.hasAttribute": "string",
    "properties.groupedAmenities.security.items.residentManager.label": "string",
    "properties.groupedAmenities.security.items.residentManager.showAlways": "string",
    "properties.groupedAmenities.security.items.surveillance.hasAttribute": "string",
    "properties.groupedAmenities.security.items.surveillance.label": "string",
    "properties.groupedAmenities.security.items.surveillance.showAlways": "string",
    "properties.groupedAmenities.security.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.showAlways": "string",
    "properties.groupedAmenities.vehicle.label": "string",
    "properties.hours.access.text.friday": "string",
    "properties.hours.access.text.monday": "string",
    "properties.hours.access.text.saturday": "string",
    "properties.hours.access.text.sunday": "string",
    "properties.hours.access.text.thursday": "string",
    "properties.hours.access.text.tuesday": "string",
    "properties.hours.access.text.wednesday": "string",
    "properties.hours.office.meta": "string",
    "properties.hours.office.text.friday": "string",
    "properties.hours.office.text.monday": "string",
    "properties.hours.office.text.saturday": "string",
    "properties.hours.office.text.sunday": "string",
    "properties.hours.office.text.thursday": "string",
    "properties.hours.office.text.tuesday": "string",
    "properties.hours.office.text.wednesday": "string",
    "properties.id": "string",
    "properties.imageDetails": [
        {
            "image": "string",
            "tag": "string"
        }
    ],
    "properties.images": [
        "string"
    ],
    "properties.inNetwork": "string",
    "properties.irmFacility": "string",
    "properties.irmMarket": "string",
    "properties.isActive": "string",
    "properties.isFullServiceStandalone": "string",
    "properties.isOutOfNetwork": "string",
    "properties.isReact": "string",
    "properties.isSelfStorage": "string",
    "properties.jordanProp": "string",
    "properties.label": "string",
    "properties.location.city": "string",
    "properties.location.country": "string",
    "properties.location.fullState": "string",
    "properties.location.id": "string",
    "properties.location.latitude": "string",
    "properties.location.longitude": "string",
    "properties.location.state": "string",
    "properties.location.streetAddress": "string",
    "properties.location.streetView.active": "string",
    "properties.location.streetView.image": "string",
    "properties.location.streetView.pitch": "string",
    "properties.location.streetView.yaw": "string",
    "properties.location.streetView.zoom": "string",
    "properties.location.subLocality": "string",
    "properties.location.text": "string",
    "properties.location.zip": "string",
    "properties.messaging.amexActive": "string",
    "properties.messaging.hasPenskeTruck": "string",
    "properties.messaging.isAaaEligible": "string",
    "properties.messaging.isOpenNow": "string",
    "properties.messaging.isOrWillBeOpen": "string",
    "properties.messaging.isUrgent": "string",
    "properties.name": "string",
    "properties.nearby.facilities": [
        "string"
    ],
    "properties.phone": "string",
    "properties.promotion": "string",
    "properties.reviewMetadata.average": "string",
    "properties.reviewMetadata.cons": [
        "string"
    ],
    "properties.reviewMetadata.count": "string",
    "properties.reviewMetadata.pros": [
        {
            "name": "string",
            "reviewCount": "string"
        }
    ],
    "properties.reviewMetadata.ratingCounts": [
        {
            "count": "string",
            "rating": "string"
        }
    ],
    "properties.reviewMetadata.recommendedCount": "string",
    "properties.reviews": [
        {
            "date.day": "string",
            "date.dayOfWeek": "string",
            "date.dayOfWeekText": "string",
            "date.format.human.date": "string",
            "date.format.human.time": "string",
            "date.format.iso": "string",
            "date.format.mdy": "string",
            "date.format.timestamp": "string",
            "date.format.ymd": "string",
            "date.hour": "string",
            "date.isValidDate": "string",
            "date.isValidTime": "string",
            "date.minute": "string",
            "date.month": "string",
            "date.monthText": "string",
            "date.second": "string",
            "date.utcOffset": "string",
            "date.year": "string",
            "denialReason": "string",
            "facilityId": "string",
            "id": "string",
            "ipAddress": "string",
            "message": "string",
            "nickname": "string",
            "parentId": "string",
            "rating": "string",
            "ratingCleanliness": "string",
            "ratingDetails.ratingCleanliness.text": "string",
            "ratingDetails.ratingCleanliness.value": "string",
            "ratingDetails.ratingCleanliness.valueText": "string",
            "ratingDetails.ratingPrice.text": "string",
            "ratingDetails.ratingPrice.value": "string",
            "ratingDetails.ratingPrice.valueText": "string",
            "ratingDetails.ratingService.text": "string",
            "ratingDetails.ratingService.value": "string",
            "ratingDetails.ratingService.valueText": "string",
            "ratingPrice": "string",
            "ratingRecommended": "string",
            "ratingService": "string",
            "siteId": "string",
            "source": "string",
            "status": "string",
            "title": "string",
            "userId": "string",
            "visitId": "string"
        }
    ],
    "properties.searchId": "string",
    "properties.serviceArea": "string",
    "properties.showLocalPhones": "string",
    "properties.site_id": "string",
    "properties.staticMapUrl": "string",
    "properties.staticMapUrlLarge": "string",
    "properties.tos": "string",
    "properties.units": [
        "int"
    ],
    "properties.url.city": "string",
    "properties.url.facility": "string",
    "properties.url.state": "string",
    "properties.url.website": "string",
    "properties.website": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 434
schema_scan_id: 6400922
updated: 2024-01-10 09:51:24

Version 4699741

created: 2023-11-29 16:06:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_submit`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_submit`\n(\n`type`STRING,`version`STRING,`channel`STRING,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`integrations`struct<`_empty_`:STRING>,`_origin`STRING,`properties`struct<`images`:array,`searchId`:STRING,`showLocalPhones`:STRING,`site_id`:STRING,`irmFacility`:STRING,`staticMapUrlLarge`:STRING,`promotion`:STRING,`isSelfStorage`:STRING,`imageDetails`:array>,`reviewMetadata`:struct<`count`:STRING,`cons`:array,`average`:STRING,`ratingCounts`:array>,`pros`:array>,`recommendedCount`:STRING>,`messaging`:struct<`amexActive`:STRING,`isUrgent`:STRING,`isOpenNow`:STRING,`isAaaEligible`:STRING,`hasPenskeTruck`:STRING,`isOrWillBeOpen`:STRING>,`staticMapUrl`:STRING,`isOutOfNetwork`:STRING,`isReact`:STRING,`tos`:STRING,`location`:struct<`city`:STRING,`streetView`:struct<`active`:STRING,`image`:STRING,`yaw`:STRING,`zoom`:STRING,`pitch`:STRING>,`zip`:STRING,`country`:STRING,`fullState`:STRING,`state`:STRING,`longitude`:STRING,`streetAddress`:STRING,`text`:STRING,`latitude`:STRING,`id`:STRING,`subLocality`:STRING>,`amenities`:struct<`acceptedCreditCards`:array>,`label`:STRING,`isActive`:STRING,`category`:STRING,`units`:array,`nearby`:struct<`facilities`:array>,`closures`:array,`extra`:struct<`alternateEmails`:array,`promo`:STRING,`matchReasons`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`centershiftAccountId`:STRING,`bidType`:STRING,`invoiceId`:STRING,`confirmationCode`:STRING,`complete`:STRING,`payoutBatchId`:STRING,`rebateProcessed`:STRING,`bookedUnit`:struct<`promotion`:STRING,`id`:STRING,`unitType`:STRING,`amenities`:array,`description`:struct<`physical`:struct<`length`:STRING,`width`:STRING,`height`:STRING>,`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>>,`reservation_days`:STRING,`price`:struct<`meta`:STRING>>,`estimatedRevenue`:STRING,`apiLeadId`:STRING,`emailHash`:STRING,`facilitylocation`:struct<`country`:STRING,`address2`:STRING,`city`:STRING,`zip`:STRING,`address1`:STRING,`state`:STRING>,`userId`:STRING,`AAAMemberNumber`:STRING,`sizeW`:STRING,`sizeD`:STRING,`disputeReason`:STRING,`modifiedDtm`:STRING,`depositPaid`:STRING,`pickupTime`:STRING,`actualW`:STRING,`callCenterTransfer`:STRING,`lastName`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`free`:STRING,`message`:STRING,`corrected`:STRING,`listingWantId`:STRING,`matchScore`:STRING,`facilityTenantId`:STRING,`alternateLastNames`:array,`promoCode`:STRING,`eSignType`:STRING,`bookingType`:STRING,`price`:STRING,`contacted`:STRING,`movedIn`:STRING,`phone`:STRING,`bookingState`:STRING,`onlineMoveInUrl`:STRING,`bookingAgentId`:STRING,`companyCode`:STRING,`unitId`:STRING,`totalPaid`:STRING,`hotLead`:STRING,`actualD`:STRING,`read`:STRING,`alternatePhones`:array,`facilityId`:STRING,`searchWeightId`:STRING,`reviewStatus`:STRING,`monthlyInsurance`:STRING,`visitId`:STRING,`facilityTenant`:STRING,`baseBid`:STRING,`unitNumber`:STRING,`hasContactlessMoveins`:STRING,`callCenter`:STRING,`statementId`:STRING,`bookingWidget`:STRING,`commission`:STRING,`resaleRate`:STRING,`duplicateOf`:STRING,`timestamp`:STRING,`moveOut`:STRING,`customerNotes`:STRING,`callCenterNotes`:STRING,`autoState`:STRING,`sizeH`:STRING,`phoneFacilityTransfer`:STRING,`callerIdPhone`:STRING,`phoneChangedNumber`:STRING,`apiCustId`:STRING,`siteId`:STRING,`omiFlowEnabled`:STRING,`alternateFirstNames`:array,`bidAmount`:STRING,`affiliateId`:STRING,`trafficSourceId`:STRING,`firstName`:STRING,`typeOfListing`:STRING,`termsVersion`:STRING,`canceled`:STRING,`facilityPhone`:STRING,`moveIn`:STRING,`email`:STRING,`facilityName`:STRING,`searchWeightTestId`:STRING,`hasOnlineMoveIns`:STRING,`phoneStatus`:STRING,`bookingAgent`:STRING,`moveInOriginal`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`experiments`:struct<`sf_11349_sfdc_omi`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_11616_homepage_updates`:STRING>,`unit`:struct<`unitIds`:array>,`npv`:STRING,`sitePhone`:STRING,`omiCompleted`:STRING,`hostedWebsite`:STRING,`phoneVerified`:STRING,`apiUnitId`:STRING>,`chatbot`:STRING,`groupedAmenities`:struct<`premium`:struct<`items`:struct<`propane`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`generalMaintenance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`detailing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`ice`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`water`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`washStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`airPump`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vacuum`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fuel`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`inspections`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`dumpStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`billing`:struct<`items`:struct<`chargeDate`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`cashAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`creditCardsAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`autoPay`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`securityDeposit`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`emailInvoicing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`checksAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`administration`:struct<`items`:struct<`bilingualManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`acceptTenantMail`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`adminFee`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`access`:struct<`items`:struct<`truckAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`handcarts`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`kiosk`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`egateAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`elevator`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`discounts`:struct<`items`:struct<`seniorDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`militaryDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`studentDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`other`:struct<`items`:struct<`paperworkRemotely`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`bandPracticeAllowed`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`moving`:struct<`items`:struct<`truckRentalAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`movingSupplies`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`freeTruckRental`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`vehicle`:struct<`items`:struct<`vehicleRequiresInsurance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresTitle`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresRegistration`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleMustBeRunning`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`security`:struct<`items`:struct<`residentManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fenced`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`surveillance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`insurance`:struct<`items`:struct<`homeInsuranceAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceRequired`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>>,`name`:STRING,`serviceArea`:STRING,`jordanProp`:STRING,`description`:STRING,`phone`:STRING,`fees`:struct<`admin`:struct<`text`:STRING,`value`:STRING>,`deposit`:struct<`hasDeposit`:STRING,`text`:STRING,`percent`:STRING,`isRefundable`:STRING,`value`:STRING>,`insurance`:STRING>,`reviews`:array>,`utcOffset`:STRING,`month`:STRING,`isValidDate`:STRING,`isValidTime`:STRING,`year`:STRING,`dayOfWeekText`:STRING,`day`:STRING,`minute`:STRING,`second`:STRING>,`title`:STRING,`ratingDetails`:struct<`ratingService`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingPrice`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingCleanliness`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>>,`nickname`:STRING,`message`:STRING,`ratingRecommended`:STRING>>,`corporation`:struct<`sourceId`:STRING,`type`:STRING,`id`:STRING>,`url`:struct<`website`:STRING,`city`:STRING,`state`:STRING,`facility`:STRING>,`inNetwork`:STRING,`website`:STRING,`isFullServiceStandalone`:STRING,`hours`:struct<`access`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>>,`office`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>,`meta`:STRING>>,`irmMarket`:STRING,`env`:STRING,`id`:STRING,`Hit_Timestamp`:STRING>,`userId`STRING,`sentAt`STRING,`messageId`STRING,`event`STRING,`projectId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`context`struct<`userAgent`:STRING,`timezone`:STRING,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`locale`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`userAgentData`:struct<`platform`:STRING,`brands`:array>,`mobile`:STRING>,`campaign`:struct<`content`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING>>,`receivedAt`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/submit'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_submit"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/submit
id: 4699741
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c552c7d935bd0001b8729c",
            "59c13cfcc84de40001a9cdcc"
        ],
        "unbundled": []
    },
    "_origin": "2023-11-29T22:06:08Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1701216000000/1701295332048.events-archiver-480-1..c299e8a3-25cd-40c6-9e29-c588a00043cb.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "2987ff49-7d9a-4d23-a302-957cfcea342d",
    "channel": "client",
    "context": {
        "ip": "54.175.218.140",
        "library": {
            "name": "analytics.js",
            "version": "next-1.61.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/reservation/confirmation/M3KEZWJHC",
            "referrer": "https://www.sparefoot.moreyard.com/Loxahatchee-FL-self-storage/Life-Storage-4235-Westlake-Seminole-Pratt-Whitney-Rd-233726.html",
            "search": "",
            "title": "Life Storage - 4235 - Westlake - Seminole Pratt Whitney Rd | 4701 Seminole Pratt Whitney Road | SpareFoot",
            "url": "https://www.sparefoot.moreyard.com/reservation/confirmation/M3KEZWJHC"
        },
        "timezone": "America/Chicago",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Chromium",
                    "version": "118"
                },
                {
                    "brand": "Google Chrome",
                    "version": "118"
                },
                {
                    "brand": "Not=A?Brand",
                    "version": "99"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "submit",
    "integrations": {},
    "messageId": "ajs-next-befdde57f6fba645debfc532421256bc",
    "originalTimestamp": "2023-11-29T21:29:36.271Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1701293376270,
        "category": "update move in form-confirmationPage",
        "env": "dev",
        "isReact": true,
        "label": "fail-booking-move-in",
        "site_id": -1
    },
    "receivedAt": "2023-11-29T21:29:36.657Z",
    "sentAt": "2023-11-29T21:29:36.277Z",
    "timestamp": "2023-11-29T21:29:36.651Z",
    "type": "track",
    "userId": "f668459318ab728275947c0dcb619dc1",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.amenities.acceptedCreditCards": [
        "string"
    ],
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.closures": [
        "string"
    ],
    "properties.corporation.id": "string",
    "properties.corporation.sourceId": "string",
    "properties.corporation.type": "string",
    "properties.description": "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.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.omiCompleted": "string",
    "properties.extra.omiFlowEnabled": "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.fees.admin.text": "string",
    "properties.fees.admin.value": "string",
    "properties.fees.deposit.hasDeposit": "string",
    "properties.fees.deposit.isRefundable": "string",
    "properties.fees.deposit.percent": "string",
    "properties.fees.deposit.text": "string",
    "properties.fees.deposit.value": "string",
    "properties.fees.insurance": "string",
    "properties.groupedAmenities.access.items.egateAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.egateAccess.label": "string",
    "properties.groupedAmenities.access.items.egateAccess.showAlways": "string",
    "properties.groupedAmenities.access.items.elevator.hasAttribute": "string",
    "properties.groupedAmenities.access.items.elevator.label": "string",
    "properties.groupedAmenities.access.items.elevator.showAlways": "string",
    "properties.groupedAmenities.access.items.handcarts.hasAttribute": "string",
    "properties.groupedAmenities.access.items.handcarts.label": "string",
    "properties.groupedAmenities.access.items.handcarts.showAlways": "string",
    "properties.groupedAmenities.access.items.kiosk.hasAttribute": "string",
    "properties.groupedAmenities.access.items.kiosk.label": "string",
    "properties.groupedAmenities.access.items.kiosk.showAlways": "string",
    "properties.groupedAmenities.access.items.truckAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.truckAccess.label": "string",
    "properties.groupedAmenities.access.items.truckAccess.showAlways": "string",
    "properties.groupedAmenities.access.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.showAlways": "string",
    "properties.groupedAmenities.administration.items.adminFee.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.adminFee.label": "string",
    "properties.groupedAmenities.administration.items.adminFee.showAlways": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.label": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.showAlways": "string",
    "properties.groupedAmenities.administration.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.autoPay.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.showAlways": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.label": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.chargeDate.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.chargeDate.label": "string",
    "properties.groupedAmenities.billing.items.chargeDate.showAlways": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.label": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.label": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.label": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.showAlways": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.label": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.showAlways": "string",
    "properties.groupedAmenities.billing.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.showAlways": "string",
    "properties.groupedAmenities.insurance.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.showAlways": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.label": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.showAlways": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.label": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.showAlways": "string",
    "properties.groupedAmenities.moving.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.hasAttribute": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.showAlways": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.hasAttribute": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.label": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.showAlways": "string",
    "properties.groupedAmenities.other.label": "string",
    "properties.groupedAmenities.premium.items.airPump.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.airPump.label": "string",
    "properties.groupedAmenities.premium.items.airPump.showAlways": "string",
    "properties.groupedAmenities.premium.items.detailing.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.detailing.label": "string",
    "properties.groupedAmenities.premium.items.detailing.showAlways": "string",
    "properties.groupedAmenities.premium.items.dumpStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.dumpStation.label": "string",
    "properties.groupedAmenities.premium.items.dumpStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.fuel.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.fuel.label": "string",
    "properties.groupedAmenities.premium.items.fuel.showAlways": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.label": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.showAlways": "string",
    "properties.groupedAmenities.premium.items.ice.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.ice.label": "string",
    "properties.groupedAmenities.premium.items.ice.showAlways": "string",
    "properties.groupedAmenities.premium.items.inspections.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.inspections.label": "string",
    "properties.groupedAmenities.premium.items.inspections.showAlways": "string",
    "properties.groupedAmenities.premium.items.propane.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.propane.label": "string",
    "properties.groupedAmenities.premium.items.propane.showAlways": "string",
    "properties.groupedAmenities.premium.items.vacuum.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.vacuum.label": "string",
    "properties.groupedAmenities.premium.items.vacuum.showAlways": "string",
    "properties.groupedAmenities.premium.items.washStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.washStation.label": "string",
    "properties.groupedAmenities.premium.items.washStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.water.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.water.label": "string",
    "properties.groupedAmenities.premium.items.water.showAlways": "string",
    "properties.groupedAmenities.premium.label": "string",
    "properties.groupedAmenities.security.items.fenced.hasAttribute": "string",
    "properties.groupedAmenities.security.items.fenced.label": "string",
    "properties.groupedAmenities.security.items.fenced.showAlways": "string",
    "properties.groupedAmenities.security.items.residentManager.hasAttribute": "string",
    "properties.groupedAmenities.security.items.residentManager.label": "string",
    "properties.groupedAmenities.security.items.residentManager.showAlways": "string",
    "properties.groupedAmenities.security.items.surveillance.hasAttribute": "string",
    "properties.groupedAmenities.security.items.surveillance.label": "string",
    "properties.groupedAmenities.security.items.surveillance.showAlways": "string",
    "properties.groupedAmenities.security.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.showAlways": "string",
    "properties.groupedAmenities.vehicle.label": "string",
    "properties.hours.access.text.friday": "string",
    "properties.hours.access.text.monday": "string",
    "properties.hours.access.text.saturday": "string",
    "properties.hours.access.text.sunday": "string",
    "properties.hours.access.text.thursday": "string",
    "properties.hours.access.text.tuesday": "string",
    "properties.hours.access.text.wednesday": "string",
    "properties.hours.office.meta": "string",
    "properties.hours.office.text.friday": "string",
    "properties.hours.office.text.monday": "string",
    "properties.hours.office.text.saturday": "string",
    "properties.hours.office.text.sunday": "string",
    "properties.hours.office.text.thursday": "string",
    "properties.hours.office.text.tuesday": "string",
    "properties.hours.office.text.wednesday": "string",
    "properties.id": "string",
    "properties.imageDetails": [
        {
            "image": "string",
            "tag": "string"
        }
    ],
    "properties.images": [
        "string"
    ],
    "properties.inNetwork": "string",
    "properties.irmFacility": "string",
    "properties.irmMarket": "string",
    "properties.isActive": "string",
    "properties.isFullServiceStandalone": "string",
    "properties.isOutOfNetwork": "string",
    "properties.isReact": "string",
    "properties.isSelfStorage": "string",
    "properties.jordanProp": "string",
    "properties.label": "string",
    "properties.location.city": "string",
    "properties.location.country": "string",
    "properties.location.fullState": "string",
    "properties.location.id": "string",
    "properties.location.latitude": "string",
    "properties.location.longitude": "string",
    "properties.location.state": "string",
    "properties.location.streetAddress": "string",
    "properties.location.streetView.active": "string",
    "properties.location.streetView.image": "string",
    "properties.location.streetView.pitch": "string",
    "properties.location.streetView.yaw": "string",
    "properties.location.streetView.zoom": "string",
    "properties.location.subLocality": "string",
    "properties.location.text": "string",
    "properties.location.zip": "string",
    "properties.messaging.amexActive": "string",
    "properties.messaging.hasPenskeTruck": "string",
    "properties.messaging.isAaaEligible": "string",
    "properties.messaging.isOpenNow": "string",
    "properties.messaging.isOrWillBeOpen": "string",
    "properties.messaging.isUrgent": "string",
    "properties.name": "string",
    "properties.nearby.facilities": [
        "string"
    ],
    "properties.phone": "string",
    "properties.promotion": "string",
    "properties.reviewMetadata.average": "string",
    "properties.reviewMetadata.cons": [
        "string"
    ],
    "properties.reviewMetadata.count": "string",
    "properties.reviewMetadata.pros": [
        {
            "name": "string",
            "reviewCount": "string"
        }
    ],
    "properties.reviewMetadata.ratingCounts": [
        {
            "count": "string",
            "rating": "string"
        }
    ],
    "properties.reviewMetadata.recommendedCount": "string",
    "properties.reviews": [
        {
            "date.day": "string",
            "date.dayOfWeek": "string",
            "date.dayOfWeekText": "string",
            "date.format.human.date": "string",
            "date.format.human.time": "string",
            "date.format.iso": "string",
            "date.format.mdy": "string",
            "date.format.timestamp": "string",
            "date.format.ymd": "string",
            "date.hour": "string",
            "date.isValidDate": "string",
            "date.isValidTime": "string",
            "date.minute": "string",
            "date.month": "string",
            "date.monthText": "string",
            "date.second": "string",
            "date.utcOffset": "string",
            "date.year": "string",
            "denialReason": "string",
            "facilityId": "string",
            "id": "string",
            "ipAddress": "string",
            "message": "string",
            "nickname": "string",
            "parentId": "string",
            "rating": "string",
            "ratingCleanliness": "string",
            "ratingDetails.ratingCleanliness.text": "string",
            "ratingDetails.ratingCleanliness.value": "string",
            "ratingDetails.ratingCleanliness.valueText": "string",
            "ratingDetails.ratingPrice.text": "string",
            "ratingDetails.ratingPrice.value": "string",
            "ratingDetails.ratingPrice.valueText": "string",
            "ratingDetails.ratingService.text": "string",
            "ratingDetails.ratingService.value": "string",
            "ratingDetails.ratingService.valueText": "string",
            "ratingPrice": "string",
            "ratingRecommended": "string",
            "ratingService": "string",
            "siteId": "string",
            "source": "string",
            "status": "string",
            "title": "string",
            "userId": "string",
            "visitId": "string"
        }
    ],
    "properties.searchId": "string",
    "properties.serviceArea": "string",
    "properties.showLocalPhones": "string",
    "properties.site_id": "string",
    "properties.staticMapUrl": "string",
    "properties.staticMapUrlLarge": "string",
    "properties.tos": "string",
    "properties.units": [
        "int"
    ],
    "properties.url.city": "string",
    "properties.url.facility": "string",
    "properties.url.state": "string",
    "properties.url.website": "string",
    "properties.website": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 434
schema_scan_id: 6359340
updated: 2023-11-29 16:07:07

Version 4696875

created: 2023-07-07 16:40:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_submit`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_submit`\n(\n`sentAt`STRING,`version`STRING,`channel`STRING,`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`type`STRING,`messageId`STRING,`_origin`STRING,`userId`STRING,`event`STRING,`anonymousId`STRING,`context`struct<`locale`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`userAgent`:STRING,`page`:struct<`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING,`search`:STRING>,`ip`:STRING,`userAgentData`:struct<`mobile`:STRING,`platform`:STRING,`brands`:array>>>,`originalTimestamp`STRING,`receivedAt`STRING,`properties`struct<`promotion`:STRING,`Hit_Timestamp`:STRING,`searchId`:STRING,`isFullServiceStandalone`:STRING,`images`:array,`staticMapUrlLarge`:STRING,`url`:struct<`website`:STRING,`city`:STRING,`state`:STRING,`facility`:STRING>,`reviewMetadata`:struct<`count`:STRING,`cons`:array,`average`:STRING,`ratingCounts`:array>,`pros`:array>,`recommendedCount`:STRING>,`jordanProp`:STRING,`isSelfStorage`:STRING,`reviews`:array>,`utcOffset`:STRING,`month`:STRING,`isValidDate`:STRING,`isValidTime`:STRING,`year`:STRING,`dayOfWeekText`:STRING,`day`:STRING,`minute`:STRING,`second`:STRING>,`title`:STRING,`ratingDetails`:struct<`ratingService`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingPrice`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingCleanliness`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>>,`nickname`:STRING,`message`:STRING,`ratingRecommended`:STRING>>,`description`:STRING,`closures`:array,`groupedAmenities`:struct<`premium`:struct<`items`:struct<`propane`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`generalMaintenance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`detailing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`ice`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`water`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`washStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`airPump`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vacuum`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fuel`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`inspections`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`dumpStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`billing`:struct<`items`:struct<`chargeDate`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`cashAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`creditCardsAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`autoPay`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`securityDeposit`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`emailInvoicing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`checksAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`administration`:struct<`items`:struct<`bilingualManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`acceptTenantMail`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`adminFee`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`access`:struct<`items`:struct<`truckAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`handcarts`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`kiosk`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`egateAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`elevator`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`discounts`:struct<`items`:struct<`seniorDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`militaryDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`studentDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`other`:struct<`items`:struct<`paperworkRemotely`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`bandPracticeAllowed`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`moving`:struct<`items`:struct<`truckRentalAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`movingSupplies`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`freeTruckRental`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`vehicle`:struct<`items`:struct<`vehicleRequiresInsurance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresTitle`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresRegistration`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleMustBeRunning`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`security`:struct<`items`:struct<`residentManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fenced`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`surveillance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`insurance`:struct<`items`:struct<`homeInsuranceAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceRequired`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>>,`irmFacility`:STRING,`env`:STRING,`messaging`:struct<`amexActive`:STRING,`isUrgent`:STRING,`isOpenNow`:STRING,`isAaaEligible`:STRING,`hasPenskeTruck`:STRING,`isOrWillBeOpen`:STRING>,`id`:STRING,`amenities`:struct<`acceptedCreditCards`:array>,`website`:STRING,`isActive`:STRING,`showLocalPhones`:STRING,`staticMapUrl`:STRING,`isReact`:STRING,`nearby`:struct<`facilities`:array>,`name`:STRING,`extra`:struct<`alternateEmails`:array,`promo`:STRING,`matchReasons`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`centershiftAccountId`:STRING,`bidType`:STRING,`invoiceId`:STRING,`confirmationCode`:STRING,`complete`:STRING,`payoutBatchId`:STRING,`rebateProcessed`:STRING,`bookedUnit`:struct<`promotion`:STRING,`id`:STRING,`unitType`:STRING,`amenities`:array,`description`:struct<`physical`:struct<`length`:STRING,`width`:STRING,`height`:STRING>,`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>>,`reservation_days`:STRING,`price`:struct<`meta`:STRING>>,`estimatedRevenue`:STRING,`apiLeadId`:STRING,`emailHash`:STRING,`facilitylocation`:struct<`country`:STRING,`address2`:STRING,`city`:STRING,`zip`:STRING,`address1`:STRING,`state`:STRING>,`userId`:STRING,`AAAMemberNumber`:STRING,`sizeW`:STRING,`sizeD`:STRING,`disputeReason`:STRING,`modifiedDtm`:STRING,`depositPaid`:STRING,`pickupTime`:STRING,`actualW`:STRING,`callCenterTransfer`:STRING,`lastName`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`free`:STRING,`message`:STRING,`corrected`:STRING,`listingWantId`:STRING,`matchScore`:STRING,`facilityTenantId`:STRING,`alternateLastNames`:array,`promoCode`:STRING,`eSignType`:STRING,`bookingType`:STRING,`price`:STRING,`contacted`:STRING,`movedIn`:STRING,`phone`:STRING,`bookingState`:STRING,`onlineMoveInUrl`:STRING,`bookingAgentId`:STRING,`companyCode`:STRING,`unitId`:STRING,`totalPaid`:STRING,`hotLead`:STRING,`actualD`:STRING,`read`:STRING,`alternatePhones`:array,`facilityId`:STRING,`searchWeightId`:STRING,`reviewStatus`:STRING,`monthlyInsurance`:STRING,`visitId`:STRING,`facilityTenant`:STRING,`baseBid`:STRING,`unitNumber`:STRING,`hasContactlessMoveins`:STRING,`callCenter`:STRING,`statementId`:STRING,`bookingWidget`:STRING,`commission`:STRING,`resaleRate`:STRING,`duplicateOf`:STRING,`timestamp`:STRING,`moveOut`:STRING,`customerNotes`:STRING,`callCenterNotes`:STRING,`autoState`:STRING,`sizeH`:STRING,`phoneFacilityTransfer`:STRING,`callerIdPhone`:STRING,`phoneChangedNumber`:STRING,`apiCustId`:STRING,`siteId`:STRING,`omiFlowEnabled`:STRING,`alternateFirstNames`:array,`bidAmount`:STRING,`affiliateId`:STRING,`trafficSourceId`:STRING,`firstName`:STRING,`typeOfListing`:STRING,`termsVersion`:STRING,`canceled`:STRING,`facilityPhone`:STRING,`moveIn`:STRING,`email`:STRING,`facilityName`:STRING,`searchWeightTestId`:STRING,`hasOnlineMoveIns`:STRING,`phoneStatus`:STRING,`bookingAgent`:STRING,`moveInOriginal`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`experiments`:struct<`sf_11349_sfdc_omi`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_omi_mfe_embed`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_11616_homepage_updates`:STRING>,`unit`:struct<`unitIds`:array>,`npv`:STRING,`sitePhone`:STRING,`omiCompleted`:STRING,`hostedWebsite`:STRING,`phoneVerified`:STRING,`apiUnitId`:STRING>,`serviceArea`:STRING,`hours`:struct<`access`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>>,`office`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>,`meta`:STRING>>,`imageDetails`:array>,`irmMarket`:STRING,`phone`:STRING,`isOutOfNetwork`:STRING,`site_id`:STRING,`location`:struct<`city`:STRING,`streetView`:struct<`active`:STRING,`image`:STRING,`yaw`:STRING,`zoom`:STRING,`pitch`:STRING>,`zip`:STRING,`country`:STRING,`fullState`:STRING,`state`:STRING,`longitude`:STRING,`streetAddress`:STRING,`text`:STRING,`latitude`:STRING,`id`:STRING,`subLocality`:STRING>,`fees`:struct<`admin`:struct<`text`:STRING,`value`:STRING>,`deposit`:struct<`hasDeposit`:STRING,`text`:STRING,`percent`:STRING,`isRefundable`:STRING,`value`:STRING>,`insurance`:STRING>,`units`:array,`chatbot`:STRING,`label`:STRING,`category`:STRING,`corporation`:struct<`sourceId`:STRING,`type`:STRING,`id`:STRING>,`inNetwork`:STRING,`tos`:STRING>,`projectId`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/submit'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_submit"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/submit
id: 4696875
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c552c7d935bd0001b8729c",
            "59c13cfcc84de40001a9cdcc"
        ],
        "unbundled": []
    },
    "_origin": "2023-07-07T21:39:57Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1688688000000/1688765883782.events-archiver-480-29.8ebb200.61ff568b-258c-4a85-b86e-19394458c5b3.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "22999e74-073a-43a0-93a9-6060efd44ee8",
    "channel": "client",
    "context": {
        "ip": "54.146.71.248",
        "library": {
            "name": "analytics.js",
            "version": "next-1.53.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage/Brittanys-Test-Facility-Testing-things-212063.html",
            "referrer": "https://www.sparefoot.moreyard.com/Perryville-AK-self-storage.html?location=Perryville%2C%20AK%2C%20USA&latitude=55.9121988&longitude=-159.1453343",
            "search": "",
            "title": "Brittany's Test Facility - Testing things! | 5555 Brooks Road | SpareFoot",
            "url": "https://www.sparefoot.moreyard.com/Perryville-AK-self-storage/Brittanys-Test-Facility-Testing-things-212063.html"
        },
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Not.A/Brand",
                    "version": "8"
                },
                {
                    "brand": "Chromium",
                    "version": "114"
                },
                {
                    "brand": "Google Chrome",
                    "version": "114"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "submit",
    "integrations": {},
    "messageId": "ajs-next-e8896cd8c8f15fede7de8e160484015b",
    "originalTimestamp": "2023-07-07T21:09:21.712Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1688764161711,
        "category": "reservation form interactions-facilityPage",
        "env": "dev",
        "extra": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 2318,
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": null,
            "apiLeadId": null,
            "apiUnitId": null,
            "autoState": null,
            "baseBid": "3.00",
            "bidAmount": "75.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "-1st Floor",
                    "24 Hour Access",
                    "Climate Controlled",
                    "Interior",
                    "Stacked Skybox/Mezzanine Unit",
                    "Swing Door"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "3.00",
                        "width": "3.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 25750024,
                "price": {
                    "meta": "25.00"
                },
                "promotion": "Only $1 for the first full month",
                "reservation_days": 45,
                "unitType": "locker"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2023-07-07 4:09pm] Booking 3' x 3' locker $25 (-1st Floor, 24 Hour Access, Climate Controlled, Interior, Stacked Skybox/Mezzanine Unit, Swing Door) Promo: Only $1 for the first full month on website (SpareFoot.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": "",
            "complete": 1,
            "confirmationCode": "UQKSS5AQC",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "721b629239662f18a8f4fcdcdcc76e3ab2ecc0f37f536c270530b7ed93bafb8e",
            "estimatedRevenue": 5.61,
            "experiments": {
                "sf_11292_confirmation_page_hero": "variation",
                "sf_11349_sfdc_omi": "inactive",
                "sf_11464_neighbordotcom_cpc_ad": "inactive",
                "sf_11786_sfdc_omi_redesign": "variation",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 212063,
            "facilityName": "Brittany's Test Facility - Testing things",
            "facilityPhone": 5555555555,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "5555 Brooks Road",
                "address2": "",
                "city": "Perryville",
                "country": "",
                "state": "AK",
                "zip": "99648"
            },
            "firstName": "Jake",
            "free": 0,
            "hasContactlessMoveins": true,
            "hasOnlineMoveIns": false,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "Varness",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2023-07-07 16:09:21",
            "monthlyInsurance": null,
            "moveIn": "2023-07-14",
            "moveInActual": null,
            "moveInOriginal": "2023-07-14",
            "moveOut": null,
            "movedIn": 0,
            "npv": "75.00",
            "omiCompleted": false,
            "omiFlowEnabled": false,
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "5555555555",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "25.00",
            "promo": "Only $1 for the first full month",
            "promoCode": null,
            "read": 0,
            "rebateProcessed": 0,
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": -1,
            "sitePhone": null,
            "sizeD": "3.00",
            "sizeH": null,
            "sizeW": "3.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2023-07-07 16:09:21",
            "totalPaid": null,
            "trafficSourceId": "__Direct",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "25750024"
                ]
            },
            "unitId": 25750024,
            "unitNumber": null,
            "userId": 1682,
            "visitId": null
        },
        "isReact": true,
        "label": "filterable units-reservation form-success-web-locker-3x3",
        "site_id": -1
    },
    "receivedAt": "2023-07-07T21:09:22.186Z",
    "sentAt": "2023-07-07T21:09:21.777Z",
    "timestamp": "2023-07-07T21:09:22.121Z",
    "type": "track",
    "userId": "c2cfbd7dd70495ae417b8d7ba5cd930b",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.amenities.acceptedCreditCards": [
        "string"
    ],
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.closures": [
        "string"
    ],
    "properties.corporation.id": "string",
    "properties.corporation.sourceId": "string",
    "properties.corporation.type": "string",
    "properties.description": "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.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.omiCompleted": "string",
    "properties.extra.omiFlowEnabled": "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.fees.admin.text": "string",
    "properties.fees.admin.value": "string",
    "properties.fees.deposit.hasDeposit": "string",
    "properties.fees.deposit.isRefundable": "string",
    "properties.fees.deposit.percent": "string",
    "properties.fees.deposit.text": "string",
    "properties.fees.deposit.value": "string",
    "properties.fees.insurance": "string",
    "properties.groupedAmenities.access.items.egateAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.egateAccess.label": "string",
    "properties.groupedAmenities.access.items.egateAccess.showAlways": "string",
    "properties.groupedAmenities.access.items.elevator.hasAttribute": "string",
    "properties.groupedAmenities.access.items.elevator.label": "string",
    "properties.groupedAmenities.access.items.elevator.showAlways": "string",
    "properties.groupedAmenities.access.items.handcarts.hasAttribute": "string",
    "properties.groupedAmenities.access.items.handcarts.label": "string",
    "properties.groupedAmenities.access.items.handcarts.showAlways": "string",
    "properties.groupedAmenities.access.items.kiosk.hasAttribute": "string",
    "properties.groupedAmenities.access.items.kiosk.label": "string",
    "properties.groupedAmenities.access.items.kiosk.showAlways": "string",
    "properties.groupedAmenities.access.items.truckAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.truckAccess.label": "string",
    "properties.groupedAmenities.access.items.truckAccess.showAlways": "string",
    "properties.groupedAmenities.access.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.showAlways": "string",
    "properties.groupedAmenities.administration.items.adminFee.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.adminFee.label": "string",
    "properties.groupedAmenities.administration.items.adminFee.showAlways": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.label": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.showAlways": "string",
    "properties.groupedAmenities.administration.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.autoPay.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.showAlways": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.label": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.chargeDate.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.chargeDate.label": "string",
    "properties.groupedAmenities.billing.items.chargeDate.showAlways": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.label": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.label": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.label": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.showAlways": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.label": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.showAlways": "string",
    "properties.groupedAmenities.billing.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.showAlways": "string",
    "properties.groupedAmenities.insurance.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.showAlways": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.label": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.showAlways": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.label": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.showAlways": "string",
    "properties.groupedAmenities.moving.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.hasAttribute": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.showAlways": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.hasAttribute": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.label": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.showAlways": "string",
    "properties.groupedAmenities.other.label": "string",
    "properties.groupedAmenities.premium.items.airPump.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.airPump.label": "string",
    "properties.groupedAmenities.premium.items.airPump.showAlways": "string",
    "properties.groupedAmenities.premium.items.detailing.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.detailing.label": "string",
    "properties.groupedAmenities.premium.items.detailing.showAlways": "string",
    "properties.groupedAmenities.premium.items.dumpStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.dumpStation.label": "string",
    "properties.groupedAmenities.premium.items.dumpStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.fuel.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.fuel.label": "string",
    "properties.groupedAmenities.premium.items.fuel.showAlways": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.label": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.showAlways": "string",
    "properties.groupedAmenities.premium.items.ice.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.ice.label": "string",
    "properties.groupedAmenities.premium.items.ice.showAlways": "string",
    "properties.groupedAmenities.premium.items.inspections.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.inspections.label": "string",
    "properties.groupedAmenities.premium.items.inspections.showAlways": "string",
    "properties.groupedAmenities.premium.items.propane.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.propane.label": "string",
    "properties.groupedAmenities.premium.items.propane.showAlways": "string",
    "properties.groupedAmenities.premium.items.vacuum.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.vacuum.label": "string",
    "properties.groupedAmenities.premium.items.vacuum.showAlways": "string",
    "properties.groupedAmenities.premium.items.washStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.washStation.label": "string",
    "properties.groupedAmenities.premium.items.washStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.water.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.water.label": "string",
    "properties.groupedAmenities.premium.items.water.showAlways": "string",
    "properties.groupedAmenities.premium.label": "string",
    "properties.groupedAmenities.security.items.fenced.hasAttribute": "string",
    "properties.groupedAmenities.security.items.fenced.label": "string",
    "properties.groupedAmenities.security.items.fenced.showAlways": "string",
    "properties.groupedAmenities.security.items.residentManager.hasAttribute": "string",
    "properties.groupedAmenities.security.items.residentManager.label": "string",
    "properties.groupedAmenities.security.items.residentManager.showAlways": "string",
    "properties.groupedAmenities.security.items.surveillance.hasAttribute": "string",
    "properties.groupedAmenities.security.items.surveillance.label": "string",
    "properties.groupedAmenities.security.items.surveillance.showAlways": "string",
    "properties.groupedAmenities.security.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.showAlways": "string",
    "properties.groupedAmenities.vehicle.label": "string",
    "properties.hours.access.text.friday": "string",
    "properties.hours.access.text.monday": "string",
    "properties.hours.access.text.saturday": "string",
    "properties.hours.access.text.sunday": "string",
    "properties.hours.access.text.thursday": "string",
    "properties.hours.access.text.tuesday": "string",
    "properties.hours.access.text.wednesday": "string",
    "properties.hours.office.meta": "string",
    "properties.hours.office.text.friday": "string",
    "properties.hours.office.text.monday": "string",
    "properties.hours.office.text.saturday": "string",
    "properties.hours.office.text.sunday": "string",
    "properties.hours.office.text.thursday": "string",
    "properties.hours.office.text.tuesday": "string",
    "properties.hours.office.text.wednesday": "string",
    "properties.id": "string",
    "properties.imageDetails": [
        {
            "image": "string",
            "tag": "string"
        }
    ],
    "properties.images": [
        "string"
    ],
    "properties.inNetwork": "string",
    "properties.irmFacility": "string",
    "properties.irmMarket": "string",
    "properties.isActive": "string",
    "properties.isFullServiceStandalone": "string",
    "properties.isOutOfNetwork": "string",
    "properties.isReact": "string",
    "properties.isSelfStorage": "string",
    "properties.jordanProp": "string",
    "properties.label": "string",
    "properties.location.city": "string",
    "properties.location.country": "string",
    "properties.location.fullState": "string",
    "properties.location.id": "string",
    "properties.location.latitude": "string",
    "properties.location.longitude": "string",
    "properties.location.state": "string",
    "properties.location.streetAddress": "string",
    "properties.location.streetView.active": "string",
    "properties.location.streetView.image": "string",
    "properties.location.streetView.pitch": "string",
    "properties.location.streetView.yaw": "string",
    "properties.location.streetView.zoom": "string",
    "properties.location.subLocality": "string",
    "properties.location.text": "string",
    "properties.location.zip": "string",
    "properties.messaging.amexActive": "string",
    "properties.messaging.hasPenskeTruck": "string",
    "properties.messaging.isAaaEligible": "string",
    "properties.messaging.isOpenNow": "string",
    "properties.messaging.isOrWillBeOpen": "string",
    "properties.messaging.isUrgent": "string",
    "properties.name": "string",
    "properties.nearby.facilities": [
        "string"
    ],
    "properties.phone": "string",
    "properties.promotion": "string",
    "properties.reviewMetadata.average": "string",
    "properties.reviewMetadata.cons": [
        "string"
    ],
    "properties.reviewMetadata.count": "string",
    "properties.reviewMetadata.pros": [
        {
            "name": "string",
            "reviewCount": "string"
        }
    ],
    "properties.reviewMetadata.ratingCounts": [
        {
            "count": "string",
            "rating": "string"
        }
    ],
    "properties.reviewMetadata.recommendedCount": "string",
    "properties.reviews": [
        {
            "date.day": "string",
            "date.dayOfWeek": "string",
            "date.dayOfWeekText": "string",
            "date.format.human.date": "string",
            "date.format.human.time": "string",
            "date.format.iso": "string",
            "date.format.mdy": "string",
            "date.format.timestamp": "string",
            "date.format.ymd": "string",
            "date.hour": "string",
            "date.isValidDate": "string",
            "date.isValidTime": "string",
            "date.minute": "string",
            "date.month": "string",
            "date.monthText": "string",
            "date.second": "string",
            "date.utcOffset": "string",
            "date.year": "string",
            "denialReason": "string",
            "facilityId": "string",
            "id": "string",
            "ipAddress": "string",
            "message": "string",
            "nickname": "string",
            "parentId": "string",
            "rating": "string",
            "ratingCleanliness": "string",
            "ratingDetails.ratingCleanliness.text": "string",
            "ratingDetails.ratingCleanliness.value": "string",
            "ratingDetails.ratingCleanliness.valueText": "string",
            "ratingDetails.ratingPrice.text": "string",
            "ratingDetails.ratingPrice.value": "string",
            "ratingDetails.ratingPrice.valueText": "string",
            "ratingDetails.ratingService.text": "string",
            "ratingDetails.ratingService.value": "string",
            "ratingDetails.ratingService.valueText": "string",
            "ratingPrice": "string",
            "ratingRecommended": "string",
            "ratingService": "string",
            "siteId": "string",
            "source": "string",
            "status": "string",
            "title": "string",
            "userId": "string",
            "visitId": "string"
        }
    ],
    "properties.searchId": "string",
    "properties.serviceArea": "string",
    "properties.showLocalPhones": "string",
    "properties.site_id": "string",
    "properties.staticMapUrl": "string",
    "properties.staticMapUrlLarge": "string",
    "properties.tos": "string",
    "properties.units": [
        "int"
    ],
    "properties.url.city": "string",
    "properties.url.facility": "string",
    "properties.url.state": "string",
    "properties.url.website": "string",
    "properties.website": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 434
schema_scan_id: 6221848
updated: 2023-07-07 16:41:20

Schema Scans: 3

Last at 2024-01-10 09:50:46

Scan 6400922

duration: 0:00:52.414111

exit_message:

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

id: 6400922

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-dev/separated_dt/submit/dt=2024-01-10/",
        "name": "dt",
        "type": "string",
        "value": "2024-01-10"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit",
        "key": "separated_dt/submit/dt=2024-01-10/1704901657096.events-archiver-480-30..369d93d3-2a3b-4e01-8515-ee955f1a78e5.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_submit",
        "type": "segment"
    }
}

running: False
schema_name_id: 434
start_time: 2024-01-10 09:50:46
success: True
trace_id: 4070342827946378589

Scan 6359340

duration: 0:01:13.171657

exit_message:

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

id: 6359340

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-dev/separated_dt/submit/dt=2023-11-29/",
        "name": "dt",
        "type": "string",
        "value": "2023-11-29"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit",
        "key": "separated_dt/submit/dt=2023-11-29/1701295332048.events-archiver-480-1..c299e8a3-25cd-40c6-9e29-c588a00043cb.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_submit",
        "type": "segment"
    }
}

running: False
schema_name_id: 434
start_time: 2023-11-29 16:06:11
success: True
trace_id: 13878702279898365069

Scan 6221848

duration: 0:01:04.588835

exit_message:

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

id: 6221848

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-dev/separated_dt/submit/dt=2023-07-07/",
        "name": "dt",
        "type": "string",
        "value": "2023-07-07"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit",
        "key": "separated_dt/submit/dt=2023-07-07/1688765883782.events-archiver-480-29.8ebb200.61ff568b-258c-4a85-b86e-19394458c5b3.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_submit",
        "type": "segment"
    }
}

running: False
schema_name_id: 434
start_time: 2023-07-07 16:40:30
success: True
trace_id: 4350401926212198971

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_dev_segment.reactfoot_submit`\nADD\n\n\n PARTITION (dt='2025-01-22') location 's3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-22/'\n PARTITION (dt='2025-01-23') location 's3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-23/'\n PARTITION (dt='2025-01-24') location 's3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-24/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 286286,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-22/",
            "name": "dt",
            "value": "2025-01-22"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-01-22 09:44:55",
                "last_data": "2025-01-22 17:25:04"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 286398,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-23/",
            "name": "dt",
            "value": "2025-01-23"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-01-23 09:47:10",
                "last_data": "2025-01-23 09:51:47"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 286502,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-24/",
            "name": "dt",
            "value": "2025-01-24"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-01-24 10:45:56",
                "last_data": "2025-01-24 17:26:25"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.amenities.acceptedCreditCards": [
        "string"
    ],
    "properties.category": "string",
    "properties.chatbot": "string",
    "properties.closures": [
        "string"
    ],
    "properties.corporation.id": "string",
    "properties.corporation.sourceId": "string",
    "properties.corporation.type": "string",
    "properties.description": "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_12289_sfdc_holiday_messaging": "string",
    "properties.extra.experiments.sf_12496_sfdc_clp_unitcardrefresh": "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.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.omiCompleted": "string",
    "properties.extra.omiFlowEnabled": "string",
    "properties.extra.omiPri": "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.fees.admin.text": "string",
    "properties.fees.admin.value": "string",
    "properties.fees.deposit.hasDeposit": "string",
    "properties.fees.deposit.isRefundable": "string",
    "properties.fees.deposit.percent": "string",
    "properties.fees.deposit.text": "string",
    "properties.fees.deposit.value": "string",
    "properties.fees.insurance": "string",
    "properties.groupedAmenities.access.items.egateAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.egateAccess.label": "string",
    "properties.groupedAmenities.access.items.egateAccess.showAlways": "string",
    "properties.groupedAmenities.access.items.elevator.hasAttribute": "string",
    "properties.groupedAmenities.access.items.elevator.label": "string",
    "properties.groupedAmenities.access.items.elevator.showAlways": "string",
    "properties.groupedAmenities.access.items.handcarts.hasAttribute": "string",
    "properties.groupedAmenities.access.items.handcarts.label": "string",
    "properties.groupedAmenities.access.items.handcarts.showAlways": "string",
    "properties.groupedAmenities.access.items.kiosk.hasAttribute": "string",
    "properties.groupedAmenities.access.items.kiosk.label": "string",
    "properties.groupedAmenities.access.items.kiosk.showAlways": "string",
    "properties.groupedAmenities.access.items.truckAccess.hasAttribute": "string",
    "properties.groupedAmenities.access.items.truckAccess.label": "string",
    "properties.groupedAmenities.access.items.truckAccess.showAlways": "string",
    "properties.groupedAmenities.access.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.label": "string",
    "properties.groupedAmenities.administration.items.acceptTenantMail.showAlways": "string",
    "properties.groupedAmenities.administration.items.adminFee.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.adminFee.label": "string",
    "properties.groupedAmenities.administration.items.adminFee.showAlways": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.hasAttribute": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.label": "string",
    "properties.groupedAmenities.administration.items.bilingualManager.showAlways": "string",
    "properties.groupedAmenities.administration.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.autoPay.label": "string",
    "properties.groupedAmenities.billing.items.autoPay.showAlways": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.label": "string",
    "properties.groupedAmenities.billing.items.cashAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.chargeDate.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.chargeDate.label": "string",
    "properties.groupedAmenities.billing.items.chargeDate.showAlways": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.label": "string",
    "properties.groupedAmenities.billing.items.checksAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.label": "string",
    "properties.groupedAmenities.billing.items.creditCardsAccepted.showAlways": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.label": "string",
    "properties.groupedAmenities.billing.items.emailInvoicing.showAlways": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.hasAttribute": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.label": "string",
    "properties.groupedAmenities.billing.items.securityDeposit.showAlways": "string",
    "properties.groupedAmenities.billing.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.militaryDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.seniorDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.hasAttribute": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.label": "string",
    "properties.groupedAmenities.discounts.items.studentDiscount.showAlways": "string",
    "properties.groupedAmenities.discounts.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.label": "string",
    "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceAvailable.showAlways": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.hasAttribute": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.label": "string",
    "properties.groupedAmenities.insurance.items.insuranceRequired.showAlways": "string",
    "properties.groupedAmenities.insurance.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.label": "string",
    "properties.groupedAmenities.moving.items.freeTruckRental.showAlways": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.label": "string",
    "properties.groupedAmenities.moving.items.movingSupplies.showAlways": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.hasAttribute": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.label": "string",
    "properties.groupedAmenities.moving.items.truckRentalAvailable.showAlways": "string",
    "properties.groupedAmenities.moving.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.hasAttribute": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.label": "string",
    "properties.groupedAmenities.other.items.bandPracticeAllowed.showAlways": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.hasAttribute": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.label": "string",
    "properties.groupedAmenities.other.items.paperworkRemotely.showAlways": "string",
    "properties.groupedAmenities.other.label": "string",
    "properties.groupedAmenities.premium.items.airPump.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.airPump.label": "string",
    "properties.groupedAmenities.premium.items.airPump.showAlways": "string",
    "properties.groupedAmenities.premium.items.detailing.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.detailing.label": "string",
    "properties.groupedAmenities.premium.items.detailing.showAlways": "string",
    "properties.groupedAmenities.premium.items.dumpStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.dumpStation.label": "string",
    "properties.groupedAmenities.premium.items.dumpStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.fuel.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.fuel.label": "string",
    "properties.groupedAmenities.premium.items.fuel.showAlways": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.label": "string",
    "properties.groupedAmenities.premium.items.generalMaintenance.showAlways": "string",
    "properties.groupedAmenities.premium.items.ice.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.ice.label": "string",
    "properties.groupedAmenities.premium.items.ice.showAlways": "string",
    "properties.groupedAmenities.premium.items.inspections.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.inspections.label": "string",
    "properties.groupedAmenities.premium.items.inspections.showAlways": "string",
    "properties.groupedAmenities.premium.items.propane.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.propane.label": "string",
    "properties.groupedAmenities.premium.items.propane.showAlways": "string",
    "properties.groupedAmenities.premium.items.vacuum.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.vacuum.label": "string",
    "properties.groupedAmenities.premium.items.vacuum.showAlways": "string",
    "properties.groupedAmenities.premium.items.washStation.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.washStation.label": "string",
    "properties.groupedAmenities.premium.items.washStation.showAlways": "string",
    "properties.groupedAmenities.premium.items.water.hasAttribute": "string",
    "properties.groupedAmenities.premium.items.water.label": "string",
    "properties.groupedAmenities.premium.items.water.showAlways": "string",
    "properties.groupedAmenities.premium.label": "string",
    "properties.groupedAmenities.security.items.fenced.hasAttribute": "string",
    "properties.groupedAmenities.security.items.fenced.label": "string",
    "properties.groupedAmenities.security.items.fenced.showAlways": "string",
    "properties.groupedAmenities.security.items.residentManager.hasAttribute": "string",
    "properties.groupedAmenities.security.items.residentManager.label": "string",
    "properties.groupedAmenities.security.items.residentManager.showAlways": "string",
    "properties.groupedAmenities.security.items.surveillance.hasAttribute": "string",
    "properties.groupedAmenities.security.items.surveillance.label": "string",
    "properties.groupedAmenities.security.items.surveillance.showAlways": "string",
    "properties.groupedAmenities.security.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.showAlways": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.hasAttribute": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.label": "string",
    "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.showAlways": "string",
    "properties.groupedAmenities.vehicle.label": "string",
    "properties.hours.access.text.friday": "string",
    "properties.hours.access.text.monday": "string",
    "properties.hours.access.text.saturday": "string",
    "properties.hours.access.text.sunday": "string",
    "properties.hours.access.text.thursday": "string",
    "properties.hours.access.text.tuesday": "string",
    "properties.hours.access.text.wednesday": "string",
    "properties.hours.office.meta": "string",
    "properties.hours.office.text.friday": "string",
    "properties.hours.office.text.monday": "string",
    "properties.hours.office.text.saturday": "string",
    "properties.hours.office.text.sunday": "string",
    "properties.hours.office.text.thursday": "string",
    "properties.hours.office.text.tuesday": "string",
    "properties.hours.office.text.wednesday": "string",
    "properties.id": "string",
    "properties.imageDetails": [
        {
            "image": "string",
            "tag": "string"
        }
    ],
    "properties.images": [
        "string"
    ],
    "properties.inNetwork": "string",
    "properties.irmFacility": "string",
    "properties.irmMarket": "string",
    "properties.isActive": "string",
    "properties.isFullServiceStandalone": "string",
    "properties.isOutOfNetwork": "string",
    "properties.isReact": "string",
    "properties.isSelfStorage": "string",
    "properties.jordanProp": "string",
    "properties.label": "string",
    "properties.location.city": "string",
    "properties.location.country": "string",
    "properties.location.fullState": "string",
    "properties.location.id": "string",
    "properties.location.latitude": "string",
    "properties.location.longitude": "string",
    "properties.location.state": "string",
    "properties.location.streetAddress": "string",
    "properties.location.streetView.active": "string",
    "properties.location.streetView.image": "string",
    "properties.location.streetView.pitch": "string",
    "properties.location.streetView.yaw": "string",
    "properties.location.streetView.zoom": "string",
    "properties.location.subLocality": "string",
    "properties.location.text": "string",
    "properties.location.zip": "string",
    "properties.messaging.amexActive": "string",
    "properties.messaging.hasPenskeTruck": "string",
    "properties.messaging.isAaaEligible": "string",
    "properties.messaging.isOpenNow": "string",
    "properties.messaging.isOrWillBeOpen": "string",
    "properties.messaging.isUrgent": "string",
    "properties.name": "string",
    "properties.nearby.facilities": [
        "string"
    ],
    "properties.phone": "string",
    "properties.promotion": "string",
    "properties.reviewMetadata.average": "string",
    "properties.reviewMetadata.cons": [
        "string"
    ],
    "properties.reviewMetadata.count": "string",
    "properties.reviewMetadata.pros": [
        {
            "name": "string",
            "reviewCount": "string"
        }
    ],
    "properties.reviewMetadata.ratingCounts": [
        {
            "count": "string",
            "rating": "string"
        }
    ],
    "properties.reviewMetadata.recommendedCount": "string",
    "properties.reviews": [
        {
            "date.day": "string",
            "date.dayOfWeek": "string",
            "date.dayOfWeekText": "string",
            "date.format.human.date": "string",
            "date.format.human.time": "string",
            "date.format.iso": "string",
            "date.format.mdy": "string",
            "date.format.timestamp": "string",
            "date.format.ymd": "string",
            "date.hour": "string",
            "date.isValidDate": "string",
            "date.isValidTime": "string",
            "date.minute": "string",
            "date.month": "string",
            "date.monthText": "string",
            "date.second": "string",
            "date.utcOffset": "string",
            "date.year": "string",
            "denialReason": "string",
            "facilityId": "string",
            "id": "string",
            "ipAddress": "string",
            "message": "string",
            "nickname": "string",
            "parentId": "string",
            "rating": "string",
            "ratingCleanliness": "string",
            "ratingDetails.ratingCleanliness.text": "string",
            "ratingDetails.ratingCleanliness.value": "string",
            "ratingDetails.ratingCleanliness.valueText": "string",
            "ratingDetails.ratingPrice.text": "string",
            "ratingDetails.ratingPrice.value": "string",
            "ratingDetails.ratingPrice.valueText": "string",
            "ratingDetails.ratingService.text": "string",
            "ratingDetails.ratingService.value": "string",
            "ratingDetails.ratingService.valueText": "string",
            "ratingPrice": "string",
            "ratingRecommended": "string",
            "ratingService": "string",
            "siteId": "string",
            "source": "string",
            "status": "string",
            "title": "string",
            "userId": "string",
            "visitId": "string"
        }
    ],
    "properties.searchId": "string",
    "properties.serviceArea": "string",
    "properties.showLocalPhones": "string",
    "properties.site_id": "string",
    "properties.staticMapUrl": "string",
    "properties.staticMapUrlLarge": "string",
    "properties.tos": "string",
    "properties.units": [
        "int"
    ],
    "properties.url.city": "string",
    "properties.url.facility": "string",
    "properties.url.state": "string",
    "properties.url.website": "string",
    "properties.website": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2024-01-10 09:50:54

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_submit`\n(\n`type`STRING,`version`STRING,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`timestamp`STRING,`integrations`struct<`_empty_`:STRING>,`_origin`STRING,`properties`struct<`images`:array,`searchId`:STRING,`showLocalPhones`:STRING,`site_id`:STRING,`irmFacility`:STRING,`staticMapUrlLarge`:STRING,`promotion`:STRING,`isSelfStorage`:STRING,`imageDetails`:array>,`reviewMetadata`:struct<`count`:STRING,`cons`:array,`average`:STRING,`ratingCounts`:array>,`pros`:array>,`recommendedCount`:STRING>,`messaging`:struct<`amexActive`:STRING,`isUrgent`:STRING,`isOpenNow`:STRING,`isAaaEligible`:STRING,`hasPenskeTruck`:STRING,`isOrWillBeOpen`:STRING>,`staticMapUrl`:STRING,`isOutOfNetwork`:STRING,`isReact`:STRING,`tos`:STRING,`location`:struct<`city`:STRING,`streetView`:struct<`active`:STRING,`image`:STRING,`yaw`:STRING,`zoom`:STRING,`pitch`:STRING>,`zip`:STRING,`country`:STRING,`fullState`:STRING,`state`:STRING,`longitude`:STRING,`streetAddress`:STRING,`text`:STRING,`latitude`:STRING,`id`:STRING,`subLocality`:STRING>,`amenities`:struct<`acceptedCreditCards`:array>,`label`:STRING,`isActive`:STRING,`category`:STRING,`units`:array,`nearby`:struct<`facilities`:array>,`closures`:array,`extra`:struct<`lastName`:STRING,`bidAmount`:STRING,`omiPri`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`AAAMemberNumber`:STRING,`moveIn`:STRING,`promoCode`:STRING,`bookedUnit`:struct<`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array,`promotion`:STRING,`description`:struct<`physical`:struct<`length`:STRING,`width`:STRING,`height`:STRING>,`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>>,`reservation_days`:STRING,`id`:STRING>,`apiLeadId`:STRING,`matchReasons`:STRING,`bookingAgentId`:STRING,`apiCustId`:STRING,`movedIn`:STRING,`userId`:STRING,`duplicateOf`:STRING,`autoState`:STRING,`email`:STRING,`pickupTime`:STRING,`searchWeightTestId`:STRING,`hasOnlineMoveIns`:STRING,`payoutBatchId`:STRING,`moveOut`:STRING,`estimatedRevenue`:STRING,`onlineMoveInUrl`:STRING,`actualD`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`facilityId`:STRING,`bookingType`:STRING,`matchScore`:STRING,`callCenter`:STRING,`phone`:STRING,`npv`:STRING,`rebateProcessed`:STRING,`totalPaid`:STRING,`bookingState`:STRING,`depositPaid`:STRING,`omiFlowEnabled`:STRING,`phoneFacilityTransfer`:STRING,`callCenterTransfer`:STRING,`facilityName`:STRING,`hotLead`:STRING,`bidType`:STRING,`facilitylocation`:struct<`address1`:STRING,`city`:STRING,`country`:STRING,`zip`:STRING,`address2`:STRING,`state`:STRING>,`complete`:STRING,`sessionId`:STRING,`unitId`:STRING,`resaleRate`:STRING,`invoiceId`:STRING,`free`:STRING,`confirmationCode`:STRING,`price`:STRING,`unit`:struct<`unitIds`:array>,`monthlyInsurance`:STRING,`referrerId`:STRING,`trafficSourceId`:STRING,`typeOfListing`:STRING,`emailHash`:STRING,`hasContactlessMoveins`:STRING,`sizeH`:STRING,`facilityTenant`:STRING,`promo`:STRING,`alternateLastNames`:array,`phoneVerified`:STRING,`facilityTenantId`:STRING,`sizeD`:STRING,`actualW`:STRING,`statementId`:STRING,`read`:STRING,`termsVersion`:STRING,`callerIdPhone`:STRING,`contacted`:STRING,`firstName`:STRING,`facilityPhone`:STRING,`hostedWebsite`:STRING,`modifiedDtm`:STRING,`message`:STRING,`bookingWidget`:STRING,`alternatePhones`:array,`experiments`:struct<`sf_omi_mfe_embed`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11616_homepage_updates`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING>,`alternateEmails`:array,`timestamp`:STRING,`sizeW`:STRING,`phoneStatus`:STRING,`commission`:STRING,`centershiftAccountId`:STRING,`apiUnitId`:STRING,`eVisitId`:STRING,`corrected`:STRING,`reviewStatus`:STRING,`eSignType`:STRING,`searchWeightId`:STRING,`siteId`:STRING,`unitNumber`:STRING,`visitId`:STRING,`alternateFirstNames`:array,`omiCompleted`:STRING,`affiliateId`:STRING,`sitePhone`:STRING,`bookingAgent`:STRING,`phoneChangedNumber`:STRING,`companyCode`:STRING,`moveInOriginal`:STRING,`baseBid`:STRING,`canceled`:STRING,`disputeReason`:STRING,`customerNotes`:STRING,`callCenterNotes`:STRING>,`chatbot`:STRING,`groupedAmenities`:struct<`premium`:struct<`items`:struct<`propane`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`generalMaintenance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`detailing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`ice`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`water`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`washStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`airPump`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vacuum`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fuel`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`inspections`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`dumpStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`billing`:struct<`items`:struct<`chargeDate`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`cashAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`creditCardsAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`autoPay`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`securityDeposit`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`emailInvoicing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`checksAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`administration`:struct<`items`:struct<`bilingualManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`acceptTenantMail`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`adminFee`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`access`:struct<`items`:struct<`truckAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`handcarts`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`kiosk`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`egateAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`elevator`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`discounts`:struct<`items`:struct<`seniorDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`militaryDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`studentDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`other`:struct<`items`:struct<`paperworkRemotely`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`bandPracticeAllowed`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`moving`:struct<`items`:struct<`truckRentalAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`movingSupplies`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`freeTruckRental`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`vehicle`:struct<`items`:struct<`vehicleRequiresInsurance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresTitle`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresRegistration`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleMustBeRunning`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`security`:struct<`items`:struct<`residentManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fenced`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`surveillance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`insurance`:struct<`items`:struct<`homeInsuranceAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceRequired`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>>,`name`:STRING,`serviceArea`:STRING,`jordanProp`:STRING,`description`:STRING,`phone`:STRING,`fees`:struct<`admin`:struct<`text`:STRING,`value`:STRING>,`deposit`:struct<`hasDeposit`:STRING,`text`:STRING,`percent`:STRING,`isRefundable`:STRING,`value`:STRING>,`insurance`:STRING>,`reviews`:array>,`utcOffset`:STRING,`month`:STRING,`isValidDate`:STRING,`isValidTime`:STRING,`year`:STRING,`dayOfWeekText`:STRING,`day`:STRING,`minute`:STRING,`second`:STRING>,`title`:STRING,`ratingDetails`:struct<`ratingService`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingPrice`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingCleanliness`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>>,`nickname`:STRING,`message`:STRING,`ratingRecommended`:STRING>>,`corporation`:struct<`sourceId`:STRING,`type`:STRING,`id`:STRING>,`url`:struct<`website`:STRING,`city`:STRING,`state`:STRING,`facility`:STRING>,`inNetwork`:STRING,`website`:STRING,`isFullServiceStandalone`:STRING,`hours`:struct<`access`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>>,`office`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>,`meta`:STRING>>,`irmMarket`:STRING,`env`:STRING,`id`:STRING,`Hit_Timestamp`:STRING>,`userId`STRING,`sentAt`STRING,`messageId`STRING,`event`STRING,`projectId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`context`struct<`ip`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING>,`userAgent`:STRING,`timezone`:STRING,`locale`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`library`:struct<`version`:STRING,`name`:STRING>>,`receivedAt`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/submit'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_submit`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_submit"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2017-10-02 15:04:22",
        "disabled": false,
        "format": "raw",
        "id": 434,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_segment",
            "table": "reactfoot_submit"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_segment.reactfoot_submit`\nADD\n\n\n PARTITION (dt='2025-01-22') location 's3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-22/'\n PARTITION (dt='2025-01-23') location 's3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-23/'\n PARTITION (dt='2025-01-24') location 's3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-24/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 286286,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-22/",
                    "name": "dt",
                    "value": "2025-01-22"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-01-22 09:44:55",
                        "last_data": "2025-01-22 17:25:04"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 286398,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-23/",
                    "name": "dt",
                    "value": "2025-01-23"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-01-23 09:47:10",
                        "last_data": "2025-01-23 09:51:47"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 286502,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/submit/dt=2025-01-24/",
                    "name": "dt",
                    "value": "2025-01-24"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-01-24 10:45:56",
                        "last_data": "2025-01-24 17:26:25"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "anonymousId": "string",
            "channel": "string",
            "context.campaign.content": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.ip": "string",
            "context.library.name": "string",
            "context.library.version": "string",
            "context.locale": "string",
            "context.page.path": "string",
            "context.page.referrer": "string",
            "context.page.search": "string",
            "context.page.title": "string",
            "context.page.url": "string",
            "context.timezone": "string",
            "context.userAgent": "string",
            "context.userAgentData.brands": [
                {
                    "brand": "string",
                    "version": "string"
                }
            ],
            "context.userAgentData.mobile": "string",
            "context.userAgentData.platform": "string",
            "event": "string",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.amenities.acceptedCreditCards": [
                "string"
            ],
            "properties.category": "string",
            "properties.chatbot": "string",
            "properties.closures": [
                "string"
            ],
            "properties.corporation.id": "string",
            "properties.corporation.sourceId": "string",
            "properties.corporation.type": "string",
            "properties.description": "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_12289_sfdc_holiday_messaging": "string",
            "properties.extra.experiments.sf_12496_sfdc_clp_unitcardrefresh": "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.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.omiCompleted": "string",
            "properties.extra.omiFlowEnabled": "string",
            "properties.extra.omiPri": "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.fees.admin.text": "string",
            "properties.fees.admin.value": "string",
            "properties.fees.deposit.hasDeposit": "string",
            "properties.fees.deposit.isRefundable": "string",
            "properties.fees.deposit.percent": "string",
            "properties.fees.deposit.text": "string",
            "properties.fees.deposit.value": "string",
            "properties.fees.insurance": "string",
            "properties.groupedAmenities.access.items.egateAccess.hasAttribute": "string",
            "properties.groupedAmenities.access.items.egateAccess.label": "string",
            "properties.groupedAmenities.access.items.egateAccess.showAlways": "string",
            "properties.groupedAmenities.access.items.elevator.hasAttribute": "string",
            "properties.groupedAmenities.access.items.elevator.label": "string",
            "properties.groupedAmenities.access.items.elevator.showAlways": "string",
            "properties.groupedAmenities.access.items.handcarts.hasAttribute": "string",
            "properties.groupedAmenities.access.items.handcarts.label": "string",
            "properties.groupedAmenities.access.items.handcarts.showAlways": "string",
            "properties.groupedAmenities.access.items.kiosk.hasAttribute": "string",
            "properties.groupedAmenities.access.items.kiosk.label": "string",
            "properties.groupedAmenities.access.items.kiosk.showAlways": "string",
            "properties.groupedAmenities.access.items.truckAccess.hasAttribute": "string",
            "properties.groupedAmenities.access.items.truckAccess.label": "string",
            "properties.groupedAmenities.access.items.truckAccess.showAlways": "string",
            "properties.groupedAmenities.access.label": "string",
            "properties.groupedAmenities.administration.items.acceptTenantMail.hasAttribute": "string",
            "properties.groupedAmenities.administration.items.acceptTenantMail.label": "string",
            "properties.groupedAmenities.administration.items.acceptTenantMail.showAlways": "string",
            "properties.groupedAmenities.administration.items.adminFee.hasAttribute": "string",
            "properties.groupedAmenities.administration.items.adminFee.label": "string",
            "properties.groupedAmenities.administration.items.adminFee.showAlways": "string",
            "properties.groupedAmenities.administration.items.bilingualManager.hasAttribute": "string",
            "properties.groupedAmenities.administration.items.bilingualManager.label": "string",
            "properties.groupedAmenities.administration.items.bilingualManager.showAlways": "string",
            "properties.groupedAmenities.administration.label": "string",
            "properties.groupedAmenities.billing.items.autoPay.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.autoPay.label": "string",
            "properties.groupedAmenities.billing.items.autoPay.showAlways": "string",
            "properties.groupedAmenities.billing.items.cashAccepted.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.cashAccepted.label": "string",
            "properties.groupedAmenities.billing.items.cashAccepted.showAlways": "string",
            "properties.groupedAmenities.billing.items.chargeDate.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.chargeDate.label": "string",
            "properties.groupedAmenities.billing.items.chargeDate.showAlways": "string",
            "properties.groupedAmenities.billing.items.checksAccepted.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.checksAccepted.label": "string",
            "properties.groupedAmenities.billing.items.checksAccepted.showAlways": "string",
            "properties.groupedAmenities.billing.items.creditCardsAccepted.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.creditCardsAccepted.label": "string",
            "properties.groupedAmenities.billing.items.creditCardsAccepted.showAlways": "string",
            "properties.groupedAmenities.billing.items.emailInvoicing.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.emailInvoicing.label": "string",
            "properties.groupedAmenities.billing.items.emailInvoicing.showAlways": "string",
            "properties.groupedAmenities.billing.items.securityDeposit.hasAttribute": "string",
            "properties.groupedAmenities.billing.items.securityDeposit.label": "string",
            "properties.groupedAmenities.billing.items.securityDeposit.showAlways": "string",
            "properties.groupedAmenities.billing.label": "string",
            "properties.groupedAmenities.discounts.items.militaryDiscount.hasAttribute": "string",
            "properties.groupedAmenities.discounts.items.militaryDiscount.label": "string",
            "properties.groupedAmenities.discounts.items.militaryDiscount.showAlways": "string",
            "properties.groupedAmenities.discounts.items.seniorDiscount.hasAttribute": "string",
            "properties.groupedAmenities.discounts.items.seniorDiscount.label": "string",
            "properties.groupedAmenities.discounts.items.seniorDiscount.showAlways": "string",
            "properties.groupedAmenities.discounts.items.studentDiscount.hasAttribute": "string",
            "properties.groupedAmenities.discounts.items.studentDiscount.label": "string",
            "properties.groupedAmenities.discounts.items.studentDiscount.showAlways": "string",
            "properties.groupedAmenities.discounts.label": "string",
            "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.hasAttribute": "string",
            "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.label": "string",
            "properties.groupedAmenities.insurance.items.homeInsuranceAccepted.showAlways": "string",
            "properties.groupedAmenities.insurance.items.insuranceAvailable.hasAttribute": "string",
            "properties.groupedAmenities.insurance.items.insuranceAvailable.label": "string",
            "properties.groupedAmenities.insurance.items.insuranceAvailable.showAlways": "string",
            "properties.groupedAmenities.insurance.items.insuranceRequired.hasAttribute": "string",
            "properties.groupedAmenities.insurance.items.insuranceRequired.label": "string",
            "properties.groupedAmenities.insurance.items.insuranceRequired.showAlways": "string",
            "properties.groupedAmenities.insurance.label": "string",
            "properties.groupedAmenities.moving.items.freeTruckRental.hasAttribute": "string",
            "properties.groupedAmenities.moving.items.freeTruckRental.label": "string",
            "properties.groupedAmenities.moving.items.freeTruckRental.showAlways": "string",
            "properties.groupedAmenities.moving.items.movingSupplies.hasAttribute": "string",
            "properties.groupedAmenities.moving.items.movingSupplies.label": "string",
            "properties.groupedAmenities.moving.items.movingSupplies.showAlways": "string",
            "properties.groupedAmenities.moving.items.truckRentalAvailable.hasAttribute": "string",
            "properties.groupedAmenities.moving.items.truckRentalAvailable.label": "string",
            "properties.groupedAmenities.moving.items.truckRentalAvailable.showAlways": "string",
            "properties.groupedAmenities.moving.label": "string",
            "properties.groupedAmenities.other.items.bandPracticeAllowed.hasAttribute": "string",
            "properties.groupedAmenities.other.items.bandPracticeAllowed.label": "string",
            "properties.groupedAmenities.other.items.bandPracticeAllowed.showAlways": "string",
            "properties.groupedAmenities.other.items.paperworkRemotely.hasAttribute": "string",
            "properties.groupedAmenities.other.items.paperworkRemotely.label": "string",
            "properties.groupedAmenities.other.items.paperworkRemotely.showAlways": "string",
            "properties.groupedAmenities.other.label": "string",
            "properties.groupedAmenities.premium.items.airPump.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.airPump.label": "string",
            "properties.groupedAmenities.premium.items.airPump.showAlways": "string",
            "properties.groupedAmenities.premium.items.detailing.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.detailing.label": "string",
            "properties.groupedAmenities.premium.items.detailing.showAlways": "string",
            "properties.groupedAmenities.premium.items.dumpStation.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.dumpStation.label": "string",
            "properties.groupedAmenities.premium.items.dumpStation.showAlways": "string",
            "properties.groupedAmenities.premium.items.fuel.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.fuel.label": "string",
            "properties.groupedAmenities.premium.items.fuel.showAlways": "string",
            "properties.groupedAmenities.premium.items.generalMaintenance.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.generalMaintenance.label": "string",
            "properties.groupedAmenities.premium.items.generalMaintenance.showAlways": "string",
            "properties.groupedAmenities.premium.items.ice.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.ice.label": "string",
            "properties.groupedAmenities.premium.items.ice.showAlways": "string",
            "properties.groupedAmenities.premium.items.inspections.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.inspections.label": "string",
            "properties.groupedAmenities.premium.items.inspections.showAlways": "string",
            "properties.groupedAmenities.premium.items.propane.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.propane.label": "string",
            "properties.groupedAmenities.premium.items.propane.showAlways": "string",
            "properties.groupedAmenities.premium.items.vacuum.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.vacuum.label": "string",
            "properties.groupedAmenities.premium.items.vacuum.showAlways": "string",
            "properties.groupedAmenities.premium.items.washStation.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.washStation.label": "string",
            "properties.groupedAmenities.premium.items.washStation.showAlways": "string",
            "properties.groupedAmenities.premium.items.water.hasAttribute": "string",
            "properties.groupedAmenities.premium.items.water.label": "string",
            "properties.groupedAmenities.premium.items.water.showAlways": "string",
            "properties.groupedAmenities.premium.label": "string",
            "properties.groupedAmenities.security.items.fenced.hasAttribute": "string",
            "properties.groupedAmenities.security.items.fenced.label": "string",
            "properties.groupedAmenities.security.items.fenced.showAlways": "string",
            "properties.groupedAmenities.security.items.residentManager.hasAttribute": "string",
            "properties.groupedAmenities.security.items.residentManager.label": "string",
            "properties.groupedAmenities.security.items.residentManager.showAlways": "string",
            "properties.groupedAmenities.security.items.surveillance.hasAttribute": "string",
            "properties.groupedAmenities.security.items.surveillance.label": "string",
            "properties.groupedAmenities.security.items.surveillance.showAlways": "string",
            "properties.groupedAmenities.security.label": "string",
            "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.hasAttribute": "string",
            "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.label": "string",
            "properties.groupedAmenities.vehicle.items.vehicleMustBeRunning.showAlways": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.hasAttribute": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.label": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresInsurance.showAlways": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.hasAttribute": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.label": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresRegistration.showAlways": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.hasAttribute": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.label": "string",
            "properties.groupedAmenities.vehicle.items.vehicleRequiresTitle.showAlways": "string",
            "properties.groupedAmenities.vehicle.label": "string",
            "properties.hours.access.text.friday": "string",
            "properties.hours.access.text.monday": "string",
            "properties.hours.access.text.saturday": "string",
            "properties.hours.access.text.sunday": "string",
            "properties.hours.access.text.thursday": "string",
            "properties.hours.access.text.tuesday": "string",
            "properties.hours.access.text.wednesday": "string",
            "properties.hours.office.meta": "string",
            "properties.hours.office.text.friday": "string",
            "properties.hours.office.text.monday": "string",
            "properties.hours.office.text.saturday": "string",
            "properties.hours.office.text.sunday": "string",
            "properties.hours.office.text.thursday": "string",
            "properties.hours.office.text.tuesday": "string",
            "properties.hours.office.text.wednesday": "string",
            "properties.id": "string",
            "properties.imageDetails": [
                {
                    "image": "string",
                    "tag": "string"
                }
            ],
            "properties.images": [
                "string"
            ],
            "properties.inNetwork": "string",
            "properties.irmFacility": "string",
            "properties.irmMarket": "string",
            "properties.isActive": "string",
            "properties.isFullServiceStandalone": "string",
            "properties.isOutOfNetwork": "string",
            "properties.isReact": "string",
            "properties.isSelfStorage": "string",
            "properties.jordanProp": "string",
            "properties.label": "string",
            "properties.location.city": "string",
            "properties.location.country": "string",
            "properties.location.fullState": "string",
            "properties.location.id": "string",
            "properties.location.latitude": "string",
            "properties.location.longitude": "string",
            "properties.location.state": "string",
            "properties.location.streetAddress": "string",
            "properties.location.streetView.active": "string",
            "properties.location.streetView.image": "string",
            "properties.location.streetView.pitch": "string",
            "properties.location.streetView.yaw": "string",
            "properties.location.streetView.zoom": "string",
            "properties.location.subLocality": "string",
            "properties.location.text": "string",
            "properties.location.zip": "string",
            "properties.messaging.amexActive": "string",
            "properties.messaging.hasPenskeTruck": "string",
            "properties.messaging.isAaaEligible": "string",
            "properties.messaging.isOpenNow": "string",
            "properties.messaging.isOrWillBeOpen": "string",
            "properties.messaging.isUrgent": "string",
            "properties.name": "string",
            "properties.nearby.facilities": [
                "string"
            ],
            "properties.phone": "string",
            "properties.promotion": "string",
            "properties.reviewMetadata.average": "string",
            "properties.reviewMetadata.cons": [
                "string"
            ],
            "properties.reviewMetadata.count": "string",
            "properties.reviewMetadata.pros": [
                {
                    "name": "string",
                    "reviewCount": "string"
                }
            ],
            "properties.reviewMetadata.ratingCounts": [
                {
                    "count": "string",
                    "rating": "string"
                }
            ],
            "properties.reviewMetadata.recommendedCount": "string",
            "properties.reviews": [
                {
                    "date.day": "string",
                    "date.dayOfWeek": "string",
                    "date.dayOfWeekText": "string",
                    "date.format.human.date": "string",
                    "date.format.human.time": "string",
                    "date.format.iso": "string",
                    "date.format.mdy": "string",
                    "date.format.timestamp": "string",
                    "date.format.ymd": "string",
                    "date.hour": "string",
                    "date.isValidDate": "string",
                    "date.isValidTime": "string",
                    "date.minute": "string",
                    "date.month": "string",
                    "date.monthText": "string",
                    "date.second": "string",
                    "date.utcOffset": "string",
                    "date.year": "string",
                    "denialReason": "string",
                    "facilityId": "string",
                    "id": "string",
                    "ipAddress": "string",
                    "message": "string",
                    "nickname": "string",
                    "parentId": "string",
                    "rating": "string",
                    "ratingCleanliness": "string",
                    "ratingDetails.ratingCleanliness.text": "string",
                    "ratingDetails.ratingCleanliness.value": "string",
                    "ratingDetails.ratingCleanliness.valueText": "string",
                    "ratingDetails.ratingPrice.text": "string",
                    "ratingDetails.ratingPrice.value": "string",
                    "ratingDetails.ratingPrice.valueText": "string",
                    "ratingDetails.ratingService.text": "string",
                    "ratingDetails.ratingService.value": "string",
                    "ratingDetails.ratingService.valueText": "string",
                    "ratingPrice": "string",
                    "ratingRecommended": "string",
                    "ratingService": "string",
                    "siteId": "string",
                    "source": "string",
                    "status": "string",
                    "title": "string",
                    "userId": "string",
                    "visitId": "string"
                }
            ],
            "properties.searchId": "string",
            "properties.serviceArea": "string",
            "properties.showLocalPhones": "string",
            "properties.site_id": "string",
            "properties.staticMapUrl": "string",
            "properties.staticMapUrlLarge": "string",
            "properties.tos": "string",
            "properties.units": [
                "int"
            ],
            "properties.url.city": "string",
            "properties.url.facility": "string",
            "properties.url.state": "string",
            "properties.url.website": "string",
            "properties.website": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2024-01-10 09:50:54",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_submit`\n(\n`type`STRING,`version`STRING,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`timestamp`STRING,`integrations`struct<`_empty_`:STRING>,`_origin`STRING,`properties`struct<`images`:array,`searchId`:STRING,`showLocalPhones`:STRING,`site_id`:STRING,`irmFacility`:STRING,`staticMapUrlLarge`:STRING,`promotion`:STRING,`isSelfStorage`:STRING,`imageDetails`:array>,`reviewMetadata`:struct<`count`:STRING,`cons`:array,`average`:STRING,`ratingCounts`:array>,`pros`:array>,`recommendedCount`:STRING>,`messaging`:struct<`amexActive`:STRING,`isUrgent`:STRING,`isOpenNow`:STRING,`isAaaEligible`:STRING,`hasPenskeTruck`:STRING,`isOrWillBeOpen`:STRING>,`staticMapUrl`:STRING,`isOutOfNetwork`:STRING,`isReact`:STRING,`tos`:STRING,`location`:struct<`city`:STRING,`streetView`:struct<`active`:STRING,`image`:STRING,`yaw`:STRING,`zoom`:STRING,`pitch`:STRING>,`zip`:STRING,`country`:STRING,`fullState`:STRING,`state`:STRING,`longitude`:STRING,`streetAddress`:STRING,`text`:STRING,`latitude`:STRING,`id`:STRING,`subLocality`:STRING>,`amenities`:struct<`acceptedCreditCards`:array>,`label`:STRING,`isActive`:STRING,`category`:STRING,`units`:array,`nearby`:struct<`facilities`:array>,`closures`:array,`extra`:struct<`lastName`:STRING,`bidAmount`:STRING,`omiPri`:STRING,`listingWantId`:STRING,`moveInActual`:STRING,`AAAMemberNumber`:STRING,`moveIn`:STRING,`promoCode`:STRING,`bookedUnit`:struct<`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array,`promotion`:STRING,`description`:struct<`physical`:struct<`length`:STRING,`width`:STRING,`height`:STRING>,`vehicle`:struct<`only`:STRING,`permitted`:STRING,`warehouse`:STRING>>,`reservation_days`:STRING,`id`:STRING>,`apiLeadId`:STRING,`matchReasons`:STRING,`bookingAgentId`:STRING,`apiCustId`:STRING,`movedIn`:STRING,`userId`:STRING,`duplicateOf`:STRING,`autoState`:STRING,`email`:STRING,`pickupTime`:STRING,`searchWeightTestId`:STRING,`hasOnlineMoveIns`:STRING,`payoutBatchId`:STRING,`moveOut`:STRING,`estimatedRevenue`:STRING,`onlineMoveInUrl`:STRING,`actualD`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`facilityId`:STRING,`bookingType`:STRING,`matchScore`:STRING,`callCenter`:STRING,`phone`:STRING,`npv`:STRING,`rebateProcessed`:STRING,`totalPaid`:STRING,`bookingState`:STRING,`depositPaid`:STRING,`omiFlowEnabled`:STRING,`phoneFacilityTransfer`:STRING,`callCenterTransfer`:STRING,`facilityName`:STRING,`hotLead`:STRING,`bidType`:STRING,`facilitylocation`:struct<`address1`:STRING,`city`:STRING,`country`:STRING,`zip`:STRING,`address2`:STRING,`state`:STRING>,`complete`:STRING,`sessionId`:STRING,`unitId`:STRING,`resaleRate`:STRING,`invoiceId`:STRING,`free`:STRING,`confirmationCode`:STRING,`price`:STRING,`unit`:struct<`unitIds`:array>,`monthlyInsurance`:STRING,`referrerId`:STRING,`trafficSourceId`:STRING,`typeOfListing`:STRING,`emailHash`:STRING,`hasContactlessMoveins`:STRING,`sizeH`:STRING,`facilityTenant`:STRING,`promo`:STRING,`alternateLastNames`:array,`phoneVerified`:STRING,`facilityTenantId`:STRING,`sizeD`:STRING,`actualW`:STRING,`statementId`:STRING,`read`:STRING,`termsVersion`:STRING,`callerIdPhone`:STRING,`contacted`:STRING,`firstName`:STRING,`facilityPhone`:STRING,`hostedWebsite`:STRING,`modifiedDtm`:STRING,`message`:STRING,`bookingWidget`:STRING,`alternatePhones`:array,`experiments`:struct<`sf_omi_mfe_embed`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_11616_homepage_updates`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING>,`alternateEmails`:array,`timestamp`:STRING,`sizeW`:STRING,`phoneStatus`:STRING,`commission`:STRING,`centershiftAccountId`:STRING,`apiUnitId`:STRING,`eVisitId`:STRING,`corrected`:STRING,`reviewStatus`:STRING,`eSignType`:STRING,`searchWeightId`:STRING,`siteId`:STRING,`unitNumber`:STRING,`visitId`:STRING,`alternateFirstNames`:array,`omiCompleted`:STRING,`affiliateId`:STRING,`sitePhone`:STRING,`bookingAgent`:STRING,`phoneChangedNumber`:STRING,`companyCode`:STRING,`moveInOriginal`:STRING,`baseBid`:STRING,`canceled`:STRING,`disputeReason`:STRING,`customerNotes`:STRING,`callCenterNotes`:STRING>,`chatbot`:STRING,`groupedAmenities`:struct<`premium`:struct<`items`:struct<`propane`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`generalMaintenance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`detailing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`ice`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`water`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`washStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`airPump`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vacuum`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fuel`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`inspections`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`dumpStation`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`billing`:struct<`items`:struct<`chargeDate`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`cashAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`creditCardsAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`autoPay`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`securityDeposit`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`emailInvoicing`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`checksAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`administration`:struct<`items`:struct<`bilingualManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`acceptTenantMail`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`adminFee`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`access`:struct<`items`:struct<`truckAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`handcarts`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`kiosk`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`egateAccess`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`elevator`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`discounts`:struct<`items`:struct<`seniorDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`militaryDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`studentDiscount`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`other`:struct<`items`:struct<`paperworkRemotely`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`bandPracticeAllowed`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`moving`:struct<`items`:struct<`truckRentalAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`movingSupplies`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`freeTruckRental`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`vehicle`:struct<`items`:struct<`vehicleRequiresInsurance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresTitle`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleRequiresRegistration`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`vehicleMustBeRunning`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`security`:struct<`items`:struct<`residentManager`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`fenced`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`surveillance`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>,`insurance`:struct<`items`:struct<`homeInsuranceAccepted`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceRequired`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>,`insuranceAvailable`:struct<`showAlways`:STRING,`hasAttribute`:STRING,`label`:STRING>>,`label`:STRING>>,`name`:STRING,`serviceArea`:STRING,`jordanProp`:STRING,`description`:STRING,`phone`:STRING,`fees`:struct<`admin`:struct<`text`:STRING,`value`:STRING>,`deposit`:struct<`hasDeposit`:STRING,`text`:STRING,`percent`:STRING,`isRefundable`:STRING,`value`:STRING>,`insurance`:STRING>,`reviews`:array>,`utcOffset`:STRING,`month`:STRING,`isValidDate`:STRING,`isValidTime`:STRING,`year`:STRING,`dayOfWeekText`:STRING,`day`:STRING,`minute`:STRING,`second`:STRING>,`title`:STRING,`ratingDetails`:struct<`ratingService`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingPrice`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>,`ratingCleanliness`:struct<`text`:STRING,`value`:STRING,`valueText`:STRING>>,`nickname`:STRING,`message`:STRING,`ratingRecommended`:STRING>>,`corporation`:struct<`sourceId`:STRING,`type`:STRING,`id`:STRING>,`url`:struct<`website`:STRING,`city`:STRING,`state`:STRING,`facility`:STRING>,`inNetwork`:STRING,`website`:STRING,`isFullServiceStandalone`:STRING,`hours`:struct<`access`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>>,`office`:struct<`text`:struct<`monday`:STRING,`tuesday`:STRING,`friday`:STRING,`wednesday`:STRING,`thursday`:STRING,`sunday`:STRING,`saturday`:STRING>,`meta`:STRING>>,`irmMarket`:STRING,`env`:STRING,`id`:STRING,`Hit_Timestamp`:STRING>,`userId`STRING,`sentAt`STRING,`messageId`STRING,`event`STRING,`projectId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`context`struct<`ip`:STRING,`campaign`:struct<`content`:STRING,`medium`:STRING,`source`:STRING,`name`:STRING>,`userAgent`:STRING,`timezone`:STRING,`locale`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`userAgentData`:struct<`platform`:STRING,`mobile`:STRING,`brands`:array>>,`library`:struct<`version`:STRING,`name`:STRING>>,`receivedAt`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/submit'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_submit`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_submit"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}