Schema Info
Schema Name: sfdl_dev_segment.ssdc_submit
- created: 2017-12-11 14:13:56
- disabled: False
- format: raw
- id: 494
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_segment", "table": "ssdc_submit" } - type: segment
Schema Versions: 3
-
Version 4752792
- created: 2025-01-13 01:11:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_submit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_submit`\n(\n`event`STRING,`_origin`STRING,`properties`struct<`label`:STRING,`category`:STRING,`failureLabel`:STRING,`successLabel`:STRING,`site_id`:STRING,`env`:STRING,`extra`:struct<`promoCode`:STRING,`statementId`:STRING,`facilitylocation`:struct<`zip`:STRING,`address1`:STRING,`country`:STRING,`address2`:STRING,`city`:STRING,`state`:STRING>,`unit`:struct<`unitIds`:array>,`npv`:STRING,`sitePhone`:STRING,`affiliateId`:STRING,`facilityId`:STRING,`matchScore`:STRING,`contacted`:STRING,`bookingAuth`:STRING,`alternateNames`:array ,`eSignType`:STRING,`actualW`:STRING,`complete`:STRING,`actualD`:STRING,`matchReasons`:STRING,`free`:STRING,`bookingAgentId`:STRING,`callCenterNotes`:STRING,`autoState`:STRING,`duplicateOf`:STRING,`siteId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`amenities`:array ,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>>,`reservation_days`:STRING,`id`:STRING,`size`:STRING,`unitType`:STRING,`price`:struct<`meta`:STRING>,`typeText`:STRING,`reservationDays`:STRING>,`typeOfListing`:STRING,`timestamp`:STRING,`canceled`:STRING,`invoiceId`:STRING,`facilityLocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`facilityTenantId`:STRING,`bookingState`:STRING,`termsVersion`:STRING,`customerNotes`:STRING,`depositPaid`:STRING,`phoneStatus`:STRING,`callerIdPhone`:STRING,`lastName`:STRING,`apiLeadId`:STRING,`confirmationCode`:STRING,`price`:STRING,`facilityTenant`:STRING,`corrected`:STRING,`phoneFacilityTransfer`:STRING,`onlineMoveInUrl`:STRING,`resaleRate`:STRING,`bidType`:STRING,`promo`:STRING,`facilityPhone`:STRING,`AAAMemberNumber`:STRING,`moveInOriginal`:STRING,`centershiftAccountId`:STRING,`trafficSourceId`:STRING,`unitNumber`:STRING,`eVisitId`:STRING,`omiPri`:STRING,`modifiedDtm`:STRING,`visitId`:STRING,`rawBooking`:struct<`facilityGetsNotificationEmails`:STRING,`contacted`:STRING,`baseBid`:STRING,`userId`:STRING,`affiliateId`:STRING,`eSignType`:STRING,`typeOfListing`:STRING,`hostedWebsite`:STRING,`visitId`:STRING,`unitId`:STRING,`hotLead`:STRING,`callCenter`:STRING,`sitePhone`:STRING,`alternateFirstNames`:array ,`facilityPhone`:STRING,`apiCustId`:STRING,`reviewStatus`:STRING,`read`:STRING,`timestamp`:STRING,`alternatePhones`:array ,`callCenterTransfer`:STRING,`sizeD`:STRING,`confirmationCode`:STRING,`duplicateOf`:STRING,`matchScore`:STRING,`sizeH`:STRING,`movedIn`:STRING,`moveInOriginal`:STRING,`companyCode`:STRING,`centershiftAccountId`:STRING,`facilityId`:STRING,`callCenterNotes`:STRING,`apiLeadId`:STRING,`totalPaid`:STRING,`bookingAgent`:STRING,`resaleRate`:STRING,`AAAMemberNumber`:STRING,`email`:STRING,`depositPaid`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>,`physical`:struct<`width`:STRING,`length`:STRING,`height`:STRING>>,`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array ,`promotion`:STRING,`id`:STRING>,`free`:STRING,`autoState`:STRING,`facilityTenantId`:STRING,`listingWantId`:STRING,`lastName`:STRING,`promoCode`:STRING,`phoneChangedNumber`:STRING,`statementId`:STRING,`rebateProcessed`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`monthlyInsurance`:STRING,`bookingType`:STRING,`unit`:struct<`unitIds`:array >,`bookingWidget`:STRING,`customerNotes`:STRING,`commission`:STRING,`estimatedRevenue`:STRING,`searchWeightTestId`:STRING,`facilityTenant`:STRING,`complete`:STRING,`bidType`:STRING,`facilitylocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`corrected`:STRING,`alternateEmails`:array ,`phone`:STRING,`pickupTime`:STRING,`actualD`:STRING,`firstName`:STRING,`bookingState`:STRING,`bidAmount`:STRING,`phoneFacilityTransfer`:STRING,`phoneVerified`:STRING,`actualW`:STRING,`moveIn`:STRING,`moveOut`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`canceled`:STRING,`sizeW`:STRING,`alternateLastNames`:array ,`callerIdPhone`:STRING,`apiUnitId`:STRING,`termsVersion`:STRING,`facilityName`:STRING,`modifiedDtm`:STRING,`invoiceId`:STRING,`promo`:STRING,`trafficSourceId`:STRING,`price`:STRING,`payoutBatchId`:STRING,`unitNumber`:STRING,`phoneStatus`:STRING,`npv`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`searchWeightId`:STRING,`bookingAgentId`:STRING,`siteId`:STRING>,`movedIn`:STRING,`apiUnitId`:STRING,`estimatedRevenue`:STRING,`meta`:struct<`title`:STRING>,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`phone`:STRING,`read`:STRING,`apiCustId`:STRING,`alternateLastNames`:array ,`moveInActual`:STRING,`facilityGetsNotificationEmails`:STRING,`unitId`:STRING,`firstName`:STRING,`alternateFirstNames`:array ,`reviewStatus`:STRING,`commission`:STRING,`sessionId`:STRING,`companyCode`:STRING,`hostedWebsite`:STRING,`bidAmount`:STRING,`facilityName`:STRING,`totalPaid`:STRING,`sizeH`:STRING,`bookingAgent`:STRING,`listingWantId`:STRING,`referrerId`:STRING,`bookingWidget`:STRING,`callCenterTransfer`:STRING,`phoneVerified`:STRING,`hotLead`:STRING,`moveOut`:STRING,`alternatePhones`:array ,`alternateEmails`:array ,`phoneChangedNumber`:STRING,`disputeReason`:STRING,`payoutBatchId`:STRING,`userId`:STRING,`sizeD`:STRING,`omiCompleted`:STRING,`searchWeightTestId`:STRING,`omiFlowEnabled`:STRING,`hasOnlineMoveIns`:STRING,`hasContactlessMoveins`:STRING,`baseBid`:STRING,`omiAttributes`:struct<`facility`:STRING,`organization`:STRING,`unit`:STRING,`reservation`:STRING,`provider`:STRING>,`monthlyInsurance`:STRING,`pickupTime`:STRING,`sizeW`:STRING,`rebateProcessed`:STRING,`searchWeightId`:STRING,`callCenter`:STRING,`email`:STRING,`bookingType`:STRING,`moveIn`:STRING>,`isReact`:STRING,`Hit_Timestamp`:STRING>,`integrations`struct<`_empty_`:STRING>,`sentAt`STRING,`type`STRING,`channel`STRING,`version`STRING,`receivedAt`STRING,`userId`STRING,`context`struct<`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING,`userAgentData`:struct<`brands`:array ,`unbundled`:array >,`timestamp`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-ssdc-dev/separated_dt/submit'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_submit" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/submit
- id: 4752792
- processed: 1
- raw_data:
{ "__segment_internal": {}, "_metadata": { "bundled": [ "Google Tag Manager", "Segment.io" ], "bundledIds": [ "5ab94e33d7cab31211fc1606" ], "unbundled": [] }, "_origin": "2025-01-13T07:10:57Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1736726400000/1736752230499.events-archiver-480-10..15bab840-e856-43f9-83da-403e888df8f7.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "0a22d289-4340-4a82-ab02-2ef2243409c5", "channel": "client", "context": { "ip": "2401:4900:6764:e92f:88bb:a4cd:4001:dc12", "library": { "name": "analytics.js", "version": "next-1.76.0" }, "locale": "en-GB", "page": { "path": "/self-storage/alaska/perryville/sitelink-demo-facility-105463/reserve/17000954/", "referrer": "https://www.selfstorage.moreyard.com/search?location=peryville%2Cak&type=storage", "search": "", "title": "Reserve a 5' x 5' unit with 1st Floor, Interior at SiteLink Demo Facility in Perryville", "url": "https://www.selfstorage.moreyard.com/self-storage/alaska/perryville/sitelink-demo-facility-105463/reserve/17000954/" }, "timezone": "Asia/Calcutta", "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": "submit", "integrations": {}, "messageId": "ajs-next-1736749189227-7b891029-41d6-43a2-8dfd-ff0b5862048e", "originalTimestamp": "2025-01-13T06:19:49.227Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1736749189227, "category": "reservation form interactions-reservePage", "env": "dev", "extra": { "AAAMemberNumber": null, "account": { "accountId": 2318, "hasOnlineMoveIns": true }, "actualD": null, "actualW": null, "affiliateId": "sparefoot", "alternateEmails": [], "alternateFirstNames": [], "alternateLastNames": [], "alternatePhones": [], "apiCustId": "513424", "apiLeadId": "237123", "apiUnitId": "43811", "autoState": null, "baseBid": "5.00", "bidAmount": "375.00", "bidType": "PERCENT", "bookedUnit": { "amenities": [ "1st Floor", "Interior" ], "description": { "physical": { "height": null, "length": "5.00", "width": "5.00" }, "vehicle": { "only": false, "permitted": false, "warehouse": false } }, "id": 17000954, "price": { "meta": "48.75" }, "promotion": "Free 1 Months Rent - P2", "reservation_days": 60, "unitType": "storage" }, "bookingAgent": null, "bookingAgentId": null, "bookingAuth": "eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJzaXRlLWlkIiwiaWF0IjoxNzM2NzQ5MTg4LCJleHAiOjE3MzY5MjE5ODgsImRhdGEiOnsiZW1haWwiOiJjaGFyaXNobWEubGFza2htaUBzdG9yYWJsZS5jb20iLCJjb25maXJtYXRpb25Db2RlIjoiVkVOTkI4M0RDIn19.EeUZPKUKqMlkHCz5WyuPTdO332fHEuBf5ADqE4M9ZBE", "bookingState": "PENDING", "bookingType": "STANDARD", "bookingWidget": 0, "callCenter": 0, "callCenterNotes": "[2025-01-13 12:19am] Booking 5' x 5' unit $48.75 (1st Floor, Interior) Promo: Free 1 Months Rent - P2 on website (SpareFoot.com)\n[2025-01-13 12:19am] SL Reference ID: 1452931398", "callCenterTransfer": false, "callerIdPhone": null, "canceled": "0", "centershiftAccountId": null, "commission": 0, "companyCode": "", "complete": 1, "confirmationCode": "VENNB83DC", "contacted": 0, "corrected": 0, "customerNotes": null, "depositPaid": "0.00", "disputeReason": null, "duplicateOf": null, "eSignType": null, "eVisitId": null, "email": "[email protected]", "estimatedRevenue": null, "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": "Charishma Lakshmi", "free": 0, "hasContactlessMoveins": true, "hasOnlineMoveIns": true, "hostedWebsite": 0, "hotLead": null, "invoiceId": null, "lastName": "Pagadala", "listingWantId": null, "matchReasons": null, "matchScore": null, "modifiedDtm": "2025-01-13 00:19:48", "monthlyInsurance": null, "moveIn": "2025-01-14", "moveInActual": null, "moveInOriginal": "2025-01-14", "moveOut": null, "movedIn": 0, "npv": "375.00", "omiAttributes": { "facility": "LTRAIN", "organization": "CSPFT", "provider": "sl", "reservation": "pal:reservation:sl:CSPFT;LTRAIN;237123", "unit": "43811" }, "omiCompleted": false, "omiFlowEnabled": true, "omiPri": "pal:reservation:sl:CSPFT;LTRAIN;237123", "onlineMoveInUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?ep=PIohUNkQ3b76qL6WCojInHbzWv9BaiPQZciyrMX5wU9YlQp%2bkkziwYQr6LCPvZWPCUxsYJMNdYwHoaK5tM30jc6Ai%2fEeNOUNiZS0wCptHHkyQfmm79VIXvc9pe53nTz8a4CfvOCv%2f3b1P%2fOFLmF%2bVBMHDTojfhz9x3ZP9wcdbII%3d", "payoutBatchId": null, "phone": "1231231231", "phoneChangedNumber": 0, "phoneFacilityTransfer": 0, "phoneStatus": null, "phoneVerified": 0, "pickupTime": null, "price": "48.75", "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": "2025-01-13 00:19:48", "totalPaid": null, "trafficSourceId": "__Direct", "typeOfListing": 2, "unit": { "unitIds": [ "17000952", "17000954", "17000955", "17000957" ] }, "unitId": 17000954, "unitNumber": "402", "userId": 6486761, "visitId": null }, "isReact": true, "label": "success-web-STANDARD-5.00-5.00", "site_id": 27 }, "receivedAt": "2025-01-13T06:19:49.736Z", "sentAt": "2025-01-13T06:19:49.236Z", "timestamp": "2025-01-13T06:19:49.727Z", "type": "track", "userId": "7f9d6422f0fb36a58d390081263460ba", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "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.category": "string", "properties.env": "string", "properties.extra.AAAMemberNumber": "string", "properties.extra.account.accountId": "string", "properties.extra.account.hasOnlineMoveIns": "string", "properties.extra.actualD": "string", "properties.extra.actualW": "string", "properties.extra.affiliateId": "string", "properties.extra.alternateEmails": [ "string" ], "properties.extra.alternateFirstNames": [ "string" ], "properties.extra.alternateLastNames": [ "string" ], "properties.extra.alternateNames": [ "string" ], "properties.extra.alternatePhones": [ "string" ], "properties.extra.apiCustId": "string", "properties.extra.apiLeadId": "string", "properties.extra.apiUnitId": "string", "properties.extra.autoState": "string", "properties.extra.baseBid": "string", "properties.extra.bidAmount": "string", "properties.extra.bidType": "string", "properties.extra.bookedUnit.amenities": [ "string" ], "properties.extra.bookedUnit.description.physical.height": "string", "properties.extra.bookedUnit.description.physical.length": "string", "properties.extra.bookedUnit.description.physical.width": "string", "properties.extra.bookedUnit.description.vehicle.only": "string", "properties.extra.bookedUnit.description.vehicle.permitted": "string", "properties.extra.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.bookedUnit.id": "string", "properties.extra.bookedUnit.price.meta": "string", "properties.extra.bookedUnit.promotion": "string", "properties.extra.bookedUnit.reservationDays": "string", "properties.extra.bookedUnit.reservation_days": "string", "properties.extra.bookedUnit.size": "string", "properties.extra.bookedUnit.typeText": "string", "properties.extra.bookedUnit.unitType": "string", "properties.extra.bookingAgent": "string", "properties.extra.bookingAgentId": "string", "properties.extra.bookingAuth": "string", "properties.extra.bookingState": "string", "properties.extra.bookingType": "string", "properties.extra.bookingWidget": "string", "properties.extra.callCenter": "string", "properties.extra.callCenterNotes": "string", "properties.extra.callCenterTransfer": "string", "properties.extra.callerIdPhone": "string", "properties.extra.canceled": "string", "properties.extra.centershiftAccountId": "string", "properties.extra.commission": "string", "properties.extra.companyCode": "string", "properties.extra.complete": "string", "properties.extra.confirmationCode": "string", "properties.extra.contacted": "string", "properties.extra.corrected": "string", "properties.extra.customerNotes": "string", "properties.extra.depositPaid": "string", "properties.extra.disputeReason": "string", "properties.extra.duplicateOf": "string", "properties.extra.eSignType": "string", "properties.extra.eVisitId": "string", "properties.extra.email": "string", "properties.extra.estimatedRevenue": "string", "properties.extra.facilityGetsNotificationEmails": "string", "properties.extra.facilityId": "string", "properties.extra.facilityLocation.address1": "string", "properties.extra.facilityLocation.address2": "string", "properties.extra.facilityLocation.city": "string", "properties.extra.facilityLocation.country": "string", "properties.extra.facilityLocation.state": "string", "properties.extra.facilityLocation.zip": "string", "properties.extra.facilityName": "string", "properties.extra.facilityPhone": "string", "properties.extra.facilityTenant": "string", "properties.extra.facilityTenantId": "string", "properties.extra.facilitylocation.address1": "string", "properties.extra.facilitylocation.address2": "string", "properties.extra.facilitylocation.city": "string", "properties.extra.facilitylocation.country": "string", "properties.extra.facilitylocation.state": "string", "properties.extra.facilitylocation.zip": "string", "properties.extra.firstName": "string", "properties.extra.free": "string", "properties.extra.hasContactlessMoveins": "string", "properties.extra.hasOnlineMoveIns": "string", "properties.extra.hostedWebsite": "string", "properties.extra.hotLead": "string", "properties.extra.invoiceId": "string", "properties.extra.lastName": "string", "properties.extra.listingWantId": "string", "properties.extra.matchReasons": "string", "properties.extra.matchScore": "string", "properties.extra.meta.title": "string", "properties.extra.modifiedDtm": "string", "properties.extra.monthlyInsurance": "string", "properties.extra.moveIn": "string", "properties.extra.moveInActual": "string", "properties.extra.moveInOriginal": "string", "properties.extra.moveOut": "string", "properties.extra.movedIn": "string", "properties.extra.npv": "string", "properties.extra.omiAttributes.facility": "string", "properties.extra.omiAttributes.organization": "string", "properties.extra.omiAttributes.provider": "string", "properties.extra.omiAttributes.reservation": "string", "properties.extra.omiAttributes.unit": "string", "properties.extra.omiCompleted": "string", "properties.extra.omiFlowEnabled": "string", "properties.extra.omiPri": "string", "properties.extra.onlineMoveInUrl": "string", "properties.extra.payoutBatchId": "string", "properties.extra.phone": "string", "properties.extra.phoneChangedNumber": "string", "properties.extra.phoneFacilityTransfer": "string", "properties.extra.phoneStatus": "string", "properties.extra.phoneVerified": "string", "properties.extra.pickupTime": "string", "properties.extra.price": "string", "properties.extra.promo": "string", "properties.extra.promoCode": "string", "properties.extra.rawBooking.AAAMemberNumber": "string", "properties.extra.rawBooking.actualD": "string", "properties.extra.rawBooking.actualW": "string", "properties.extra.rawBooking.affiliateId": "string", "properties.extra.rawBooking.alternateEmails": [ "string" ], "properties.extra.rawBooking.alternateFirstNames": [ "string" ], "properties.extra.rawBooking.alternateLastNames": [ "string" ], "properties.extra.rawBooking.alternatePhones": [ "string" ], "properties.extra.rawBooking.apiCustId": "string", "properties.extra.rawBooking.apiLeadId": "string", "properties.extra.rawBooking.apiUnitId": "string", "properties.extra.rawBooking.autoState": "string", "properties.extra.rawBooking.baseBid": "string", "properties.extra.rawBooking.bidAmount": "string", "properties.extra.rawBooking.bidType": "string", "properties.extra.rawBooking.bookedUnit.amenities": [ "string" ], "properties.extra.rawBooking.bookedUnit.description.physical.height": "string", "properties.extra.rawBooking.bookedUnit.description.physical.length": "string", "properties.extra.rawBooking.bookedUnit.description.physical.width": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.only": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.permitted": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.rawBooking.bookedUnit.id": "string", "properties.extra.rawBooking.bookedUnit.price.meta": "string", "properties.extra.rawBooking.bookedUnit.promotion": "string", "properties.extra.rawBooking.bookedUnit.reservation_days": "string", "properties.extra.rawBooking.bookedUnit.unitType": "string", "properties.extra.rawBooking.bookingAgent": "string", "properties.extra.rawBooking.bookingAgentId": "string", "properties.extra.rawBooking.bookingState": "string", "properties.extra.rawBooking.bookingType": "string", "properties.extra.rawBooking.bookingWidget": "string", "properties.extra.rawBooking.callCenter": "string", "properties.extra.rawBooking.callCenterNotes": "string", "properties.extra.rawBooking.callCenterTransfer": "string", "properties.extra.rawBooking.callerIdPhone": "string", "properties.extra.rawBooking.canceled": "string", "properties.extra.rawBooking.centershiftAccountId": "string", "properties.extra.rawBooking.commission": "string", "properties.extra.rawBooking.companyCode": "string", "properties.extra.rawBooking.complete": "string", "properties.extra.rawBooking.confirmationCode": "string", "properties.extra.rawBooking.contacted": "string", "properties.extra.rawBooking.corrected": "string", "properties.extra.rawBooking.customerNotes": "string", "properties.extra.rawBooking.depositPaid": "string", "properties.extra.rawBooking.disputeReason": "string", "properties.extra.rawBooking.duplicateOf": "string", "properties.extra.rawBooking.eSignType": "string", "properties.extra.rawBooking.eVisitId": "string", "properties.extra.rawBooking.email": "string", "properties.extra.rawBooking.estimatedRevenue": "string", "properties.extra.rawBooking.facilityGetsNotificationEmails": "string", "properties.extra.rawBooking.facilityId": "string", "properties.extra.rawBooking.facilityName": "string", "properties.extra.rawBooking.facilityPhone": "string", "properties.extra.rawBooking.facilityTenant": "string", "properties.extra.rawBooking.facilityTenantId": "string", "properties.extra.rawBooking.facilitylocation.address1": "string", "properties.extra.rawBooking.facilitylocation.address2": "string", "properties.extra.rawBooking.facilitylocation.city": "string", "properties.extra.rawBooking.facilitylocation.country": "string", "properties.extra.rawBooking.facilitylocation.state": "string", "properties.extra.rawBooking.facilitylocation.zip": "string", "properties.extra.rawBooking.firstName": "string", "properties.extra.rawBooking.free": "string", "properties.extra.rawBooking.hostedWebsite": "string", "properties.extra.rawBooking.hotLead": "string", "properties.extra.rawBooking.invoiceId": "string", "properties.extra.rawBooking.lastName": "string", "properties.extra.rawBooking.listingWantId": "string", "properties.extra.rawBooking.matchReasons": "string", "properties.extra.rawBooking.matchScore": "string", "properties.extra.rawBooking.modifiedDtm": "string", "properties.extra.rawBooking.monthlyInsurance": "string", "properties.extra.rawBooking.moveIn": "string", "properties.extra.rawBooking.moveInActual": "string", "properties.extra.rawBooking.moveInOriginal": "string", "properties.extra.rawBooking.moveOut": "string", "properties.extra.rawBooking.movedIn": "string", "properties.extra.rawBooking.npv": "string", "properties.extra.rawBooking.payoutBatchId": "string", "properties.extra.rawBooking.phone": "string", "properties.extra.rawBooking.phoneChangedNumber": "string", "properties.extra.rawBooking.phoneFacilityTransfer": "string", "properties.extra.rawBooking.phoneStatus": "string", "properties.extra.rawBooking.phoneVerified": "string", "properties.extra.rawBooking.pickupTime": "string", "properties.extra.rawBooking.price": "string", "properties.extra.rawBooking.promo": "string", "properties.extra.rawBooking.promoCode": "string", "properties.extra.rawBooking.read": "string", "properties.extra.rawBooking.rebateProcessed": "string", "properties.extra.rawBooking.referrerId": "string", "properties.extra.rawBooking.resaleRate": "string", "properties.extra.rawBooking.reviewStatus": "string", "properties.extra.rawBooking.searchWeightId": "string", "properties.extra.rawBooking.searchWeightTestId": "string", "properties.extra.rawBooking.sessionId": "string", "properties.extra.rawBooking.siteId": "string", "properties.extra.rawBooking.sitePhone": "string", "properties.extra.rawBooking.sizeD": "string", "properties.extra.rawBooking.sizeH": "string", "properties.extra.rawBooking.sizeW": "string", "properties.extra.rawBooking.statementId": "string", "properties.extra.rawBooking.termsVersion": "string", "properties.extra.rawBooking.timestamp": "string", "properties.extra.rawBooking.totalPaid": "string", "properties.extra.rawBooking.trafficSourceId": "string", "properties.extra.rawBooking.typeOfListing": "string", "properties.extra.rawBooking.unit.unitIds": [ "string" ], "properties.extra.rawBooking.unitId": "string", "properties.extra.rawBooking.unitNumber": "string", "properties.extra.rawBooking.userId": "string", "properties.extra.rawBooking.visitId": "string", "properties.extra.read": "string", "properties.extra.rebateProcessed": "string", "properties.extra.referrerId": "string", "properties.extra.resaleRate": "string", "properties.extra.reviewStatus": "string", "properties.extra.searchWeightId": "string", "properties.extra.searchWeightTestId": "string", "properties.extra.sessionId": "string", "properties.extra.siteId": "string", "properties.extra.sitePhone": "string", "properties.extra.sizeD": "string", "properties.extra.sizeH": "string", "properties.extra.sizeW": "string", "properties.extra.statementId": "string", "properties.extra.termsVersion": "string", "properties.extra.timestamp": "string", "properties.extra.totalPaid": "string", "properties.extra.trafficSourceId": "string", "properties.extra.typeOfListing": "string", "properties.extra.unit.unitIds": [ "string" ], "properties.extra.unitId": "string", "properties.extra.unitNumber": "string", "properties.extra.userId": "string", "properties.extra.visitId": "string", "properties.failureLabel": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.successLabel": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 494
- schema_scan_id: 6750184
- updated: 2025-01-13 01:12:14
-
Version 4709833
- created: 2024-09-03 13:05:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_submit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_submit`\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 ,`unitNumber`:STRING,`hostedWebsite`:STRING,`movedIn`: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 >,`firstName`:STRING,`autoState`:STRING,`rawBooking`:struct<`facilityGetsNotificationEmails`:STRING,`contacted`:STRING,`baseBid`:STRING,`userId`:STRING,`affiliateId`:STRING,`eSignType`:STRING,`typeOfListing`:STRING,`hostedWebsite`:STRING,`visitId`:STRING,`unitId`:STRING,`hotLead`:STRING,`callCenter`:STRING,`sitePhone`:STRING,`alternateFirstNames`:array ,`facilityPhone`:STRING,`apiCustId`:STRING,`reviewStatus`:STRING,`read`:STRING,`timestamp`:STRING,`alternatePhones`:array ,`callCenterTransfer`:STRING,`sizeD`:STRING,`confirmationCode`:STRING,`duplicateOf`:STRING,`matchScore`:STRING,`sizeH`:STRING,`movedIn`:STRING,`moveInOriginal`:STRING,`companyCode`:STRING,`centershiftAccountId`:STRING,`facilityId`:STRING,`callCenterNotes`:STRING,`apiLeadId`:STRING,`totalPaid`:STRING,`bookingAgent`:STRING,`resaleRate`:STRING,`AAAMemberNumber`:STRING,`email`:STRING,`depositPaid`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>,`physical`:struct<`width`:STRING,`length`:STRING,`height`:STRING>>,`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array ,`promotion`:STRING,`id`:STRING>,`free`:STRING,`autoState`:STRING,`facilityTenantId`:STRING,`listingWantId`:STRING,`lastName`:STRING,`promoCode`:STRING,`phoneChangedNumber`:STRING,`statementId`:STRING,`rebateProcessed`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`monthlyInsurance`:STRING,`bookingType`:STRING,`unit`:struct<`unitIds`:array >,`bookingWidget`:STRING,`customerNotes`:STRING,`commission`:STRING,`estimatedRevenue`:STRING,`searchWeightTestId`:STRING,`facilityTenant`:STRING,`complete`:STRING,`bidType`:STRING,`facilitylocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`corrected`:STRING,`alternateEmails`:array ,`phone`:STRING,`pickupTime`:STRING,`actualD`:STRING,`firstName`:STRING,`bookingState`:STRING,`bidAmount`:STRING,`phoneFacilityTransfer`:STRING,`phoneVerified`:STRING,`actualW`:STRING,`moveIn`:STRING,`moveOut`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`canceled`:STRING,`sizeW`:STRING,`alternateLastNames`:array ,`callerIdPhone`:STRING,`apiUnitId`:STRING,`termsVersion`:STRING,`facilityName`:STRING,`modifiedDtm`:STRING,`invoiceId`:STRING,`promo`:STRING,`trafficSourceId`:STRING,`price`:STRING,`payoutBatchId`:STRING,`unitNumber`:STRING,`phoneStatus`:STRING,`npv`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`searchWeightId`:STRING,`bookingAgentId`:STRING,`siteId`: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,`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,`actualD`:STRING,`invoiceId`:STRING,`apiLeadId`:STRING,`facilityLocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`facilityId`:STRING,`free`:STRING,`hasOnlineMoveIns`:STRING,`modifiedDtm`:STRING,`sizeH`:STRING,`searchWeightTestId`:STRING,`facilityPhone`:STRING,`listingWantId`:STRING,`hotLead`:STRING,`phoneChangedNumber`:STRING,`corrected`:STRING,`moveInOriginal`:STRING,`phoneVerified`:STRING,`alternateFirstNames`:array ,`bookingAgentId`:STRING,`promo`:STRING,`moveIn`:STRING,`bidType`:STRING,`duplicateOf`:STRING,`apiUnitId`:STRING,`callerIdPhone`:STRING,`customerNotes`:STRING,`referrerId`:STRING,`callCenterTransfer`:STRING,`apiCustId`:STRING,`matchReasons`:STRING,`matchScore`:STRING,`bookedUnit`:struct<`promotion`:STRING,`reservationDays`:STRING,`unitType`:STRING,`id`:STRING,`typeText`:STRING,`reservation_days`:STRING,`amenities`:array ,`price`:struct<`meta`:STRING>,`size`:STRING,`description`:struct<`vehicle`:struct<`permitted`:STRING,`warehouse`:STRING,`only`:STRING>,`physical`:struct<`height`:STRING,`length`:STRING,`width`:STRING>>>,`actualW`:STRING,`searchWeightId`:STRING,`sessionId`:STRING,`price`:STRING,`npv`:STRING,`facilityTenant`:STRING,`userId`:STRING,`bookingType`:STRING,`meta`:struct<`title`:STRING>,`facilityGetsNotificationEmails`:STRING,`baseBid`:STRING,`omiAttributes`:struct<`organization`:STRING,`provider`:STRING,`facility`:STRING,`unit`:STRING,`reservation`:STRING>,`payoutBatchId`:STRING,`facilityName`:STRING,`bookingState`:STRING,`phone`:STRING,`trafficSourceId`:STRING,`alternateLastNames`:array ,`facilityTenantId`:STRING,`resaleRate`:STRING,`contacted`:STRING,`visitId`:STRING,`moveInActual`:STRING,`eVisitId`:STRING>,`isReact`:STRING,`Hit_Timestamp`:STRING,`failureLabel`:STRING,`site_id`:STRING,`category`:STRING,`label`: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-ssdc-dev/separated_dt/submit'\n", "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_submit" ] - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/submit
- id: 4709833
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "IAdHmAh2FE", "5ab94e33d7cab31211fc1606" ], "unbundled": [] }, "_origin": "2024-09-03T18:04:59Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1725321600000/1725386674550.events-archiver-480-29..556138b8-0369-44ee-9da3-90f9b9e25535.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "edd7a391-ef88-405a-b07b-0649c4cff816", "channel": "client", "context": { "ip": "187.142.57.164", "library": { "name": "analytics.js", "version": "next-1.72.1" }, "locale": "en-US", "page": { "path": "/self-storage/alaska/perryville/sitelink-demo-facility-105463/", "referrer": "", "search": "", "title": "SiteLink Demo Facility: Lowest Rates - SelfStorage.com", "url": "http://localhost:9116/self-storage/alaska/perryville/sitelink-demo-facility-105463/" }, "timezone": "America/Mexico_City", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "128" }, { "brand": "Not;A=Brand", "version": "24" }, { "brand": "Google Chrome", "version": "128" } ], "mobile": false, "platform": "macOS" } }, "event": "submit", "integrations": {}, "messageId": "ajs-next-1725383380704-57b9a295-23c8-4477-bebd-34daa01c6e70", "originalTimestamp": "2024-09-03T17:09:40.704Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1725383380704, "category": "reservation form interactions-facilityPage", "env": "development", "extra": { "AAAMemberNumber": null, "account": { "accountId": 2318, "hasOnlineMoveIns": true }, "actualD": null, "actualW": null, "affiliateId": "Storage.com", "alternateEmails": [], "alternateFirstNames": [], "alternateLastNames": [], "alternatePhones": [], "apiCustId": "505721", "apiLeadId": "229568", "apiUnitId": "82023", "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-09-03 12:09pm] Booking 3' x 3' locker $21.45 (100' Ceiling, 1st Floor, Alarm, Climate Controlled, Interior) Promo: Free 1 Months Rent - P2 on website (Storage.com)\n[2024-09-03 12:09pm] SL Reference ID: 542709876", "callCenterTransfer": false, "callerIdPhone": null, "canceled": "0", "centershiftAccountId": null, "commission": null, "companyCode": "", "complete": 1, "confirmationCode": "TENZA9E57", "contacted": 0, "corrected": 0, "customerNotes": null, "depositPaid": "0.00", "disputeReason": null, "duplicateOf": "J58B22AEW", "eSignType": null, "eVisitId": null, "email": "[email protected]", "estimatedRevenue": null, "facilityId": 105463, "facilityName": "SiteLink Demo Facility", "facilityPhone": 5127056208, "facilityTenant": false, "facilityTenantId": null, "facilitylocation": { "address1": "403 Brooks Road", "address2": "", "city": "Perryville", "country": "", "state": "AK", "zip": "99648" }, "firstName": "test", "free": 0, "hasContactlessMoveins": true, "hasOnlineMoveIns": true, "hostedWebsite": 0, "hotLead": null, "invoiceId": null, "lastName": "test", "listingWantId": null, "matchReasons": null, "matchScore": null, "modifiedDtm": "2024-09-03 12:09:38", "monthlyInsurance": null, "moveIn": "2024-09-03", "moveInActual": null, "moveInOriginal": "2024-09-03", "moveOut": null, "movedIn": 0, "npv": "165.00", "omiAttributes": { "facility": "LTRAIN", "organization": "CSPFT", "provider": "sl", "reservation": "pal:reservation:sl:CSPFT;LTRAIN;229568", "unit": "82023" }, "omiCompleted": false, "omiFlowEnabled": true, "omiPri": "pal:reservation:sl:CSPFT;LTRAIN;229568", "onlineMoveInUrl": "https://www.smdservers.net/SLWebSiteTemplate_V2/ReserveMoveIn.aspx?ep=PIohUNkQ3b76qL6WCojInHbzWv9BaiPQZciyrMX5wU9YlQp%2bkkziwYQr6LCPvZWPCUxsYJMNdYwHoaK5tM30jc6Ai%2fEeNOUNiZS0wCptHHkyQfmm79VIXvc9pe53nTz8%2bZ2YWeRf6lewsoJ6rN7AenctXSPBuwDShAyMW%2f9guxo%3d", "payoutBatchId": null, "phone": "5555555555", "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": 424, "sitePhone": null, "sizeD": "3.00", "sizeH": null, "sizeW": "3.00", "statementId": null, "termsVersion": "20130106", "timestamp": "2024-09-03 12:09:38", "totalPaid": null, "trafficSourceId": "null", "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": "X17", "userId": 1253, "visitId": null }, "isReact": true, "label": "success-web-STANDARD-3.00-3.00", "site_id": 27 }, "receivedAt": "2024-09-03T17:09:41.137Z", "sentAt": "2024-09-03T17:09:40.738Z", "timestamp": "2024-09-03T17:09:41.103Z", "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.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.category": "string", "properties.env": "string", "properties.extra.AAAMemberNumber": "string", "properties.extra.account.accountId": "string", "properties.extra.account.hasOnlineMoveIns": "string", "properties.extra.actualD": "string", "properties.extra.actualW": "string", "properties.extra.affiliateId": "string", "properties.extra.alternateEmails": [ "string" ], "properties.extra.alternateFirstNames": [ "string" ], "properties.extra.alternateLastNames": [ "string" ], "properties.extra.alternateNames": [ "string" ], "properties.extra.alternatePhones": [ "string" ], "properties.extra.apiCustId": "string", "properties.extra.apiLeadId": "string", "properties.extra.apiUnitId": "string", "properties.extra.autoState": "string", "properties.extra.baseBid": "string", "properties.extra.bidAmount": "string", "properties.extra.bidType": "string", "properties.extra.bookedUnit.amenities": [ "string" ], "properties.extra.bookedUnit.description.physical.height": "string", "properties.extra.bookedUnit.description.physical.length": "string", "properties.extra.bookedUnit.description.physical.width": "string", "properties.extra.bookedUnit.description.vehicle.only": "string", "properties.extra.bookedUnit.description.vehicle.permitted": "string", "properties.extra.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.bookedUnit.id": "string", "properties.extra.bookedUnit.price.meta": "string", "properties.extra.bookedUnit.promotion": "string", "properties.extra.bookedUnit.reservationDays": "string", "properties.extra.bookedUnit.reservation_days": "string", "properties.extra.bookedUnit.size": "string", "properties.extra.bookedUnit.typeText": "string", "properties.extra.bookedUnit.unitType": "string", "properties.extra.bookingAgent": "string", "properties.extra.bookingAgentId": "string", "properties.extra.bookingState": "string", "properties.extra.bookingType": "string", "properties.extra.bookingWidget": "string", "properties.extra.callCenter": "string", "properties.extra.callCenterNotes": "string", "properties.extra.callCenterTransfer": "string", "properties.extra.callerIdPhone": "string", "properties.extra.canceled": "string", "properties.extra.centershiftAccountId": "string", "properties.extra.commission": "string", "properties.extra.companyCode": "string", "properties.extra.complete": "string", "properties.extra.confirmationCode": "string", "properties.extra.contacted": "string", "properties.extra.corrected": "string", "properties.extra.customerNotes": "string", "properties.extra.depositPaid": "string", "properties.extra.disputeReason": "string", "properties.extra.duplicateOf": "string", "properties.extra.eSignType": "string", "properties.extra.eVisitId": "string", "properties.extra.email": "string", "properties.extra.estimatedRevenue": "string", "properties.extra.facilityGetsNotificationEmails": "string", "properties.extra.facilityId": "string", "properties.extra.facilityLocation.address1": "string", "properties.extra.facilityLocation.address2": "string", "properties.extra.facilityLocation.city": "string", "properties.extra.facilityLocation.country": "string", "properties.extra.facilityLocation.state": "string", "properties.extra.facilityLocation.zip": "string", "properties.extra.facilityName": "string", "properties.extra.facilityPhone": "string", "properties.extra.facilityTenant": "string", "properties.extra.facilityTenantId": "string", "properties.extra.facilitylocation.address1": "string", "properties.extra.facilitylocation.address2": "string", "properties.extra.facilitylocation.city": "string", "properties.extra.facilitylocation.country": "string", "properties.extra.facilitylocation.state": "string", "properties.extra.facilitylocation.zip": "string", "properties.extra.firstName": "string", "properties.extra.free": "string", "properties.extra.hasContactlessMoveins": "string", "properties.extra.hasOnlineMoveIns": "string", "properties.extra.hostedWebsite": "string", "properties.extra.hotLead": "string", "properties.extra.invoiceId": "string", "properties.extra.lastName": "string", "properties.extra.listingWantId": "string", "properties.extra.matchReasons": "string", "properties.extra.matchScore": "string", "properties.extra.meta.title": "string", "properties.extra.modifiedDtm": "string", "properties.extra.monthlyInsurance": "string", "properties.extra.moveIn": "string", "properties.extra.moveInActual": "string", "properties.extra.moveInOriginal": "string", "properties.extra.moveOut": "string", "properties.extra.movedIn": "string", "properties.extra.npv": "string", "properties.extra.omiAttributes.facility": "string", "properties.extra.omiAttributes.organization": "string", "properties.extra.omiAttributes.provider": "string", "properties.extra.omiAttributes.reservation": "string", "properties.extra.omiAttributes.unit": "string", "properties.extra.omiCompleted": "string", "properties.extra.omiFlowEnabled": "string", "properties.extra.omiPri": "string", "properties.extra.onlineMoveInUrl": "string", "properties.extra.payoutBatchId": "string", "properties.extra.phone": "string", "properties.extra.phoneChangedNumber": "string", "properties.extra.phoneFacilityTransfer": "string", "properties.extra.phoneStatus": "string", "properties.extra.phoneVerified": "string", "properties.extra.pickupTime": "string", "properties.extra.price": "string", "properties.extra.promo": "string", "properties.extra.promoCode": "string", "properties.extra.rawBooking.AAAMemberNumber": "string", "properties.extra.rawBooking.actualD": "string", "properties.extra.rawBooking.actualW": "string", "properties.extra.rawBooking.affiliateId": "string", "properties.extra.rawBooking.alternateEmails": [ "string" ], "properties.extra.rawBooking.alternateFirstNames": [ "string" ], "properties.extra.rawBooking.alternateLastNames": [ "string" ], "properties.extra.rawBooking.alternatePhones": [ "string" ], "properties.extra.rawBooking.apiCustId": "string", "properties.extra.rawBooking.apiLeadId": "string", "properties.extra.rawBooking.apiUnitId": "string", "properties.extra.rawBooking.autoState": "string", "properties.extra.rawBooking.baseBid": "string", "properties.extra.rawBooking.bidAmount": "string", "properties.extra.rawBooking.bidType": "string", "properties.extra.rawBooking.bookedUnit.amenities": [ "string" ], "properties.extra.rawBooking.bookedUnit.description.physical.height": "string", "properties.extra.rawBooking.bookedUnit.description.physical.length": "string", "properties.extra.rawBooking.bookedUnit.description.physical.width": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.only": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.permitted": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.rawBooking.bookedUnit.id": "string", "properties.extra.rawBooking.bookedUnit.price.meta": "string", "properties.extra.rawBooking.bookedUnit.promotion": "string", "properties.extra.rawBooking.bookedUnit.reservation_days": "string", "properties.extra.rawBooking.bookedUnit.unitType": "string", "properties.extra.rawBooking.bookingAgent": "string", "properties.extra.rawBooking.bookingAgentId": "string", "properties.extra.rawBooking.bookingState": "string", "properties.extra.rawBooking.bookingType": "string", "properties.extra.rawBooking.bookingWidget": "string", "properties.extra.rawBooking.callCenter": "string", "properties.extra.rawBooking.callCenterNotes": "string", "properties.extra.rawBooking.callCenterTransfer": "string", "properties.extra.rawBooking.callerIdPhone": "string", "properties.extra.rawBooking.canceled": "string", "properties.extra.rawBooking.centershiftAccountId": "string", "properties.extra.rawBooking.commission": "string", "properties.extra.rawBooking.companyCode": "string", "properties.extra.rawBooking.complete": "string", "properties.extra.rawBooking.confirmationCode": "string", "properties.extra.rawBooking.contacted": "string", "properties.extra.rawBooking.corrected": "string", "properties.extra.rawBooking.customerNotes": "string", "properties.extra.rawBooking.depositPaid": "string", "properties.extra.rawBooking.disputeReason": "string", "properties.extra.rawBooking.duplicateOf": "string", "properties.extra.rawBooking.eSignType": "string", "properties.extra.rawBooking.eVisitId": "string", "properties.extra.rawBooking.email": "string", "properties.extra.rawBooking.estimatedRevenue": "string", "properties.extra.rawBooking.facilityGetsNotificationEmails": "string", "properties.extra.rawBooking.facilityId": "string", "properties.extra.rawBooking.facilityName": "string", "properties.extra.rawBooking.facilityPhone": "string", "properties.extra.rawBooking.facilityTenant": "string", "properties.extra.rawBooking.facilityTenantId": "string", "properties.extra.rawBooking.facilitylocation.address1": "string", "properties.extra.rawBooking.facilitylocation.address2": "string", "properties.extra.rawBooking.facilitylocation.city": "string", "properties.extra.rawBooking.facilitylocation.country": "string", "properties.extra.rawBooking.facilitylocation.state": "string", "properties.extra.rawBooking.facilitylocation.zip": "string", "properties.extra.rawBooking.firstName": "string", "properties.extra.rawBooking.free": "string", "properties.extra.rawBooking.hostedWebsite": "string", "properties.extra.rawBooking.hotLead": "string", "properties.extra.rawBooking.invoiceId": "string", "properties.extra.rawBooking.lastName": "string", "properties.extra.rawBooking.listingWantId": "string", "properties.extra.rawBooking.matchReasons": "string", "properties.extra.rawBooking.matchScore": "string", "properties.extra.rawBooking.modifiedDtm": "string", "properties.extra.rawBooking.monthlyInsurance": "string", "properties.extra.rawBooking.moveIn": "string", "properties.extra.rawBooking.moveInActual": "string", "properties.extra.rawBooking.moveInOriginal": "string", "properties.extra.rawBooking.moveOut": "string", "properties.extra.rawBooking.movedIn": "string", "properties.extra.rawBooking.npv": "string", "properties.extra.rawBooking.payoutBatchId": "string", "properties.extra.rawBooking.phone": "string", "properties.extra.rawBooking.phoneChangedNumber": "string", "properties.extra.rawBooking.phoneFacilityTransfer": "string", "properties.extra.rawBooking.phoneStatus": "string", "properties.extra.rawBooking.phoneVerified": "string", "properties.extra.rawBooking.pickupTime": "string", "properties.extra.rawBooking.price": "string", "properties.extra.rawBooking.promo": "string", "properties.extra.rawBooking.promoCode": "string", "properties.extra.rawBooking.read": "string", "properties.extra.rawBooking.rebateProcessed": "string", "properties.extra.rawBooking.referrerId": "string", "properties.extra.rawBooking.resaleRate": "string", "properties.extra.rawBooking.reviewStatus": "string", "properties.extra.rawBooking.searchWeightId": "string", "properties.extra.rawBooking.searchWeightTestId": "string", "properties.extra.rawBooking.sessionId": "string", "properties.extra.rawBooking.siteId": "string", "properties.extra.rawBooking.sitePhone": "string", "properties.extra.rawBooking.sizeD": "string", "properties.extra.rawBooking.sizeH": "string", "properties.extra.rawBooking.sizeW": "string", "properties.extra.rawBooking.statementId": "string", "properties.extra.rawBooking.termsVersion": "string", "properties.extra.rawBooking.timestamp": "string", "properties.extra.rawBooking.totalPaid": "string", "properties.extra.rawBooking.trafficSourceId": "string", "properties.extra.rawBooking.typeOfListing": "string", "properties.extra.rawBooking.unit.unitIds": [ "string" ], "properties.extra.rawBooking.unitId": "string", "properties.extra.rawBooking.unitNumber": "string", "properties.extra.rawBooking.userId": "string", "properties.extra.rawBooking.visitId": "string", "properties.extra.read": "string", "properties.extra.rebateProcessed": "string", "properties.extra.referrerId": "string", "properties.extra.resaleRate": "string", "properties.extra.reviewStatus": "string", "properties.extra.searchWeightId": "string", "properties.extra.searchWeightTestId": "string", "properties.extra.sessionId": "string", "properties.extra.siteId": "string", "properties.extra.sitePhone": "string", "properties.extra.sizeD": "string", "properties.extra.sizeH": "string", "properties.extra.sizeW": "string", "properties.extra.statementId": "string", "properties.extra.termsVersion": "string", "properties.extra.timestamp": "string", "properties.extra.totalPaid": "string", "properties.extra.trafficSourceId": "string", "properties.extra.typeOfListing": "string", "properties.extra.unit.unitIds": [ "string" ], "properties.extra.unitId": "string", "properties.extra.unitNumber": "string", "properties.extra.userId": "string", "properties.extra.visitId": "string", "properties.failureLabel": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.successLabel": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 494
- schema_scan_id: 6581187
- updated: 2024-09-03 13:05:39
-
Version 4699534
- created: 2023-11-17 15:59:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_submit`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_submit`\n(\n`type`STRING,`timestamp`STRING,`channel`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array >,`version`STRING,`integrations`struct<`_empty_`:STRING>,`_origin`STRING,`properties`struct<`Hit_Timestamp`:STRING,`extra`:struct<`corrected`:STRING,`actualW`:STRING,`sitePhone`:STRING,`bidAmount`:STRING,`timestamp`:STRING,`duplicateOf`:STRING,`omiPri`:STRING,`affiliateId`:STRING,`apiLeadId`:STRING,`callCenterTransfer`:STRING,`unit`:struct<`unitIds`:array >,`autoState`:STRING,`lastName`:STRING,`companyCode`:STRING,`alternateFirstNames`:array ,`modifiedDtm`:STRING,`centershiftAccountId`:STRING,`canceled`:STRING,`bookingState`:STRING,`rawBooking`:struct<`facilityGetsNotificationEmails`:STRING,`contacted`:STRING,`baseBid`:STRING,`userId`:STRING,`affiliateId`:STRING,`eSignType`:STRING,`typeOfListing`:STRING,`hostedWebsite`:STRING,`visitId`:STRING,`unitId`:STRING,`hotLead`:STRING,`callCenter`:STRING,`sitePhone`:STRING,`alternateFirstNames`:array ,`facilityPhone`:STRING,`apiCustId`:STRING,`reviewStatus`:STRING,`read`:STRING,`timestamp`:STRING,`alternatePhones`:array ,`callCenterTransfer`:STRING,`sizeD`:STRING,`confirmationCode`:STRING,`duplicateOf`:STRING,`matchScore`:STRING,`sizeH`:STRING,`movedIn`:STRING,`moveInOriginal`:STRING,`companyCode`:STRING,`centershiftAccountId`:STRING,`facilityId`:STRING,`callCenterNotes`:STRING,`apiLeadId`:STRING,`totalPaid`:STRING,`bookingAgent`:STRING,`resaleRate`:STRING,`AAAMemberNumber`:STRING,`email`:STRING,`depositPaid`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>,`physical`:struct<`width`:STRING,`length`:STRING,`height`:STRING>>,`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array ,`promotion`:STRING,`id`:STRING>,`free`:STRING,`autoState`:STRING,`facilityTenantId`:STRING,`listingWantId`:STRING,`lastName`:STRING,`promoCode`:STRING,`phoneChangedNumber`:STRING,`statementId`:STRING,`rebateProcessed`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`monthlyInsurance`:STRING,`bookingType`:STRING,`unit`:struct<`unitIds`:array >,`bookingWidget`:STRING,`customerNotes`:STRING,`commission`:STRING,`estimatedRevenue`:STRING,`searchWeightTestId`:STRING,`facilityTenant`:STRING,`complete`:STRING,`bidType`:STRING,`facilitylocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`corrected`:STRING,`alternateEmails`:array ,`phone`:STRING,`pickupTime`:STRING,`actualD`:STRING,`firstName`:STRING,`bookingState`:STRING,`bidAmount`:STRING,`phoneFacilityTransfer`:STRING,`phoneVerified`:STRING,`actualW`:STRING,`moveIn`:STRING,`moveOut`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`canceled`:STRING,`sizeW`:STRING,`alternateLastNames`:array ,`callerIdPhone`:STRING,`apiUnitId`:STRING,`termsVersion`:STRING,`facilityName`:STRING,`modifiedDtm`:STRING,`invoiceId`:STRING,`promo`:STRING,`trafficSourceId`:STRING,`price`:STRING,`payoutBatchId`:STRING,`unitNumber`:STRING,`phoneStatus`:STRING,`npv`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`searchWeightId`:STRING,`bookingAgentId`:STRING,`siteId`:STRING>,`hasContactlessMoveins`:STRING,`confirmationCode`:STRING,`facilityPhone`:STRING,`bookedUnit`:struct<`reservationDays`:STRING,`price`:struct<`meta`:STRING>,`typeText`:STRING,`promotion`:STRING,`unitType`:STRING,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`permitted`:STRING,`only`:STRING,`warehouse`:STRING>>,`reservation_days`:STRING,`size`:STRING,`id`:STRING,`amenities`:array >,`contacted`:STRING,`hotLead`:STRING,`apiUnitId`:STRING,`baseBid`:STRING,`apiCustId`:STRING,`phoneVerified`:STRING,`sessionId`:STRING,`moveInOriginal`:STRING,`omiCompleted`:STRING,`omiFlowEnabled`:STRING,`facilitylocation`:struct<`state`:STRING,`address2`:STRING,`zip`:STRING,`address1`:STRING,`country`:STRING,`city`:STRING>,`AAAMemberNumber`:STRING,`bookingAgent`:STRING,`facilityName`:STRING,`meta`:struct<`title`:STRING>,`listingWantId`:STRING,`facilityId`:STRING,`complete`:STRING,`alternateLastNames`:array ,`visitId`:STRING,`pickupTime`:STRING,`phoneChangedNumber`:STRING,`disputeReason`:STRING,`sizeD`:STRING,`callerIdPhone`:STRING,`siteId`:STRING,`searchWeightTestId`:STRING,`unitNumber`:STRING,`bookingType`:STRING,`facilityLocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`depositPaid`:STRING,`facilityTenant`:STRING,`hostedWebsite`:STRING,`referrerId`:STRING,`sizeH`:STRING,`payoutBatchId`:STRING,`facilityGetsNotificationEmails`:STRING,`npv`:STRING,`sizeW`:STRING,`actualD`:STRING,`invoiceId`:STRING,`callCenterNotes`:STRING,`monthlyInsurance`:STRING,`totalPaid`:STRING,`estimatedRevenue`:STRING,`alternatePhones`:array ,`moveIn`:STRING,`promoCode`:STRING,`price`:STRING,`alternateEmails`:array ,`facilityTenantId`:STRING,`searchWeightId`:STRING,`phoneStatus`:STRING,`bidType`:STRING,`statementId`:STRING,`typeOfListing`:STRING,`onlineMoveInUrl`:STRING,`customerNotes`:STRING,`movedIn`:STRING,`commission`:STRING,`rebateProcessed`:STRING,`account`:struct<`accountId`:STRING,`hasOnlineMoveIns`:STRING>,`trafficSourceId`:STRING,`callCenter`:STRING,`moveOut`:STRING,`matchScore`:STRING,`moveInActual`:STRING,`firstName`:STRING,`userId`:STRING,`resaleRate`:STRING,`promo`:STRING,`free`:STRING,`phoneFacilityTransfer`:STRING,`matchReasons`:STRING,`eSignType`:STRING,`unitId`:STRING,`termsVersion`:STRING,`hasOnlineMoveIns`:STRING,`eVisitId`:STRING,`email`:STRING,`bookingWidget`:STRING,`bookingAgentId`:STRING,`reviewStatus`:STRING,`alternateNames`:array ,`phone`:STRING,`read`:STRING>,`site_id`:STRING,`isReact`:STRING,`successLabel`:STRING,`label`:STRING,`env`:STRING,`category`:STRING,`failureLabel`:STRING>,`userId`STRING,`messageId`STRING,`sentAt`STRING,`event`STRING,`projectId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`context`struct<`userAgent`:STRING,`timezone`:STRING,`ip`:STRING,`library`:struct<`version`:STRING,`name`:STRING>,`locale`:STRING,`page`:struct<`path`:STRING,`url`:STRING,`referrer`:STRING,`title`:STRING,`search`:STRING>,`userAgentData`:struct<`platform`:STRING,`brands`:array - hive_path: s3://sfdl-segment-ssdc-dev/separated_dt/submit
- id: 4699534
- processed: 1
- raw_data:
{ "_metadata": { "bundled": [ "Google Analytics", "Google Tag Manager", "Segment.io" ], "bundledIds": [ "IAdHmAh2FE", "5ab94e33d7cab31211fc1606" ], "unbundled": [] }, "_origin": "2023-11-17T21:59:05Z|s3://sfdl-segment-ssdc-dev/segment-logs/VCAARGbeZs/1700179200000/1700258136022.events-archiver-480-2..0c293e66-68c4-4dee-ab28-7f9b643183cc.gz|analytics-segment-separator-dev:$LATEST", "anonymousId": "857fecdf-0626-4a89-be22-9c70ad1bb20a", "channel": "client", "context": { "campaign": {}, "ip": "54.175.218.140", "library": { "name": "analytics.js", "version": "next-1.61.0" }, "locale": "en-US", "page": { "path": "/", "referrer": "", "search": "?city=Phoenix&latitude=33.4483771&location=Phoenix%2C%20AZ%2C%20USA&locationSource=google_autocomplete&longitude=-112.0740373&state=AZ&type=storage", "title": "SelfStorage.com: Find Cheap Storage Units Near You", "url": "https://www.selfstorage.moreyard.com/?city=Phoenix&latitude=33.4483771&location=Phoenix%2C%20AZ%2C%20USA&locationSource=google_autocomplete&longitude=-112.0740373&state=AZ&type=storage" }, "timezone": "America/Phoenix", "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.0.0 Safari/537.36", "userAgentData": { "brands": [ { "brand": "Chromium", "version": "118" }, { "brand": "Google Chrome", "version": "118" }, { "brand": "Not=A?Brand", "version": "99" } ], "mobile": false, "platform": "macOS" } }, "event": "submit", "integrations": {}, "messageId": "ajs-next-deaf1d75600dddb9fcd0e81810550ffe", "originalTimestamp": "2023-11-17T21:10:37.625Z", "projectId": "VCAARGbeZs", "properties": { "Hit Timestamp": 1700255437624, "category": "search interactions-homePage", "env": "dev", "isReact": true, "label": "success", "site_id": 27 }, "receivedAt": "2023-11-17T21:10:37.995Z", "sentAt": "2023-11-17T21:10:37.637Z", "timestamp": "2023-11-17T21:10:37.983Z", "type": "track", "userId": "4fdfcbb55c5cd2f2baca427aec45c6c1", "version": 2 } - schema_attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "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.category": "string", "properties.env": "string", "properties.extra.AAAMemberNumber": "string", "properties.extra.account.accountId": "string", "properties.extra.account.hasOnlineMoveIns": "string", "properties.extra.actualD": "string", "properties.extra.actualW": "string", "properties.extra.affiliateId": "string", "properties.extra.alternateEmails": [ "string" ], "properties.extra.alternateFirstNames": [ "string" ], "properties.extra.alternateLastNames": [ "string" ], "properties.extra.alternateNames": [ "string" ], "properties.extra.alternatePhones": [ "string" ], "properties.extra.apiCustId": "string", "properties.extra.apiLeadId": "string", "properties.extra.apiUnitId": "string", "properties.extra.autoState": "string", "properties.extra.baseBid": "string", "properties.extra.bidAmount": "string", "properties.extra.bidType": "string", "properties.extra.bookedUnit.amenities": [ "string" ], "properties.extra.bookedUnit.description.physical.height": "string", "properties.extra.bookedUnit.description.physical.length": "string", "properties.extra.bookedUnit.description.physical.width": "string", "properties.extra.bookedUnit.description.vehicle.only": "string", "properties.extra.bookedUnit.description.vehicle.permitted": "string", "properties.extra.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.bookedUnit.id": "string", "properties.extra.bookedUnit.price.meta": "string", "properties.extra.bookedUnit.promotion": "string", "properties.extra.bookedUnit.reservationDays": "string", "properties.extra.bookedUnit.reservation_days": "string", "properties.extra.bookedUnit.size": "string", "properties.extra.bookedUnit.typeText": "string", "properties.extra.bookedUnit.unitType": "string", "properties.extra.bookingAgent": "string", "properties.extra.bookingAgentId": "string", "properties.extra.bookingState": "string", "properties.extra.bookingType": "string", "properties.extra.bookingWidget": "string", "properties.extra.callCenter": "string", "properties.extra.callCenterNotes": "string", "properties.extra.callCenterTransfer": "string", "properties.extra.callerIdPhone": "string", "properties.extra.canceled": "string", "properties.extra.centershiftAccountId": "string", "properties.extra.commission": "string", "properties.extra.companyCode": "string", "properties.extra.complete": "string", "properties.extra.confirmationCode": "string", "properties.extra.contacted": "string", "properties.extra.corrected": "string", "properties.extra.customerNotes": "string", "properties.extra.depositPaid": "string", "properties.extra.disputeReason": "string", "properties.extra.duplicateOf": "string", "properties.extra.eSignType": "string", "properties.extra.eVisitId": "string", "properties.extra.email": "string", "properties.extra.estimatedRevenue": "string", "properties.extra.facilityGetsNotificationEmails": "string", "properties.extra.facilityId": "string", "properties.extra.facilityLocation.address1": "string", "properties.extra.facilityLocation.address2": "string", "properties.extra.facilityLocation.city": "string", "properties.extra.facilityLocation.country": "string", "properties.extra.facilityLocation.state": "string", "properties.extra.facilityLocation.zip": "string", "properties.extra.facilityName": "string", "properties.extra.facilityPhone": "string", "properties.extra.facilityTenant": "string", "properties.extra.facilityTenantId": "string", "properties.extra.facilitylocation.address1": "string", "properties.extra.facilitylocation.address2": "string", "properties.extra.facilitylocation.city": "string", "properties.extra.facilitylocation.country": "string", "properties.extra.facilitylocation.state": "string", "properties.extra.facilitylocation.zip": "string", "properties.extra.firstName": "string", "properties.extra.free": "string", "properties.extra.hasContactlessMoveins": "string", "properties.extra.hasOnlineMoveIns": "string", "properties.extra.hostedWebsite": "string", "properties.extra.hotLead": "string", "properties.extra.invoiceId": "string", "properties.extra.lastName": "string", "properties.extra.listingWantId": "string", "properties.extra.matchReasons": "string", "properties.extra.matchScore": "string", "properties.extra.meta.title": "string", "properties.extra.modifiedDtm": "string", "properties.extra.monthlyInsurance": "string", "properties.extra.moveIn": "string", "properties.extra.moveInActual": "string", "properties.extra.moveInOriginal": "string", "properties.extra.moveOut": "string", "properties.extra.movedIn": "string", "properties.extra.npv": "string", "properties.extra.omiCompleted": "string", "properties.extra.omiFlowEnabled": "string", "properties.extra.omiPri": "string", "properties.extra.onlineMoveInUrl": "string", "properties.extra.payoutBatchId": "string", "properties.extra.phone": "string", "properties.extra.phoneChangedNumber": "string", "properties.extra.phoneFacilityTransfer": "string", "properties.extra.phoneStatus": "string", "properties.extra.phoneVerified": "string", "properties.extra.pickupTime": "string", "properties.extra.price": "string", "properties.extra.promo": "string", "properties.extra.promoCode": "string", "properties.extra.rawBooking.AAAMemberNumber": "string", "properties.extra.rawBooking.actualD": "string", "properties.extra.rawBooking.actualW": "string", "properties.extra.rawBooking.affiliateId": "string", "properties.extra.rawBooking.alternateEmails": [ "string" ], "properties.extra.rawBooking.alternateFirstNames": [ "string" ], "properties.extra.rawBooking.alternateLastNames": [ "string" ], "properties.extra.rawBooking.alternatePhones": [ "string" ], "properties.extra.rawBooking.apiCustId": "string", "properties.extra.rawBooking.apiLeadId": "string", "properties.extra.rawBooking.apiUnitId": "string", "properties.extra.rawBooking.autoState": "string", "properties.extra.rawBooking.baseBid": "string", "properties.extra.rawBooking.bidAmount": "string", "properties.extra.rawBooking.bidType": "string", "properties.extra.rawBooking.bookedUnit.amenities": [ "string" ], "properties.extra.rawBooking.bookedUnit.description.physical.height": "string", "properties.extra.rawBooking.bookedUnit.description.physical.length": "string", "properties.extra.rawBooking.bookedUnit.description.physical.width": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.only": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.permitted": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.rawBooking.bookedUnit.id": "string", "properties.extra.rawBooking.bookedUnit.price.meta": "string", "properties.extra.rawBooking.bookedUnit.promotion": "string", "properties.extra.rawBooking.bookedUnit.reservation_days": "string", "properties.extra.rawBooking.bookedUnit.unitType": "string", "properties.extra.rawBooking.bookingAgent": "string", "properties.extra.rawBooking.bookingAgentId": "string", "properties.extra.rawBooking.bookingState": "string", "properties.extra.rawBooking.bookingType": "string", "properties.extra.rawBooking.bookingWidget": "string", "properties.extra.rawBooking.callCenter": "string", "properties.extra.rawBooking.callCenterNotes": "string", "properties.extra.rawBooking.callCenterTransfer": "string", "properties.extra.rawBooking.callerIdPhone": "string", "properties.extra.rawBooking.canceled": "string", "properties.extra.rawBooking.centershiftAccountId": "string", "properties.extra.rawBooking.commission": "string", "properties.extra.rawBooking.companyCode": "string", "properties.extra.rawBooking.complete": "string", "properties.extra.rawBooking.confirmationCode": "string", "properties.extra.rawBooking.contacted": "string", "properties.extra.rawBooking.corrected": "string", "properties.extra.rawBooking.customerNotes": "string", "properties.extra.rawBooking.depositPaid": "string", "properties.extra.rawBooking.disputeReason": "string", "properties.extra.rawBooking.duplicateOf": "string", "properties.extra.rawBooking.eSignType": "string", "properties.extra.rawBooking.eVisitId": "string", "properties.extra.rawBooking.email": "string", "properties.extra.rawBooking.estimatedRevenue": "string", "properties.extra.rawBooking.facilityGetsNotificationEmails": "string", "properties.extra.rawBooking.facilityId": "string", "properties.extra.rawBooking.facilityName": "string", "properties.extra.rawBooking.facilityPhone": "string", "properties.extra.rawBooking.facilityTenant": "string", "properties.extra.rawBooking.facilityTenantId": "string", "properties.extra.rawBooking.facilitylocation.address1": "string", "properties.extra.rawBooking.facilitylocation.address2": "string", "properties.extra.rawBooking.facilitylocation.city": "string", "properties.extra.rawBooking.facilitylocation.country": "string", "properties.extra.rawBooking.facilitylocation.state": "string", "properties.extra.rawBooking.facilitylocation.zip": "string", "properties.extra.rawBooking.firstName": "string", "properties.extra.rawBooking.free": "string", "properties.extra.rawBooking.hostedWebsite": "string", "properties.extra.rawBooking.hotLead": "string", "properties.extra.rawBooking.invoiceId": "string", "properties.extra.rawBooking.lastName": "string", "properties.extra.rawBooking.listingWantId": "string", "properties.extra.rawBooking.matchReasons": "string", "properties.extra.rawBooking.matchScore": "string", "properties.extra.rawBooking.modifiedDtm": "string", "properties.extra.rawBooking.monthlyInsurance": "string", "properties.extra.rawBooking.moveIn": "string", "properties.extra.rawBooking.moveInActual": "string", "properties.extra.rawBooking.moveInOriginal": "string", "properties.extra.rawBooking.moveOut": "string", "properties.extra.rawBooking.movedIn": "string", "properties.extra.rawBooking.npv": "string", "properties.extra.rawBooking.payoutBatchId": "string", "properties.extra.rawBooking.phone": "string", "properties.extra.rawBooking.phoneChangedNumber": "string", "properties.extra.rawBooking.phoneFacilityTransfer": "string", "properties.extra.rawBooking.phoneStatus": "string", "properties.extra.rawBooking.phoneVerified": "string", "properties.extra.rawBooking.pickupTime": "string", "properties.extra.rawBooking.price": "string", "properties.extra.rawBooking.promo": "string", "properties.extra.rawBooking.promoCode": "string", "properties.extra.rawBooking.read": "string", "properties.extra.rawBooking.rebateProcessed": "string", "properties.extra.rawBooking.referrerId": "string", "properties.extra.rawBooking.resaleRate": "string", "properties.extra.rawBooking.reviewStatus": "string", "properties.extra.rawBooking.searchWeightId": "string", "properties.extra.rawBooking.searchWeightTestId": "string", "properties.extra.rawBooking.sessionId": "string", "properties.extra.rawBooking.siteId": "string", "properties.extra.rawBooking.sitePhone": "string", "properties.extra.rawBooking.sizeD": "string", "properties.extra.rawBooking.sizeH": "string", "properties.extra.rawBooking.sizeW": "string", "properties.extra.rawBooking.statementId": "string", "properties.extra.rawBooking.termsVersion": "string", "properties.extra.rawBooking.timestamp": "string", "properties.extra.rawBooking.totalPaid": "string", "properties.extra.rawBooking.trafficSourceId": "string", "properties.extra.rawBooking.typeOfListing": "string", "properties.extra.rawBooking.unit.unitIds": [ "string" ], "properties.extra.rawBooking.unitId": "string", "properties.extra.rawBooking.unitNumber": "string", "properties.extra.rawBooking.userId": "string", "properties.extra.rawBooking.visitId": "string", "properties.extra.read": "string", "properties.extra.rebateProcessed": "string", "properties.extra.referrerId": "string", "properties.extra.resaleRate": "string", "properties.extra.reviewStatus": "string", "properties.extra.searchWeightId": "string", "properties.extra.searchWeightTestId": "string", "properties.extra.sessionId": "string", "properties.extra.siteId": "string", "properties.extra.sitePhone": "string", "properties.extra.sizeD": "string", "properties.extra.sizeH": "string", "properties.extra.sizeW": "string", "properties.extra.statementId": "string", "properties.extra.termsVersion": "string", "properties.extra.timestamp": "string", "properties.extra.totalPaid": "string", "properties.extra.trafficSourceId": "string", "properties.extra.typeOfListing": "string", "properties.extra.unit.unitIds": [ "string" ], "properties.extra.unitId": "string", "properties.extra.unitNumber": "string", "properties.extra.userId": "string", "properties.extra.visitId": "string", "properties.failureLabel": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.successLabel": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - schema_name_id: 494
- schema_scan_id: 6351771
- updated: 2023-11-17 16:00:45
Schema Scans: 3
Last at 2025-01-13 01:11:07
-
Scan 6750184
- duration: 0:01:00.393304
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1037, "partitions_applied": false, "success": true } - id: 6750184
- payload:
{ "datatype_dict": { "dt": "date", "originaltimestamp": "timestamp_iso8601", "properties.facilityId": "bigint", "receivedAt": "timestamp_iso8601", "sentat": "timestamp_iso8601", "timestamp": "timestamp_iso8601" }, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-13/", "name": "dt", "type": "string", "value": "2025-01-13" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/submit", "key": "separated_dt/submit/dt=2025-01-13/1736752230499.events-archiver-480-10..15bab840-e856-43f9-83da-403e888df8f7.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_submit", "type": "segment" } } - running: False
- schema_name_id: 494
- start_time: 2025-01-13 01:11:07
- success: True
- trace_id: 4292366186479714891
-
Scan 6581187
- duration: 0:02:06.515481
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1003, "partitions_applied": false, "success": true } - id: 6581187
- payload:
{ "datatype_dict": { "dt": "date", "originaltimestamp": "timestamp_iso8601", "properties.facilityId": "bigint", "receivedAt": "timestamp_iso8601", "sentat": "timestamp_iso8601", "timestamp": "timestamp_iso8601" }, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2024-09-03/", "name": "dt", "type": "string", "value": "2024-09-03" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/submit", "key": "separated_dt/submit/dt=2024-09-03/1725386674550.events-archiver-480-29..556138b8-0369-44ee-9da3-90f9b9e25535.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_submit", "type": "segment" } } - running: False
- schema_name_id: 494
- start_time: 2024-09-03 13:05:00
- success: True
- trace_id: 14915807732529719050
-
Scan 6351771
- duration: 0:01:47.426055
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 924, "partitions_applied": false, "success": true } - id: 6351771
- payload:
{ "datatype_dict": { "dt": "date", "originaltimestamp": "timestamp_iso8601", "properties.facilityId": "bigint", "receivedAt": "timestamp_iso8601", "sentat": "timestamp_iso8601", "timestamp": "timestamp_iso8601" }, "file_format": "json", "is_schema_datatyped": false, "partition": { "location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2023-11-17/", "name": "dt", "type": "string", "value": "2023-11-17" }, "s3": { "bucket": "sfdl-segment-ssdc-dev", "hive_path": "s3://sfdl-segment-ssdc-dev/separated_dt/submit", "key": "separated_dt/submit/dt=2023-11-17/1700258136022.events-archiver-480-2..0c293e66-68c4-4dee-ab28-7f9b643183cc.json.gz" }, "schema": { "name": "sfdl_dev_segment.ssdc_submit", "type": "segment" } } - running: False
- schema_name_id: 494
- start_time: 2023-11-17 15:59:19
- success: True
- trace_id: 3301356781659308965
- count: 3
- ddl:
[ "ALTER TABLE\n `sfdl_dev_segment.ssdc_submit`\nADD\n\n\n PARTITION (dt='2025-01-30') location 's3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-30/'\n PARTITION (dt='2025-01-31') location 's3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-31/'\n PARTITION (dt='2025-02-06') location 's3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-02-06/'\n;" ] - name: dt
- state:
[ { "info": { "id": 287040, "location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-30/", "name": "dt", "value": "2025-01-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-01-30 02:38:11", "last_data": "2025-01-30 07:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 287134, "location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-31/", "name": "dt", "value": "2025-01-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-01-31 01:41:51", "last_data": "2025-01-31 01:47:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } }, { "info": { "id": 287971, "location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-02-06/", "name": "dt", "value": "2025-02-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-02-06 10:17:27", "last_data": "2025-02-06 10:17:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": true } } } ] - type: string
- attributes:
{ "_origin": "string", "anonymousId": "string", "channel": "string", "context.campaign.content": "string", "context.campaign.medium": "string", "context.campaign.name": "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.category": "string", "properties.env": "string", "properties.extra.AAAMemberNumber": "string", "properties.extra.account.accountId": "string", "properties.extra.account.hasOnlineMoveIns": "string", "properties.extra.actualD": "string", "properties.extra.actualW": "string", "properties.extra.affiliateId": "string", "properties.extra.alternateEmails": [ "string" ], "properties.extra.alternateFirstNames": [ "string" ], "properties.extra.alternateLastNames": [ "string" ], "properties.extra.alternateNames": [ "string" ], "properties.extra.alternatePhones": [ "string" ], "properties.extra.apiCustId": "string", "properties.extra.apiLeadId": "string", "properties.extra.apiUnitId": "string", "properties.extra.autoState": "string", "properties.extra.baseBid": "string", "properties.extra.bidAmount": "string", "properties.extra.bidType": "string", "properties.extra.bookedUnit.amenities": [ "string" ], "properties.extra.bookedUnit.description.physical.height": "string", "properties.extra.bookedUnit.description.physical.length": "string", "properties.extra.bookedUnit.description.physical.width": "string", "properties.extra.bookedUnit.description.vehicle.only": "string", "properties.extra.bookedUnit.description.vehicle.permitted": "string", "properties.extra.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.bookedUnit.id": "string", "properties.extra.bookedUnit.price.meta": "string", "properties.extra.bookedUnit.promotion": "string", "properties.extra.bookedUnit.reservationDays": "string", "properties.extra.bookedUnit.reservation_days": "string", "properties.extra.bookedUnit.size": "string", "properties.extra.bookedUnit.typeText": "string", "properties.extra.bookedUnit.unitType": "string", "properties.extra.bookingAgent": "string", "properties.extra.bookingAgentId": "string", "properties.extra.bookingAuth": "string", "properties.extra.bookingState": "string", "properties.extra.bookingType": "string", "properties.extra.bookingWidget": "string", "properties.extra.callCenter": "string", "properties.extra.callCenterNotes": "string", "properties.extra.callCenterTransfer": "string", "properties.extra.callerIdPhone": "string", "properties.extra.canceled": "string", "properties.extra.centershiftAccountId": "string", "properties.extra.commission": "string", "properties.extra.companyCode": "string", "properties.extra.complete": "string", "properties.extra.confirmationCode": "string", "properties.extra.contacted": "string", "properties.extra.corrected": "string", "properties.extra.customerNotes": "string", "properties.extra.depositPaid": "string", "properties.extra.disputeReason": "string", "properties.extra.duplicateOf": "string", "properties.extra.eSignType": "string", "properties.extra.eVisitId": "string", "properties.extra.email": "string", "properties.extra.estimatedRevenue": "string", "properties.extra.facilityGetsNotificationEmails": "string", "properties.extra.facilityId": "string", "properties.extra.facilityLocation.address1": "string", "properties.extra.facilityLocation.address2": "string", "properties.extra.facilityLocation.city": "string", "properties.extra.facilityLocation.country": "string", "properties.extra.facilityLocation.state": "string", "properties.extra.facilityLocation.zip": "string", "properties.extra.facilityName": "string", "properties.extra.facilityPhone": "string", "properties.extra.facilityTenant": "string", "properties.extra.facilityTenantId": "string", "properties.extra.facilitylocation.address1": "string", "properties.extra.facilitylocation.address2": "string", "properties.extra.facilitylocation.city": "string", "properties.extra.facilitylocation.country": "string", "properties.extra.facilitylocation.state": "string", "properties.extra.facilitylocation.zip": "string", "properties.extra.firstName": "string", "properties.extra.free": "string", "properties.extra.hasContactlessMoveins": "string", "properties.extra.hasOnlineMoveIns": "string", "properties.extra.hostedWebsite": "string", "properties.extra.hotLead": "string", "properties.extra.invoiceId": "string", "properties.extra.lastName": "string", "properties.extra.listingWantId": "string", "properties.extra.matchReasons": "string", "properties.extra.matchScore": "string", "properties.extra.meta.title": "string", "properties.extra.modifiedDtm": "string", "properties.extra.monthlyInsurance": "string", "properties.extra.moveIn": "string", "properties.extra.moveInActual": "string", "properties.extra.moveInOriginal": "string", "properties.extra.moveOut": "string", "properties.extra.movedIn": "string", "properties.extra.npv": "string", "properties.extra.omiAttributes.facility": "string", "properties.extra.omiAttributes.organization": "string", "properties.extra.omiAttributes.provider": "string", "properties.extra.omiAttributes.reservation": "string", "properties.extra.omiAttributes.unit": "string", "properties.extra.omiCompleted": "string", "properties.extra.omiFlowEnabled": "string", "properties.extra.omiPri": "string", "properties.extra.onlineMoveInUrl": "string", "properties.extra.payoutBatchId": "string", "properties.extra.phone": "string", "properties.extra.phoneChangedNumber": "string", "properties.extra.phoneFacilityTransfer": "string", "properties.extra.phoneStatus": "string", "properties.extra.phoneVerified": "string", "properties.extra.pickupTime": "string", "properties.extra.price": "string", "properties.extra.promo": "string", "properties.extra.promoCode": "string", "properties.extra.rawBooking.AAAMemberNumber": "string", "properties.extra.rawBooking.actualD": "string", "properties.extra.rawBooking.actualW": "string", "properties.extra.rawBooking.affiliateId": "string", "properties.extra.rawBooking.alternateEmails": [ "string" ], "properties.extra.rawBooking.alternateFirstNames": [ "string" ], "properties.extra.rawBooking.alternateLastNames": [ "string" ], "properties.extra.rawBooking.alternatePhones": [ "string" ], "properties.extra.rawBooking.apiCustId": "string", "properties.extra.rawBooking.apiLeadId": "string", "properties.extra.rawBooking.apiUnitId": "string", "properties.extra.rawBooking.autoState": "string", "properties.extra.rawBooking.baseBid": "string", "properties.extra.rawBooking.bidAmount": "string", "properties.extra.rawBooking.bidType": "string", "properties.extra.rawBooking.bookedUnit.amenities": [ "string" ], "properties.extra.rawBooking.bookedUnit.description.physical.height": "string", "properties.extra.rawBooking.bookedUnit.description.physical.length": "string", "properties.extra.rawBooking.bookedUnit.description.physical.width": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.only": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.permitted": "string", "properties.extra.rawBooking.bookedUnit.description.vehicle.warehouse": "string", "properties.extra.rawBooking.bookedUnit.id": "string", "properties.extra.rawBooking.bookedUnit.price.meta": "string", "properties.extra.rawBooking.bookedUnit.promotion": "string", "properties.extra.rawBooking.bookedUnit.reservation_days": "string", "properties.extra.rawBooking.bookedUnit.unitType": "string", "properties.extra.rawBooking.bookingAgent": "string", "properties.extra.rawBooking.bookingAgentId": "string", "properties.extra.rawBooking.bookingState": "string", "properties.extra.rawBooking.bookingType": "string", "properties.extra.rawBooking.bookingWidget": "string", "properties.extra.rawBooking.callCenter": "string", "properties.extra.rawBooking.callCenterNotes": "string", "properties.extra.rawBooking.callCenterTransfer": "string", "properties.extra.rawBooking.callerIdPhone": "string", "properties.extra.rawBooking.canceled": "string", "properties.extra.rawBooking.centershiftAccountId": "string", "properties.extra.rawBooking.commission": "string", "properties.extra.rawBooking.companyCode": "string", "properties.extra.rawBooking.complete": "string", "properties.extra.rawBooking.confirmationCode": "string", "properties.extra.rawBooking.contacted": "string", "properties.extra.rawBooking.corrected": "string", "properties.extra.rawBooking.customerNotes": "string", "properties.extra.rawBooking.depositPaid": "string", "properties.extra.rawBooking.disputeReason": "string", "properties.extra.rawBooking.duplicateOf": "string", "properties.extra.rawBooking.eSignType": "string", "properties.extra.rawBooking.eVisitId": "string", "properties.extra.rawBooking.email": "string", "properties.extra.rawBooking.estimatedRevenue": "string", "properties.extra.rawBooking.facilityGetsNotificationEmails": "string", "properties.extra.rawBooking.facilityId": "string", "properties.extra.rawBooking.facilityName": "string", "properties.extra.rawBooking.facilityPhone": "string", "properties.extra.rawBooking.facilityTenant": "string", "properties.extra.rawBooking.facilityTenantId": "string", "properties.extra.rawBooking.facilitylocation.address1": "string", "properties.extra.rawBooking.facilitylocation.address2": "string", "properties.extra.rawBooking.facilitylocation.city": "string", "properties.extra.rawBooking.facilitylocation.country": "string", "properties.extra.rawBooking.facilitylocation.state": "string", "properties.extra.rawBooking.facilitylocation.zip": "string", "properties.extra.rawBooking.firstName": "string", "properties.extra.rawBooking.free": "string", "properties.extra.rawBooking.hostedWebsite": "string", "properties.extra.rawBooking.hotLead": "string", "properties.extra.rawBooking.invoiceId": "string", "properties.extra.rawBooking.lastName": "string", "properties.extra.rawBooking.listingWantId": "string", "properties.extra.rawBooking.matchReasons": "string", "properties.extra.rawBooking.matchScore": "string", "properties.extra.rawBooking.modifiedDtm": "string", "properties.extra.rawBooking.monthlyInsurance": "string", "properties.extra.rawBooking.moveIn": "string", "properties.extra.rawBooking.moveInActual": "string", "properties.extra.rawBooking.moveInOriginal": "string", "properties.extra.rawBooking.moveOut": "string", "properties.extra.rawBooking.movedIn": "string", "properties.extra.rawBooking.npv": "string", "properties.extra.rawBooking.payoutBatchId": "string", "properties.extra.rawBooking.phone": "string", "properties.extra.rawBooking.phoneChangedNumber": "string", "properties.extra.rawBooking.phoneFacilityTransfer": "string", "properties.extra.rawBooking.phoneStatus": "string", "properties.extra.rawBooking.phoneVerified": "string", "properties.extra.rawBooking.pickupTime": "string", "properties.extra.rawBooking.price": "string", "properties.extra.rawBooking.promo": "string", "properties.extra.rawBooking.promoCode": "string", "properties.extra.rawBooking.read": "string", "properties.extra.rawBooking.rebateProcessed": "string", "properties.extra.rawBooking.referrerId": "string", "properties.extra.rawBooking.resaleRate": "string", "properties.extra.rawBooking.reviewStatus": "string", "properties.extra.rawBooking.searchWeightId": "string", "properties.extra.rawBooking.searchWeightTestId": "string", "properties.extra.rawBooking.sessionId": "string", "properties.extra.rawBooking.siteId": "string", "properties.extra.rawBooking.sitePhone": "string", "properties.extra.rawBooking.sizeD": "string", "properties.extra.rawBooking.sizeH": "string", "properties.extra.rawBooking.sizeW": "string", "properties.extra.rawBooking.statementId": "string", "properties.extra.rawBooking.termsVersion": "string", "properties.extra.rawBooking.timestamp": "string", "properties.extra.rawBooking.totalPaid": "string", "properties.extra.rawBooking.trafficSourceId": "string", "properties.extra.rawBooking.typeOfListing": "string", "properties.extra.rawBooking.unit.unitIds": [ "string" ], "properties.extra.rawBooking.unitId": "string", "properties.extra.rawBooking.unitNumber": "string", "properties.extra.rawBooking.userId": "string", "properties.extra.rawBooking.visitId": "string", "properties.extra.read": "string", "properties.extra.rebateProcessed": "string", "properties.extra.referrerId": "string", "properties.extra.resaleRate": "string", "properties.extra.reviewStatus": "string", "properties.extra.searchWeightId": "string", "properties.extra.searchWeightTestId": "string", "properties.extra.sessionId": "string", "properties.extra.siteId": "string", "properties.extra.sitePhone": "string", "properties.extra.sizeD": "string", "properties.extra.sizeH": "string", "properties.extra.sizeW": "string", "properties.extra.statementId": "string", "properties.extra.termsVersion": "string", "properties.extra.timestamp": "string", "properties.extra.totalPaid": "string", "properties.extra.trafficSourceId": "string", "properties.extra.typeOfListing": "string", "properties.extra.unit.unitIds": [ "string" ], "properties.extra.unitId": "string", "properties.extra.unitNumber": "string", "properties.extra.userId": "string", "properties.extra.visitId": "string", "properties.failureLabel": "string", "properties.isReact": "string", "properties.label": "string", "properties.site_id": "string", "properties.successLabel": "string", "receivedAt": "string", "sentAt": "string", "timestamp": "string", "type": "string", "userId": "string", "version": "string" } - created: 2025-01-13 01:11:14
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_submit`\n(\n`event`STRING,`_origin`STRING,`properties`struct<`label`:STRING,`category`:STRING,`failureLabel`:STRING,`successLabel`:STRING,`site_id`:STRING,`env`:STRING,`extra`:struct<`promoCode`:STRING,`statementId`:STRING,`facilitylocation`:struct<`zip`:STRING,`address1`:STRING,`country`:STRING,`address2`:STRING,`city`:STRING,`state`:STRING>,`unit`:struct<`unitIds`:array>,`npv`:STRING,`sitePhone`:STRING,`affiliateId`:STRING,`facilityId`:STRING,`matchScore`:STRING,`contacted`:STRING,`bookingAuth`:STRING,`alternateNames`:array ,`eSignType`:STRING,`actualW`:STRING,`complete`:STRING,`actualD`:STRING,`matchReasons`:STRING,`free`:STRING,`bookingAgentId`:STRING,`callCenterNotes`:STRING,`autoState`:STRING,`duplicateOf`:STRING,`siteId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`amenities`:array ,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>>,`reservation_days`:STRING,`id`:STRING,`size`:STRING,`unitType`:STRING,`price`:struct<`meta`:STRING>,`typeText`:STRING,`reservationDays`:STRING>,`typeOfListing`:STRING,`timestamp`:STRING,`canceled`:STRING,`invoiceId`:STRING,`facilityLocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`facilityTenantId`:STRING,`bookingState`:STRING,`termsVersion`:STRING,`customerNotes`:STRING,`depositPaid`:STRING,`phoneStatus`:STRING,`callerIdPhone`:STRING,`lastName`:STRING,`apiLeadId`:STRING,`confirmationCode`:STRING,`price`:STRING,`facilityTenant`:STRING,`corrected`:STRING,`phoneFacilityTransfer`:STRING,`onlineMoveInUrl`:STRING,`resaleRate`:STRING,`bidType`:STRING,`promo`:STRING,`facilityPhone`:STRING,`AAAMemberNumber`:STRING,`moveInOriginal`:STRING,`centershiftAccountId`:STRING,`trafficSourceId`:STRING,`unitNumber`:STRING,`eVisitId`:STRING,`omiPri`:STRING,`modifiedDtm`:STRING,`visitId`:STRING,`rawBooking`:struct<`facilityGetsNotificationEmails`:STRING,`contacted`:STRING,`baseBid`:STRING,`userId`:STRING,`affiliateId`:STRING,`eSignType`:STRING,`typeOfListing`:STRING,`hostedWebsite`:STRING,`visitId`:STRING,`unitId`:STRING,`hotLead`:STRING,`callCenter`:STRING,`sitePhone`:STRING,`alternateFirstNames`:array ,`facilityPhone`:STRING,`apiCustId`:STRING,`reviewStatus`:STRING,`read`:STRING,`timestamp`:STRING,`alternatePhones`:array ,`callCenterTransfer`:STRING,`sizeD`:STRING,`confirmationCode`:STRING,`duplicateOf`:STRING,`matchScore`:STRING,`sizeH`:STRING,`movedIn`:STRING,`moveInOriginal`:STRING,`companyCode`:STRING,`centershiftAccountId`:STRING,`facilityId`:STRING,`callCenterNotes`:STRING,`apiLeadId`:STRING,`totalPaid`:STRING,`bookingAgent`:STRING,`resaleRate`:STRING,`AAAMemberNumber`:STRING,`email`:STRING,`depositPaid`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>,`physical`:struct<`width`:STRING,`length`:STRING,`height`:STRING>>,`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array ,`promotion`:STRING,`id`:STRING>,`free`:STRING,`autoState`:STRING,`facilityTenantId`:STRING,`listingWantId`:STRING,`lastName`:STRING,`promoCode`:STRING,`phoneChangedNumber`:STRING,`statementId`:STRING,`rebateProcessed`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`monthlyInsurance`:STRING,`bookingType`:STRING,`unit`:struct<`unitIds`:array >,`bookingWidget`:STRING,`customerNotes`:STRING,`commission`:STRING,`estimatedRevenue`:STRING,`searchWeightTestId`:STRING,`facilityTenant`:STRING,`complete`:STRING,`bidType`:STRING,`facilitylocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`corrected`:STRING,`alternateEmails`:array ,`phone`:STRING,`pickupTime`:STRING,`actualD`:STRING,`firstName`:STRING,`bookingState`:STRING,`bidAmount`:STRING,`phoneFacilityTransfer`:STRING,`phoneVerified`:STRING,`actualW`:STRING,`moveIn`:STRING,`moveOut`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`canceled`:STRING,`sizeW`:STRING,`alternateLastNames`:array ,`callerIdPhone`:STRING,`apiUnitId`:STRING,`termsVersion`:STRING,`facilityName`:STRING,`modifiedDtm`:STRING,`invoiceId`:STRING,`promo`:STRING,`trafficSourceId`:STRING,`price`:STRING,`payoutBatchId`:STRING,`unitNumber`:STRING,`phoneStatus`:STRING,`npv`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`searchWeightId`:STRING,`bookingAgentId`:STRING,`siteId`:STRING>,`movedIn`:STRING,`apiUnitId`:STRING,`estimatedRevenue`:STRING,`meta`:struct<`title`:STRING>,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`phone`:STRING,`read`:STRING,`apiCustId`:STRING,`alternateLastNames`:array ,`moveInActual`:STRING,`facilityGetsNotificationEmails`:STRING,`unitId`:STRING,`firstName`:STRING,`alternateFirstNames`:array ,`reviewStatus`:STRING,`commission`:STRING,`sessionId`:STRING,`companyCode`:STRING,`hostedWebsite`:STRING,`bidAmount`:STRING,`facilityName`:STRING,`totalPaid`:STRING,`sizeH`:STRING,`bookingAgent`:STRING,`listingWantId`:STRING,`referrerId`:STRING,`bookingWidget`:STRING,`callCenterTransfer`:STRING,`phoneVerified`:STRING,`hotLead`:STRING,`moveOut`:STRING,`alternatePhones`:array ,`alternateEmails`:array ,`phoneChangedNumber`:STRING,`disputeReason`:STRING,`payoutBatchId`:STRING,`userId`:STRING,`sizeD`:STRING,`omiCompleted`:STRING,`searchWeightTestId`:STRING,`omiFlowEnabled`:STRING,`hasOnlineMoveIns`:STRING,`hasContactlessMoveins`:STRING,`baseBid`:STRING,`omiAttributes`:struct<`facility`:STRING,`organization`:STRING,`unit`:STRING,`reservation`:STRING,`provider`:STRING>,`monthlyInsurance`:STRING,`pickupTime`:STRING,`sizeW`:STRING,`rebateProcessed`:STRING,`searchWeightId`:STRING,`callCenter`:STRING,`email`:STRING,`bookingType`:STRING,`moveIn`:STRING>,`isReact`:STRING,`Hit_Timestamp`:STRING>,`integrations`struct<`_empty_`:STRING>,`sentAt`STRING,`type`STRING,`channel`STRING,`version`STRING,`receivedAt`STRING,`userId`STRING,`context`struct<`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING,`userAgentData`:struct<`brands`:array ,`unbundled`:array >,`timestamp`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-ssdc-dev/separated_dt/submit'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_submit`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_submit" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2017-12-11 14:13:56",
"disabled": false,
"format": "raw",
"id": 494,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_segment",
"table": "ssdc_submit"
},
"type": "segment"
},
"partition": {
"count": 3,
"ddl": [
"ALTER TABLE\n `sfdl_dev_segment.ssdc_submit`\nADD\n\n\n PARTITION (dt='2025-01-30') location 's3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-30/'\n PARTITION (dt='2025-01-31') location 's3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-31/'\n PARTITION (dt='2025-02-06') location 's3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-02-06/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 287040,
"location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-30/",
"name": "dt",
"value": "2025-01-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-01-30 02:38:11",
"last_data": "2025-01-30 07:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 287134,
"location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-01-31/",
"name": "dt",
"value": "2025-01-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-01-31 01:41:51",
"last_data": "2025-01-31 01:47:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": true
}
}
},
{
"info": {
"id": 287971,
"location": "s3://sfdl-segment-ssdc-dev/separated_dt/submit/dt=2025-02-06/",
"name": "dt",
"value": "2025-02-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-02-06 10:17:27",
"last_data": "2025-02-06 10:17:27"
},
"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.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.category": "string",
"properties.env": "string",
"properties.extra.AAAMemberNumber": "string",
"properties.extra.account.accountId": "string",
"properties.extra.account.hasOnlineMoveIns": "string",
"properties.extra.actualD": "string",
"properties.extra.actualW": "string",
"properties.extra.affiliateId": "string",
"properties.extra.alternateEmails": [
"string"
],
"properties.extra.alternateFirstNames": [
"string"
],
"properties.extra.alternateLastNames": [
"string"
],
"properties.extra.alternateNames": [
"string"
],
"properties.extra.alternatePhones": [
"string"
],
"properties.extra.apiCustId": "string",
"properties.extra.apiLeadId": "string",
"properties.extra.apiUnitId": "string",
"properties.extra.autoState": "string",
"properties.extra.baseBid": "string",
"properties.extra.bidAmount": "string",
"properties.extra.bidType": "string",
"properties.extra.bookedUnit.amenities": [
"string"
],
"properties.extra.bookedUnit.description.physical.height": "string",
"properties.extra.bookedUnit.description.physical.length": "string",
"properties.extra.bookedUnit.description.physical.width": "string",
"properties.extra.bookedUnit.description.vehicle.only": "string",
"properties.extra.bookedUnit.description.vehicle.permitted": "string",
"properties.extra.bookedUnit.description.vehicle.warehouse": "string",
"properties.extra.bookedUnit.id": "string",
"properties.extra.bookedUnit.price.meta": "string",
"properties.extra.bookedUnit.promotion": "string",
"properties.extra.bookedUnit.reservationDays": "string",
"properties.extra.bookedUnit.reservation_days": "string",
"properties.extra.bookedUnit.size": "string",
"properties.extra.bookedUnit.typeText": "string",
"properties.extra.bookedUnit.unitType": "string",
"properties.extra.bookingAgent": "string",
"properties.extra.bookingAgentId": "string",
"properties.extra.bookingAuth": "string",
"properties.extra.bookingState": "string",
"properties.extra.bookingType": "string",
"properties.extra.bookingWidget": "string",
"properties.extra.callCenter": "string",
"properties.extra.callCenterNotes": "string",
"properties.extra.callCenterTransfer": "string",
"properties.extra.callerIdPhone": "string",
"properties.extra.canceled": "string",
"properties.extra.centershiftAccountId": "string",
"properties.extra.commission": "string",
"properties.extra.companyCode": "string",
"properties.extra.complete": "string",
"properties.extra.confirmationCode": "string",
"properties.extra.contacted": "string",
"properties.extra.corrected": "string",
"properties.extra.customerNotes": "string",
"properties.extra.depositPaid": "string",
"properties.extra.disputeReason": "string",
"properties.extra.duplicateOf": "string",
"properties.extra.eSignType": "string",
"properties.extra.eVisitId": "string",
"properties.extra.email": "string",
"properties.extra.estimatedRevenue": "string",
"properties.extra.facilityGetsNotificationEmails": "string",
"properties.extra.facilityId": "string",
"properties.extra.facilityLocation.address1": "string",
"properties.extra.facilityLocation.address2": "string",
"properties.extra.facilityLocation.city": "string",
"properties.extra.facilityLocation.country": "string",
"properties.extra.facilityLocation.state": "string",
"properties.extra.facilityLocation.zip": "string",
"properties.extra.facilityName": "string",
"properties.extra.facilityPhone": "string",
"properties.extra.facilityTenant": "string",
"properties.extra.facilityTenantId": "string",
"properties.extra.facilitylocation.address1": "string",
"properties.extra.facilitylocation.address2": "string",
"properties.extra.facilitylocation.city": "string",
"properties.extra.facilitylocation.country": "string",
"properties.extra.facilitylocation.state": "string",
"properties.extra.facilitylocation.zip": "string",
"properties.extra.firstName": "string",
"properties.extra.free": "string",
"properties.extra.hasContactlessMoveins": "string",
"properties.extra.hasOnlineMoveIns": "string",
"properties.extra.hostedWebsite": "string",
"properties.extra.hotLead": "string",
"properties.extra.invoiceId": "string",
"properties.extra.lastName": "string",
"properties.extra.listingWantId": "string",
"properties.extra.matchReasons": "string",
"properties.extra.matchScore": "string",
"properties.extra.meta.title": "string",
"properties.extra.modifiedDtm": "string",
"properties.extra.monthlyInsurance": "string",
"properties.extra.moveIn": "string",
"properties.extra.moveInActual": "string",
"properties.extra.moveInOriginal": "string",
"properties.extra.moveOut": "string",
"properties.extra.movedIn": "string",
"properties.extra.npv": "string",
"properties.extra.omiAttributes.facility": "string",
"properties.extra.omiAttributes.organization": "string",
"properties.extra.omiAttributes.provider": "string",
"properties.extra.omiAttributes.reservation": "string",
"properties.extra.omiAttributes.unit": "string",
"properties.extra.omiCompleted": "string",
"properties.extra.omiFlowEnabled": "string",
"properties.extra.omiPri": "string",
"properties.extra.onlineMoveInUrl": "string",
"properties.extra.payoutBatchId": "string",
"properties.extra.phone": "string",
"properties.extra.phoneChangedNumber": "string",
"properties.extra.phoneFacilityTransfer": "string",
"properties.extra.phoneStatus": "string",
"properties.extra.phoneVerified": "string",
"properties.extra.pickupTime": "string",
"properties.extra.price": "string",
"properties.extra.promo": "string",
"properties.extra.promoCode": "string",
"properties.extra.rawBooking.AAAMemberNumber": "string",
"properties.extra.rawBooking.actualD": "string",
"properties.extra.rawBooking.actualW": "string",
"properties.extra.rawBooking.affiliateId": "string",
"properties.extra.rawBooking.alternateEmails": [
"string"
],
"properties.extra.rawBooking.alternateFirstNames": [
"string"
],
"properties.extra.rawBooking.alternateLastNames": [
"string"
],
"properties.extra.rawBooking.alternatePhones": [
"string"
],
"properties.extra.rawBooking.apiCustId": "string",
"properties.extra.rawBooking.apiLeadId": "string",
"properties.extra.rawBooking.apiUnitId": "string",
"properties.extra.rawBooking.autoState": "string",
"properties.extra.rawBooking.baseBid": "string",
"properties.extra.rawBooking.bidAmount": "string",
"properties.extra.rawBooking.bidType": "string",
"properties.extra.rawBooking.bookedUnit.amenities": [
"string"
],
"properties.extra.rawBooking.bookedUnit.description.physical.height": "string",
"properties.extra.rawBooking.bookedUnit.description.physical.length": "string",
"properties.extra.rawBooking.bookedUnit.description.physical.width": "string",
"properties.extra.rawBooking.bookedUnit.description.vehicle.only": "string",
"properties.extra.rawBooking.bookedUnit.description.vehicle.permitted": "string",
"properties.extra.rawBooking.bookedUnit.description.vehicle.warehouse": "string",
"properties.extra.rawBooking.bookedUnit.id": "string",
"properties.extra.rawBooking.bookedUnit.price.meta": "string",
"properties.extra.rawBooking.bookedUnit.promotion": "string",
"properties.extra.rawBooking.bookedUnit.reservation_days": "string",
"properties.extra.rawBooking.bookedUnit.unitType": "string",
"properties.extra.rawBooking.bookingAgent": "string",
"properties.extra.rawBooking.bookingAgentId": "string",
"properties.extra.rawBooking.bookingState": "string",
"properties.extra.rawBooking.bookingType": "string",
"properties.extra.rawBooking.bookingWidget": "string",
"properties.extra.rawBooking.callCenter": "string",
"properties.extra.rawBooking.callCenterNotes": "string",
"properties.extra.rawBooking.callCenterTransfer": "string",
"properties.extra.rawBooking.callerIdPhone": "string",
"properties.extra.rawBooking.canceled": "string",
"properties.extra.rawBooking.centershiftAccountId": "string",
"properties.extra.rawBooking.commission": "string",
"properties.extra.rawBooking.companyCode": "string",
"properties.extra.rawBooking.complete": "string",
"properties.extra.rawBooking.confirmationCode": "string",
"properties.extra.rawBooking.contacted": "string",
"properties.extra.rawBooking.corrected": "string",
"properties.extra.rawBooking.customerNotes": "string",
"properties.extra.rawBooking.depositPaid": "string",
"properties.extra.rawBooking.disputeReason": "string",
"properties.extra.rawBooking.duplicateOf": "string",
"properties.extra.rawBooking.eSignType": "string",
"properties.extra.rawBooking.eVisitId": "string",
"properties.extra.rawBooking.email": "string",
"properties.extra.rawBooking.estimatedRevenue": "string",
"properties.extra.rawBooking.facilityGetsNotificationEmails": "string",
"properties.extra.rawBooking.facilityId": "string",
"properties.extra.rawBooking.facilityName": "string",
"properties.extra.rawBooking.facilityPhone": "string",
"properties.extra.rawBooking.facilityTenant": "string",
"properties.extra.rawBooking.facilityTenantId": "string",
"properties.extra.rawBooking.facilitylocation.address1": "string",
"properties.extra.rawBooking.facilitylocation.address2": "string",
"properties.extra.rawBooking.facilitylocation.city": "string",
"properties.extra.rawBooking.facilitylocation.country": "string",
"properties.extra.rawBooking.facilitylocation.state": "string",
"properties.extra.rawBooking.facilitylocation.zip": "string",
"properties.extra.rawBooking.firstName": "string",
"properties.extra.rawBooking.free": "string",
"properties.extra.rawBooking.hostedWebsite": "string",
"properties.extra.rawBooking.hotLead": "string",
"properties.extra.rawBooking.invoiceId": "string",
"properties.extra.rawBooking.lastName": "string",
"properties.extra.rawBooking.listingWantId": "string",
"properties.extra.rawBooking.matchReasons": "string",
"properties.extra.rawBooking.matchScore": "string",
"properties.extra.rawBooking.modifiedDtm": "string",
"properties.extra.rawBooking.monthlyInsurance": "string",
"properties.extra.rawBooking.moveIn": "string",
"properties.extra.rawBooking.moveInActual": "string",
"properties.extra.rawBooking.moveInOriginal": "string",
"properties.extra.rawBooking.moveOut": "string",
"properties.extra.rawBooking.movedIn": "string",
"properties.extra.rawBooking.npv": "string",
"properties.extra.rawBooking.payoutBatchId": "string",
"properties.extra.rawBooking.phone": "string",
"properties.extra.rawBooking.phoneChangedNumber": "string",
"properties.extra.rawBooking.phoneFacilityTransfer": "string",
"properties.extra.rawBooking.phoneStatus": "string",
"properties.extra.rawBooking.phoneVerified": "string",
"properties.extra.rawBooking.pickupTime": "string",
"properties.extra.rawBooking.price": "string",
"properties.extra.rawBooking.promo": "string",
"properties.extra.rawBooking.promoCode": "string",
"properties.extra.rawBooking.read": "string",
"properties.extra.rawBooking.rebateProcessed": "string",
"properties.extra.rawBooking.referrerId": "string",
"properties.extra.rawBooking.resaleRate": "string",
"properties.extra.rawBooking.reviewStatus": "string",
"properties.extra.rawBooking.searchWeightId": "string",
"properties.extra.rawBooking.searchWeightTestId": "string",
"properties.extra.rawBooking.sessionId": "string",
"properties.extra.rawBooking.siteId": "string",
"properties.extra.rawBooking.sitePhone": "string",
"properties.extra.rawBooking.sizeD": "string",
"properties.extra.rawBooking.sizeH": "string",
"properties.extra.rawBooking.sizeW": "string",
"properties.extra.rawBooking.statementId": "string",
"properties.extra.rawBooking.termsVersion": "string",
"properties.extra.rawBooking.timestamp": "string",
"properties.extra.rawBooking.totalPaid": "string",
"properties.extra.rawBooking.trafficSourceId": "string",
"properties.extra.rawBooking.typeOfListing": "string",
"properties.extra.rawBooking.unit.unitIds": [
"string"
],
"properties.extra.rawBooking.unitId": "string",
"properties.extra.rawBooking.unitNumber": "string",
"properties.extra.rawBooking.userId": "string",
"properties.extra.rawBooking.visitId": "string",
"properties.extra.read": "string",
"properties.extra.rebateProcessed": "string",
"properties.extra.referrerId": "string",
"properties.extra.resaleRate": "string",
"properties.extra.reviewStatus": "string",
"properties.extra.searchWeightId": "string",
"properties.extra.searchWeightTestId": "string",
"properties.extra.sessionId": "string",
"properties.extra.siteId": "string",
"properties.extra.sitePhone": "string",
"properties.extra.sizeD": "string",
"properties.extra.sizeH": "string",
"properties.extra.sizeW": "string",
"properties.extra.statementId": "string",
"properties.extra.termsVersion": "string",
"properties.extra.timestamp": "string",
"properties.extra.totalPaid": "string",
"properties.extra.trafficSourceId": "string",
"properties.extra.typeOfListing": "string",
"properties.extra.unit.unitIds": [
"string"
],
"properties.extra.unitId": "string",
"properties.extra.unitNumber": "string",
"properties.extra.userId": "string",
"properties.extra.visitId": "string",
"properties.failureLabel": "string",
"properties.isReact": "string",
"properties.label": "string",
"properties.site_id": "string",
"properties.successLabel": "string",
"receivedAt": "string",
"sentAt": "string",
"timestamp": "string",
"type": "string",
"userId": "string",
"version": "string"
},
"created": "2025-01-13 01:11:14",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_segment`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_segment.ssdc_submit`\n(\n`event`STRING,`_origin`STRING,`properties`struct<`label`:STRING,`category`:STRING,`failureLabel`:STRING,`successLabel`:STRING,`site_id`:STRING,`env`:STRING,`extra`:struct<`promoCode`:STRING,`statementId`:STRING,`facilitylocation`:struct<`zip`:STRING,`address1`:STRING,`country`:STRING,`address2`:STRING,`city`:STRING,`state`:STRING>,`unit`:struct<`unitIds`:array>,`npv`:STRING,`sitePhone`:STRING,`affiliateId`:STRING,`facilityId`:STRING,`matchScore`:STRING,`contacted`:STRING,`bookingAuth`:STRING,`alternateNames`:array,`eSignType`:STRING,`actualW`:STRING,`complete`:STRING,`actualD`:STRING,`matchReasons`:STRING,`free`:STRING,`bookingAgentId`:STRING,`callCenterNotes`:STRING,`autoState`:STRING,`duplicateOf`:STRING,`siteId`:STRING,`bookedUnit`:struct<`promotion`:STRING,`amenities`:array,`description`:struct<`physical`:struct<`width`:STRING,`height`:STRING,`length`:STRING>,`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>>,`reservation_days`:STRING,`id`:STRING,`size`:STRING,`unitType`:STRING,`price`:struct<`meta`:STRING>,`typeText`:STRING,`reservationDays`:STRING>,`typeOfListing`:STRING,`timestamp`:STRING,`canceled`:STRING,`invoiceId`:STRING,`facilityLocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`facilityTenantId`:STRING,`bookingState`:STRING,`termsVersion`:STRING,`customerNotes`:STRING,`depositPaid`:STRING,`phoneStatus`:STRING,`callerIdPhone`:STRING,`lastName`:STRING,`apiLeadId`:STRING,`confirmationCode`:STRING,`price`:STRING,`facilityTenant`:STRING,`corrected`:STRING,`phoneFacilityTransfer`:STRING,`onlineMoveInUrl`:STRING,`resaleRate`:STRING,`bidType`:STRING,`promo`:STRING,`facilityPhone`:STRING,`AAAMemberNumber`:STRING,`moveInOriginal`:STRING,`centershiftAccountId`:STRING,`trafficSourceId`:STRING,`unitNumber`:STRING,`eVisitId`:STRING,`omiPri`:STRING,`modifiedDtm`:STRING,`visitId`:STRING,`rawBooking`:struct<`facilityGetsNotificationEmails`:STRING,`contacted`:STRING,`baseBid`:STRING,`userId`:STRING,`affiliateId`:STRING,`eSignType`:STRING,`typeOfListing`:STRING,`hostedWebsite`:STRING,`visitId`:STRING,`unitId`:STRING,`hotLead`:STRING,`callCenter`:STRING,`sitePhone`:STRING,`alternateFirstNames`:array,`facilityPhone`:STRING,`apiCustId`:STRING,`reviewStatus`:STRING,`read`:STRING,`timestamp`:STRING,`alternatePhones`:array,`callCenterTransfer`:STRING,`sizeD`:STRING,`confirmationCode`:STRING,`duplicateOf`:STRING,`matchScore`:STRING,`sizeH`:STRING,`movedIn`:STRING,`moveInOriginal`:STRING,`companyCode`:STRING,`centershiftAccountId`:STRING,`facilityId`:STRING,`callCenterNotes`:STRING,`apiLeadId`:STRING,`totalPaid`:STRING,`bookingAgent`:STRING,`resaleRate`:STRING,`AAAMemberNumber`:STRING,`email`:STRING,`depositPaid`:STRING,`bookedUnit`:struct<`reservation_days`:STRING,`description`:struct<`vehicle`:struct<`warehouse`:STRING,`only`:STRING,`permitted`:STRING>,`physical`:struct<`width`:STRING,`length`:STRING,`height`:STRING>>,`price`:struct<`meta`:STRING>,`unitType`:STRING,`amenities`:array,`promotion`:STRING,`id`:STRING>,`free`:STRING,`autoState`:STRING,`facilityTenantId`:STRING,`listingWantId`:STRING,`lastName`:STRING,`promoCode`:STRING,`phoneChangedNumber`:STRING,`statementId`:STRING,`rebateProcessed`:STRING,`disputeReason`:STRING,`matchReasons`:STRING,`monthlyInsurance`:STRING,`bookingType`:STRING,`unit`:struct<`unitIds`:array>,`bookingWidget`:STRING,`customerNotes`:STRING,`commission`:STRING,`estimatedRevenue`:STRING,`searchWeightTestId`:STRING,`facilityTenant`:STRING,`complete`:STRING,`bidType`:STRING,`facilitylocation`:struct<`city`:STRING,`zip`:STRING,`address1`:STRING,`address2`:STRING,`state`:STRING,`country`:STRING>,`corrected`:STRING,`alternateEmails`:array,`phone`:STRING,`pickupTime`:STRING,`actualD`:STRING,`firstName`:STRING,`bookingState`:STRING,`bidAmount`:STRING,`phoneFacilityTransfer`:STRING,`phoneVerified`:STRING,`actualW`:STRING,`moveIn`:STRING,`moveOut`:STRING,`eVisitId`:STRING,`referrerId`:STRING,`canceled`:STRING,`sizeW`:STRING,`alternateLastNames`:array,`callerIdPhone`:STRING,`apiUnitId`:STRING,`termsVersion`:STRING,`facilityName`:STRING,`modifiedDtm`:STRING,`invoiceId`:STRING,`promo`:STRING,`trafficSourceId`:STRING,`price`:STRING,`payoutBatchId`:STRING,`unitNumber`:STRING,`phoneStatus`:STRING,`npv`:STRING,`moveInActual`:STRING,`sessionId`:STRING,`searchWeightId`:STRING,`bookingAgentId`:STRING,`siteId`:STRING>,`movedIn`:STRING,`apiUnitId`:STRING,`estimatedRevenue`:STRING,`meta`:struct<`title`:STRING>,`account`:struct<`hasOnlineMoveIns`:STRING,`accountId`:STRING>,`phone`:STRING,`read`:STRING,`apiCustId`:STRING,`alternateLastNames`:array,`moveInActual`:STRING,`facilityGetsNotificationEmails`:STRING,`unitId`:STRING,`firstName`:STRING,`alternateFirstNames`:array,`reviewStatus`:STRING,`commission`:STRING,`sessionId`:STRING,`companyCode`:STRING,`hostedWebsite`:STRING,`bidAmount`:STRING,`facilityName`:STRING,`totalPaid`:STRING,`sizeH`:STRING,`bookingAgent`:STRING,`listingWantId`:STRING,`referrerId`:STRING,`bookingWidget`:STRING,`callCenterTransfer`:STRING,`phoneVerified`:STRING,`hotLead`:STRING,`moveOut`:STRING,`alternatePhones`:array,`alternateEmails`:array,`phoneChangedNumber`:STRING,`disputeReason`:STRING,`payoutBatchId`:STRING,`userId`:STRING,`sizeD`:STRING,`omiCompleted`:STRING,`searchWeightTestId`:STRING,`omiFlowEnabled`:STRING,`hasOnlineMoveIns`:STRING,`hasContactlessMoveins`:STRING,`baseBid`:STRING,`omiAttributes`:struct<`facility`:STRING,`organization`:STRING,`unit`:STRING,`reservation`:STRING,`provider`:STRING>,`monthlyInsurance`:STRING,`pickupTime`:STRING,`sizeW`:STRING,`rebateProcessed`:STRING,`searchWeightId`:STRING,`callCenter`:STRING,`email`:STRING,`bookingType`:STRING,`moveIn`:STRING>,`isReact`:STRING,`Hit_Timestamp`:STRING>,`integrations`struct<`_empty_`:STRING>,`sentAt`STRING,`type`STRING,`channel`STRING,`version`STRING,`receivedAt`STRING,`userId`STRING,`context`struct<`campaign`:struct<`content`:STRING,`medium`:STRING,`name`:STRING>,`timezone`:STRING,`ip`:STRING,`userAgentData`:struct<`brands`:array>,`platform`:STRING,`mobile`:STRING>,`page`:struct<`referrer`:STRING,`url`:STRING,`title`:STRING,`search`:STRING,`path`:STRING>,`userAgent`:STRING,`locale`:STRING,`library`:struct<`name`:STRING,`version`:STRING>>,`projectId`STRING,`messageId`STRING,`originalTimestamp`STRING,`anonymousId`STRING,`_metadata`struct<`bundled`:array,`unbundled`:array>,`timestamp`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-ssdc-dev/separated_dt/submit'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_segment.ssdc_submit`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_segment.ssdc_submit"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}