Schema Info

Schema Name: sfdl_dev_segment.reactfoot_gtmwebreservation

created: 2018-01-24 14:44:44
disabled: False
format: raw
id: 540
is_partitioned: True
is_schema_datatyped: False

name:

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

type: segment

Schema Versions: 3

Version 4751334

created: 2024-12-12 10:37:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
    "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_gtmwebreservation`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_gtmwebreservation`\n(\n`event`STRING,`sentAt`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`originalTimestamp`STRING,`messageId`STRING,`properties`struct<`booking`:struct<`email`:STRING,`emailHash`:STRING,`npv`:STRING,`confirmationCode`:STRING>,`site_id`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`transaction`:struct<`pickupTime`:STRING,`hotLead`:STRING,`moveOut`:STRING,`facilityTenantId`:STRING,`searchWeightId`:STRING,`eVisitId`:STRING,`autoState`:STRING,`experiments`:struct<`sf_6128_click_to_show_phone_number`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`ssdr_rollout_90_10`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_6138_mid_field_text`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_5635_half_nomad`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_omi_mfe_embed`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_7371_NVF_100_donuts`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`red_716_tracking_prerender`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_5430_incentive_header`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_4606_post_res_sms`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_13380_sfdc_new_filter`:STRING,`hack_01_facility_page`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5289_facility_page_two`:STRING,`sf_7018_upsellit`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_6852_serp_results`:STRING,`sf_6327_visa_incentive`:STRING,`sf_4161_post_res_paid`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_6999_sparephone_branded_vs_unbranded`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_11616_homepage_updates`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_5129_call_me_back`:STRING>,`monthlyInsurance`:STRING,`invoiceId`:STRING,`sessionId`:STRING,`centershiftAccountId`:STRING,`sitePhone`:STRING,`facilitylocation`:struct<`address2`:STRING,`state`:STRING,`city`:STRING,`country`:STRING,`address1`:STRING,`zip`:STRING>,`apiUnitId`:STRING,`phoneVerified`:STRING,`companyCode`:STRING,`eSignType`:STRING,`contacted`:STRING,`callCenter`:STRING,`commission`:STRING,`onlineMoveInUrl`:STRING,`sizeW`:STRING,`facilityTenant`:STRING,`AAAMemberNumber`:STRING,`npv`:STRING,`bookingAgent`:STRING,`customerNotes`:STRING,`actualW`:STRING,`status`:STRING,`price`:STRING,`facilityId`:STRING,`duplicateOf`:STRING,`termsVersion`:STRING,`hostedWebsite`:STRING,`hasContactlessMoveins`:STRING,`visitId`:STRING,`movedIn`:STRING,`typeOfListing`:STRING,`canceled`:STRING,`read`:STRING,`moveIn`:STRING,`resaleRate`:STRING,`apiLeadId`:STRING,`alternatePhones`:array,`depositPaid`:STRING,`corrected`:STRING,`sizeH`:STRING,`apiCustId`:STRING,`payoutBatchId`:STRING,`unit`:struct<`unitIds`:array>,`promoCode`:STRING,`bookingType`:STRING,`bookingAuth`:STRING,`actualD`:STRING,`moveInOriginal`:STRING,`bookingWidget`:STRING,`matchReasons`:STRING,`alternateLastNames`:array,`bidAmount`:STRING,`sizeD`:STRING,`phoneChangedNumber`:STRING,`siteId`:STRING,`emailHash`:STRING,`modifiedDtm`:STRING,`userId`:STRING,`disputeReason`:STRING,`facilityGetsNotificationEmails`:STRING,`moveInActual`:STRING,`omiPri`:STRING,`free`:STRING,`phone`:STRING,`unitNumber`:STRING,`message`:STRING,`phoneStatus`:STRING,`email`:STRING,`omiFlowEnabled`:STRING,`bookingAgentId`:STRING,`rebateProcessed`:STRING,`reviewStatus`:STRING,`referrerId`:STRING,`omiAttributes`:struct<`reservation`:STRING,`unit`:STRING,`provider`:STRING,`organization`:STRING,`facility`:STRING>,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`bookingState`:STRING,`facilityName`:STRING,`complete`:STRING,`callCenterTransfer`:STRING,`facilityPhone`:STRING,`statementId`:STRING,`trafficSourceId`:STRING,`promo`:STRING,`estimatedRevenue`:STRING,`unitId`:STRING,`listingWantId`:STRING,`confirmationCode`:STRING,`omiCompleted`:STRING,`callCenterNotes`:STRING,`firstName`:STRING,`matchScore`:STRING,`bookedUnit`:struct<`id`:STRING,`amenities`:array,`description`:struct<`vehicle`:struct<`only`:STRING,`warehouse`:STRING,`permitted`:STRING>,`physical`:struct<`length`:STRING,`height`:STRING,`width`:STRING>>,`price`:struct<`meta`:STRING>,`promotion`:STRING,`unitType`:STRING,`reservation_days`:STRING>,`hasOnlineMoveIns`:STRING,`affiliateId`:STRING,`bidType`:STRING,`callerIdPhone`:STRING,`baseBid`:STRING,`phoneFacilityTransfer`:STRING,`alternateEmails`:array,`alternateFirstNames`:array,`lastName`:STRING,`totalPaid`:STRING,`timestamp`:STRING,`searchWeightTestId`:STRING>,`isReact`:STRING>,`receivedAt`STRING,`userId`STRING,`integrations`struct<`_empty_`:STRING>,`type`STRING,`channel`STRING,`_origin`STRING,`version`STRING,`context`struct<`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`timezone`:STRING,`userAgent`:STRING,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`mobile`:STRING,`platform`:STRING,`brands`:array>>,`page`:struct<`search`:STRING,`path`:STRING,`url`:STRING,`title`:STRING,`referrer`:STRING>,`locale`:STRING>,`timestamp`STRING,`projectId`STRING,`anonymousId`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation'\n",
    "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_gtmwebreservation"
]

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation
id: 4751334
processed: 1

raw_data:

{
    "__segment_internal": {},
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c552c7d935bd0001b8729c",
            "59c13cfcc84de40001a9cdcc"
        ],
        "unbundled": []
    },
    "_origin": "2024-12-12T16:37:03Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1733961600000/1734021413753.events-archiver-480-37..fde2811f-1a92-4b0a-adfa-983714f5d3a4.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "5c569a59-69c2-42bf-b219-7d5e1a9d6a6c",
    "channel": "client",
    "context": {
        "ip": "54.175.218.140",
        "library": {
            "name": "analytics.js",
            "version": "next-1.76.0"
        },
        "locale": "en-US",
        "page": {
            "path": "/Perryville-AK-self-storage/Not-Real-Storage-Facility-158303.html",
            "referrer": "http://localhost:9000/search.html?location=Perryville%2C%20AK%2C%20USA&latitude=55.9121988&longitude=-159.1453343",
            "search": "",
            "title": "Not Real Storage Facility | 475 Brooks Road | SpareFoot",
            "url": "http://localhost:9000/Perryville-AK-self-storage/Not-Real-Storage-Facility-158303.html"
        },
        "timezone": "America/Phoenix",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Google Chrome",
                    "version": "131"
                },
                {
                    "brand": "Chromium",
                    "version": "131"
                },
                {
                    "brand": "Not_A Brand",
                    "version": "24"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1734017857428-50505522-9d7a-4ea5-862a-e819d847a157",
    "originalTimestamp": "2024-12-12T15:37:37.428Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1734017857428,
        "booking": {
            "confirmationCode": "PU3D44K55",
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "npv": "500.00"
        },
        "env": "development",
        "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": null,
            "apiLeadId": "",
            "apiUnitId": null,
            "autoState": null,
            "baseBid": "10.00",
            "bidAmount": "500.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "Interior"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "5.00",
                        "width": "8.50"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 32011605,
                "price": {
                    "meta": "50.00"
                },
                "promotion": "",
                "reservation_days": 11,
                "unitType": "storage"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingAuth": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJzaXRlLWlkIiwiaWF0IjoxNzM0MDE3ODU2LCJleHAiOjE3MzQxOTA2NTYsImRhdGEiOnsiZW1haWwiOiJ0ZXN0QHRlc3QuY29tIiwiY29uZmlybWF0aW9uQ29kZSI6IlBVM0Q0NEs1NSJ9fQ.dwR0vejTVGqp2g7p66haFc6Ck37p-D-UdgLOjwrH38E",
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-12-12 9:37am] Booking 8½' x 5' unit $50 (Interior) on website (Storage.com)",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": null,
            "companyCode": "",
            "complete": 1,
            "confirmationCode": "PU3D44K55",
            "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_11349_sfdc_omi": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "control",
                "sf_12700_sfdc_paid_landing_refresh": "control",
                "sf_13230_distance_top_five_algo": "control",
                "sf_13380_sfdc_new_filter": "inactive",
                "sf_13810_new_map_strategy": "inactive",
                "sf_omi_mfe_embed": "inactive"
            },
            "facilityId": 158303,
            "facilityName": "Not Real Storage Facility",
            "facilityPhone": 5555555555,
            "facilityTenant": false,
            "facilityTenantId": null,
            "facilitylocation": {
                "address1": "475 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-12-12 09:37:34",
            "monthlyInsurance": null,
            "moveIn": "2024-12-17",
            "moveInActual": null,
            "moveInOriginal": "2024-12-17",
            "moveOut": null,
            "movedIn": 0,
            "npv": "500.00",
            "omiCompleted": false,
            "omiFlowEnabled": false,
            "omiPri": null,
            "onlineMoveInUrl": null,
            "payoutBatchId": null,
            "phone": "5555555555",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "50.00",
            "promo": "",
            "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": "8.50",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-12-12 09:37:34",
            "totalPaid": null,
            "trafficSourceId": null,
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "32011605"
                ]
            },
            "unitId": 32011605,
            "unitNumber": null,
            "userId": 1253,
            "visitId": null
        }
    },
    "receivedAt": "2024-12-12T15:37:37.991Z",
    "sentAt": "2024-12-12T15:37:37.451Z",
    "timestamp": "2024-12-12T15:37:37.968Z",
    "type": "track",
    "userId": "error",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.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.bookingAuth": "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_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "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_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_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_6999_sparephone_branded_vs_unbranded": "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_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.experiments.ssdr_rollout_90_10": "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.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.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.status": "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: 540
schema_scan_id: 6723814
updated: 2024-12-12 10:37:36

Version 4711496

created: 2024-10-08 08:15:33

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation
id: 4711496
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c552c7d935bd0001b8729c",
            "59c13cfcc84de40001a9cdcc"
        ],
        "unbundled": []
    },
    "_origin": "2024-10-08T13:15:17Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1728345600000/1728393299194.events-archiver-480-6..c66e3e41-425f-44b1-a4b7-e80e7776a281.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "6db9ca5d-8de1-46c0-923b-76fd22a76506",
    "channel": "client",
    "context": {
        "ip": "122.183.162.85",
        "library": {
            "name": "analytics.js",
            "version": "next-1.72.1"
        },
        "locale": "en-GB",
        "page": {
            "path": "/Perryville-AK-self-storage/SiteLink-Demo-Facility-105463.html",
            "referrer": "https://www.sparefoot.moreyard.com/search.html?location=Ak%20periville",
            "search": "",
            "title": "SiteLink Demo Facility | 403 Brooks Road | SpareFoot",
            "url": "https://www.sparefoot.moreyard.com/Perryville-AK-self-storage/SiteLink-Demo-Facility-105463.html"
        },
        "timezone": "Asia/Calcutta",
        "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36",
        "userAgentData": {
            "brands": [
                {
                    "brand": "Google Chrome",
                    "version": "129"
                },
                {
                    "brand": "Not=A?Brand",
                    "version": "8"
                },
                {
                    "brand": "Chromium",
                    "version": "129"
                }
            ],
            "mobile": false,
            "platform": "macOS"
        }
    },
    "event": "gtmWebReservation",
    "integrations": {},
    "messageId": "ajs-next-1728390342051-30be6657-5b33-4607-b44a-f9b7052d8f28",
    "originalTimestamp": "2024-10-08T12:25:42.051Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1728390342051,
        "booking": {
            "confirmationCode": "ZE9SMD4C9",
            "email": "[email protected]",
            "emailHash": "f8e09b50bd7550ba51ec1ccffd0147374f6b48acfa1dfc14ce2a4b6873b93537",
            "npv": "165.00"
        },
        "env": "dev",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 2318,
                "hasOnlineMoveIns": true
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "507612",
            "apiLeadId": "231291",
            "apiUnitId": "82024",
            "autoState": null,
            "baseBid": "5.00",
            "bidAmount": "165.00",
            "bidType": "PERCENT",
            "bookedUnit": {
                "amenities": [
                    "100' Ceiling",
                    "1st Floor",
                    "Alarm",
                    "Climate Controlled",
                    "Interior"
                ],
                "description": {
                    "physical": {
                        "height": null,
                        "length": "3.00",
                        "width": "3.00"
                    },
                    "vehicle": {
                        "only": false,
                        "permitted": false,
                        "warehouse": false
                    }
                },
                "id": 24136113,
                "price": {
                    "meta": "21.45"
                },
                "promotion": "Free 1 Months Rent - P2",
                "reservation_days": 60,
                "unitType": "locker"
            },
            "bookingAgent": null,
            "bookingAgentId": null,
            "bookingState": "PENDING",
            "bookingType": "STANDARD",
            "bookingWidget": 0,
            "callCenter": 0,
            "callCenterNotes": "[2024-10-08 7:25am] Booking 3' x 3' locker $21.45 (100' Ceiling, 1st Floor, Alarm, Climate Controlled, Interior) Promo: Free 1 Months Rent - P2 on website (SpareFoot.com)\n[2024-10-08 7:25am] SL Reference ID: 1700268699",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": "",
            "complete": 1,
            "confirmationCode": "ZE9SMD4C9",
            "contacted": 0,
            "corrected": 0,
            "customerNotes": null,
            "depositPaid": "0.00",
            "disputeReason": null,
            "duplicateOf": null,
            "eSignType": null,
            "eVisitId": null,
            "email": "[email protected]",
            "emailHash": "f8e09b50bd7550ba51ec1ccffd0147374f6b48acfa1dfc14ce2a4b6873b93537",
            "estimatedRevenue": null,
            "experiments": {
                "sf_11349_sfdc_omi": "inactive",
                "sf_12289_sfdc_holiday_messaging": "inactive",
                "sf_12496_sfdc_clp_unitcardrefresh": "inactive",
                "sf_12510_hidden_facilities": "variation",
                "sf_12700_sfdc_paid_landing_refresh": "variation2",
                "sf_13230_distance_top_five_algo": "control",
                "sf_13380_sfdc_new_filter": "variation",
                "sf_13810_new_map_strategy": "inactive",
                "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": "Praveen test",
            "free": 0,
            "hasContactlessMoveins": true,
            "hasOnlineMoveIns": true,
            "hostedWebsite": 0,
            "hotLead": null,
            "invoiceId": null,
            "lastName": "kumar",
            "listingWantId": null,
            "matchReasons": null,
            "matchScore": null,
            "message": "Booking was successfully created!",
            "modifiedDtm": "2024-10-08 07:25:37",
            "monthlyInsurance": null,
            "moveIn": "2024-10-08",
            "moveInActual": null,
            "moveInOriginal": "2024-10-08",
            "moveOut": null,
            "movedIn": 0,
            "npv": "165.00",
            "omiAttributes": {
                "facility": "LTRAIN",
                "organization": "CSPFT",
                "provider": "sl",
                "reservation": "pal:reservation:sl:CSPFT;LTRAIN;231291",
                "unit": "82024"
            },
            "omiCompleted": false,
            "omiFlowEnabled": true,
            "omiPri": "pal:reservation:sl:CSPFT;LTRAIN;231291",
            "onlineMoveInUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?ep=PIohUNkQ3b76qL6WCojInHbzWv9BaiPQZciyrMX5wU9YlQp%2bkkziwYQr6LCPvZWPCUxsYJMNdYwHoaK5tM30jc6Ai%2fEeNOUNiZS0wCptHHkyQfmm79VIXvc9pe53nTz8MXm5iyPOwlCSoXJBYm0lK1QPVts2VrAXboimII9HfVQ%3d",
            "payoutBatchId": null,
            "phone": "8888888888",
            "phoneChangedNumber": 0,
            "phoneFacilityTransfer": 0,
            "phoneStatus": null,
            "phoneVerified": 0,
            "pickupTime": null,
            "price": "21.45",
            "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": -1,
            "sitePhone": null,
            "sizeD": "3.00",
            "sizeH": null,
            "sizeW": "3.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-10-08 07:25:36",
            "totalPaid": null,
            "trafficSourceId": "__Direct",
            "typeOfListing": 2,
            "unit": {
                "unitIds": [
                    "24136100",
                    "24136101",
                    "24136102",
                    "24136103",
                    "24136104",
                    "24136105",
                    "24136106",
                    "24136107",
                    "24136108",
                    "24136109",
                    "24136110",
                    "24136111",
                    "24136112",
                    "24136113",
                    "24136114",
                    "24136115",
                    "24136116",
                    "24136117",
                    "24136118",
                    "24136119"
                ]
            },
            "unitId": 24136113,
            "unitNumber": "X18",
            "userId": 6319815,
            "visitId": null
        }
    },
    "receivedAt": "2024-10-08T12:25:42.979Z",
    "sentAt": "2024-10-08T12:25:42.067Z",
    "timestamp": "2024-10-08T12:25:42.963Z",
    "type": "track",
    "userId": "df30e0e92b3e2119f8040073e10aedeb",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.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_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "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_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_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_6999_sparephone_branded_vs_unbranded": "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_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.experiments.ssdr_rollout_90_10": "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.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.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.status": "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: 540
schema_scan_id: 6613210
updated: 2024-10-08 08:15:55

Version 4709203

created: 2024-08-21 16:50:47

ddl:

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

hive_path: s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation
id: 4709203
processed: 1

raw_data:

{
    "_metadata": {
        "bundled": [
            "Google Analytics",
            "Google Tag Manager",
            "Segment.io"
        ],
        "bundledIds": [
            "59c552c7d935bd0001b8729c",
            "59c13cfcc84de40001a9cdcc"
        ],
        "unbundled": []
    },
    "_origin": "2024-08-21T21:50:39Z|s3://sfdl-segment-reactfoot-dev/segment-logs/iHhi46PCMy/1724198400000/1724277033037.events-archiver-480-48..569b869a-046f-4fb1-bfe0-61f4a0276d72.gz|analytics-segment-separator-dev:$LATEST",
    "anonymousId": "0ece8573-184b-4786-a2a9-4ac4d2a5e301",
    "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": "",
            "search": "",
            "title": "SiteLink Demo Facility | 403 Brooks Road | SpareFoot",
            "url": "https://www.sparefoot.moreyard.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-1724273728814-846cd28e-079a-484e-9248-31d24b2a13d0",
    "originalTimestamp": "2024-08-21T20:55:28.814Z",
    "projectId": "iHhi46PCMy",
    "properties": {
        "Hit Timestamp": 1724273728814,
        "booking": {
            "confirmationCode": "J4SCNPSCH",
            "email": "[email protected]",
            "emailHash": "f660ab912ec121d1b1e928a0bb4bc61b15f5ad44d5efdc4e1c92a25e99b8e44a",
            "npv": "500.00"
        },
        "env": "dev",
        "isReact": true,
        "site_id": -1,
        "transaction": {
            "AAAMemberNumber": null,
            "account": {
                "accountId": 2318,
                "hasOnlineMoveIns": false
            },
            "actualD": null,
            "actualW": null,
            "affiliateId": "sparefoot",
            "alternateEmails": [],
            "alternateFirstNames": [],
            "alternateLastNames": [],
            "alternatePhones": [],
            "apiCustId": "505021",
            "apiLeadId": "228926",
            "apiUnitId": "82072",
            "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": 24152190,
                "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-21 3:55pm] Booking 5' x 5' unit $65.00 (Alarm, Climate Controlled, Electricity, Interior) Promo: Free 1 Months Rent - P2 on website (SpareFoot.com)\n[2024-08-21 3:55pm] SL Reference ID: 1936311477",
            "callCenterTransfer": false,
            "callerIdPhone": null,
            "canceled": "0",
            "centershiftAccountId": null,
            "commission": 0,
            "companyCode": "",
            "complete": 1,
            "confirmationCode": "J4SCNPSCH",
            "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": "inactive",
                "sf_12700_sfdc_paid_landing_refresh": "variation2",
                "sf_13230_distance_top_five_algo": "variation",
                "sf_13380_sfdc_new_filter": "control",
                "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-21 15:55:28",
            "monthlyInsurance": null,
            "moveIn": "2024-08-28",
            "moveInActual": null,
            "moveInOriginal": "2024-08-28",
            "moveOut": null,
            "movedIn": 0,
            "npv": "500.00",
            "omiAttributes": {
                "facility": "LTRAIN",
                "organization": "CSPFT",
                "provider": "sl",
                "reservation": "pal:reservation:sl:CSPFT;LTRAIN;228926",
                "unit": "82072"
            },
            "omiCompleted": false,
            "omiFlowEnabled": true,
            "omiPri": "pal:reservation:sl:CSPFT;LTRAIN;228926",
            "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": -1,
            "sitePhone": null,
            "sizeD": "5.00",
            "sizeH": null,
            "sizeW": "5.00",
            "statementId": null,
            "termsVersion": "20130106",
            "timestamp": "2024-08-21 15:55:28",
            "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": 24152190,
            "unitNumber": "365",
            "userId": 1253,
            "visitId": null
        }
    },
    "receivedAt": "2024-08-21T20:55:29.071Z",
    "sentAt": "2024-08-21T20:55:28.825Z",
    "timestamp": "2024-08-21T20:55:29.060Z",
    "type": "track",
    "userId": "e311e575bbbfbe8be8b42648f58ced18",
    "version": 2
}

schema_attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.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_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "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_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_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_6999_sparephone_branded_vs_unbranded": "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_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.experiments.ssdr_rollout_90_10": "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.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.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.status": "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: 540
schema_scan_id: 6571750
updated: 2024-08-21 16:51:11

Schema Scans: 3

Last at 2024-12-12 10:37:08

Scan 6723814

duration: 0:00:46.983909

exit_message:

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

id: 6723814

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2024-12-12/",
        "name": "dt",
        "type": "string",
        "value": "2024-12-12"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-12-12/1734021413753.events-archiver-480-37..fde2811f-1a92-4b0a-adfa-983714f5d3a4.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 540
start_time: 2024-12-12 10:37:08
success: True
trace_id: 17545099647626466327

Scan 6613210

duration: 0:00:41.161563

exit_message:

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

id: 6613210

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2024-10-08/",
        "name": "dt",
        "type": "string",
        "value": "2024-10-08"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-10-08/1728393299194.events-archiver-480-6..c66e3e41-425f-44b1-a4b7-e80e7776a281.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 540
start_time: 2024-10-08 08:15:27
success: True
trace_id: 7787991419506695661

Scan 6571750

duration: 0:00:44.475053

exit_message:

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

id: 6571750

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": false,
    "partition": {
        "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2024-08-21/",
        "name": "dt",
        "type": "string",
        "value": "2024-08-21"
    },
    "s3": {
        "bucket": "sfdl-segment-reactfoot-dev",
        "hive_path": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation",
        "key": "separated_dt/gtmWebReservation/dt=2024-08-21/1724277033037.events-archiver-480-48..569b869a-046f-4fb1-bfe0-61f4a0276d72.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_segment.reactfoot_gtmWebReservation",
        "type": "segment"
    }
}

running: False
schema_name_id: 540
start_time: 2024-08-21 16:50:41
success: True
trace_id: 17120848403565463207

Partitions:

count: 4

ddl:

[
    "ALTER TABLE\n    `sfdl_dev_segment.reactfoot_gtmwebreservation`\nADD\n\n\n PARTITION (dt='2025-01-29') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-29/'\n PARTITION (dt='2025-01-31') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-31/'\n PARTITION (dt='2025-02-03') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-03/'\n PARTITION (dt='2025-02-04') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-04/'\n;"
]

name: dt

state:

[
    {
        "info": {
            "id": 286850,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-29/",
            "name": "dt",
            "value": "2025-01-29"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-01-29 01:48:48",
                "last_data": "2025-01-29 08:14:58"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 287149,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-31/",
            "name": "dt",
            "value": "2025-01-31"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-01-31 04:34:08",
                "last_data": "2025-01-31 10:17:23"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 287460,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-03/",
            "name": "dt",
            "value": "2025-02-03"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-02-03 12:08:00",
                "last_data": "2025-02-03 12:17:06"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    },
    {
        "info": {
            "id": 287474,
            "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-04/",
            "name": "dt",
            "value": "2025-02-04"
        },
        "state": {
            "arrival": {
                "athena_discovery": true,
                "first_data": "2025-02-03 23:41:38",
                "last_data": "2025-02-04 04:04:01"
            },
            "parquet": {
                "first_performed": null,
                "in_progress": null,
                "job_id": null,
                "last_performed": null,
                "queued": true
            }
        }
    }
]

type: string

Schema:

attributes:

{
    "_origin": "string",
    "anonymousId": "string",
    "channel": "string",
    "context.campaign.content": "string",
    "context.campaign.medium": "string",
    "context.campaign.name": "string",
    "context.campaign.source": "string",
    "context.ip": "string",
    "context.library.name": "string",
    "context.library.version": "string",
    "context.locale": "string",
    "context.page.path": "string",
    "context.page.referrer": "string",
    "context.page.search": "string",
    "context.page.title": "string",
    "context.page.url": "string",
    "context.timezone": "string",
    "context.userAgent": "string",
    "context.userAgentData.brands": [
        {
            "brand": "string",
            "version": "string"
        }
    ],
    "context.userAgentData.mobile": "string",
    "context.userAgentData.platform": "string",
    "event": "string",
    "messageId": "string",
    "originalTimestamp": "string",
    "projectId": "string",
    "properties.Hit_Timestamp": "string",
    "properties.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.bookingAuth": "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_13810_new_map_strategy": "string",
    "properties.transaction.experiments.sf_4161_post_res_paid": "string",
    "properties.transaction.experiments.sf_4606_post_res_sms": "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_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_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_6999_sparephone_branded_vs_unbranded": "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_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.experiments.ssdr_rollout_90_10": "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.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.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.status": "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-12-12 10:37:15

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2018-01-24 14:44:44",
        "disabled": false,
        "format": "raw",
        "id": 540,
        "is_partitioned": true,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_dev_segment",
            "table": "reactfoot_gtmwebreservation"
        },
        "type": "segment"
    },
    "partition": {
        "count": 4,
        "ddl": [
            "ALTER TABLE\n    `sfdl_dev_segment.reactfoot_gtmwebreservation`\nADD\n\n\n PARTITION (dt='2025-01-29') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-29/'\n PARTITION (dt='2025-01-31') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-31/'\n PARTITION (dt='2025-02-03') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-03/'\n PARTITION (dt='2025-02-04') location 's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-04/'\n;"
        ],
        "name": "dt",
        "state": [
            {
                "info": {
                    "id": 286850,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-29/",
                    "name": "dt",
                    "value": "2025-01-29"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-01-29 01:48:48",
                        "last_data": "2025-01-29 08:14:58"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 287149,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-01-31/",
                    "name": "dt",
                    "value": "2025-01-31"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-01-31 04:34:08",
                        "last_data": "2025-01-31 10:17:23"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 287460,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-03/",
                    "name": "dt",
                    "value": "2025-02-03"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-02-03 12:08:00",
                        "last_data": "2025-02-03 12:17:06"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            },
            {
                "info": {
                    "id": 287474,
                    "location": "s3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation/dt=2025-02-04/",
                    "name": "dt",
                    "value": "2025-02-04"
                },
                "state": {
                    "arrival": {
                        "athena_discovery": true,
                        "first_data": "2025-02-03 23:41:38",
                        "last_data": "2025-02-04 04:04:01"
                    },
                    "parquet": {
                        "first_performed": null,
                        "in_progress": null,
                        "job_id": null,
                        "last_performed": null,
                        "queued": true
                    }
                }
            }
        ],
        "type": "string"
    },
    "schema": {
        "attributes": {
            "_origin": "string",
            "anonymousId": "string",
            "channel": "string",
            "context.campaign.content": "string",
            "context.campaign.medium": "string",
            "context.campaign.name": "string",
            "context.campaign.source": "string",
            "context.ip": "string",
            "context.library.name": "string",
            "context.library.version": "string",
            "context.locale": "string",
            "context.page.path": "string",
            "context.page.referrer": "string",
            "context.page.search": "string",
            "context.page.title": "string",
            "context.page.url": "string",
            "context.timezone": "string",
            "context.userAgent": "string",
            "context.userAgentData.brands": [
                {
                    "brand": "string",
                    "version": "string"
                }
            ],
            "context.userAgentData.mobile": "string",
            "context.userAgentData.platform": "string",
            "event": "string",
            "messageId": "string",
            "originalTimestamp": "string",
            "projectId": "string",
            "properties.Hit_Timestamp": "string",
            "properties.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.bookingAuth": "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_13810_new_map_strategy": "string",
            "properties.transaction.experiments.sf_4161_post_res_paid": "string",
            "properties.transaction.experiments.sf_4606_post_res_sms": "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_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_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_6999_sparephone_branded_vs_unbranded": "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_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.experiments.ssdr_rollout_90_10": "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.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.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.status": "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-12-12 10:37:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.reactfoot_gtmwebreservation`\n(\n`event`STRING,`sentAt`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`originalTimestamp`STRING,`messageId`STRING,`properties`struct<`booking`:struct<`email`:STRING,`emailHash`:STRING,`npv`:STRING,`confirmationCode`:STRING>,`site_id`:STRING,`Hit_Timestamp`:STRING,`env`:STRING,`transaction`:struct<`pickupTime`:STRING,`hotLead`:STRING,`moveOut`:STRING,`facilityTenantId`:STRING,`searchWeightId`:STRING,`eVisitId`:STRING,`autoState`:STRING,`experiments`:struct<`sf_6128_click_to_show_phone_number`:STRING,`sf_6804_two_step_checkout`:STRING,`sf_11786_sfdc_omi_redesign`:STRING,`ssdr_rollout_90_10`:STRING,`sf_7485_scarcity_treatment`:STRING,`sf_5069_alt_contact_info`:STRING,`sf_12510_hidden_facilities`:STRING,`sf_6138_mid_field_text`:STRING,`sf_13810_new_map_strategy`:STRING,`sf_5635_half_nomad`:STRING,`sf_7514_sfdc_time_boxed_reservation_process`:STRING,`sf_10286_sfdc_cronut_algo`:STRING,`sf_9384_sfdc_car_storage_psp`:STRING,`sf_7046_recommended_facility_badge`:STRING,`sf_8718_sfdc_reserve_for_free_cta`:STRING,`sf_11464_neighbordotcom_cpc_ad`:STRING,`sf_omi_mfe_embed`:STRING,`sf_8714_sfdc_form_field_positive_reinforcement`:STRING,`sf_9463_sfdc_tpp_badging`:STRING,`sf_10867_sfdc_smaller_informed_search`:STRING,`sf_10841_sfdc_platform_x_integration`:STRING,`sf_8535_sfdc_unit_comparison_v1`:STRING,`sf_7155_two_step_checkout_v3`:STRING,`sf_7371_NVF_100_donuts`:STRING,`sf_9827_sfdc_cta_text_change`:STRING,`sf_7058_two_step_checkout_v2`:STRING,`sf_7885_sfdc_unit_size_guide_v2`:STRING,`sf_7490_sfdc_cta_color_change`:STRING,`sf_7249_guided_unit_selection`:STRING,`sf_8336_sfdc_tabbed_facility_page_v2`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_9561_sfdc_covid_confirmation_page_alert`:STRING,`sf_8575_sfdc_price_context_while_shopping`:STRING,`sf_13230_distance_top_five_algo`:STRING,`sf_12700_sfdc_paid_landing_refresh`:STRING,`sf_7537_sfdc_tabbed_facility_page`:STRING,`sf_9431_sfdc_vip_large_card`:STRING,`sf_10181_sfdc_erental_badging`:STRING,`sf_10757_sfdc_chatbot`:STRING,`sf_11825_sfdc_new_datepicker`:STRING,`sf_8326_sfdc_time_boxed_reservation_process_v2`:STRING,`red_716_tracking_prerender`:STRING,`sf_9464_sfdc_persist_top_yielders`:STRING,`sf_11292_confirmation_page_hero`:STRING,`sf_5430_incentive_header`:STRING,`sf_12496_sfdc_clp_unitcardrefresh`:STRING,`c19_1_sfdc_contactless_movein_badging`:STRING,`sf_4606_post_res_sms`:STRING,`sf_8708_sfdc_price_transparency_false_door`:STRING,`sf_9564_sfdc_covid_dont_call_notification`:STRING,`sf_6684_hurricane_relief`:STRING,`sf_13380_sfdc_new_filter`:STRING,`hack_01_facility_page`:STRING,`sf_8641_sfdc_reserve_for_free_banner`:STRING,`sf_11267_sticky_search_clp_hero`:STRING,`sf_10518_sfdc_geo_specific_unit_blends`:STRING,`c19_46_sfdc_confirmation_page_online_moveins`:STRING,`sf_5289_facility_page_two`:STRING,`sf_7018_upsellit`:STRING,`sf_11349_sfdc_omi`:STRING,`sf_6852_serp_results`:STRING,`sf_6327_visa_incentive`:STRING,`sf_4161_post_res_paid`:STRING,`sf_12289_sfdc_holiday_messaging`:STRING,`sf_10104_sfdc_confirmation_cta`:STRING,`sf_6999_sparephone_branded_vs_unbranded`:STRING,`sf_9189_sfdc_collapsable_info_on_cards`:STRING,`sf_11616_homepage_updates`:STRING,`sf_4830_aa_phlag_band_aid`:STRING,`sf_9484_sfdc_add_deals_link_to_header`:STRING,`sf_7371_nvf_100_donuts`:STRING,`sf_5129_call_me_back`:STRING>,`monthlyInsurance`:STRING,`invoiceId`:STRING,`sessionId`:STRING,`centershiftAccountId`:STRING,`sitePhone`:STRING,`facilitylocation`:struct<`address2`:STRING,`state`:STRING,`city`:STRING,`country`:STRING,`address1`:STRING,`zip`:STRING>,`apiUnitId`:STRING,`phoneVerified`:STRING,`companyCode`:STRING,`eSignType`:STRING,`contacted`:STRING,`callCenter`:STRING,`commission`:STRING,`onlineMoveInUrl`:STRING,`sizeW`:STRING,`facilityTenant`:STRING,`AAAMemberNumber`:STRING,`npv`:STRING,`bookingAgent`:STRING,`customerNotes`:STRING,`actualW`:STRING,`status`:STRING,`price`:STRING,`facilityId`:STRING,`duplicateOf`:STRING,`termsVersion`:STRING,`hostedWebsite`:STRING,`hasContactlessMoveins`:STRING,`visitId`:STRING,`movedIn`:STRING,`typeOfListing`:STRING,`canceled`:STRING,`read`:STRING,`moveIn`:STRING,`resaleRate`:STRING,`apiLeadId`:STRING,`alternatePhones`:array,`depositPaid`:STRING,`corrected`:STRING,`sizeH`:STRING,`apiCustId`:STRING,`payoutBatchId`:STRING,`unit`:struct<`unitIds`:array>,`promoCode`:STRING,`bookingType`:STRING,`bookingAuth`:STRING,`actualD`:STRING,`moveInOriginal`:STRING,`bookingWidget`:STRING,`matchReasons`:STRING,`alternateLastNames`:array,`bidAmount`:STRING,`sizeD`:STRING,`phoneChangedNumber`:STRING,`siteId`:STRING,`emailHash`:STRING,`modifiedDtm`:STRING,`userId`:STRING,`disputeReason`:STRING,`facilityGetsNotificationEmails`:STRING,`moveInActual`:STRING,`omiPri`:STRING,`free`:STRING,`phone`:STRING,`unitNumber`:STRING,`message`:STRING,`phoneStatus`:STRING,`email`:STRING,`omiFlowEnabled`:STRING,`bookingAgentId`:STRING,`rebateProcessed`:STRING,`reviewStatus`:STRING,`referrerId`:STRING,`omiAttributes`:struct<`reservation`:STRING,`unit`:STRING,`provider`:STRING,`organization`:STRING,`facility`:STRING>,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`bookingState`:STRING,`facilityName`:STRING,`complete`:STRING,`callCenterTransfer`:STRING,`facilityPhone`:STRING,`statementId`:STRING,`trafficSourceId`:STRING,`promo`:STRING,`estimatedRevenue`:STRING,`unitId`:STRING,`listingWantId`:STRING,`confirmationCode`:STRING,`omiCompleted`:STRING,`callCenterNotes`:STRING,`firstName`:STRING,`matchScore`:STRING,`bookedUnit`:struct<`id`:STRING,`amenities`:array,`description`:struct<`vehicle`:struct<`only`:STRING,`warehouse`:STRING,`permitted`:STRING>,`physical`:struct<`length`:STRING,`height`:STRING,`width`:STRING>>,`price`:struct<`meta`:STRING>,`promotion`:STRING,`unitType`:STRING,`reservation_days`:STRING>,`hasOnlineMoveIns`:STRING,`affiliateId`:STRING,`bidType`:STRING,`callerIdPhone`:STRING,`baseBid`:STRING,`phoneFacilityTransfer`:STRING,`alternateEmails`:array,`alternateFirstNames`:array,`lastName`:STRING,`totalPaid`:STRING,`timestamp`:STRING,`searchWeightTestId`:STRING>,`isReact`:STRING>,`receivedAt`STRING,`userId`STRING,`integrations`struct<`_empty_`:STRING>,`type`STRING,`channel`STRING,`_origin`STRING,`version`STRING,`context`struct<`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING,`source`:STRING>,`timezone`:STRING,`userAgent`:STRING,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`userAgentData`:struct<`mobile`:STRING,`platform`:STRING,`brands`:array>>,`page`:struct<`search`:STRING,`path`:STRING,`url`:STRING,`title`:STRING,`referrer`:STRING>,`locale`:STRING>,`timestamp`STRING,`projectId`STRING,`anonymousId`STRING\n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-segment-reactfoot-dev/separated_dt/gtmWebReservation'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.reactfoot_gtmwebreservation`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.reactfoot_gtmwebreservation"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}