Schema Info

Schema Name: sfdl_stage_segment.reactfoot_gtmwebreservation

created: 2017-11-01 20:58:18
disabled: False
format: raw
id: 289
is_partitioned: True
is_schema_datatyped: False

name:

{
    "database": "sfdl_stage_segment",
    "table": "reactfoot_gtmwebreservation"
}

type: segment

Schema Versions: 3

Version 738307

created: 2024-08-22 16:24:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
    "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`channel`STRING,`projectId`STRING,`sentAt`STRING,`userId`STRING,`version`STRING,`original_key`STRING,`receivedAt`STRING,`messageId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`anonymousId`STRING,`originalTimestamp`STRING,`_origin`STRING,`context`struct<`timezone`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`campaign`:struct<`_empty_`:STRING>>,`type`STRING,`properties`struct<`booking`:struct<`email`:STRING,`npv`:STRING,`emailHash`:STRING,`confirmationCode`:STRING>,`site_id`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`isReact`:STRING,`transaction`:struct<`email`:STRING,`companyCode`:STRING,`customerNotes`:STRING,`confirmationCode`:STRING,`centershiftAccountId`:STRING,`callCenter`:STRING,`unitNumber`:STRING,`baseBid`:STRING,`AAAMemberNumber`:STRING,`disputeReason`:STRING,`incentivePitchedByAgent`:STRING,`listingWantId`:STRING,`moveIn`:STRING,`userId`:STRING,`payoutBatchId`:STRING,`sitePhone`:STRING,`pageType`:STRING,`firstName`:STRING,`phoneChangedNumber`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`apiUnitId`:STRING,`promo`:STRING,`statementId`:STRING,`experiments`:struct<`sf_9464_sfdc_persist_top_yielders`:STRING,`red_716_tracking_prerender`:STRING,`sf_4394_search_bar`:STRING,`sf_4603_paid_landing_page`:STRING,`sf_4651_stacked_ui_links`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_6138_mid_field_text`:STRING,`sf_4161_post_res_paid`:STRING,`sf_4641_stacked_ui_chevron`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_4346_hide_mobile_map`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_11616_homepage_updates`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_5288_informed_search`:STRING,`sf_4642_lock_incentive`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_6852_serp_results`:STRING,`sf_5289_facility_page_two`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_omi_mfe_embed`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_4788_search_filters`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_5430_incentive_header`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_13380_sfdc_new_filter`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_7018_upsellit`:STRING,`sf_4319_facility_grid`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_4606_post_res_sms`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_5695_click_to_show_phone_number`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`hack_01_facility_page`:STRING,`sf_4792_remove_date_from_search`:STRING,`sf_4398_updated_res_conf`:STRING,`sf_4787_facility_page`:STRING,`sf_6327_visa_incentive`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_5635_half_nomad`:STRING,`sf_5069_alt_contact_info`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_5288_informed_search_2`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_5198_oon_facility_page`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_5129_call_me_back`:STRING>,`autoState`:STRING,`contacted`:STRING,`read`:STRING,`alternateFirstNames`:array,`emailHash`:STRING,`facilityTenant`:STRING,`bookingState`:STRING,`matchScore`:STRING,`timestamp`:STRING,`phoneFacilityTransfer`:STRING,`corrected`:STRING,`facilityGetsNotificationEmails`:STRING,`moveInActual`:STRING,`affiliateId`:STRING,`complete`:STRING,`npv`:STRING,`invoiceId`:STRING,`duplicateOf`:STRING,`actualD`:STRING,`hasContactlessMoveins`:STRING,`facilityId`:STRING,`alternatePhones`:array,`matchReasons`:STRING,`phoneStatus`:STRING,`referrerId`:STRING,`resaleRate`:STRING,`message`:STRING,`canceled`:STRING,`moveOut`:STRING,`promoCode`:STRING,`siteId`:STRING,`apiLeadId`:STRING,`depositPaid`:STRING,`movedIn`:STRING,`bookingType`:STRING,`reviewStatus`:STRING,`sizeH`:STRING,`omiCompleted`:STRING,`termsVersion`:STRING,`typeOfListing`:STRING,`incentiveTypeId`:STRING,`hotLead`:STRING,`callCenterNotes`:STRING,`modifiedDtm`:STRING,`phoneVerified`:STRING,`sizeW`:STRING,`facilityName`:STRING,`alternateEmails`:array,`rebateProcessed`:STRING,`lastName`:STRING,`unit`:struct<`unitIds`:array>,`omiPri`:STRING,`pickupTime`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`hasOnlineMoveIns`:STRING,`bookingAgentId`:STRING,`sessionId`:STRING,`trafficSourceId`:STRING,`sizeD`:STRING,`facilitylocation`:struct<`zip`:STRING,`country`:STRING,`state`:STRING,`address1`:STRING,`city`:STRING,`address2`:STRING>,`facilityTenantId`:STRING,`commission`:STRING,`free`:STRING,`totalPaid`:STRING,`eSignType`:STRING,`monthlyInsurance`:STRING,`bidAmount`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`unitId`:STRING,`bidType`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`alternateLastNames`:array,`bookingAgent`:STRING,`facilityPhone`:STRING,`bookingWidget`:STRING,`eVisitId`:STRING,`apiCustId`:STRING,`omiFlowEnabled`:STRING,`price`:STRING,`moveInOriginal`:STRING,`onlineMoveInUrl`:STRING,`actualW`:STRING,`bookedUnit`:struct<`unitType`:STRING,`amenities`:array,`id`:STRING,`price`:struct<`meta`:STRING>,`reservation_days`:STRING,`promotion`:STRING,`description`:struct<`physical`:struct<`height`:STRING,`width`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>>>,`estimatedRevenue`:STRING,`searchWeightId`:STRING,`phone`:STRING,`visitId`:STRING>>,`event`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-stage/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation
id: 738307
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "FullStory",
            "Google Analytics",
            "Segment.io"
        ],
        "bundledIds": [
            "5e32e71155e30dd61b5fd962",
            "59c551d1c3469c0001a4e89a"
        ],
        "unbundled": []
    },
    "_origin": "2024-08-22T21:24:16Z|s3://sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1724284800000/1724361838336.events-archiver-480-47..885ecd9a-4ff1-4d87-8d5c-561a631a8bed.gz|analytics-segment-separator-stage:$LATEST",
    "anonymousId": "21ee8497-a4b1-41e9-85cb-2945d5aff2b1",
    "channel": "client",
    "context": {
        "ip": "99.61.65.36",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage/SiteLink-Demo-Facility-105463.html",
            "referrer": "https://sparefoot.extrameter.com/search.html?location=perryville%20alaska",
            "search": "",
            "title": "SiteLink Demo Facility | 403 Brooks Road | SpareFoot",
            "url": "https://www.sparefoot.extrameter.com/Perryville-AK-self-storage/SiteLink-Demo-Facility-105463.html"
        },
        "timezone": "America/Chicago",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Not)A;Brand",
                    "version": "99"
                },
                {
                    "brand": "Google Chrome",
                    "version": "127"
                },
                {
                    "brand": "Chromium",
                    "version": "127"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1724358649630-02725d2e-4d96-4f02-ab3d-87786fb2ea7a",
    "originalTimestamp": "2024-08-22T20:30:49.630Z",
    "projectId": "nQDzdrZI1K",
    "properties": {
        "Hit Timestamp": 1724358649630,
        "booking": {
            "confirmationCode": "4A7N4TXWP",
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "npv": "500.00"
        },
        "env": "stage",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 2318,
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "Storage.com",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "505074",
            "apiLeadId": "228977",
            "apiUnitId": "82073",
            "autoState": null,
            "baseBid": "5.00",
            "bidAmount": "500.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "Alarm",
                    "Climate Controlled",
                    "Electricity",
                    "Interior"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "5.00",
                        "width": "5.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 24152191,
                "price": {
                    "meta": "65.00"
                },
                "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-08-22 3:30pm] Booking 5' x 5' unit $65.00 (Alarm, Climate Controlled, Electricity, Interior) Promo: Free 1 Months Rent - P2 on website (Storage.com)\n[2024-08-22 3:30pm] SL Reference ID: 1002836802",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": null,
            "companyCode": "",
            "complete": 1,
            "confirmationCode": "4A7N4TXWP",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "estimatedRevenue": null,
            "experiments": {
                "sf_11292_confirmation_page_hero": "variation",
                "sf_11349_sfdc_omi": "inactive",
                "sf_11786_sfdc_omi_redesign": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "control",
                "sf_12700_sfdc_paid_landing_refresh": "variation1",
                "sf_13230_distance_top_five_algo": "control",
                "sf_13380_sfdc_new_filter": "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": false,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "test",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-08-22 15:30:49",
            "monthlyInsurance": null,
            "moveIn": "2024-08-24",
            "moveInActual": null,
            "moveInOriginal": "2024-08-24",
            "moveOut": null,
            "movedIn": 0,
            "npv": "500.00",
            "omiAttributes": {
                "facility": "LTRAIN",
                "organization": "CSPFT",
                "provider": "sl",
                "reservation": "pal:reservation:sl:CSPFT;LTRAIN;228977",
                "unit": "82073"
            },
            "omiCompleted": false,
            "omiFlowEnabled": true,
            "omiPri": "pal:reservation:sl:CSPFT;LTRAIN;228977",
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "5555555555",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "65.00",
            "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-08-22 15:30:48",
            "totalPaid": null,
            "trafficSourceId": "__Direct",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "24152175",
                    "24152176",
                    "24152177",
                    "24152178",
                    "24152179",
                    "24152180",
                    "24152181",
                    "24152182",
                    "24152183",
                    "24152184",
                    "24152185",
                    "24152186",
                    "24152187",
                    "24152188",
                    "24152189",
                    "24152190",
                    "24152191",
                    "24152192",
                    "24152193",
                    "24152194",
                    "24152195",
                    "24152196",
                    "24152197",
                    "24152198",
                    "24152199",
                    "24152200",
                    "24152201",
                    "24152202",
                    "24152203",
                    "24152204",
                    "24152205",
                    "24152206",
                    "24152207",
                    "24152208",
                    "24152209",
                    "24152210",
                    "24152211",
                    "24152212",
                    "24152213",
                    "24152214",
                    "24152215",
                    "24152216",
                    "24152217",
                    "24152218",
                    "24152219",
                    "24152220",
                    "24152221",
                    "24152222",
                    "24152223",
                    "24152224"
                ]
            },
            "unitId": 24152191,
            "unitNumber": "366",
            "userId": 1253,
            "visitId": null
        }
    },
    "receivedAt": "2024-08-22T20:30:49.919Z",
    "sentAt": "2024-08-22T20:30:49.643Z",
    "timestamp": "2024-08-22T20:30:49.906Z",
    "type": "track",
    "userId": "a08a07fd28e98ca78ca3b87a6d94efe4",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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",
    "original_key": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4319_facility_grid": "string",
    "properties.transaction.experiments.sf_4346_hide_mobile_map": "string",
    "properties.transaction.experiments.sf_4394_search_bar": "string",
    "properties.transaction.experiments.sf_4398_updated_res_conf": "string",
    "properties.transaction.experiments.sf_4603_paid_landing_page": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4641_stacked_ui_chevron": "string",
    "properties.transaction.experiments.sf_4642_lock_incentive": "string",
    "properties.transaction.experiments.sf_4651_stacked_ui_links": "string",
    "properties.transaction.experiments.sf_4787_facility_page": "string",
    "properties.transaction.experiments.sf_4788_search_filters": "string",
    "properties.transaction.experiments.sf_4792_remove_date_from_search": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5198_oon_facility_page": "string",
    "properties.transaction.experiments.sf_5288_informed_search": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_5695_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.incentivePitchedByAgent": "string",
    "properties.transaction.incentiveTypeId": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiAttributes.facility": "string",
    "properties.transaction.omiAttributes.organization": "string",
    "properties.transaction.omiAttributes.provider": "string",
    "properties.transaction.omiAttributes.reservation": "string",
    "properties.transaction.omiAttributes.unit": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.pageType": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 289
schema_scan_id: 5943876
updated: 2024-08-22 16:24:51

Version 728975

created: 2024-08-01 02:44:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
    "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_gtmwebreservation`\n(\n`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`_origin`STRING,`messageId`STRING,`integrations`struct<`_empty_`:STRING>,`context`struct<`ip`:STRING,`locale`:STRING,`timezone`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`_empty_`:STRING>,`page`:struct<`search`:STRING,`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING>,`userAgent`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`event`STRING,`channel`STRING,`type`STRING,`original_key`STRING,`sentAt`STRING,`userId`STRING,`receivedAt`STRING,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`booking`:struct<`confirmationCode`:STRING,`emailHash`:STRING,`email`:STRING,`npv`:STRING>,`transaction`:struct<`incentiveTypeId`:STRING,`sizeW`:STRING,`facilityTenant`:STRING,`hasContactlessMoveins`:STRING,`affiliateId`:STRING,`reviewStatus`:STRING,`email`:STRING,`movedIn`:STRING,`matchScore`:STRING,`bookingWidget`:STRING,`bidAmount`:STRING,`phoneChangedNumber`:STRING,`emailHash`:STRING,`callerIdPhone`:STRING,`phoneVerified`:STRING,`omiPri`:STRING,`centershiftAccountId`:STRING,`resaleRate`:STRING,`bookingType`:STRING,`pickupTime`:STRING,`phoneStatus`:STRING,`customerNotes`:STRING,`experiments`:struct<`sf_4137_sms_opt_in`:STRING,`sf_5288_informed_search`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_11349_sfdc_omi`:STRING,`hack_01_facility_page`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_4641_stacked_ui_chevron`:STRING,`sf_4603_paid_landing_page`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`red_716_tracking_prerender`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_5288_informed_search_2`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_7018_upsellit`:STRING,`sf_5289_facility_page_two`:STRING,`sf_4792_remove_date_from_search`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_4787_facility_page`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_5695_click_to_show_phone_number`:STRING,`sf_4398_updated_res_conf`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_6852_serp_results`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_4642_lock_incentive`:STRING,`sf_4651_stacked_ui_links`:STRING,`sf_4346_hide_mobile_map`:STRING,`sf_6327_visa_incentive`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_4394_search_bar`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_4788_search_filters`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_omi_mfe_embed`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_11616_homepage_updates`:STRING,`sf_6138_mid_field_text`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_4606_post_res_sms`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_5430_incentive_header`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_5198_oon_facility_page`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_4161_post_res_paid`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_13380_sfdc_new_filter`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5129_call_me_back`:STRING,`sf_4319_facility_grid`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_5635_half_nomad`:STRING>,`price`:STRING,`hostedWebsite`:STRING,`moveInOriginal`:STRING,`phoneFacilityTransfer`:STRING,`promoCode`:STRING,`firstName`:STRING,`complete`:STRING,`monthlyInsurance`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`apiCustId`:STRING,`referrerId`:STRING,`companyCode`:STRING,`phone`:STRING,`apiUnitId`:STRING,`duplicateOf`:STRING,`commission`:STRING,`baseBid`:STRING,`unitNumber`:STRING,`facilityTenantId`:STRING,`promo`:STRING,`moveIn`:STRING,`searchWeightId`:STRING,`totalPaid`:STRING,`omiCompleted`:STRING,`facilityGetsNotificationEmails`:STRING,`lastName`:STRING,`hotLead`:STRING,`alternateFirstNames`:array,`autoState`:STRING,`moveOut`:STRING,`facilityName`:STRING,`message`:STRING,`bookingAgentId`:STRING,`statementId`:STRING,`hasOnlineMoveIns`:STRING,`listingWantId`:STRING,`callCenterNotes`:STRING,`actualD`:STRING,`canceled`:STRING,`incentivePitchedByAgent`:STRING,`searchWeightTestId`:STRING,`depositPaid`:STRING,`termsVersion`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>,`physical`:struct<`length`:STRING,`height`:STRING,`width`:STRING>>,`amenities`:array,`id`:STRING,`promotion`:STRING,`unitType`:STRING,`price`:struct<`meta`:STRING>>,`modifiedDtm`:STRING,`AAAMemberNumber`:STRING,`bidType`:STRING,`eSignType`:STRING,`estimatedRevenue`:STRING,`alternateEmails`:array,`facilityPhone`:STRING,`facilitylocation`:struct<`city`:STRING,`country`:STRING,`zip`:STRING,`address2`:STRING,`state`:STRING,`address1`:STRING>,`bookingAgent`:STRING,`callCenter`:STRING,`rebateProcessed`:STRING,`userId`:STRING,`visitId`:STRING,`typeOfListing`:STRING,`omiFlowEnabled`:STRING,`npv`:STRING,`corrected`:STRING,`payoutBatchId`:STRING,`onlineMoveInUrl`:STRING,`timestamp`:STRING,`callCenterTransfer`:STRING,`moveInActual`:STRING,`pageType`:STRING,`bookingState`:STRING,`contacted`:STRING,`siteId`:STRING,`sitePhone`:STRING,`free`:STRING,`alternateLastNames`:array,`unitId`:STRING,`alternatePhones`:array,`facilityId`:STRING,`eVisitId`:STRING,`trafficSourceId`:STRING,`actualW`:STRING,`invoiceId`:STRING,`matchReasons`:STRING,`read`:STRING,`confirmationCode`:STRING,`unit`:struct<`unitIds`:array>,`disputeReason`:STRING,`sizeD`:STRING,`apiLeadId`:STRING,`sizeH`:STRING,`sessionId`:STRING>,`env`:STRING>,`version`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-stage/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation
id: 728975
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "FullStory",
            "Google Analytics",
            "Segment.io"
        ],
        "bundledIds": [
            "5e32e71155e30dd61b5fd962",
            "59c551d1c3469c0001a4e89a"
        ],
        "unbundled": []
    },
    "_origin": "2024-08-01T07:44:00Z|s3://sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1722470400000/1722498223410.events-archiver-480-50..7ded2c0d-cab1-430e-8c2b-e5fa22210791.gz|analytics-segment-separator-stage:$LATEST",
    "anonymousId": "22ba2d1e-52ff-4558-9664-a3040975f8b9",
    "channel": "client",
    "context": {
        "ip": "103.169.83.19",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage/Voyager-Test-Site-236279.html",
            "referrer": "https://www.sparefoot.extrameter.com/search.html?location=Perryville%2C%20Alaska%2C%20USA&latitude=55.9121988&longitude=-159.1453343",
            "search": "",
            "title": "Voyager Test Site | 400 Brooks Road | SpareFoot",
            "url": "https://www.sparefoot.extrameter.com/Perryville-AK-self-storage/Voyager-Test-Site-236279.html"
        },
        "timezone": "Asia/Calcutta",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Not)A;Brand",
                    "version": "99"
                },
                {
                    "brand": "Google Chrome",
                    "version": "127"
                },
                {
                    "brand": "Chromium",
                    "version": "127"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1722495300845-b910ff1c-3782-4b90-8aec-3ed084398a5d",
    "originalTimestamp": "2024-08-01T06:55:00.845Z",
    "projectId": "nQDzdrZI1K",
    "properties": {
        "Hit Timestamp": 1722495300845,
        "booking": {
            "confirmationCode": "QTTUAY3XS",
            "email": "[email protected]",
            "emailHash": "e6337ecd52083436f8cbe1d35803c2087d54e8cd94d899778d353a54e5dce284",
            "npv": "312.00"
        },
        "env": "stage",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 2318,
                "hasOnlineMoveIns": true
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "18df6e29-ba1a-44c8-8950-53b45c62",
            "apiLeadId": "927ba9ae-a114-408f-b17a-4e7ea4237ef1",
            "apiUnitId": null,
            "autoState": null,
            "baseBid": "1.30",
            "bidAmount": "312.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "Air Cooled",
                    "Humidity Controlled",
                    "Interior",
                    "Swing Door"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "20.00",
                        "width": "10.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 31797989,
                "price": {
                    "meta": "240.00"
                },
                "promotion": "10% Disc",
                "reservation_days": 60,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-08-01 1:54am] Booking 10' x 20' unit $240.00 (Air Cooled, Humidity Controlled, Interior, Swing Door) Promo: 10% Disc on website (SpareFoot.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": "",
            "complete": 1,
            "confirmationCode": "QTTUAY3XS",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "e6337ecd52083436f8cbe1d35803c2087d54e8cd94d899778d353a54e5dce284",
            "estimatedRevenue": 134.5344,
            "experiments": {
                "sf_11292_confirmation_page_hero": "variation",
                "sf_11349_sfdc_omi": "inactive",
                "sf_11786_sfdc_omi_redesign": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "variation",
                "sf_12700_sfdc_paid_landing_refresh": "variation1",
                "sf_13230_distance_top_five_algo": "control",
                "sf_13380_sfdc_new_filter": "control",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 236279,
            "facilityName": "Voyager Test Site",
            "facilityPhone": 2172172687,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "400 Brooks Road",
                "address2": "",
                "city": "Perryville",
                "country": "",
                "state": "AK",
                "zip": "99648"
            },
            "firstName": "Anil",
            "free": 0,
            "hasContactlessMoveins": false,
            "hasOnlineMoveIns": true,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "Kumar",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-08-01 01:55:00",
            "monthlyInsurance": null,
            "moveIn": "2024-08-02",
            "moveInActual": null,
            "moveInOriginal": "2024-08-02",
            "moveOut": null,
            "movedIn": 0,
            "npv": "312.00",
            "omiCompleted": false,
            "omiFlowEnabled": true,
            "omiPri": "pal:reservation:se:60cf0b2c-d342-4d31-b87d-c0f1900b5db6;927ba9ae-a114-408f-b17a-4e7ea4237ef1",
            "onlineMoveInUrl": "https://mvin.online/0f93ae7b",
            "payoutBatchId": null,
            "phone": "7306306102",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "240.00",
            "promo": "10% Disc",
            "promoCode": null,
            "read": 0,
            "rebateProcessed": 0,
            "referrerId": null,
            "resaleRate": null,
            "reviewStatus": null,
            "searchWeightId": null,
            "searchWeightTestId": null,
            "sessionId": null,
            "siteId": -1,
            "sitePhone": null,
            "sizeD": "20.00",
            "sizeH": null,
            "sizeW": "10.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-08-01 01:55:00",
            "totalPaid": null,
            "trafficSourceId": "__Direct",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "31797989",
                    "31797990",
                    "31797991"
                ]
            },
            "unitId": 31797989,
            "unitNumber": null,
            "userId": 6134728,
            "visitId": "e2028799711787ffc3dab0593c4d4bf3"
        }
    },
    "receivedAt": "2024-08-01T06:55:01.229Z",
    "sentAt": "2024-08-01T06:55:00.860Z",
    "timestamp": "2024-08-01T06:55:01.214Z",
    "type": "track",
    "userId": "e2028799711787ffc3dab0593c4d4bf3",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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",
    "original_key": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4319_facility_grid": "string",
    "properties.transaction.experiments.sf_4346_hide_mobile_map": "string",
    "properties.transaction.experiments.sf_4394_search_bar": "string",
    "properties.transaction.experiments.sf_4398_updated_res_conf": "string",
    "properties.transaction.experiments.sf_4603_paid_landing_page": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4641_stacked_ui_chevron": "string",
    "properties.transaction.experiments.sf_4642_lock_incentive": "string",
    "properties.transaction.experiments.sf_4651_stacked_ui_links": "string",
    "properties.transaction.experiments.sf_4787_facility_page": "string",
    "properties.transaction.experiments.sf_4788_search_filters": "string",
    "properties.transaction.experiments.sf_4792_remove_date_from_search": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5198_oon_facility_page": "string",
    "properties.transaction.experiments.sf_5288_informed_search": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_5695_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.incentivePitchedByAgent": "string",
    "properties.transaction.incentiveTypeId": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.pageType": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 289
schema_scan_id: 5897250
updated: 2024-08-01 02:44:48

Version 711629

created: 2024-06-21 10:09:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
    "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_gtmwebreservation`\n(\n`timestamp`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`_origin`STRING,`messageId`STRING,`integrations`struct<`_empty_`:STRING>,`context`struct<`ip`:STRING,`locale`:STRING,`timezone`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`library`:struct<`version`:STRING,`name`:STRING>,`campaign`:struct<`_empty_`:STRING>,`page`:struct<`search`:STRING,`url`:STRING,`path`:STRING,`title`:STRING,`referrer`:STRING>,`userAgent`:STRING>,`anonymousId`STRING,`originalTimestamp`STRING,`event`STRING,`channel`STRING,`type`STRING,`original_key`STRING,`sentAt`STRING,`userId`STRING,`receivedAt`STRING,`properties`struct<`Hit_Timestamp`:STRING,`isReact`:STRING,`site_id`:STRING,`booking`:struct<`confirmationCode`:STRING,`emailHash`:STRING,`npv`:STRING,`email`:STRING>,`transaction`:struct<`incentiveTypeId`:STRING,`sizeW`:STRING,`facilityTenant`:STRING,`hasContactlessMoveins`:STRING,`affiliateId`:STRING,`reviewStatus`:STRING,`email`:STRING,`movedIn`:STRING,`matchScore`:STRING,`bookingWidget`:STRING,`bidAmount`:STRING,`phoneChangedNumber`:STRING,`emailHash`:STRING,`callerIdPhone`:STRING,`phoneVerified`:STRING,`omiPri`:STRING,`centershiftAccountId`:STRING,`resaleRate`:STRING,`bookingType`:STRING,`pickupTime`:STRING,`phoneStatus`:STRING,`customerNotes`:STRING,`experiments`:struct<`sf_4137_sms_opt_in`:STRING,`sf_5288_informed_search`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_11349_sfdc_omi`:STRING,`hack_01_facility_page`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_4641_stacked_ui_chevron`:STRING,`sf_4603_paid_landing_page`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`red_716_tracking_prerender`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_5288_informed_search_2`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_7018_upsellit`:STRING,`sf_5289_facility_page_two`:STRING,`sf_4792_remove_date_from_search`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_4787_facility_page`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_5695_click_to_show_phone_number`:STRING,`sf_4398_updated_res_conf`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_6852_serp_results`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_4642_lock_incentive`:STRING,`sf_4651_stacked_ui_links`:STRING,`sf_4346_hide_mobile_map`:STRING,`sf_6327_visa_incentive`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_4394_search_bar`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_4788_search_filters`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_omi_mfe_embed`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_11616_homepage_updates`:STRING,`sf_6138_mid_field_text`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_4606_post_res_sms`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_5430_incentive_header`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_5198_oon_facility_page`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_4161_post_res_paid`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5129_call_me_back`:STRING,`sf_4319_facility_grid`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_5635_half_nomad`:STRING>,`price`:STRING,`hostedWebsite`:STRING,`moveInOriginal`:STRING,`phoneFacilityTransfer`:STRING,`promoCode`:STRING,`firstName`:STRING,`complete`:STRING,`monthlyInsurance`:STRING,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`apiCustId`:STRING,`referrerId`:STRING,`companyCode`:STRING,`phone`:STRING,`apiUnitId`:STRING,`duplicateOf`:STRING,`commission`:STRING,`baseBid`:STRING,`unitNumber`:STRING,`facilityTenantId`:STRING,`promo`:STRING,`moveIn`:STRING,`searchWeightId`:STRING,`totalPaid`:STRING,`omiCompleted`:STRING,`facilityGetsNotificationEmails`:STRING,`lastName`:STRING,`hotLead`:STRING,`alternateFirstNames`:array,`autoState`:STRING,`moveOut`:STRING,`facilityName`:STRING,`message`:STRING,`bookingAgentId`:STRING,`statementId`:STRING,`hasOnlineMoveIns`:STRING,`listingWantId`:STRING,`callCenterNotes`:STRING,`actualD`:STRING,`canceled`:STRING,`incentivePitchedByAgent`:STRING,`searchWeightTestId`:STRING,`depositPaid`:STRING,`termsVersion`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>,`physical`:struct<`length`:STRING,`height`:STRING,`width`:STRING>>,`amenities`:array,`id`:STRING,`promotion`:STRING,`unitType`:STRING,`price`:struct<`meta`:STRING>>,`modifiedDtm`:STRING,`AAAMemberNumber`:STRING,`bidType`:STRING,`eSignType`:STRING,`estimatedRevenue`:STRING,`alternateEmails`:array,`facilityPhone`:STRING,`facilitylocation`:struct<`city`:STRING,`country`:STRING,`zip`:STRING,`address2`:STRING,`state`:STRING,`address1`:STRING>,`bookingAgent`:STRING,`callCenter`:STRING,`rebateProcessed`:STRING,`userId`:STRING,`visitId`:STRING,`typeOfListing`:STRING,`omiFlowEnabled`:STRING,`npv`:STRING,`corrected`:STRING,`payoutBatchId`:STRING,`onlineMoveInUrl`:STRING,`timestamp`:STRING,`callCenterTransfer`:STRING,`moveInActual`:STRING,`pageType`:STRING,`bookingState`:STRING,`contacted`:STRING,`siteId`:STRING,`sitePhone`:STRING,`free`:STRING,`alternateLastNames`:array,`unitId`:STRING,`alternatePhones`:array,`facilityId`:STRING,`eVisitId`:STRING,`trafficSourceId`:STRING,`actualW`:STRING,`invoiceId`:STRING,`matchReasons`:STRING,`read`:STRING,`confirmationCode`:STRING,`unit`:struct<`unitIds`:array>,`disputeReason`:STRING,`sizeD`:STRING,`apiLeadId`:STRING,`sizeH`:STRING,`sessionId`:STRING>,`env`:STRING>,`version`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-stage/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation
id: 711629
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "FullStory",
            "Google Analytics",
            "Segment.io"
        ],
        "bundledIds": [
            "5e32e71155e30dd61b5fd962",
            "59c551d1c3469c0001a4e89a"
        ],
        "unbundled": []
    },
    "_origin": "2024-06-21T15:09:05Z|s3://sfdl-segment-reactfoot-stage/segment-logs/nQDzdrZI1K/1718928000000/1718982456445.events-archiver-480-8..3b61e347-7965-400b-9620-4f2d6152d06d.gz|analytics-segment-separator-stage:$LATEST",
    "anonymousId": "1ced5292-bd4a-4d0f-ab0f-edde4bed9411",
    "channel": "client",
    "context": {
        "campaign": {},
        "ip": "99.61.65.36",
        "library": {
            "name": "analytics.js",
            "version": "next-1.70.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage/Sparefoot-Engineering-Demo-20210322-204142.html",
            "referrer": "",
            "search": "?SELENIUM=true&tsid=ABC",
            "title": "Sparefoot Engineering Demo - 20210322 | B Street | SpareFoot",
            "url": "https://www.sparefoot.extrameter.com/Perryville-AK-self-storage/Sparefoot-Engineering-Demo-20210322-204142.html?SELENIUM=true&tsid=ABC"
        },
        "timezone": "America/Chicago",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Google Chrome",
                    "version": "125"
                },
                {
                    "brand": "Chromium",
                    "version": "125"
                },
                {
                    "brand": "Not.A/Brand",
                    "version": "24"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1718980518423-edb372aa-f047-4d6a-b2cd-73614c15a445",
    "originalTimestamp": "2024-06-21T14:35:18.423Z",
    "projectId": "nQDzdrZI1K",
    "properties": {
        "Hit Timestamp": 1718980518423,
        "booking": {
            "confirmationCode": "2FPQU92PH",
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "npv": "110.00"
        },
        "env": "stage",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 7760,
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "Storage.com",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": null,
            "apiLeadId": "",
            "apiUnitId": null,
            "autoState": null,
            "baseBid": "1.25",
            "bidAmount": "110.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "ADA Accessible",
                    "Air Cooled",
                    "Alarm",
                    "Drive Up Access",
                    "Electricity",
                    "Heated",
                    "Humidity Controlled",
                    "Light in Unit",
                    "Premium Location",
                    "Pull-Through",
                    "Roll Up Door",
                    "Shelves in Unit",
                    "Stacked Skybox/Mezzanine Unit",
                    "Underground Level"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "8.00",
                        "width": "8.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 21178453,
                "price": {
                    "meta": "66.00"
                },
                "promotion": "Only $1 for the first full month",
                "reservation_days": 60,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-06-21 9:34am] Booking 8' x 8' unit $66.00 (ADA Accessible, Air Cooled, Alarm, Drive Up Access, Electricity, Heated, Humidity Controlled, Light in Unit, Premium Location, Pull-Through, Roll Up Door, Shelves in Unit, Stacked Skybox/Mezzanine Unit, Underground Level) Promo: Only $1 for the first full month on website (Storage.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": null,
            "companyCode": "(DO NOT HIDE)",
            "complete": 1,
            "confirmationCode": "2FPQU92PH",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "estimatedRevenue": 22.66,
            "experiments": {
                "sf_11292_confirmation_page_hero": "variation",
                "sf_11349_sfdc_omi": "inactive",
                "sf_11464_neighbordotcom_cpc_ad": "inactive",
                "sf_11786_sfdc_omi_redesign": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "variation",
                "sf_12700_sfdc_paid_landing_refresh": "variation1",
                "sf_13230_distance_top_five_algo": "control",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 204142,
            "facilityName": "Sparefoot Engineering Demo - 20210322",
            "facilityPhone": 5555555555,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "B Street",
                "address2": "",
                "city": "Perryville",
                "country": "",
                "state": "AK",
                "zip": "99648"
            },
            "firstName": "test",
            "free": 0,
            "hasContactlessMoveins": false,
            "hasOnlineMoveIns": false,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "test",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-06-21 09:35:16",
            "monthlyInsurance": null,
            "moveIn": "2024-06-25",
            "moveInActual": null,
            "moveInOriginal": "2024-06-25",
            "moveOut": null,
            "movedIn": 0,
            "npv": "110.00",
            "omiCompleted": false,
            "omiFlowEnabled": false,
            "omiPri": null,
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "5555555555",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "66.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": 424,
            "sitePhone": null,
            "sizeD": "8.00",
            "sizeH": null,
            "sizeW": "8.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-06-21 09:35:16",
            "totalPaid": null,
            "trafficSourceId": "ABC",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "21178453"
                ]
            },
            "unitId": 21178453,
            "unitNumber": null,
            "userId": 1253,
            "visitId": null
        }
    },
    "receivedAt": "2024-06-21T14:35:18.767Z",
    "sentAt": "2024-06-21T14:35:18.437Z",
    "timestamp": "2024-06-21T14:35:18.753Z",
    "type": "track",
    "userId": "SELENIUM",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "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",
    "original_key": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4319_facility_grid": "string",
    "properties.transaction.experiments.sf_4346_hide_mobile_map": "string",
    "properties.transaction.experiments.sf_4394_search_bar": "string",
    "properties.transaction.experiments.sf_4398_updated_res_conf": "string",
    "properties.transaction.experiments.sf_4603_paid_landing_page": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4641_stacked_ui_chevron": "string",
    "properties.transaction.experiments.sf_4642_lock_incentive": "string",
    "properties.transaction.experiments.sf_4651_stacked_ui_links": "string",
    "properties.transaction.experiments.sf_4787_facility_page": "string",
    "properties.transaction.experiments.sf_4788_search_filters": "string",
    "properties.transaction.experiments.sf_4792_remove_date_from_search": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5198_oon_facility_page": "string",
    "properties.transaction.experiments.sf_5288_informed_search": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_5695_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.incentivePitchedByAgent": "string",
    "properties.transaction.incentiveTypeId": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.pageType": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

schema_name_id: 289
schema_scan_id: 5799891
updated: 2024-06-21 10:09:40

Schema Scans: 3

Last at 2024-08-22 16:24:19

Scan 5943876

duration: 0:00:50.388719

exit_message:

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

id: 5943876

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-08-22/",
        "name": "dt",
        "type": "string",
        "value": "2024-08-22"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-stage",
        "hive_path": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-08-22/1724361838336.events-archiver-480-47..885ecd9a-4ff1-4d87-8d5c-561a631a8bed.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 289
start_time: 2024-08-22 16:24:19
success: True
trace_id: 4788816570840349356

Scan 5897250

duration: 0:00:46.852066

exit_message:

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

id: 5897250

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-08-01/",
        "name": "dt",
        "type": "string",
        "value": "2024-08-01"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-stage",
        "hive_path": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-08-01/1722498223410.events-archiver-480-50..7ded2c0d-cab1-430e-8c2b-e5fa22210791.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 289
start_time: 2024-08-01 02:44:15
success: True
trace_id: 14205178762997027092

Scan 5799891

duration: 0:01:28.717512

exit_message:

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

id: 5799891

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-06-21/",
        "name": "dt",
        "type": "string",
        "value": "2024-06-21"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-stage",
        "hive_path": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-06-21/1718982456445.events-archiver-480-8..3b61e347-7965-400b-9620-4f2d6152d06d.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 289
start_time: 2024-06-21 10:09:07
success: True
trace_id: 17441832285389427765

Partitions:

count: 3

ddl:

[
    "ALTER TABLE\n    `sfdl_stage_segment.reactfoot_gtmwebreservation`\nADD\n\n\n PARTITION (dt='2024-09-09') location 's3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-09/'\n PARTITION (dt='2024-09-10') location 's3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-10/'\n PARTITION (dt='2024-09-16') location 's3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-16/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 562659,
            "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-09/",
            "name": "dt",
            "value": "2024-09-09"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-09-09 11:20:30",
                "last_data": "2024-09-09 11:20:30"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 562701,
            "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-10/",
            "name": "dt",
            "value": "2024-09-10"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-09-10 01:04:54",
                "last_data": "2024-09-10 17:36:38"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 564878,
            "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-16/",
            "name": "dt",
            "value": "2024-09-16"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2024-09-16 05:30:11",
                "last_data": "2024-09-16 05:30:11"
            },
            "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.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",
    "original_key": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.booking.confirmationCode": "string",
    "properties.booking.email": "string",
    "properties.booking.emailHash": "string",
    "properties.booking.npv": "string",
    "properties.env": "string",
    "properties.isReact": "string",
    "properties.site_id": "string",
    "properties.transaction.AAAMemberNumber": "string",
    "properties.transaction.account.accountId": "string",
    "properties.transaction.account.hasOnlineMoveIns": "string",
    "properties.transaction.actualD": "string",
    "properties.transaction.actualW": "string",
    "properties.transaction.affiliateId": "string",
    "properties.transaction.alternateEmails": [
        "string"
    ],
    "properties.transaction.alternateFirstNames": [
        "string"
    ],
    "properties.transaction.alternateLastNames": [
        "string"
    ],
    "properties.transaction.alternatePhones": [
        "string"
    ],
    "properties.transaction.apiCustId": "string",
    "properties.transaction.apiLeadId": "string",
    "properties.transaction.apiUnitId": "string",
    "properties.transaction.autoState": "string",
    "properties.transaction.baseBid": "string",
    "properties.transaction.bidAmount": "string",
    "properties.transaction.bidType": "string",
    "properties.transaction.bookedUnit.amenities": [
        "string"
    ],
    "properties.transaction.bookedUnit.description.physical.height": "string",
    "properties.transaction.bookedUnit.description.physical.length": "string",
    "properties.transaction.bookedUnit.description.physical.width": "string",
    "properties.transaction.bookedUnit.description.vehicle.only": "string",
    "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
    "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
    "properties.transaction.bookedUnit.id": "string",
    "properties.transaction.bookedUnit.price.meta": "string",
    "properties.transaction.bookedUnit.promotion": "string",
    "properties.transaction.bookedUnit.reservation_days": "string",
    "properties.transaction.bookedUnit.unitType": "string",
    "properties.transaction.bookingAgent": "string",
    "properties.transaction.bookingAgentId": "string",
    "properties.transaction.bookingState": "string",
    "properties.transaction.bookingType": "string",
    "properties.transaction.bookingWidget": "string",
    "properties.transaction.callCenter": "string",
    "properties.transaction.callCenterNotes": "string",
    "properties.transaction.callCenterTransfer": "string",
    "properties.transaction.callerIdPhone": "string",
    "properties.transaction.canceled": "string",
    "properties.transaction.centershiftAccountId": "string",
    "properties.transaction.commission": "string",
    "properties.transaction.companyCode": "string",
    "properties.transaction.complete": "string",
    "properties.transaction.confirmationCode": "string",
    "properties.transaction.contacted": "string",
    "properties.transaction.corrected": "string",
    "properties.transaction.customerNotes": "string",
    "properties.transaction.depositPaid": "string",
    "properties.transaction.disputeReason": "string",
    "properties.transaction.duplicateOf": "string",
    "properties.transaction.eSignType": "string",
    "properties.transaction.eVisitId": "string",
    "properties.transaction.email": "string",
    "properties.transaction.emailHash": "string",
    "properties.transaction.estimatedRevenue": "string",
    "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
    "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
    "properties.transaction.experiments.hack_01_facility_page": "string",
    "properties.transaction.experiments.red_716_tracking_prerender": "string",
    "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
    "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
    "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
    "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
    "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
    "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
    "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
    "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
    "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
    "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
    "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
    "properties.transaction.experiments.sf_11616_homepage_updates": "string",
    "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
    "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
    "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
    "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
    "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
    "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
    "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
    "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
    "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4319_facility_grid": "string",
    "properties.transaction.experiments.sf_4346_hide_mobile_map": "string",
    "properties.transaction.experiments.sf_4394_search_bar": "string",
    "properties.transaction.experiments.sf_4398_updated_res_conf": "string",
    "properties.transaction.experiments.sf_4603_paid_landing_page": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "string",
    "properties.transaction.experiments.sf_4641_stacked_ui_chevron": "string",
    "properties.transaction.experiments.sf_4642_lock_incentive": "string",
    "properties.transaction.experiments.sf_4651_stacked_ui_links": "string",
    "properties.transaction.experiments.sf_4787_facility_page": "string",
    "properties.transaction.experiments.sf_4788_search_filters": "string",
    "properties.transaction.experiments.sf_4792_remove_date_from_search": "string",
    "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
    "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
    "properties.transaction.experiments.sf_5129_call_me_back": "string",
    "properties.transaction.experiments.sf_5198_oon_facility_page": "string",
    "properties.transaction.experiments.sf_5288_informed_search": "string",
    "properties.transaction.experiments.sf_5288_informed_search_2": "string",
    "properties.transaction.experiments.sf_5289_facility_page_two": "string",
    "properties.transaction.experiments.sf_5430_incentive_header": "string",
    "properties.transaction.experiments.sf_5635_half_nomad": "string",
    "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_5695_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
    "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
    "properties.transaction.experiments.sf_6138_mid_field_text": "string",
    "properties.transaction.experiments.sf_6327_visa_incentive": "string",
    "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
    "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
    "properties.transaction.experiments.sf_6852_serp_results": "string",
    "properties.transaction.experiments.sf_7018_upsellit": "string",
    "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
    "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
    "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
    "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
    "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
    "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
    "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
    "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
    "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
    "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
    "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
    "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
    "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
    "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
    "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
    "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
    "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
    "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
    "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
    "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
    "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
    "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
    "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
    "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
    "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
    "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
    "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
    "properties.transaction.experiments.sf_omi_mfe_embed": "string",
    "properties.transaction.facilityGetsNotificationEmails": "string",
    "properties.transaction.facilityId": "string",
    "properties.transaction.facilityName": "string",
    "properties.transaction.facilityPhone": "string",
    "properties.transaction.facilityTenant": "string",
    "properties.transaction.facilityTenantId": "string",
    "properties.transaction.facilitylocation.address1": "string",
    "properties.transaction.facilitylocation.address2": "string",
    "properties.transaction.facilitylocation.city": "string",
    "properties.transaction.facilitylocation.country": "string",
    "properties.transaction.facilitylocation.state": "string",
    "properties.transaction.facilitylocation.zip": "string",
    "properties.transaction.firstName": "string",
    "properties.transaction.free": "string",
    "properties.transaction.hasContactlessMoveins": "string",
    "properties.transaction.hasOnlineMoveIns": "string",
    "properties.transaction.hostedWebsite": "string",
    "properties.transaction.hotLead": "string",
    "properties.transaction.incentivePitchedByAgent": "string",
    "properties.transaction.incentiveTypeId": "string",
    "properties.transaction.invoiceId": "string",
    "properties.transaction.lastName": "string",
    "properties.transaction.listingWantId": "string",
    "properties.transaction.matchReasons": "string",
    "properties.transaction.matchScore": "string",
    "properties.transaction.message": "string",
    "properties.transaction.modifiedDtm": "string",
    "properties.transaction.monthlyInsurance": "string",
    "properties.transaction.moveIn": "string",
    "properties.transaction.moveInActual": "string",
    "properties.transaction.moveInOriginal": "string",
    "properties.transaction.moveOut": "string",
    "properties.transaction.movedIn": "string",
    "properties.transaction.npv": "string",
    "properties.transaction.omiAttributes.facility": "string",
    "properties.transaction.omiAttributes.organization": "string",
    "properties.transaction.omiAttributes.provider": "string",
    "properties.transaction.omiAttributes.reservation": "string",
    "properties.transaction.omiAttributes.unit": "string",
    "properties.transaction.omiCompleted": "string",
    "properties.transaction.omiFlowEnabled": "string",
    "properties.transaction.omiPri": "string",
    "properties.transaction.onlineMoveInUrl": "string",
    "properties.transaction.pageType": "string",
    "properties.transaction.payoutBatchId": "string",
    "properties.transaction.phone": "string",
    "properties.transaction.phoneChangedNumber": "string",
    "properties.transaction.phoneFacilityTransfer": "string",
    "properties.transaction.phoneStatus": "string",
    "properties.transaction.phoneVerified": "string",
    "properties.transaction.pickupTime": "string",
    "properties.transaction.price": "string",
    "properties.transaction.promo": "string",
    "properties.transaction.promoCode": "string",
    "properties.transaction.read": "string",
    "properties.transaction.rebateProcessed": "string",
    "properties.transaction.referrerId": "string",
    "properties.transaction.resaleRate": "string",
    "properties.transaction.reviewStatus": "string",
    "properties.transaction.searchWeightId": "string",
    "properties.transaction.searchWeightTestId": "string",
    "properties.transaction.sessionId": "string",
    "properties.transaction.siteId": "string",
    "properties.transaction.sitePhone": "string",
    "properties.transaction.sizeD": "string",
    "properties.transaction.sizeH": "string",
    "properties.transaction.sizeW": "string",
    "properties.transaction.statementId": "string",
    "properties.transaction.termsVersion": "string",
    "properties.transaction.timestamp": "string",
    "properties.transaction.totalPaid": "string",
    "properties.transaction.trafficSourceId": "string",
    "properties.transaction.typeOfListing": "string",
    "properties.transaction.unit.unitIds": [
        "string"
    ],
    "properties.transaction.unitId": "string",
    "properties.transaction.unitNumber": "string",
    "properties.transaction.userId": "string",
    "properties.transaction.visitId": "string",
    "receivedAt": "string",
    "sentAt": "string",
    "timestamp": "string",
    "type": "string",
    "userId": "string",
    "version": "string"
}

created: 2024-08-22 16:24:25

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`channel`STRING,`projectId`STRING,`sentAt`STRING,`userId`STRING,`version`STRING,`original_key`STRING,`receivedAt`STRING,`messageId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`anonymousId`STRING,`originalTimestamp`STRING,`_origin`STRING,`context`struct<`timezone`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`campaign`:struct<`_empty_`:STRING>>,`type`STRING,`properties`struct<`booking`:struct<`email`:STRING,`npv`:STRING,`emailHash`:STRING,`confirmationCode`:STRING>,`site_id`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`isReact`:STRING,`transaction`:struct<`email`:STRING,`companyCode`:STRING,`customerNotes`:STRING,`confirmationCode`:STRING,`centershiftAccountId`:STRING,`callCenter`:STRING,`unitNumber`:STRING,`baseBid`:STRING,`AAAMemberNumber`:STRING,`disputeReason`:STRING,`incentivePitchedByAgent`:STRING,`listingWantId`:STRING,`moveIn`:STRING,`userId`:STRING,`payoutBatchId`:STRING,`sitePhone`:STRING,`pageType`:STRING,`firstName`:STRING,`phoneChangedNumber`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`apiUnitId`:STRING,`promo`:STRING,`statementId`:STRING,`experiments`:struct<`sf_9464_sfdc_persist_top_yielders`:STRING,`red_716_tracking_prerender`:STRING,`sf_4394_search_bar`:STRING,`sf_4603_paid_landing_page`:STRING,`sf_4651_stacked_ui_links`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_6138_mid_field_text`:STRING,`sf_4161_post_res_paid`:STRING,`sf_4641_stacked_ui_chevron`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_4346_hide_mobile_map`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_11616_homepage_updates`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_5288_informed_search`:STRING,`sf_4642_lock_incentive`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_6852_serp_results`:STRING,`sf_5289_facility_page_two`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_omi_mfe_embed`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_4788_search_filters`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_5430_incentive_header`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_13380_sfdc_new_filter`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_7018_upsellit`:STRING,`sf_4319_facility_grid`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_4606_post_res_sms`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_5695_click_to_show_phone_number`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`hack_01_facility_page`:STRING,`sf_4792_remove_date_from_search`:STRING,`sf_4398_updated_res_conf`:STRING,`sf_4787_facility_page`:STRING,`sf_6327_visa_incentive`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_5635_half_nomad`:STRING,`sf_5069_alt_contact_info`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_5288_informed_search_2`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_5198_oon_facility_page`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_5129_call_me_back`:STRING>,`autoState`:STRING,`contacted`:STRING,`read`:STRING,`alternateFirstNames`:array,`emailHash`:STRING,`facilityTenant`:STRING,`bookingState`:STRING,`matchScore`:STRING,`timestamp`:STRING,`phoneFacilityTransfer`:STRING,`corrected`:STRING,`facilityGetsNotificationEmails`:STRING,`moveInActual`:STRING,`affiliateId`:STRING,`complete`:STRING,`npv`:STRING,`invoiceId`:STRING,`duplicateOf`:STRING,`actualD`:STRING,`hasContactlessMoveins`:STRING,`facilityId`:STRING,`alternatePhones`:array,`matchReasons`:STRING,`phoneStatus`:STRING,`referrerId`:STRING,`resaleRate`:STRING,`message`:STRING,`canceled`:STRING,`moveOut`:STRING,`promoCode`:STRING,`siteId`:STRING,`apiLeadId`:STRING,`depositPaid`:STRING,`movedIn`:STRING,`bookingType`:STRING,`reviewStatus`:STRING,`sizeH`:STRING,`omiCompleted`:STRING,`termsVersion`:STRING,`typeOfListing`:STRING,`incentiveTypeId`:STRING,`hotLead`:STRING,`callCenterNotes`:STRING,`modifiedDtm`:STRING,`phoneVerified`:STRING,`sizeW`:STRING,`facilityName`:STRING,`alternateEmails`:array,`rebateProcessed`:STRING,`lastName`:STRING,`unit`:struct<`unitIds`:array>,`omiPri`:STRING,`pickupTime`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`hasOnlineMoveIns`:STRING,`bookingAgentId`:STRING,`sessionId`:STRING,`trafficSourceId`:STRING,`sizeD`:STRING,`facilitylocation`:struct<`zip`:STRING,`country`:STRING,`state`:STRING,`address1`:STRING,`city`:STRING,`address2`:STRING>,`facilityTenantId`:STRING,`commission`:STRING,`free`:STRING,`totalPaid`:STRING,`eSignType`:STRING,`monthlyInsurance`:STRING,`bidAmount`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`unitId`:STRING,`bidType`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`alternateLastNames`:array,`bookingAgent`:STRING,`facilityPhone`:STRING,`bookingWidget`:STRING,`eVisitId`:STRING,`apiCustId`:STRING,`omiFlowEnabled`:STRING,`price`:STRING,`moveInOriginal`:STRING,`onlineMoveInUrl`:STRING,`actualW`:STRING,`bookedUnit`:struct<`unitType`:STRING,`amenities`:array,`id`:STRING,`price`:struct<`meta`:STRING>,`reservation_days`:STRING,`promotion`:STRING,`description`:struct<`physical`:struct<`height`:STRING,`width`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>>>,`estimatedRevenue`:STRING,`searchWeightId`:STRING,`phone`:STRING,`visitId`:STRING>>,`event`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-stage/separated_dt/gtmWebReservation'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_gtmwebreservation`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_gtmwebreservation"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2017-11-01 20:58:18",
        "disabled": false,
        "format": "raw",
        "id": 289,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_segment",
            "table": "reactfoot_gtmwebreservation"
        },
        "type": "segment"
    },
    "partition": {
        "count": 3,
        "ddl": [
            "ALTER TABLE\n    `sfdl_stage_segment.reactfoot_gtmwebreservation`\nADD\n\n\n PARTITION (dt='2024-09-09') location 's3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-09/'\n PARTITION (dt='2024-09-10') location 's3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-10/'\n PARTITION (dt='2024-09-16') location 's3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-16/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 562659,
                    "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-09/",
                    "name": "dt",
                    "value": "2024-09-09"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-09-09 11:20:30",
                        "last_data": "2024-09-09 11:20:30"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 562701,
                    "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-10/",
                    "name": "dt",
                    "value": "2024-09-10"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-09-10 01:04:54",
                        "last_data": "2024-09-10 17:36:38"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 564878,
                    "location": "s3://sfdl-segment-reactfoot-stage/separated_dt/gtmWebReservation/dt=2024-09-16/",
                    "name": "dt",
                    "value": "2024-09-16"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2024-09-16 05:30:11",
                        "last_data": "2024-09-16 05:30:11"
                    },
                    "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.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",
            "original_key": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.booking.confirmationCode": "string",
            "properties.booking.email": "string",
            "properties.booking.emailHash": "string",
            "properties.booking.npv": "string",
            "properties.env": "string",
            "properties.isReact": "string",
            "properties.site_id": "string",
            "properties.transaction.AAAMemberNumber": "string",
            "properties.transaction.account.accountId": "string",
            "properties.transaction.account.hasOnlineMoveIns": "string",
            "properties.transaction.actualD": "string",
            "properties.transaction.actualW": "string",
            "properties.transaction.affiliateId": "string",
            "properties.transaction.alternateEmails": [
                "string"
            ],
            "properties.transaction.alternateFirstNames": [
                "string"
            ],
            "properties.transaction.alternateLastNames": [
                "string"
            ],
            "properties.transaction.alternatePhones": [
                "string"
            ],
            "properties.transaction.apiCustId": "string",
            "properties.transaction.apiLeadId": "string",
            "properties.transaction.apiUnitId": "string",
            "properties.transaction.autoState": "string",
            "properties.transaction.baseBid": "string",
            "properties.transaction.bidAmount": "string",
            "properties.transaction.bidType": "string",
            "properties.transaction.bookedUnit.amenities": [
                "string"
            ],
            "properties.transaction.bookedUnit.description.physical.height": "string",
            "properties.transaction.bookedUnit.description.physical.length": "string",
            "properties.transaction.bookedUnit.description.physical.width": "string",
            "properties.transaction.bookedUnit.description.vehicle.only": "string",
            "properties.transaction.bookedUnit.description.vehicle.permitted": "string",
            "properties.transaction.bookedUnit.description.vehicle.warehouse": "string",
            "properties.transaction.bookedUnit.id": "string",
            "properties.transaction.bookedUnit.price.meta": "string",
            "properties.transaction.bookedUnit.promotion": "string",
            "properties.transaction.bookedUnit.reservation_days": "string",
            "properties.transaction.bookedUnit.unitType": "string",
            "properties.transaction.bookingAgent": "string",
            "properties.transaction.bookingAgentId": "string",
            "properties.transaction.bookingState": "string",
            "properties.transaction.bookingType": "string",
            "properties.transaction.bookingWidget": "string",
            "properties.transaction.callCenter": "string",
            "properties.transaction.callCenterNotes": "string",
            "properties.transaction.callCenterTransfer": "string",
            "properties.transaction.callerIdPhone": "string",
            "properties.transaction.canceled": "string",
            "properties.transaction.centershiftAccountId": "string",
            "properties.transaction.commission": "string",
            "properties.transaction.companyCode": "string",
            "properties.transaction.complete": "string",
            "properties.transaction.confirmationCode": "string",
            "properties.transaction.contacted": "string",
            "properties.transaction.corrected": "string",
            "properties.transaction.customerNotes": "string",
            "properties.transaction.depositPaid": "string",
            "properties.transaction.disputeReason": "string",
            "properties.transaction.duplicateOf": "string",
            "properties.transaction.eSignType": "string",
            "properties.transaction.eVisitId": "string",
            "properties.transaction.email": "string",
            "properties.transaction.emailHash": "string",
            "properties.transaction.estimatedRevenue": "string",
            "properties.transaction.experiments.c19_1_sfdc_contactless_movein_badging": "string",
            "properties.transaction.experiments.c19_46_sfdc_confirmation_page_online_moveins": "string",
            "properties.transaction.experiments.hack_01_facility_page": "string",
            "properties.transaction.experiments.red_716_tracking_prerender": "string",
            "properties.transaction.experiments.sf_10104_sfdc_confirmation_cta": "string",
            "properties.transaction.experiments.sf_10181_sfdc_erental_badging": "string",
            "properties.transaction.experiments.sf_10286_sfdc_cronut_algo": "string",
            "properties.transaction.experiments.sf_10518_sfdc_geo_specific_unit_blends": "string",
            "properties.transaction.experiments.sf_10757_sfdc_chatbot": "string",
            "properties.transaction.experiments.sf_10841_sfdc_platform_x_integration": "string",
            "properties.transaction.experiments.sf_10867_sfdc_smaller_informed_search": "string",
            "properties.transaction.experiments.sf_11267_sticky_search_clp_hero": "string",
            "properties.transaction.experiments.sf_11292_confirmation_page_hero": "string",
            "properties.transaction.experiments.sf_11349_sfdc_omi": "string",
            "properties.transaction.experiments.sf_11464_neighbordotcom_cpc_ad": "string",
            "properties.transaction.experiments.sf_11616_homepage_updates": "string",
            "properties.transaction.experiments.sf_11786_sfdc_omi_redesign": "string",
            "properties.transaction.experiments.sf_11825_sfdc_new_datepicker": "string",
            "properties.transaction.experiments.sf_12289_sfdc_holiday_messaging": "string",
            "properties.transaction.experiments.sf_12496_sfdc_clp_unitcardrefresh": "string",
            "properties.transaction.experiments.sf_12510_hidden_facilities": "string",
            "properties.transaction.experiments.sf_12700_sfdc_paid_landing_refresh": "string",
            "properties.transaction.experiments.sf_13230_distance_top_five_algo": "string",
            "properties.transaction.experiments.sf_13380_sfdc_new_filter": "string",
            "properties.transaction.experiments.sf_4137_sms_opt_in": "string",
            "properties.transaction.experiments.sf_4161_post_res_paid": "string",
            "properties.transaction.experiments.sf_4319_facility_grid": "string",
            "properties.transaction.experiments.sf_4346_hide_mobile_map": "string",
            "properties.transaction.experiments.sf_4394_search_bar": "string",
            "properties.transaction.experiments.sf_4398_updated_res_conf": "string",
            "properties.transaction.experiments.sf_4603_paid_landing_page": "string",
            "properties.transaction.experiments.sf_4606_post_res_sms": "string",
            "properties.transaction.experiments.sf_4641_stacked_ui_chevron": "string",
            "properties.transaction.experiments.sf_4642_lock_incentive": "string",
            "properties.transaction.experiments.sf_4651_stacked_ui_links": "string",
            "properties.transaction.experiments.sf_4787_facility_page": "string",
            "properties.transaction.experiments.sf_4788_search_filters": "string",
            "properties.transaction.experiments.sf_4792_remove_date_from_search": "string",
            "properties.transaction.experiments.sf_4830_aa_phlag_band_aid": "string",
            "properties.transaction.experiments.sf_5069_alt_contact_info": "string",
            "properties.transaction.experiments.sf_5129_call_me_back": "string",
            "properties.transaction.experiments.sf_5198_oon_facility_page": "string",
            "properties.transaction.experiments.sf_5288_informed_search": "string",
            "properties.transaction.experiments.sf_5288_informed_search_2": "string",
            "properties.transaction.experiments.sf_5289_facility_page_two": "string",
            "properties.transaction.experiments.sf_5430_incentive_header": "string",
            "properties.transaction.experiments.sf_5635_half_nomad": "string",
            "properties.transaction.experiments.sf_5694_click_to_show_phone_number": "string",
            "properties.transaction.experiments.sf_5695_click_to_show_phone_number": "string",
            "properties.transaction.experiments.sf_6038_pheature_last_explicit": "string",
            "properties.transaction.experiments.sf_6128_click_to_show_phone_number": "string",
            "properties.transaction.experiments.sf_6138_mid_field_text": "string",
            "properties.transaction.experiments.sf_6327_visa_incentive": "string",
            "properties.transaction.experiments.sf_6684_hurricane_relief": "string",
            "properties.transaction.experiments.sf_6804_two_step_checkout": "string",
            "properties.transaction.experiments.sf_6852_serp_results": "string",
            "properties.transaction.experiments.sf_7018_upsellit": "string",
            "properties.transaction.experiments.sf_7046_recommended_facility_badge": "string",
            "properties.transaction.experiments.sf_7058_two_step_checkout_v2": "string",
            "properties.transaction.experiments.sf_7155_two_step_checkout_v3": "string",
            "properties.transaction.experiments.sf_7249_guided_unit_selection": "string",
            "properties.transaction.experiments.sf_7371_nvf_100_donuts": "string",
            "properties.transaction.experiments.sf_7485_scarcity_treatment": "string",
            "properties.transaction.experiments.sf_7490_sfdc_cta_color_change": "string",
            "properties.transaction.experiments.sf_7514_sfdc_time_boxed_reservation_process": "string",
            "properties.transaction.experiments.sf_7537_sfdc_tabbed_facility_page": "string",
            "properties.transaction.experiments.sf_7885_sfdc_unit_size_guide_v2": "string",
            "properties.transaction.experiments.sf_8326_sfdc_time_boxed_reservation_process_v2": "string",
            "properties.transaction.experiments.sf_8336_sfdc_tabbed_facility_page_v2": "string",
            "properties.transaction.experiments.sf_8535_sfdc_unit_comparison_v1": "string",
            "properties.transaction.experiments.sf_8575_sfdc_price_context_while_shopping": "string",
            "properties.transaction.experiments.sf_8641_sfdc_reserve_for_free_banner": "string",
            "properties.transaction.experiments.sf_8708_sfdc_price_transparency_false_door": "string",
            "properties.transaction.experiments.sf_8714_sfdc_form_field_positive_reinforcement": "string",
            "properties.transaction.experiments.sf_8718_sfdc_reserve_for_free_cta": "string",
            "properties.transaction.experiments.sf_9189_sfdc_collapsable_info_on_cards": "string",
            "properties.transaction.experiments.sf_9384_sfdc_car_storage_psp": "string",
            "properties.transaction.experiments.sf_9431_sfdc_vip_large_card": "string",
            "properties.transaction.experiments.sf_9463_sfdc_tpp_badging": "string",
            "properties.transaction.experiments.sf_9464_sfdc_persist_top_yielders": "string",
            "properties.transaction.experiments.sf_9484_sfdc_add_deals_link_to_header": "string",
            "properties.transaction.experiments.sf_9561_sfdc_covid_confirmation_page_alert": "string",
            "properties.transaction.experiments.sf_9564_sfdc_covid_dont_call_notification": "string",
            "properties.transaction.experiments.sf_9827_sfdc_cta_text_change": "string",
            "properties.transaction.experiments.sf_omi_mfe_embed": "string",
            "properties.transaction.facilityGetsNotificationEmails": "string",
            "properties.transaction.facilityId": "string",
            "properties.transaction.facilityName": "string",
            "properties.transaction.facilityPhone": "string",
            "properties.transaction.facilityTenant": "string",
            "properties.transaction.facilityTenantId": "string",
            "properties.transaction.facilitylocation.address1": "string",
            "properties.transaction.facilitylocation.address2": "string",
            "properties.transaction.facilitylocation.city": "string",
            "properties.transaction.facilitylocation.country": "string",
            "properties.transaction.facilitylocation.state": "string",
            "properties.transaction.facilitylocation.zip": "string",
            "properties.transaction.firstName": "string",
            "properties.transaction.free": "string",
            "properties.transaction.hasContactlessMoveins": "string",
            "properties.transaction.hasOnlineMoveIns": "string",
            "properties.transaction.hostedWebsite": "string",
            "properties.transaction.hotLead": "string",
            "properties.transaction.incentivePitchedByAgent": "string",
            "properties.transaction.incentiveTypeId": "string",
            "properties.transaction.invoiceId": "string",
            "properties.transaction.lastName": "string",
            "properties.transaction.listingWantId": "string",
            "properties.transaction.matchReasons": "string",
            "properties.transaction.matchScore": "string",
            "properties.transaction.message": "string",
            "properties.transaction.modifiedDtm": "string",
            "properties.transaction.monthlyInsurance": "string",
            "properties.transaction.moveIn": "string",
            "properties.transaction.moveInActual": "string",
            "properties.transaction.moveInOriginal": "string",
            "properties.transaction.moveOut": "string",
            "properties.transaction.movedIn": "string",
            "properties.transaction.npv": "string",
            "properties.transaction.omiAttributes.facility": "string",
            "properties.transaction.omiAttributes.organization": "string",
            "properties.transaction.omiAttributes.provider": "string",
            "properties.transaction.omiAttributes.reservation": "string",
            "properties.transaction.omiAttributes.unit": "string",
            "properties.transaction.omiCompleted": "string",
            "properties.transaction.omiFlowEnabled": "string",
            "properties.transaction.omiPri": "string",
            "properties.transaction.onlineMoveInUrl": "string",
            "properties.transaction.pageType": "string",
            "properties.transaction.payoutBatchId": "string",
            "properties.transaction.phone": "string",
            "properties.transaction.phoneChangedNumber": "string",
            "properties.transaction.phoneFacilityTransfer": "string",
            "properties.transaction.phoneStatus": "string",
            "properties.transaction.phoneVerified": "string",
            "properties.transaction.pickupTime": "string",
            "properties.transaction.price": "string",
            "properties.transaction.promo": "string",
            "properties.transaction.promoCode": "string",
            "properties.transaction.read": "string",
            "properties.transaction.rebateProcessed": "string",
            "properties.transaction.referrerId": "string",
            "properties.transaction.resaleRate": "string",
            "properties.transaction.reviewStatus": "string",
            "properties.transaction.searchWeightId": "string",
            "properties.transaction.searchWeightTestId": "string",
            "properties.transaction.sessionId": "string",
            "properties.transaction.siteId": "string",
            "properties.transaction.sitePhone": "string",
            "properties.transaction.sizeD": "string",
            "properties.transaction.sizeH": "string",
            "properties.transaction.sizeW": "string",
            "properties.transaction.statementId": "string",
            "properties.transaction.termsVersion": "string",
            "properties.transaction.timestamp": "string",
            "properties.transaction.totalPaid": "string",
            "properties.transaction.trafficSourceId": "string",
            "properties.transaction.typeOfListing": "string",
            "properties.transaction.unit.unitIds": [
                "string"
            ],
            "properties.transaction.unitId": "string",
            "properties.transaction.unitNumber": "string",
            "properties.transaction.userId": "string",
            "properties.transaction.visitId": "string",
            "receivedAt": "string",
            "sentAt": "string",
            "timestamp": "string",
            "type": "string",
            "userId": "string",
            "version": "string"
        },
        "created": "2024-08-22 16:24:25",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_segment.reactfoot_gtmwebreservation`\n(\n`integrations`struct<`_empty_`:STRING>,`timestamp`STRING,`channel`STRING,`projectId`STRING,`sentAt`STRING,`userId`STRING,`version`STRING,`original_key`STRING,`receivedAt`STRING,`messageId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`anonymousId`STRING,`originalTimestamp`STRING,`_origin`STRING,`context`struct<`timezone`:STRING,`userAgent`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`locale`:STRING,`userAgentData`:struct<`brands`:array>,`mobile`:STRING,`platform`:STRING>,`campaign`:struct<`_empty_`:STRING>>,`type`STRING,`properties`struct<`booking`:struct<`email`:STRING,`npv`:STRING,`emailHash`:STRING,`confirmationCode`:STRING>,`site_id`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`isReact`:STRING,`transaction`:struct<`email`:STRING,`companyCode`:STRING,`customerNotes`:STRING,`confirmationCode`:STRING,`centershiftAccountId`:STRING,`callCenter`:STRING,`unitNumber`:STRING,`baseBid`:STRING,`AAAMemberNumber`:STRING,`disputeReason`:STRING,`incentivePitchedByAgent`:STRING,`listingWantId`:STRING,`moveIn`:STRING,`userId`:STRING,`payoutBatchId`:STRING,`sitePhone`:STRING,`pageType`:STRING,`firstName`:STRING,`phoneChangedNumber`:STRING,`hostedWebsite`:STRING,`searchWeightTestId`:STRING,`apiUnitId`:STRING,`promo`:STRING,`statementId`:STRING,`experiments`:struct<`sf_9464_sfdc_persist_top_yielders`:STRING,`red_716_tracking_prerender`:STRING,`sf_4394_search_bar`:STRING,`sf_4603_paid_landing_page`:STRING,`sf_4651_stacked_ui_links`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_6138_mid_field_text`:STRING,`sf_4161_post_res_paid`:STRING,`sf_4641_stacked_ui_chevron`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_4346_hide_mobile_map`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_11616_homepage_updates`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_6128_click_to_show_phone_number`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`sf_5288_informed_search`:STRING,`sf_4642_lock_incentive`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_6852_serp_results`:STRING,`sf_5289_facility_page_two`:STRING,`sf_4137_sms_opt_in`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_6038_pheature_last_explicit`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_omi_mfe_embed`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`sf_4788_search_filters`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_5430_incentive_header`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_13380_sfdc_new_filter`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_7018_upsellit`:STRING,`sf_4319_facility_grid`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_4606_post_res_sms`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_5695_click_to_show_phone_number`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`hack_01_facility_page`:STRING,`sf_4792_remove_date_from_search`:STRING,`sf_4398_updated_res_conf`:STRING,`sf_4787_facility_page`:STRING,`sf_6327_visa_incentive`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`sf_5635_half_nomad`:STRING,`sf_5069_alt_contact_info`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_5288_informed_search_2`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_5198_oon_facility_page`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_5694_click_to_show_phone_number`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_5129_call_me_back`:STRING>,`autoState`:STRING,`contacted`:STRING,`read`:STRING,`alternateFirstNames`:array,`emailHash`:STRING,`facilityTenant`:STRING,`bookingState`:STRING,`matchScore`:STRING,`timestamp`:STRING,`phoneFacilityTransfer`:STRING,`corrected`:STRING,`facilityGetsNotificationEmails`:STRING,`moveInActual`:STRING,`affiliateId`:STRING,`complete`:STRING,`npv`:STRING,`invoiceId`:STRING,`duplicateOf`:STRING,`actualD`:STRING,`hasContactlessMoveins`:STRING,`facilityId`:STRING,`alternatePhones`:array,`matchReasons`:STRING,`phoneStatus`:STRING,`referrerId`:STRING,`resaleRate`:STRING,`message`:STRING,`canceled`:STRING,`moveOut`:STRING,`promoCode`:STRING,`siteId`:STRING,`apiLeadId`:STRING,`depositPaid`:STRING,`movedIn`:STRING,`bookingType`:STRING,`reviewStatus`:STRING,`sizeH`:STRING,`omiCompleted`:STRING,`termsVersion`:STRING,`typeOfListing`:STRING,`incentiveTypeId`:STRING,`hotLead`:STRING,`callCenterNotes`:STRING,`modifiedDtm`:STRING,`phoneVerified`:STRING,`sizeW`:STRING,`facilityName`:STRING,`alternateEmails`:array,`rebateProcessed`:STRING,`lastName`:STRING,`unit`:struct<`unitIds`:array>,`omiPri`:STRING,`pickupTime`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`hasOnlineMoveIns`:STRING,`bookingAgentId`:STRING,`sessionId`:STRING,`trafficSourceId`:STRING,`sizeD`:STRING,`facilitylocation`:struct<`zip`:STRING,`country`:STRING,`state`:STRING,`address1`:STRING,`city`:STRING,`address2`:STRING>,`facilityTenantId`:STRING,`commission`:STRING,`free`:STRING,`totalPaid`:STRING,`eSignType`:STRING,`monthlyInsurance`:STRING,`bidAmount`:STRING,`callerIdPhone`:STRING,`callCenterTransfer`:STRING,`unitId`:STRING,`bidType`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`alternateLastNames`:array,`bookingAgent`:STRING,`facilityPhone`:STRING,`bookingWidget`:STRING,`eVisitId`:STRING,`apiCustId`:STRING,`omiFlowEnabled`:STRING,`price`:STRING,`moveInOriginal`:STRING,`onlineMoveInUrl`:STRING,`actualW`:STRING,`bookedUnit`:struct<`unitType`:STRING,`amenities`:array,`id`:STRING,`price`:struct<`meta`:STRING>,`reservation_days`:STRING,`promotion`:STRING,`description`:struct<`physical`:struct<`height`:STRING,`width`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>>>,`estimatedRevenue`:STRING,`searchWeightId`:STRING,`phone`:STRING,`visitId`:STRING>>,`event`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-stage/separated_dt/gtmWebReservation'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_segment.reactfoot_gtmwebreservation`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_segment.reactfoot_gtmwebreservation"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}