Schema Info

Schema Name: sfdl_stage_csv.salesforce_users

created: 2022-10-24 15:16:25
disabled: False
format: raw
id: 1456
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_csv",
    "table": "salesforce_users"
}

type: csv

Schema Versions: 3

Version 896340

created: 2026-02-27 09:11:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_users`\n(\n `Id`  string , `Username`  string , `LastName`  string , `FirstName`  string , `Name`  string , `CompanyName`  string , `Division`  string , `Department`  string , `Title`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Email`  string , `EmailPreferencesAutoBcc`  string , `EmailPreferencesAutoBccStayInTouch`  string , `EmailPreferencesStayInTouchReminder`  string , `SenderEmail`  string , `SenderName`  string , `Signature`  string , `StayInTouchSubject`  string , `StayInTouchSignature`  string , `StayInTouchNote`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `Alias`  string , `CommunityNickname`  string , `BadgeText`  string , `IsActive`  string , `TimeZoneSidKey`  string , `UserRoleId`  string , `LocaleSidKey`  string , `ReceivesInfoEmails`  string , `ReceivesAdminInfoEmails`  string , `EmailEncodingKey`  string , `DefaultCurrencyIsoCode`  string , `CurrencyIsoCode`  string , `ProfileId`  string , `UserType`  string , `StartDay`  string , `EndDay`  string , `LanguageLocaleKey`  string , `EmployeeNumber`  string , `DelegatedApproverId`  string , `ManagerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `PasswordExpirationDate`  string , `NumberOfFailedLogins`  string , `SuAccessExpirationDate`  string , `OfflineTrialExpirationDate`  string , `OfflinePdaTrialExpirationDate`  string , `UserPermissionsMarketingUser`  string , `UserPermissionsOfflineUser`  string , `UserPermissionsAvantgoUser`  string , `UserPermissionsCallCenterAutoLogin`  string , `UserPermissionsSFContentUser`  string , `UserPermissionsKnowledgeUser`  string , `UserPermissionsInteractionUser`  string , `UserPermissionsSupportUser`  string , `UserPermissionsLiveAgentUser`  string , `ForecastEnabled`  string , `UserPreferencesActivityRemindersPopup`  string , `UserPreferencesEventRemindersCheckboxDefault`  string , `UserPreferencesTaskRemindersCheckboxDefault`  string , `UserPreferencesReminderSoundOff`  string , `UserPreferencesDisableAllFeedsEmail`  string , `UserPreferencesDisableFollowersEmail`  string , `UserPreferencesDisableProfilePostEmail`  string , `UserPreferencesDisableChangeCommentEmail`  string , `UserPreferencesDisableLaterCommentEmail`  string , `UserPreferencesDisProfPostCommentEmail`  string , `UserPreferencesContentNoEmail`  string , `UserPreferencesContentEmailAsAndWhen`  string , `UserPreferencesApexPagesDeveloperMode`  string , `UserPreferencesReceiveNoNotificationsAsApprover`  string , `UserPreferencesReceiveNotificationsAsDelegatedApprover`  string , `UserPreferencesHideCSNGetChatterMobileTask`  string , `UserPreferencesDisableMentionsPostEmail`  string , `UserPreferencesDisMentionsCommentEmail`  string , `UserPreferencesHideCSNDesktopTask`  string , `UserPreferencesHideChatterOnboardingSplash`  string , `UserPreferencesHideSecondChatterOnboardingSplash`  string , `UserPreferencesDisCommentAfterLikeEmail`  string , `UserPreferencesDisableLikeEmail`  string , `UserPreferencesSortFeedByComment`  string , `UserPreferencesDisableMessageEmail`  string , `UserPreferencesDisableBookmarkEmail`  string , `UserPreferencesDisableSharePostEmail`  string , `UserPreferencesActionLauncherEinsteinGptConsent`  string , `UserPreferencesAssistiveActionsEnabledInActionLauncher`  string , `UserPreferencesEnableAutoSubForFeeds`  string , `UserPreferencesDisableFileShareNotificationsForApi`  string , `UserPreferencesShowTitleToExternalUsers`  string , `UserPreferencesShowManagerToExternalUsers`  string , `UserPreferencesShowEmailToExternalUsers`  string , `UserPreferencesShowWorkPhoneToExternalUsers`  string , `UserPreferencesShowMobilePhoneToExternalUsers`  string , `UserPreferencesShowFaxToExternalUsers`  string , `UserPreferencesShowStreetAddressToExternalUsers`  string , `UserPreferencesShowCityToExternalUsers`  string , `UserPreferencesShowStateToExternalUsers`  string , `UserPreferencesShowPostalCodeToExternalUsers`  string , `UserPreferencesShowCountryToExternalUsers`  string , `UserPreferencesShowProfilePicToGuestUsers`  string , `UserPreferencesShowTitleToGuestUsers`  string , `UserPreferencesShowCityToGuestUsers`  string , `UserPreferencesShowStateToGuestUsers`  string , `UserPreferencesShowPostalCodeToGuestUsers`  string , `UserPreferencesShowCountryToGuestUsers`  string , `UserPreferencesShowForecastingChangeSignals`  string , `UserPreferencesLiveAgentMiawSetupDeflection`  string , `UserPreferencesHideS1BrowserUI`  string , `UserPreferencesDisableEndorsementEmail`  string , `UserPreferencesPathAssistantCollapsed`  string , `UserPreferencesCacheDiagnostics`  string , `UserPreferencesShowEmailToGuestUsers`  string , `UserPreferencesShowManagerToGuestUsers`  string , `UserPreferencesShowWorkPhoneToGuestUsers`  string , `UserPreferencesShowMobilePhoneToGuestUsers`  string , `UserPreferencesShowFaxToGuestUsers`  string , `UserPreferencesShowStreetAddressToGuestUsers`  string , `UserPreferencesLightningExperiencePreferred`  string , `UserPreferencesPreviewLightning`  string , `UserPreferencesHideEndUserOnboardingAssistantModal`  string , `UserPreferencesHideLightningMigrationModal`  string , `UserPreferencesHideSfxWelcomeMat`  string , `UserPreferencesHideBiggerPhotoCallout`  string , `UserPreferencesGlobalNavBarWTShown`  string , `UserPreferencesGlobalNavGridMenuWTShown`  string , `UserPreferencesCreateLEXAppsWTShown`  string , `UserPreferencesFavoritesWTShown`  string , `UserPreferencesRecordHomeSectionCollapseWTShown`  string , `UserPreferencesRecordHomeReservedWTShown`  string , `UserPreferencesFavoritesShowTopFavorites`  string , `UserPreferencesExcludeMailAppAttachments`  string , `UserPreferencesSuppressTaskSFXReminders`  string , `UserPreferencesSuppressEventSFXReminders`  string , `UserPreferencesPreviewCustomTheme`  string , `UserPreferencesHasCelebrationBadge`  string , `UserPreferencesUserDebugModePref`  string , `UserPreferencesSRHOverrideActivities`  string , `UserPreferencesNewLightningReportRunPageEnabled`  string , `UserPreferencesReverseOpenActivitiesView`  string , `UserPreferencesHasSentWarningEmail`  string , `UserPreferencesHasSentWarningEmail238`  string , `UserPreferencesHasSentWarningEmail240`  string , `UserPreferencesNativeEmailClient`  string , `UserPreferencesBRELookupTableWelcomeMat`  string , `UserPreferencesHideBrowseProductRedirectConfirmation`  string , `UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal`  string , `UserPreferencesHideOnlineSalesAppWelcomeMat`  string , `UserPreferencesShowForecastingRoundedAmounts`  string , `HasUserVerifiedPhone`  string , `HasUserVerifiedEmail`  string , `ContactId`  string , `AccountId`  string , `CallCenterId`  string , `Extension`  string , `FederationIdentifier`  string , `AboutMe`  string , `FullPhotoUrl`  string , `SmallPhotoUrl`  string , `IsExtIndicatorVisible`  string , `OutOfOfficeMessage`  string , `MediumPhotoUrl`  string , `DigestFrequency`  string , `DefaultGroupNotificationFrequency`  string , `BannerPhotoUrl`  string , `SmallBannerPhotoUrl`  string , `MediumBannerPhotoUrl`  string , `IsProfilePhotoActive`  string , `IndividualId`  string , `Territory__c`  string , `Sales_Admin__c`  string , `LDR__c`  string , `dsfs__DSProSFMembershipStatus__c`  string , `dsfs__DSProSFPassword__c`  string , `dsfs__DSProSFUsername__c`  string , `pi__Can_View_Not_Assigned_Prospects__c`  string , `pi__Pardot_Api_Key__c`  string , `pi__Pardot_User_Id__c`  string , `pi__Pardot_User_Key__c`  string , `pi__Pardot_User_Role__c`  string , `pi__Pardot_Api_Version__c`  string , `dupcheck__dc3DisableDCTriggers__c`  string , `Out_of_Office__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `UConference__UberConferenceId__c`  string , `Date_Training_Type_Set__c`  string , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__c`  string , `Support_Trainer__c`  string , `Training_Type__c`  string , `MigrationId__c`  string , `Escalate_Case__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-stage/raw/users/2026-02-27/1772205020'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_users"
]

hive_path: s3://sfdl-csv-salesforce-stage/raw/users/2026-02-27/1772205020
id: 896340
processed: 1

raw_data:

{
    "AboutMe": 168,
    "AccountId": 164,
    "Admin_Deactivation_Date__c": 201,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 176,
    "CallCenterId": 165,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 200,
    "ContactId": 163,
    "Country": 13,
    "CreatedById": 51,
    "CreatedDate": 50,
    "CurrencyIsoCode": 41,
    "Date_Training_Type_Set__c": 197,
    "DefaultCurrencyIsoCode": 40,
    "DefaultGroupNotificationFrequency": 175,
    "DelegatedApproverId": 48,
    "Department": 7,
    "DigestFrequency": 174,
    "Division": 6,
    "Email": 17,
    "EmailEncodingKey": 39,
    "EmailPreferencesAutoBcc": 18,
    "EmailPreferencesAutoBccStayInTouch": 19,
    "EmailPreferencesStayInTouchReminder": 20,
    "EmployeeNumber": 47,
    "EndDay": 45,
    "Escalate_Case__c": 205,
    "Extension": 166,
    "Fax": 28,
    "FederationIdentifier": 167,
    "FirstName": 3,
    "ForecastEnabled": 69,
    "FullPhotoUrl": 169,
    "GeocodeAccuracy": 16,
    "HasUserVerifiedEmail": 162,
    "HasUserVerifiedPhone": 161,
    "Id": 0,
    "IndividualId": 180,
    "IsActive": 33,
    "IsExtIndicatorVisible": 171,
    "IsNotRecordOwner__c": 199,
    "IsProfilePhotoActive": 179,
    "LDR__c": 183,
    "LanguageLocaleKey": 46,
    "LastModifiedById": 53,
    "LastModifiedDate": 52,
    "LastName": 2,
    "Latitude": 14,
    "LocaleSidKey": 36,
    "Longitude": 15,
    "ManagerId": 49,
    "MediumBannerPhotoUrl": 178,
    "MediumPhotoUrl": 173,
    "MigrationId__c": 204,
    "MobilePhone": 29,
    "Name": 4,
    "NumberOfFailedLogins": 56,
    "OfflinePdaTrialExpirationDate": 59,
    "OfflineTrialExpirationDate": 58,
    "OutOfOfficeMessage": 172,
    "Out_of_Office__c": 194,
    "PasswordExpirationDate": 55,
    "Phone": 27,
    "PostalCode": 12,
    "ProfileId": 42,
    "ReceivesAdminInfoEmails": 38,
    "ReceivesInfoEmails": 37,
    "Sales_Admin__c": 182,
    "Sales_Segment__c": 198,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 177,
    "SmallPhotoUrl": 170,
    "StartDay": 44,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "SuAccessExpirationDate": 57,
    "Support_Trainer__c": 202,
    "SystemModstamp": 54,
    "Territory__c": 181,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "Training_Type__c": 203,
    "UConference__UberConferenceId__c": 196,
    "UserPermissionsAvantgoUser": 62,
    "UserPermissionsCallCenterAutoLogin": 63,
    "UserPermissionsInteractionUser": 66,
    "UserPermissionsKnowledgeUser": 65,
    "UserPermissionsLiveAgentUser": 68,
    "UserPermissionsMarketingUser": 60,
    "UserPermissionsOfflineUser": 61,
    "UserPermissionsSFContentUser": 64,
    "UserPermissionsSupportUser": 67,
    "UserPreferencesActionLauncherEinsteinGptConsent": 97,
    "UserPreferencesActivityRemindersPopup": 70,
    "UserPreferencesApexPagesDeveloperMode": 82,
    "UserPreferencesAssistiveActionsEnabledInActionLauncher": 98,
    "UserPreferencesBRELookupTableWelcomeMat": 156,
    "UserPreferencesCacheDiagnostics": 123,
    "UserPreferencesContentEmailAsAndWhen": 81,
    "UserPreferencesContentNoEmail": 80,
    "UserPreferencesCreateLEXAppsWTShown": 138,
    "UserPreferencesDisCommentAfterLikeEmail": 91,
    "UserPreferencesDisMentionsCommentEmail": 87,
    "UserPreferencesDisProfPostCommentEmail": 79,
    "UserPreferencesDisableAllFeedsEmail": 74,
    "UserPreferencesDisableBookmarkEmail": 95,
    "UserPreferencesDisableChangeCommentEmail": 77,
    "UserPreferencesDisableEndorsementEmail": 121,
    "UserPreferencesDisableFileShareNotificationsForApi": 100,
    "UserPreferencesDisableFollowersEmail": 75,
    "UserPreferencesDisableLaterCommentEmail": 78,
    "UserPreferencesDisableLikeEmail": 92,
    "UserPreferencesDisableMentionsPostEmail": 86,
    "UserPreferencesDisableMessageEmail": 94,
    "UserPreferencesDisableProfilePostEmail": 76,
    "UserPreferencesDisableSharePostEmail": 96,
    "UserPreferencesEnableAutoSubForFeeds": 99,
    "UserPreferencesEventRemindersCheckboxDefault": 71,
    "UserPreferencesExcludeMailAppAttachments": 143,
    "UserPreferencesFavoritesShowTopFavorites": 142,
    "UserPreferencesFavoritesWTShown": 139,
    "UserPreferencesGlobalNavBarWTShown": 136,
    "UserPreferencesGlobalNavGridMenuWTShown": 137,
    "UserPreferencesHasCelebrationBadge": 147,
    "UserPreferencesHasSentWarningEmail": 152,
    "UserPreferencesHasSentWarningEmail238": 153,
    "UserPreferencesHasSentWarningEmail240": 154,
    "UserPreferencesHideBiggerPhotoCallout": 135,
    "UserPreferencesHideBrowseProductRedirectConfirmation": 157,
    "UserPreferencesHideCSNDesktopTask": 88,
    "UserPreferencesHideCSNGetChatterMobileTask": 85,
    "UserPreferencesHideChatterOnboardingSplash": 89,
    "UserPreferencesHideEndUserOnboardingAssistantModal": 132,
    "UserPreferencesHideLightningMigrationModal": 133,
    "UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal": 158,
    "UserPreferencesHideOnlineSalesAppWelcomeMat": 159,
    "UserPreferencesHideS1BrowserUI": 120,
    "UserPreferencesHideSecondChatterOnboardingSplash": 90,
    "UserPreferencesHideSfxWelcomeMat": 134,
    "UserPreferencesLightningExperiencePreferred": 130,
    "UserPreferencesLiveAgentMiawSetupDeflection": 119,
    "UserPreferencesNativeEmailClient": 155,
    "UserPreferencesNewLightningReportRunPageEnabled": 150,
    "UserPreferencesPathAssistantCollapsed": 122,
    "UserPreferencesPreviewCustomTheme": 146,
    "UserPreferencesPreviewLightning": 131,
    "UserPreferencesReceiveNoNotificationsAsApprover": 83,
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": 84,
    "UserPreferencesRecordHomeReservedWTShown": 141,
    "UserPreferencesRecordHomeSectionCollapseWTShown": 140,
    "UserPreferencesReminderSoundOff": 73,
    "UserPreferencesReverseOpenActivitiesView": 151,
    "UserPreferencesSRHOverrideActivities": 149,
    "UserPreferencesShowCityToExternalUsers": 108,
    "UserPreferencesShowCityToGuestUsers": 114,
    "UserPreferencesShowCountryToExternalUsers": 111,
    "UserPreferencesShowCountryToGuestUsers": 117,
    "UserPreferencesShowEmailToExternalUsers": 103,
    "UserPreferencesShowEmailToGuestUsers": 124,
    "UserPreferencesShowFaxToExternalUsers": 106,
    "UserPreferencesShowFaxToGuestUsers": 128,
    "UserPreferencesShowForecastingChangeSignals": 118,
    "UserPreferencesShowForecastingRoundedAmounts": 160,
    "UserPreferencesShowManagerToExternalUsers": 102,
    "UserPreferencesShowManagerToGuestUsers": 125,
    "UserPreferencesShowMobilePhoneToExternalUsers": 105,
    "UserPreferencesShowMobilePhoneToGuestUsers": 127,
    "UserPreferencesShowPostalCodeToExternalUsers": 110,
    "UserPreferencesShowPostalCodeToGuestUsers": 116,
    "UserPreferencesShowProfilePicToGuestUsers": 112,
    "UserPreferencesShowStateToExternalUsers": 109,
    "UserPreferencesShowStateToGuestUsers": 115,
    "UserPreferencesShowStreetAddressToExternalUsers": 107,
    "UserPreferencesShowStreetAddressToGuestUsers": 129,
    "UserPreferencesShowTitleToExternalUsers": 101,
    "UserPreferencesShowTitleToGuestUsers": 113,
    "UserPreferencesShowWorkPhoneToExternalUsers": 104,
    "UserPreferencesShowWorkPhoneToGuestUsers": 126,
    "UserPreferencesSortFeedByComment": 93,
    "UserPreferencesSuppressEventSFXReminders": 145,
    "UserPreferencesSuppressTaskSFXReminders": 144,
    "UserPreferencesTaskRemindersCheckboxDefault": 72,
    "UserPreferencesUserDebugModePref": 148,
    "UserRoleId": 35,
    "UserType": 43,
    "Username": 1,
    "dsfs__DSProSFMembershipStatus__c": 184,
    "dsfs__DSProSFPassword__c": 185,
    "dsfs__DSProSFUsername__c": 186,
    "dupcheck__dc3DisableDCTriggers__c": 193,
    "dupcheck__dc3DisableDuplicateCheck__c": 195,
    "pi__Can_View_Not_Assigned_Prospects__c": 187,
    "pi__Pardot_Api_Key__c": 188,
    "pi__Pardot_Api_Version__c": 192,
    "pi__Pardot_User_Id__c": 189,
    "pi__Pardot_User_Key__c": 190,
    "pi__Pardot_User_Role__c": 191
}

schema_attributes:

{
    "AboutMe": "string",
    "AccountId": "string",
    "Admin_Deactivation_Date__c": "string",
    "Alias": "string",
    "Amount": "string",
    "BadgeText": "string",
    "BannerPhotoUrl": "string",
    "CallCenterId": "string",
    "City": "string",
    "CloseDate": "string",
    "CommunityNickname": "string",
    "CompanyName": "string",
    "Company_of_Origin__c": "string",
    "ContactId": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Date_Training_Type_Set__c": "string",
    "DefaultCurrencyIsoCode": "string",
    "DefaultGroupNotificationFrequency": "string",
    "DelegatedApproverId": "string",
    "Department": "string",
    "DigestFrequency": "string",
    "Division": "string",
    "Email": "string",
    "EmailEncodingKey": "string",
    "EmailPreferencesAutoBcc": "string",
    "EmailPreferencesAutoBccStayInTouch": "string",
    "EmailPreferencesStayInTouchReminder": "string",
    "EmployeeNumber": "string",
    "EndDay": "string",
    "Escalate_Case__c": "string",
    "ExpectedRevenue": "string",
    "Extension": "string",
    "Fax": "string",
    "FederationIdentifier": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "ForecastEnabled": "string",
    "FullPhotoUrl": "string",
    "GeocodeAccuracy": "string",
    "HasUserVerifiedEmail": "string",
    "HasUserVerifiedPhone": "string",
    "Id": "string",
    "IndividualId": "string",
    "IsActive": "string",
    "IsDeleted": "string",
    "IsExtIndicatorVisible": "string",
    "IsNotRecordOwner__c": "string",
    "IsProfilePhotoActive": "string",
    "LDR__c": "string",
    "LanguageLocaleKey": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "Latitude": "string",
    "LocaleSidKey": "string",
    "Longitude": "string",
    "ManagerId": "string",
    "MediumBannerPhotoUrl": "string",
    "MediumPhotoUrl": "string",
    "MigrationId__c": "string",
    "MobilePhone": "string",
    "Name": "string",
    "NumberOfFailedLogins": "string",
    "OfflinePdaTrialExpirationDate": "string",
    "OfflineTrialExpirationDate": "string",
    "OpportunityId": "string",
    "OutOfOfficeMessage": "string",
    "Out_of_Office__c": "string",
    "PasswordExpirationDate": "string",
    "Phone": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProfileId": "string",
    "ReceivesAdminInfoEmails": "string",
    "ReceivesInfoEmails": "string",
    "Sales_Admin__c": "string",
    "Sales_Segment__c": "string",
    "SenderEmail": "string",
    "SenderName": "string",
    "Signature": "string",
    "SmallBannerPhotoUrl": "string",
    "SmallPhotoUrl": "string",
    "StageName": "string",
    "StartDay": "string",
    "State": "string",
    "StayInTouchNote": "string",
    "StayInTouchSignature": "string",
    "StayInTouchSubject": "string",
    "Street": "string",
    "SuAccessExpirationDate": "string",
    "Support_Trainer__c": "string",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "string",
    "Training_Type__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UserPermissionsAvantgoUser": "string",
    "UserPermissionsCallCenterAutoLogin": "string",
    "UserPermissionsInteractionUser": "string",
    "UserPermissionsKnowledgeUser": "string",
    "UserPermissionsLiveAgentUser": "string",
    "UserPermissionsMarketingUser": "string",
    "UserPermissionsOfflineUser": "string",
    "UserPermissionsSFContentUser": "string",
    "UserPermissionsSupportUser": "string",
    "UserPreferencesActionLauncherEinsteinGptConsent": "string",
    "UserPreferencesActivityRemindersPopup": "string",
    "UserPreferencesApexPagesDeveloperMode": "string",
    "UserPreferencesAssistiveActionsEnabledInActionLauncher": "string",
    "UserPreferencesBRELookupTableWelcomeMat": "string",
    "UserPreferencesCacheDiagnostics": "string",
    "UserPreferencesContentEmailAsAndWhen": "string",
    "UserPreferencesContentNoEmail": "string",
    "UserPreferencesCreateLEXAppsWTShown": "string",
    "UserPreferencesDisCommentAfterLikeEmail": "string",
    "UserPreferencesDisMentionsCommentEmail": "string",
    "UserPreferencesDisProfPostCommentEmail": "string",
    "UserPreferencesDisableAllFeedsEmail": "string",
    "UserPreferencesDisableBookmarkEmail": "string",
    "UserPreferencesDisableChangeCommentEmail": "string",
    "UserPreferencesDisableEndorsementEmail": "string",
    "UserPreferencesDisableFileShareNotificationsForApi": "string",
    "UserPreferencesDisableFollowersEmail": "string",
    "UserPreferencesDisableLaterCommentEmail": "string",
    "UserPreferencesDisableLikeEmail": "string",
    "UserPreferencesDisableMentionsPostEmail": "string",
    "UserPreferencesDisableMessageEmail": "string",
    "UserPreferencesDisableProfilePostEmail": "string",
    "UserPreferencesDisableSharePostEmail": "string",
    "UserPreferencesEnableAutoSubForFeeds": "string",
    "UserPreferencesEventRemindersCheckboxDefault": "string",
    "UserPreferencesExcludeMailAppAttachments": "string",
    "UserPreferencesFavoritesShowTopFavorites": "string",
    "UserPreferencesFavoritesWTShown": "string",
    "UserPreferencesGlobalNavBarWTShown": "string",
    "UserPreferencesGlobalNavGridMenuWTShown": "string",
    "UserPreferencesHasCelebrationBadge": "string",
    "UserPreferencesHasSentWarningEmail": "string",
    "UserPreferencesHasSentWarningEmail238": "string",
    "UserPreferencesHasSentWarningEmail240": "string",
    "UserPreferencesHideBiggerPhotoCallout": "string",
    "UserPreferencesHideBrowseProductRedirectConfirmation": "string",
    "UserPreferencesHideCSNDesktopTask": "string",
    "UserPreferencesHideCSNGetChatterMobileTask": "string",
    "UserPreferencesHideChatterOnboardingSplash": "string",
    "UserPreferencesHideEndUserOnboardingAssistantModal": "string",
    "UserPreferencesHideLightningMigrationModal": "string",
    "UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal": "string",
    "UserPreferencesHideOnlineSalesAppWelcomeMat": "string",
    "UserPreferencesHideS1BrowserUI": "string",
    "UserPreferencesHideSecondChatterOnboardingSplash": "string",
    "UserPreferencesHideSfxWelcomeMat": "string",
    "UserPreferencesLightningExperiencePreferred": "string",
    "UserPreferencesLiveAgentMiawSetupDeflection": "string",
    "UserPreferencesNativeEmailClient": "string",
    "UserPreferencesNewLightningReportRunPageEnabled": "string",
    "UserPreferencesPathAssistantCollapsed": "string",
    "UserPreferencesPreviewCustomTheme": "string",
    "UserPreferencesPreviewLightning": "string",
    "UserPreferencesReceiveNoNotificationsAsApprover": "string",
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": "string",
    "UserPreferencesRecordHomeReservedWTShown": "string",
    "UserPreferencesRecordHomeSectionCollapseWTShown": "string",
    "UserPreferencesReminderSoundOff": "string",
    "UserPreferencesReverseOpenActivitiesView": "string",
    "UserPreferencesSRHOverrideActivities": "string",
    "UserPreferencesShowCityToExternalUsers": "string",
    "UserPreferencesShowCityToGuestUsers": "string",
    "UserPreferencesShowCountryToExternalUsers": "string",
    "UserPreferencesShowCountryToGuestUsers": "string",
    "UserPreferencesShowEmailToExternalUsers": "string",
    "UserPreferencesShowEmailToGuestUsers": "string",
    "UserPreferencesShowFaxToExternalUsers": "string",
    "UserPreferencesShowFaxToGuestUsers": "string",
    "UserPreferencesShowForecastingChangeSignals": "string",
    "UserPreferencesShowForecastingRoundedAmounts": "string",
    "UserPreferencesShowManagerToExternalUsers": "string",
    "UserPreferencesShowManagerToGuestUsers": "string",
    "UserPreferencesShowMobilePhoneToExternalUsers": "string",
    "UserPreferencesShowMobilePhoneToGuestUsers": "string",
    "UserPreferencesShowPostalCodeToExternalUsers": "string",
    "UserPreferencesShowPostalCodeToGuestUsers": "string",
    "UserPreferencesShowProfilePicToGuestUsers": "string",
    "UserPreferencesShowStateToExternalUsers": "string",
    "UserPreferencesShowStateToGuestUsers": "string",
    "UserPreferencesShowStreetAddressToExternalUsers": "string",
    "UserPreferencesShowStreetAddressToGuestUsers": "string",
    "UserPreferencesShowTitleToExternalUsers": "string",
    "UserPreferencesShowTitleToGuestUsers": "string",
    "UserPreferencesShowWorkPhoneToExternalUsers": "string",
    "UserPreferencesShowWorkPhoneToGuestUsers": "string",
    "UserPreferencesSortFeedByComment": "string",
    "UserPreferencesSuppressEventSFXReminders": "string",
    "UserPreferencesSuppressTaskSFXReminders": "string",
    "UserPreferencesTaskRemindersCheckboxDefault": "string",
    "UserPreferencesUserDebugModePref": "string",
    "UserRoleId": "string",
    "UserType": "string",
    "Username": "string",
    "dsfs__DSProSFMembershipStatus__c": "string",
    "dsfs__DSProSFPassword__c": "string",
    "dsfs__DSProSFUsername__c": "string",
    "dupcheck__dc3DisableDCTriggers__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "pi__Can_View_Not_Assigned_Prospects__c": "string",
    "pi__Pardot_Api_Key__c": "string",
    "pi__Pardot_Api_Version__c": "string",
    "pi__Pardot_User_Id__c": "string",
    "pi__Pardot_User_Key__c": "string",
    "pi__Pardot_User_Role__c": "string"
}

schema_name_id: 1456
schema_scan_id: 6391673
updated: 2026-02-27 09:12:04

Version 797888

created: 2025-01-09 15:14:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_users`\n(\n `Id`  string , `Username`  string , `LastName`  string , `FirstName`  string , `Name`  string , `CompanyName`  string , `Division`  string , `Department`  string , `Title`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Email`  string , `EmailPreferencesAutoBcc`  string , `EmailPreferencesAutoBccStayInTouch`  string , `EmailPreferencesStayInTouchReminder`  string , `SenderEmail`  string , `SenderName`  string , `Signature`  string , `StayInTouchSubject`  string , `StayInTouchSignature`  string , `StayInTouchNote`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `Alias`  string , `CommunityNickname`  string , `BadgeText`  string , `IsActive`  string , `TimeZoneSidKey`  string , `UserRoleId`  string , `LocaleSidKey`  string , `ReceivesInfoEmails`  string , `ReceivesAdminInfoEmails`  string , `EmailEncodingKey`  string , `DefaultCurrencyIsoCode`  string , `CurrencyIsoCode`  string , `ProfileId`  string , `UserType`  string , `LanguageLocaleKey`  string , `EmployeeNumber`  string , `DelegatedApproverId`  string , `ManagerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `NumberOfFailedLogins`  string , `OfflineTrialExpirationDate`  string , `OfflinePdaTrialExpirationDate`  string , `UserPermissionsMarketingUser`  string , `UserPermissionsOfflineUser`  string , `UserPermissionsAvantgoUser`  string , `UserPermissionsCallCenterAutoLogin`  string , `UserPermissionsSFContentUser`  string , `UserPermissionsKnowledgeUser`  string , `UserPermissionsInteractionUser`  string , `UserPermissionsSupportUser`  string , `UserPermissionsLiveAgentUser`  string , `ForecastEnabled`  string , `UserPreferencesActivityRemindersPopup`  string , `UserPreferencesEventRemindersCheckboxDefault`  string , `UserPreferencesTaskRemindersCheckboxDefault`  string , `UserPreferencesReminderSoundOff`  string , `UserPreferencesDisableAllFeedsEmail`  string , `UserPreferencesDisableFollowersEmail`  string , `UserPreferencesDisableProfilePostEmail`  string , `UserPreferencesDisableChangeCommentEmail`  string , `UserPreferencesDisableLaterCommentEmail`  string , `UserPreferencesDisProfPostCommentEmail`  string , `UserPreferencesContentNoEmail`  string , `UserPreferencesContentEmailAsAndWhen`  string , `UserPreferencesApexPagesDeveloperMode`  string , `UserPreferencesReceiveNoNotificationsAsApprover`  string , `UserPreferencesReceiveNotificationsAsDelegatedApprover`  string , `UserPreferencesHideCSNGetChatterMobileTask`  string , `UserPreferencesDisableMentionsPostEmail`  string , `UserPreferencesDisMentionsCommentEmail`  string , `UserPreferencesHideCSNDesktopTask`  string , `UserPreferencesHideChatterOnboardingSplash`  string , `UserPreferencesHideSecondChatterOnboardingSplash`  string , `UserPreferencesDisCommentAfterLikeEmail`  string , `UserPreferencesDisableLikeEmail`  string , `UserPreferencesSortFeedByComment`  string , `UserPreferencesDisableMessageEmail`  string , `UserPreferencesDisableBookmarkEmail`  string , `UserPreferencesDisableSharePostEmail`  string , `UserPreferencesEnableAutoSubForFeeds`  string , `UserPreferencesDisableFileShareNotificationsForApi`  string , `UserPreferencesShowTitleToExternalUsers`  string , `UserPreferencesShowManagerToExternalUsers`  string , `UserPreferencesShowEmailToExternalUsers`  string , `UserPreferencesShowWorkPhoneToExternalUsers`  string , `UserPreferencesShowMobilePhoneToExternalUsers`  string , `UserPreferencesShowFaxToExternalUsers`  string , `UserPreferencesShowStreetAddressToExternalUsers`  string , `UserPreferencesShowCityToExternalUsers`  string , `UserPreferencesShowStateToExternalUsers`  string , `UserPreferencesShowPostalCodeToExternalUsers`  string , `UserPreferencesShowCountryToExternalUsers`  string , `UserPreferencesShowProfilePicToGuestUsers`  string , `UserPreferencesShowTitleToGuestUsers`  string , `UserPreferencesShowCityToGuestUsers`  string , `UserPreferencesShowStateToGuestUsers`  string , `UserPreferencesShowPostalCodeToGuestUsers`  string , `UserPreferencesShowCountryToGuestUsers`  string , `UserPreferencesShowForecastingChangeSignals`  string , `UserPreferencesLiveAgentMiawSetupDeflection`  string , `UserPreferencesHideS1BrowserUI`  string , `UserPreferencesDisableEndorsementEmail`  string , `UserPreferencesPathAssistantCollapsed`  string , `UserPreferencesCacheDiagnostics`  string , `UserPreferencesShowEmailToGuestUsers`  string , `UserPreferencesShowManagerToGuestUsers`  string , `UserPreferencesShowWorkPhoneToGuestUsers`  string , `UserPreferencesShowMobilePhoneToGuestUsers`  string , `UserPreferencesShowFaxToGuestUsers`  string , `UserPreferencesShowStreetAddressToGuestUsers`  string , `UserPreferencesLightningExperiencePreferred`  string , `UserPreferencesPreviewLightning`  string , `UserPreferencesHideEndUserOnboardingAssistantModal`  string , `UserPreferencesHideLightningMigrationModal`  string , `UserPreferencesHideSfxWelcomeMat`  string , `UserPreferencesHideBiggerPhotoCallout`  string , `UserPreferencesGlobalNavBarWTShown`  string , `UserPreferencesGlobalNavGridMenuWTShown`  string , `UserPreferencesCreateLEXAppsWTShown`  string , `UserPreferencesFavoritesWTShown`  string , `UserPreferencesRecordHomeSectionCollapseWTShown`  string , `UserPreferencesRecordHomeReservedWTShown`  string , `UserPreferencesFavoritesShowTopFavorites`  string , `UserPreferencesExcludeMailAppAttachments`  string , `UserPreferencesSuppressTaskSFXReminders`  string , `UserPreferencesSuppressEventSFXReminders`  string , `UserPreferencesPreviewCustomTheme`  string , `UserPreferencesHasCelebrationBadge`  string , `UserPreferencesUserDebugModePref`  string , `UserPreferencesSRHOverrideActivities`  string , `UserPreferencesNewLightningReportRunPageEnabled`  string , `UserPreferencesReverseOpenActivitiesView`  string , `UserPreferencesHasSentWarningEmail`  string , `UserPreferencesHasSentWarningEmail238`  string , `UserPreferencesHasSentWarningEmail240`  string , `UserPreferencesNativeEmailClient`  string , `UserPreferencesHideBrowseProductRedirectConfirmation`  string , `UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal`  string , `UserPreferencesHideOnlineSalesAppWelcomeMat`  string , `UserPreferencesShowForecastingRoundedAmounts`  string , `ContactId`  string , `AccountId`  string , `CallCenterId`  string , `Extension`  string , `FederationIdentifier`  string , `AboutMe`  string , `FullPhotoUrl`  string , `SmallPhotoUrl`  string , `IsExtIndicatorVisible`  string , `OutOfOfficeMessage`  string , `MediumPhotoUrl`  string , `DigestFrequency`  string , `DefaultGroupNotificationFrequency`  string , `BannerPhotoUrl`  string , `SmallBannerPhotoUrl`  string , `MediumBannerPhotoUrl`  string , `IsProfilePhotoActive`  string , `IndividualId`  string , `Territory__c`  string , `Sales_Admin__c`  string , `LDR__c`  string , `dsfs__DSProSFMembershipStatus__c`  string , `dsfs__DSProSFPassword__c`  string , `dsfs__DSProSFUsername__c`  string , `pi__Can_View_Not_Assigned_Prospects__c`  string , `pi__Pardot_Api_Key__c`  string , `pi__Pardot_User_Id__c`  string , `pi__Pardot_User_Key__c`  string , `pi__Pardot_User_Role__c`  string , `pi__Pardot_Api_Version__c`  string , `dupcheck__dc3DisableDCTriggers__c`  string , `Out_of_Office__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `UConference__UberConferenceId__c`  string , `Date_Training_Type_Set__c`  string , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__c`  string , `Support_Trainer__c`  string , `Training_Type__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-stage/raw/users/2025-01-09/1736457234'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_users"
]

hive_path: s3://sfdl-csv-salesforce-stage/raw/users/2025-01-09/1736457234
id: 797888
processed: 1

raw_data:

{
    "AboutMe": 159,
    "AccountId": 155,
    "Admin_Deactivation_Date__c": 192,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 167,
    "CallCenterId": 156,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 191,
    "ContactId": 154,
    "Country": 13,
    "CreatedById": 49,
    "CreatedDate": 48,
    "CurrencyIsoCode": 41,
    "Date_Training_Type_Set__c": 188,
    "DefaultCurrencyIsoCode": 40,
    "DefaultGroupNotificationFrequency": 166,
    "DelegatedApproverId": 46,
    "Department": 7,
    "DigestFrequency": 165,
    "Division": 6,
    "Email": 17,
    "EmailEncodingKey": 39,
    "EmailPreferencesAutoBcc": 18,
    "EmailPreferencesAutoBccStayInTouch": 19,
    "EmailPreferencesStayInTouchReminder": 20,
    "EmployeeNumber": 45,
    "Extension": 157,
    "Fax": 28,
    "FederationIdentifier": 158,
    "FirstName": 3,
    "ForecastEnabled": 65,
    "FullPhotoUrl": 160,
    "GeocodeAccuracy": 16,
    "Id": 0,
    "IndividualId": 171,
    "IsActive": 33,
    "IsExtIndicatorVisible": 162,
    "IsNotRecordOwner__c": 190,
    "IsProfilePhotoActive": 170,
    "LDR__c": 174,
    "LanguageLocaleKey": 44,
    "LastModifiedById": 51,
    "LastModifiedDate": 50,
    "LastName": 2,
    "Latitude": 14,
    "LocaleSidKey": 36,
    "Longitude": 15,
    "ManagerId": 47,
    "MediumBannerPhotoUrl": 169,
    "MediumPhotoUrl": 164,
    "MobilePhone": 29,
    "Name": 4,
    "NumberOfFailedLogins": 53,
    "OfflinePdaTrialExpirationDate": 55,
    "OfflineTrialExpirationDate": 54,
    "OutOfOfficeMessage": 163,
    "Out_of_Office__c": 185,
    "Phone": 27,
    "PostalCode": 12,
    "ProfileId": 42,
    "ReceivesAdminInfoEmails": 38,
    "ReceivesInfoEmails": 37,
    "Sales_Admin__c": 173,
    "Sales_Segment__c": 189,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 168,
    "SmallPhotoUrl": 161,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "Support_Trainer__c": 193,
    "SystemModstamp": 52,
    "Territory__c": 172,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "Training_Type__c": 194,
    "UConference__UberConferenceId__c": 187,
    "UserPermissionsAvantgoUser": 58,
    "UserPermissionsCallCenterAutoLogin": 59,
    "UserPermissionsInteractionUser": 62,
    "UserPermissionsKnowledgeUser": 61,
    "UserPermissionsLiveAgentUser": 64,
    "UserPermissionsMarketingUser": 56,
    "UserPermissionsOfflineUser": 57,
    "UserPermissionsSFContentUser": 60,
    "UserPermissionsSupportUser": 63,
    "UserPreferencesActivityRemindersPopup": 66,
    "UserPreferencesApexPagesDeveloperMode": 78,
    "UserPreferencesCacheDiagnostics": 117,
    "UserPreferencesContentEmailAsAndWhen": 77,
    "UserPreferencesContentNoEmail": 76,
    "UserPreferencesCreateLEXAppsWTShown": 132,
    "UserPreferencesDisCommentAfterLikeEmail": 87,
    "UserPreferencesDisMentionsCommentEmail": 83,
    "UserPreferencesDisProfPostCommentEmail": 75,
    "UserPreferencesDisableAllFeedsEmail": 70,
    "UserPreferencesDisableBookmarkEmail": 91,
    "UserPreferencesDisableChangeCommentEmail": 73,
    "UserPreferencesDisableEndorsementEmail": 115,
    "UserPreferencesDisableFileShareNotificationsForApi": 94,
    "UserPreferencesDisableFollowersEmail": 71,
    "UserPreferencesDisableLaterCommentEmail": 74,
    "UserPreferencesDisableLikeEmail": 88,
    "UserPreferencesDisableMentionsPostEmail": 82,
    "UserPreferencesDisableMessageEmail": 90,
    "UserPreferencesDisableProfilePostEmail": 72,
    "UserPreferencesDisableSharePostEmail": 92,
    "UserPreferencesEnableAutoSubForFeeds": 93,
    "UserPreferencesEventRemindersCheckboxDefault": 67,
    "UserPreferencesExcludeMailAppAttachments": 137,
    "UserPreferencesFavoritesShowTopFavorites": 136,
    "UserPreferencesFavoritesWTShown": 133,
    "UserPreferencesGlobalNavBarWTShown": 130,
    "UserPreferencesGlobalNavGridMenuWTShown": 131,
    "UserPreferencesHasCelebrationBadge": 141,
    "UserPreferencesHasSentWarningEmail": 146,
    "UserPreferencesHasSentWarningEmail238": 147,
    "UserPreferencesHasSentWarningEmail240": 148,
    "UserPreferencesHideBiggerPhotoCallout": 129,
    "UserPreferencesHideBrowseProductRedirectConfirmation": 150,
    "UserPreferencesHideCSNDesktopTask": 84,
    "UserPreferencesHideCSNGetChatterMobileTask": 81,
    "UserPreferencesHideChatterOnboardingSplash": 85,
    "UserPreferencesHideEndUserOnboardingAssistantModal": 126,
    "UserPreferencesHideLightningMigrationModal": 127,
    "UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal": 151,
    "UserPreferencesHideOnlineSalesAppWelcomeMat": 152,
    "UserPreferencesHideS1BrowserUI": 114,
    "UserPreferencesHideSecondChatterOnboardingSplash": 86,
    "UserPreferencesHideSfxWelcomeMat": 128,
    "UserPreferencesLightningExperiencePreferred": 124,
    "UserPreferencesLiveAgentMiawSetupDeflection": 113,
    "UserPreferencesNativeEmailClient": 149,
    "UserPreferencesNewLightningReportRunPageEnabled": 144,
    "UserPreferencesPathAssistantCollapsed": 116,
    "UserPreferencesPreviewCustomTheme": 140,
    "UserPreferencesPreviewLightning": 125,
    "UserPreferencesReceiveNoNotificationsAsApprover": 79,
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": 80,
    "UserPreferencesRecordHomeReservedWTShown": 135,
    "UserPreferencesRecordHomeSectionCollapseWTShown": 134,
    "UserPreferencesReminderSoundOff": 69,
    "UserPreferencesReverseOpenActivitiesView": 145,
    "UserPreferencesSRHOverrideActivities": 143,
    "UserPreferencesShowCityToExternalUsers": 102,
    "UserPreferencesShowCityToGuestUsers": 108,
    "UserPreferencesShowCountryToExternalUsers": 105,
    "UserPreferencesShowCountryToGuestUsers": 111,
    "UserPreferencesShowEmailToExternalUsers": 97,
    "UserPreferencesShowEmailToGuestUsers": 118,
    "UserPreferencesShowFaxToExternalUsers": 100,
    "UserPreferencesShowFaxToGuestUsers": 122,
    "UserPreferencesShowForecastingChangeSignals": 112,
    "UserPreferencesShowForecastingRoundedAmounts": 153,
    "UserPreferencesShowManagerToExternalUsers": 96,
    "UserPreferencesShowManagerToGuestUsers": 119,
    "UserPreferencesShowMobilePhoneToExternalUsers": 99,
    "UserPreferencesShowMobilePhoneToGuestUsers": 121,
    "UserPreferencesShowPostalCodeToExternalUsers": 104,
    "UserPreferencesShowPostalCodeToGuestUsers": 110,
    "UserPreferencesShowProfilePicToGuestUsers": 106,
    "UserPreferencesShowStateToExternalUsers": 103,
    "UserPreferencesShowStateToGuestUsers": 109,
    "UserPreferencesShowStreetAddressToExternalUsers": 101,
    "UserPreferencesShowStreetAddressToGuestUsers": 123,
    "UserPreferencesShowTitleToExternalUsers": 95,
    "UserPreferencesShowTitleToGuestUsers": 107,
    "UserPreferencesShowWorkPhoneToExternalUsers": 98,
    "UserPreferencesShowWorkPhoneToGuestUsers": 120,
    "UserPreferencesSortFeedByComment": 89,
    "UserPreferencesSuppressEventSFXReminders": 139,
    "UserPreferencesSuppressTaskSFXReminders": 138,
    "UserPreferencesTaskRemindersCheckboxDefault": 68,
    "UserPreferencesUserDebugModePref": 142,
    "UserRoleId": 35,
    "UserType": 43,
    "Username": 1,
    "dsfs__DSProSFMembershipStatus__c": 175,
    "dsfs__DSProSFPassword__c": 176,
    "dsfs__DSProSFUsername__c": 177,
    "dupcheck__dc3DisableDCTriggers__c": 184,
    "dupcheck__dc3DisableDuplicateCheck__c": 186,
    "pi__Can_View_Not_Assigned_Prospects__c": 178,
    "pi__Pardot_Api_Key__c": 179,
    "pi__Pardot_Api_Version__c": 183,
    "pi__Pardot_User_Id__c": 180,
    "pi__Pardot_User_Key__c": 181,
    "pi__Pardot_User_Role__c": 182
}

schema_attributes:

{
    "AboutMe": "string",
    "AccountId": "string",
    "Admin_Deactivation_Date__c": "string",
    "Alias": "string",
    "Amount": "string",
    "BadgeText": "string",
    "BannerPhotoUrl": "string",
    "CallCenterId": "string",
    "City": "string",
    "CloseDate": "string",
    "CommunityNickname": "string",
    "CompanyName": "string",
    "Company_of_Origin__c": "string",
    "ContactId": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Date_Training_Type_Set__c": "string",
    "DefaultCurrencyIsoCode": "string",
    "DefaultGroupNotificationFrequency": "string",
    "DelegatedApproverId": "string",
    "Department": "string",
    "DigestFrequency": "string",
    "Division": "string",
    "Email": "string",
    "EmailEncodingKey": "string",
    "EmailPreferencesAutoBcc": "string",
    "EmailPreferencesAutoBccStayInTouch": "string",
    "EmailPreferencesStayInTouchReminder": "string",
    "EmployeeNumber": "string",
    "ExpectedRevenue": "string",
    "Extension": "string",
    "Fax": "string",
    "FederationIdentifier": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "ForecastEnabled": "string",
    "FullPhotoUrl": "string",
    "GeocodeAccuracy": "string",
    "Id": "string",
    "IndividualId": "string",
    "IsActive": "string",
    "IsDeleted": "string",
    "IsExtIndicatorVisible": "string",
    "IsNotRecordOwner__c": "string",
    "IsProfilePhotoActive": "string",
    "LDR__c": "string",
    "LanguageLocaleKey": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "Latitude": "string",
    "LocaleSidKey": "string",
    "Longitude": "string",
    "ManagerId": "string",
    "MediumBannerPhotoUrl": "string",
    "MediumPhotoUrl": "string",
    "MobilePhone": "string",
    "Name": "string",
    "NumberOfFailedLogins": "string",
    "OfflinePdaTrialExpirationDate": "string",
    "OfflineTrialExpirationDate": "string",
    "OpportunityId": "string",
    "OutOfOfficeMessage": "string",
    "Out_of_Office__c": "string",
    "Phone": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProfileId": "string",
    "ReceivesAdminInfoEmails": "string",
    "ReceivesInfoEmails": "string",
    "Sales_Admin__c": "string",
    "Sales_Segment__c": "string",
    "SenderEmail": "string",
    "SenderName": "string",
    "Signature": "string",
    "SmallBannerPhotoUrl": "string",
    "SmallPhotoUrl": "string",
    "StageName": "string",
    "State": "string",
    "StayInTouchNote": "string",
    "StayInTouchSignature": "string",
    "StayInTouchSubject": "string",
    "Street": "string",
    "Support_Trainer__c": "string",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "string",
    "Training_Type__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UserPermissionsAvantgoUser": "string",
    "UserPermissionsCallCenterAutoLogin": "string",
    "UserPermissionsInteractionUser": "string",
    "UserPermissionsKnowledgeUser": "string",
    "UserPermissionsLiveAgentUser": "string",
    "UserPermissionsMarketingUser": "string",
    "UserPermissionsOfflineUser": "string",
    "UserPermissionsSFContentUser": "string",
    "UserPermissionsSupportUser": "string",
    "UserPreferencesActivityRemindersPopup": "string",
    "UserPreferencesApexPagesDeveloperMode": "string",
    "UserPreferencesCacheDiagnostics": "string",
    "UserPreferencesContentEmailAsAndWhen": "string",
    "UserPreferencesContentNoEmail": "string",
    "UserPreferencesCreateLEXAppsWTShown": "string",
    "UserPreferencesDisCommentAfterLikeEmail": "string",
    "UserPreferencesDisMentionsCommentEmail": "string",
    "UserPreferencesDisProfPostCommentEmail": "string",
    "UserPreferencesDisableAllFeedsEmail": "string",
    "UserPreferencesDisableBookmarkEmail": "string",
    "UserPreferencesDisableChangeCommentEmail": "string",
    "UserPreferencesDisableEndorsementEmail": "string",
    "UserPreferencesDisableFileShareNotificationsForApi": "string",
    "UserPreferencesDisableFollowersEmail": "string",
    "UserPreferencesDisableLaterCommentEmail": "string",
    "UserPreferencesDisableLikeEmail": "string",
    "UserPreferencesDisableMentionsPostEmail": "string",
    "UserPreferencesDisableMessageEmail": "string",
    "UserPreferencesDisableProfilePostEmail": "string",
    "UserPreferencesDisableSharePostEmail": "string",
    "UserPreferencesEnableAutoSubForFeeds": "string",
    "UserPreferencesEventRemindersCheckboxDefault": "string",
    "UserPreferencesExcludeMailAppAttachments": "string",
    "UserPreferencesFavoritesShowTopFavorites": "string",
    "UserPreferencesFavoritesWTShown": "string",
    "UserPreferencesGlobalNavBarWTShown": "string",
    "UserPreferencesGlobalNavGridMenuWTShown": "string",
    "UserPreferencesHasCelebrationBadge": "string",
    "UserPreferencesHasSentWarningEmail": "string",
    "UserPreferencesHasSentWarningEmail238": "string",
    "UserPreferencesHasSentWarningEmail240": "string",
    "UserPreferencesHideBiggerPhotoCallout": "string",
    "UserPreferencesHideBrowseProductRedirectConfirmation": "string",
    "UserPreferencesHideCSNDesktopTask": "string",
    "UserPreferencesHideCSNGetChatterMobileTask": "string",
    "UserPreferencesHideChatterOnboardingSplash": "string",
    "UserPreferencesHideEndUserOnboardingAssistantModal": "string",
    "UserPreferencesHideLightningMigrationModal": "string",
    "UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal": "string",
    "UserPreferencesHideOnlineSalesAppWelcomeMat": "string",
    "UserPreferencesHideS1BrowserUI": "string",
    "UserPreferencesHideSecondChatterOnboardingSplash": "string",
    "UserPreferencesHideSfxWelcomeMat": "string",
    "UserPreferencesLightningExperiencePreferred": "string",
    "UserPreferencesLiveAgentMiawSetupDeflection": "string",
    "UserPreferencesNativeEmailClient": "string",
    "UserPreferencesNewLightningReportRunPageEnabled": "string",
    "UserPreferencesPathAssistantCollapsed": "string",
    "UserPreferencesPreviewCustomTheme": "string",
    "UserPreferencesPreviewLightning": "string",
    "UserPreferencesReceiveNoNotificationsAsApprover": "string",
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": "string",
    "UserPreferencesRecordHomeReservedWTShown": "string",
    "UserPreferencesRecordHomeSectionCollapseWTShown": "string",
    "UserPreferencesReminderSoundOff": "string",
    "UserPreferencesReverseOpenActivitiesView": "string",
    "UserPreferencesSRHOverrideActivities": "string",
    "UserPreferencesShowCityToExternalUsers": "string",
    "UserPreferencesShowCityToGuestUsers": "string",
    "UserPreferencesShowCountryToExternalUsers": "string",
    "UserPreferencesShowCountryToGuestUsers": "string",
    "UserPreferencesShowEmailToExternalUsers": "string",
    "UserPreferencesShowEmailToGuestUsers": "string",
    "UserPreferencesShowFaxToExternalUsers": "string",
    "UserPreferencesShowFaxToGuestUsers": "string",
    "UserPreferencesShowForecastingChangeSignals": "string",
    "UserPreferencesShowForecastingRoundedAmounts": "string",
    "UserPreferencesShowManagerToExternalUsers": "string",
    "UserPreferencesShowManagerToGuestUsers": "string",
    "UserPreferencesShowMobilePhoneToExternalUsers": "string",
    "UserPreferencesShowMobilePhoneToGuestUsers": "string",
    "UserPreferencesShowPostalCodeToExternalUsers": "string",
    "UserPreferencesShowPostalCodeToGuestUsers": "string",
    "UserPreferencesShowProfilePicToGuestUsers": "string",
    "UserPreferencesShowStateToExternalUsers": "string",
    "UserPreferencesShowStateToGuestUsers": "string",
    "UserPreferencesShowStreetAddressToExternalUsers": "string",
    "UserPreferencesShowStreetAddressToGuestUsers": "string",
    "UserPreferencesShowTitleToExternalUsers": "string",
    "UserPreferencesShowTitleToGuestUsers": "string",
    "UserPreferencesShowWorkPhoneToExternalUsers": "string",
    "UserPreferencesShowWorkPhoneToGuestUsers": "string",
    "UserPreferencesSortFeedByComment": "string",
    "UserPreferencesSuppressEventSFXReminders": "string",
    "UserPreferencesSuppressTaskSFXReminders": "string",
    "UserPreferencesTaskRemindersCheckboxDefault": "string",
    "UserPreferencesUserDebugModePref": "string",
    "UserRoleId": "string",
    "UserType": "string",
    "Username": "string",
    "dsfs__DSProSFMembershipStatus__c": "string",
    "dsfs__DSProSFPassword__c": "string",
    "dsfs__DSProSFUsername__c": "string",
    "dupcheck__dc3DisableDCTriggers__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "pi__Can_View_Not_Assigned_Prospects__c": "string",
    "pi__Pardot_Api_Key__c": "string",
    "pi__Pardot_Api_Version__c": "string",
    "pi__Pardot_User_Id__c": "string",
    "pi__Pardot_User_Key__c": "string",
    "pi__Pardot_User_Role__c": "string"
}

schema_name_id: 1456
schema_scan_id: 6197201
updated: 2025-01-09 15:14:46

Version 693443

created: 2024-05-01 08:54:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_users`\n(\n `Id`  string , `Username`  string , `LastName`  string , `FirstName`  string , `Name`  string , `CompanyName`  string , `Division`  string , `Department`  string , `Title`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Email`  string , `EmailPreferencesAutoBcc`  string , `EmailPreferencesAutoBccStayInTouch`  string , `EmailPreferencesStayInTouchReminder`  string , `SenderEmail`  string , `SenderName`  string , `Signature`  string , `StayInTouchSubject`  string , `StayInTouchSignature`  string , `StayInTouchNote`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `Alias`  string , `CommunityNickname`  string , `BadgeText`  string , `IsActive`  string , `TimeZoneSidKey`  string , `UserRoleId`  string , `LocaleSidKey`  string , `ReceivesInfoEmails`  string , `ReceivesAdminInfoEmails`  string , `EmailEncodingKey`  string , `DefaultCurrencyIsoCode`  string , `CurrencyIsoCode`  string , `ProfileId`  string , `UserType`  string , `LanguageLocaleKey`  string , `EmployeeNumber`  string , `DelegatedApproverId`  string , `ManagerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `NumberOfFailedLogins`  string , `OfflineTrialExpirationDate`  string , `OfflinePdaTrialExpirationDate`  string , `UserPermissionsMarketingUser`  string , `UserPermissionsOfflineUser`  string , `UserPermissionsAvantgoUser`  string , `UserPermissionsCallCenterAutoLogin`  string , `UserPermissionsSFContentUser`  string , `UserPermissionsKnowledgeUser`  string , `UserPermissionsInteractionUser`  string , `UserPermissionsSupportUser`  string , `UserPermissionsLiveAgentUser`  string , `ForecastEnabled`  string , `UserPreferencesActivityRemindersPopup`  string , `UserPreferencesEventRemindersCheckboxDefault`  string , `UserPreferencesTaskRemindersCheckboxDefault`  string , `UserPreferencesReminderSoundOff`  string , `UserPreferencesDisableAllFeedsEmail`  string , `UserPreferencesDisableFollowersEmail`  string , `UserPreferencesDisableProfilePostEmail`  string , `UserPreferencesDisableChangeCommentEmail`  string , `UserPreferencesDisableLaterCommentEmail`  string , `UserPreferencesDisProfPostCommentEmail`  string , `UserPreferencesContentNoEmail`  string , `UserPreferencesContentEmailAsAndWhen`  string , `UserPreferencesApexPagesDeveloperMode`  string , `UserPreferencesReceiveNoNotificationsAsApprover`  string , `UserPreferencesReceiveNotificationsAsDelegatedApprover`  string , `UserPreferencesHideCSNGetChatterMobileTask`  string , `UserPreferencesDisableMentionsPostEmail`  string , `UserPreferencesDisMentionsCommentEmail`  string , `UserPreferencesHideCSNDesktopTask`  string , `UserPreferencesHideChatterOnboardingSplash`  string , `UserPreferencesHideSecondChatterOnboardingSplash`  string , `UserPreferencesDisCommentAfterLikeEmail`  string , `UserPreferencesDisableLikeEmail`  string , `UserPreferencesSortFeedByComment`  string , `UserPreferencesDisableMessageEmail`  string , `UserPreferencesDisableBookmarkEmail`  string , `UserPreferencesDisableSharePostEmail`  string , `UserPreferencesEnableAutoSubForFeeds`  string , `UserPreferencesDisableFileShareNotificationsForApi`  string , `UserPreferencesShowTitleToExternalUsers`  string , `UserPreferencesShowManagerToExternalUsers`  string , `UserPreferencesShowEmailToExternalUsers`  string , `UserPreferencesShowWorkPhoneToExternalUsers`  string , `UserPreferencesShowMobilePhoneToExternalUsers`  string , `UserPreferencesShowFaxToExternalUsers`  string , `UserPreferencesShowStreetAddressToExternalUsers`  string , `UserPreferencesShowCityToExternalUsers`  string , `UserPreferencesShowStateToExternalUsers`  string , `UserPreferencesShowPostalCodeToExternalUsers`  string , `UserPreferencesShowCountryToExternalUsers`  string , `UserPreferencesShowProfilePicToGuestUsers`  string , `UserPreferencesShowTitleToGuestUsers`  string , `UserPreferencesShowCityToGuestUsers`  string , `UserPreferencesShowStateToGuestUsers`  string , `UserPreferencesShowPostalCodeToGuestUsers`  string , `UserPreferencesShowCountryToGuestUsers`  string , `UserPreferencesShowForecastingChangeSignals`  string , `UserPreferencesHideS1BrowserUI`  string , `UserPreferencesDisableEndorsementEmail`  string , `UserPreferencesPathAssistantCollapsed`  string , `UserPreferencesCacheDiagnostics`  string , `UserPreferencesShowEmailToGuestUsers`  string , `UserPreferencesShowManagerToGuestUsers`  string , `UserPreferencesShowWorkPhoneToGuestUsers`  string , `UserPreferencesShowMobilePhoneToGuestUsers`  string , `UserPreferencesShowFaxToGuestUsers`  string , `UserPreferencesShowStreetAddressToGuestUsers`  string , `UserPreferencesLightningExperiencePreferred`  string , `UserPreferencesPreviewLightning`  string , `UserPreferencesHideEndUserOnboardingAssistantModal`  string , `UserPreferencesHideLightningMigrationModal`  string , `UserPreferencesHideSfxWelcomeMat`  string , `UserPreferencesHideBiggerPhotoCallout`  string , `UserPreferencesGlobalNavBarWTShown`  string , `UserPreferencesGlobalNavGridMenuWTShown`  string , `UserPreferencesCreateLEXAppsWTShown`  string , `UserPreferencesFavoritesWTShown`  string , `UserPreferencesRecordHomeSectionCollapseWTShown`  string , `UserPreferencesRecordHomeReservedWTShown`  string , `UserPreferencesFavoritesShowTopFavorites`  string , `UserPreferencesExcludeMailAppAttachments`  string , `UserPreferencesSuppressTaskSFXReminders`  string , `UserPreferencesSuppressEventSFXReminders`  string , `UserPreferencesPreviewCustomTheme`  string , `UserPreferencesHasCelebrationBadge`  string , `UserPreferencesUserDebugModePref`  string , `UserPreferencesSRHOverrideActivities`  string , `UserPreferencesNewLightningReportRunPageEnabled`  string , `UserPreferencesReverseOpenActivitiesView`  string , `UserPreferencesHasSentWarningEmail`  string , `UserPreferencesHasSentWarningEmail238`  string , `UserPreferencesHasSentWarningEmail240`  string , `UserPreferencesNativeEmailClient`  string , `UserPreferencesHideBrowseProductRedirectConfirmation`  string , `UserPreferencesHideOnlineSalesAppWelcomeMat`  string , `ContactId`  string , `AccountId`  string , `CallCenterId`  string , `Extension`  string , `FederationIdentifier`  string , `AboutMe`  string , `FullPhotoUrl`  string , `SmallPhotoUrl`  string , `IsExtIndicatorVisible`  string , `OutOfOfficeMessage`  string , `MediumPhotoUrl`  string , `DigestFrequency`  string , `DefaultGroupNotificationFrequency`  string , `BannerPhotoUrl`  string , `SmallBannerPhotoUrl`  string , `MediumBannerPhotoUrl`  string , `IsProfilePhotoActive`  string , `IndividualId`  string , `Territory__c`  string , `Sales_Admin__c`  string , `LDR__c`  string , `dsfs__DSProSFMembershipStatus__c`  string , `dsfs__DSProSFPassword__c`  string , `dsfs__DSProSFUsername__c`  string , `pi__Can_View_Not_Assigned_Prospects__c`  string , `pi__Pardot_Api_Key__c`  string , `pi__Pardot_User_Id__c`  string , `pi__Pardot_User_Key__c`  string , `pi__Pardot_User_Role__c`  string , `pi__Pardot_Api_Version__c`  string , `dupcheck__dc3DisableDCTriggers__c`  string , `Out_of_Office__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `UConference__UberConferenceId__c`  string , `Date_Training_Type_Set__c`  string , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__c`  string , `Support_Trainer__c`  string , `Training_Type__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-stage/raw/users/2024-05-01/1714571599'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_users"
]

hive_path: s3://sfdl-csv-salesforce-stage/raw/users/2024-05-01/1714571599
id: 693443
processed: 1

raw_data:

{
    "AboutMe": 156,
    "AccountId": 152,
    "Admin_Deactivation_Date__c": 189,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 164,
    "CallCenterId": 153,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 188,
    "ContactId": 151,
    "Country": 13,
    "CreatedById": 49,
    "CreatedDate": 48,
    "CurrencyIsoCode": 41,
    "Date_Training_Type_Set__c": 185,
    "DefaultCurrencyIsoCode": 40,
    "DefaultGroupNotificationFrequency": 163,
    "DelegatedApproverId": 46,
    "Department": 7,
    "DigestFrequency": 162,
    "Division": 6,
    "Email": 17,
    "EmailEncodingKey": 39,
    "EmailPreferencesAutoBcc": 18,
    "EmailPreferencesAutoBccStayInTouch": 19,
    "EmailPreferencesStayInTouchReminder": 20,
    "EmployeeNumber": 45,
    "Extension": 154,
    "Fax": 28,
    "FederationIdentifier": 155,
    "FirstName": 3,
    "ForecastEnabled": 65,
    "FullPhotoUrl": 157,
    "GeocodeAccuracy": 16,
    "Id": 0,
    "IndividualId": 168,
    "IsActive": 33,
    "IsExtIndicatorVisible": 159,
    "IsNotRecordOwner__c": 187,
    "IsProfilePhotoActive": 167,
    "LDR__c": 171,
    "LanguageLocaleKey": 44,
    "LastModifiedById": 51,
    "LastModifiedDate": 50,
    "LastName": 2,
    "Latitude": 14,
    "LocaleSidKey": 36,
    "Longitude": 15,
    "ManagerId": 47,
    "MediumBannerPhotoUrl": 166,
    "MediumPhotoUrl": 161,
    "MobilePhone": 29,
    "Name": 4,
    "NumberOfFailedLogins": 53,
    "OfflinePdaTrialExpirationDate": 55,
    "OfflineTrialExpirationDate": 54,
    "OutOfOfficeMessage": 160,
    "Out_of_Office__c": 182,
    "Phone": 27,
    "PostalCode": 12,
    "ProfileId": 42,
    "ReceivesAdminInfoEmails": 38,
    "ReceivesInfoEmails": 37,
    "Sales_Admin__c": 170,
    "Sales_Segment__c": 186,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 165,
    "SmallPhotoUrl": 158,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "Support_Trainer__c": 190,
    "SystemModstamp": 52,
    "Territory__c": 169,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "Training_Type__c": 191,
    "UConference__UberConferenceId__c": 184,
    "UserPermissionsAvantgoUser": 58,
    "UserPermissionsCallCenterAutoLogin": 59,
    "UserPermissionsInteractionUser": 62,
    "UserPermissionsKnowledgeUser": 61,
    "UserPermissionsLiveAgentUser": 64,
    "UserPermissionsMarketingUser": 56,
    "UserPermissionsOfflineUser": 57,
    "UserPermissionsSFContentUser": 60,
    "UserPermissionsSupportUser": 63,
    "UserPreferencesActivityRemindersPopup": 66,
    "UserPreferencesApexPagesDeveloperMode": 78,
    "UserPreferencesCacheDiagnostics": 116,
    "UserPreferencesContentEmailAsAndWhen": 77,
    "UserPreferencesContentNoEmail": 76,
    "UserPreferencesCreateLEXAppsWTShown": 131,
    "UserPreferencesDisCommentAfterLikeEmail": 87,
    "UserPreferencesDisMentionsCommentEmail": 83,
    "UserPreferencesDisProfPostCommentEmail": 75,
    "UserPreferencesDisableAllFeedsEmail": 70,
    "UserPreferencesDisableBookmarkEmail": 91,
    "UserPreferencesDisableChangeCommentEmail": 73,
    "UserPreferencesDisableEndorsementEmail": 114,
    "UserPreferencesDisableFileShareNotificationsForApi": 94,
    "UserPreferencesDisableFollowersEmail": 71,
    "UserPreferencesDisableLaterCommentEmail": 74,
    "UserPreferencesDisableLikeEmail": 88,
    "UserPreferencesDisableMentionsPostEmail": 82,
    "UserPreferencesDisableMessageEmail": 90,
    "UserPreferencesDisableProfilePostEmail": 72,
    "UserPreferencesDisableSharePostEmail": 92,
    "UserPreferencesEnableAutoSubForFeeds": 93,
    "UserPreferencesEventRemindersCheckboxDefault": 67,
    "UserPreferencesExcludeMailAppAttachments": 136,
    "UserPreferencesFavoritesShowTopFavorites": 135,
    "UserPreferencesFavoritesWTShown": 132,
    "UserPreferencesGlobalNavBarWTShown": 129,
    "UserPreferencesGlobalNavGridMenuWTShown": 130,
    "UserPreferencesHasCelebrationBadge": 140,
    "UserPreferencesHasSentWarningEmail": 145,
    "UserPreferencesHasSentWarningEmail238": 146,
    "UserPreferencesHasSentWarningEmail240": 147,
    "UserPreferencesHideBiggerPhotoCallout": 128,
    "UserPreferencesHideBrowseProductRedirectConfirmation": 149,
    "UserPreferencesHideCSNDesktopTask": 84,
    "UserPreferencesHideCSNGetChatterMobileTask": 81,
    "UserPreferencesHideChatterOnboardingSplash": 85,
    "UserPreferencesHideEndUserOnboardingAssistantModal": 125,
    "UserPreferencesHideLightningMigrationModal": 126,
    "UserPreferencesHideOnlineSalesAppWelcomeMat": 150,
    "UserPreferencesHideS1BrowserUI": 113,
    "UserPreferencesHideSecondChatterOnboardingSplash": 86,
    "UserPreferencesHideSfxWelcomeMat": 127,
    "UserPreferencesLightningExperiencePreferred": 123,
    "UserPreferencesNativeEmailClient": 148,
    "UserPreferencesNewLightningReportRunPageEnabled": 143,
    "UserPreferencesPathAssistantCollapsed": 115,
    "UserPreferencesPreviewCustomTheme": 139,
    "UserPreferencesPreviewLightning": 124,
    "UserPreferencesReceiveNoNotificationsAsApprover": 79,
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": 80,
    "UserPreferencesRecordHomeReservedWTShown": 134,
    "UserPreferencesRecordHomeSectionCollapseWTShown": 133,
    "UserPreferencesReminderSoundOff": 69,
    "UserPreferencesReverseOpenActivitiesView": 144,
    "UserPreferencesSRHOverrideActivities": 142,
    "UserPreferencesShowCityToExternalUsers": 102,
    "UserPreferencesShowCityToGuestUsers": 108,
    "UserPreferencesShowCountryToExternalUsers": 105,
    "UserPreferencesShowCountryToGuestUsers": 111,
    "UserPreferencesShowEmailToExternalUsers": 97,
    "UserPreferencesShowEmailToGuestUsers": 117,
    "UserPreferencesShowFaxToExternalUsers": 100,
    "UserPreferencesShowFaxToGuestUsers": 121,
    "UserPreferencesShowForecastingChangeSignals": 112,
    "UserPreferencesShowManagerToExternalUsers": 96,
    "UserPreferencesShowManagerToGuestUsers": 118,
    "UserPreferencesShowMobilePhoneToExternalUsers": 99,
    "UserPreferencesShowMobilePhoneToGuestUsers": 120,
    "UserPreferencesShowPostalCodeToExternalUsers": 104,
    "UserPreferencesShowPostalCodeToGuestUsers": 110,
    "UserPreferencesShowProfilePicToGuestUsers": 106,
    "UserPreferencesShowStateToExternalUsers": 103,
    "UserPreferencesShowStateToGuestUsers": 109,
    "UserPreferencesShowStreetAddressToExternalUsers": 101,
    "UserPreferencesShowStreetAddressToGuestUsers": 122,
    "UserPreferencesShowTitleToExternalUsers": 95,
    "UserPreferencesShowTitleToGuestUsers": 107,
    "UserPreferencesShowWorkPhoneToExternalUsers": 98,
    "UserPreferencesShowWorkPhoneToGuestUsers": 119,
    "UserPreferencesSortFeedByComment": 89,
    "UserPreferencesSuppressEventSFXReminders": 138,
    "UserPreferencesSuppressTaskSFXReminders": 137,
    "UserPreferencesTaskRemindersCheckboxDefault": 68,
    "UserPreferencesUserDebugModePref": 141,
    "UserRoleId": 35,
    "UserType": 43,
    "Username": 1,
    "dsfs__DSProSFMembershipStatus__c": 172,
    "dsfs__DSProSFPassword__c": 173,
    "dsfs__DSProSFUsername__c": 174,
    "dupcheck__dc3DisableDCTriggers__c": 181,
    "dupcheck__dc3DisableDuplicateCheck__c": 183,
    "pi__Can_View_Not_Assigned_Prospects__c": 175,
    "pi__Pardot_Api_Key__c": 176,
    "pi__Pardot_Api_Version__c": 180,
    "pi__Pardot_User_Id__c": 177,
    "pi__Pardot_User_Key__c": 178,
    "pi__Pardot_User_Role__c": 179
}

schema_attributes:

{
    "AboutMe": "string",
    "AccountId": "string",
    "Admin_Deactivation_Date__c": "string",
    "Alias": "string",
    "Amount": "string",
    "BadgeText": "string",
    "BannerPhotoUrl": "string",
    "CallCenterId": "string",
    "City": "string",
    "CloseDate": "string",
    "CommunityNickname": "string",
    "CompanyName": "string",
    "Company_of_Origin__c": "string",
    "ContactId": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Date_Training_Type_Set__c": "string",
    "DefaultCurrencyIsoCode": "string",
    "DefaultGroupNotificationFrequency": "string",
    "DelegatedApproverId": "string",
    "Department": "string",
    "DigestFrequency": "string",
    "Division": "string",
    "Email": "string",
    "EmailEncodingKey": "string",
    "EmailPreferencesAutoBcc": "string",
    "EmailPreferencesAutoBccStayInTouch": "string",
    "EmailPreferencesStayInTouchReminder": "string",
    "EmployeeNumber": "string",
    "ExpectedRevenue": "string",
    "Extension": "string",
    "Fax": "string",
    "FederationIdentifier": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "ForecastEnabled": "string",
    "FullPhotoUrl": "string",
    "GeocodeAccuracy": "string",
    "Id": "string",
    "IndividualId": "string",
    "IsActive": "string",
    "IsDeleted": "string",
    "IsExtIndicatorVisible": "string",
    "IsNotRecordOwner__c": "string",
    "IsProfilePhotoActive": "string",
    "LDR__c": "string",
    "LanguageLocaleKey": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "Latitude": "string",
    "LocaleSidKey": "string",
    "Longitude": "string",
    "ManagerId": "string",
    "MediumBannerPhotoUrl": "string",
    "MediumPhotoUrl": "string",
    "MobilePhone": "string",
    "Name": "string",
    "NumberOfFailedLogins": "string",
    "OfflinePdaTrialExpirationDate": "string",
    "OfflineTrialExpirationDate": "string",
    "OpportunityId": "string",
    "OutOfOfficeMessage": "string",
    "Out_of_Office__c": "string",
    "Phone": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProfileId": "string",
    "ReceivesAdminInfoEmails": "string",
    "ReceivesInfoEmails": "string",
    "Sales_Admin__c": "string",
    "Sales_Segment__c": "string",
    "SenderEmail": "string",
    "SenderName": "string",
    "Signature": "string",
    "SmallBannerPhotoUrl": "string",
    "SmallPhotoUrl": "string",
    "StageName": "string",
    "State": "string",
    "StayInTouchNote": "string",
    "StayInTouchSignature": "string",
    "StayInTouchSubject": "string",
    "Street": "string",
    "Support_Trainer__c": "string",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "string",
    "Training_Type__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UserPermissionsAvantgoUser": "string",
    "UserPermissionsCallCenterAutoLogin": "string",
    "UserPermissionsInteractionUser": "string",
    "UserPermissionsKnowledgeUser": "string",
    "UserPermissionsLiveAgentUser": "string",
    "UserPermissionsMarketingUser": "string",
    "UserPermissionsOfflineUser": "string",
    "UserPermissionsSFContentUser": "string",
    "UserPermissionsSupportUser": "string",
    "UserPreferencesActivityRemindersPopup": "string",
    "UserPreferencesApexPagesDeveloperMode": "string",
    "UserPreferencesCacheDiagnostics": "string",
    "UserPreferencesContentEmailAsAndWhen": "string",
    "UserPreferencesContentNoEmail": "string",
    "UserPreferencesCreateLEXAppsWTShown": "string",
    "UserPreferencesDisCommentAfterLikeEmail": "string",
    "UserPreferencesDisMentionsCommentEmail": "string",
    "UserPreferencesDisProfPostCommentEmail": "string",
    "UserPreferencesDisableAllFeedsEmail": "string",
    "UserPreferencesDisableBookmarkEmail": "string",
    "UserPreferencesDisableChangeCommentEmail": "string",
    "UserPreferencesDisableEndorsementEmail": "string",
    "UserPreferencesDisableFileShareNotificationsForApi": "string",
    "UserPreferencesDisableFollowersEmail": "string",
    "UserPreferencesDisableLaterCommentEmail": "string",
    "UserPreferencesDisableLikeEmail": "string",
    "UserPreferencesDisableMentionsPostEmail": "string",
    "UserPreferencesDisableMessageEmail": "string",
    "UserPreferencesDisableProfilePostEmail": "string",
    "UserPreferencesDisableSharePostEmail": "string",
    "UserPreferencesEnableAutoSubForFeeds": "string",
    "UserPreferencesEventRemindersCheckboxDefault": "string",
    "UserPreferencesExcludeMailAppAttachments": "string",
    "UserPreferencesFavoritesShowTopFavorites": "string",
    "UserPreferencesFavoritesWTShown": "string",
    "UserPreferencesGlobalNavBarWTShown": "string",
    "UserPreferencesGlobalNavGridMenuWTShown": "string",
    "UserPreferencesHasCelebrationBadge": "string",
    "UserPreferencesHasSentWarningEmail": "string",
    "UserPreferencesHasSentWarningEmail238": "string",
    "UserPreferencesHasSentWarningEmail240": "string",
    "UserPreferencesHideBiggerPhotoCallout": "string",
    "UserPreferencesHideBrowseProductRedirectConfirmation": "string",
    "UserPreferencesHideCSNDesktopTask": "string",
    "UserPreferencesHideCSNGetChatterMobileTask": "string",
    "UserPreferencesHideChatterOnboardingSplash": "string",
    "UserPreferencesHideEndUserOnboardingAssistantModal": "string",
    "UserPreferencesHideLightningMigrationModal": "string",
    "UserPreferencesHideOnlineSalesAppWelcomeMat": "string",
    "UserPreferencesHideS1BrowserUI": "string",
    "UserPreferencesHideSecondChatterOnboardingSplash": "string",
    "UserPreferencesHideSfxWelcomeMat": "string",
    "UserPreferencesLightningExperiencePreferred": "string",
    "UserPreferencesNativeEmailClient": "string",
    "UserPreferencesNewLightningReportRunPageEnabled": "string",
    "UserPreferencesPathAssistantCollapsed": "string",
    "UserPreferencesPreviewCustomTheme": "string",
    "UserPreferencesPreviewLightning": "string",
    "UserPreferencesReceiveNoNotificationsAsApprover": "string",
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": "string",
    "UserPreferencesRecordHomeReservedWTShown": "string",
    "UserPreferencesRecordHomeSectionCollapseWTShown": "string",
    "UserPreferencesReminderSoundOff": "string",
    "UserPreferencesReverseOpenActivitiesView": "string",
    "UserPreferencesSRHOverrideActivities": "string",
    "UserPreferencesShowCityToExternalUsers": "string",
    "UserPreferencesShowCityToGuestUsers": "string",
    "UserPreferencesShowCountryToExternalUsers": "string",
    "UserPreferencesShowCountryToGuestUsers": "string",
    "UserPreferencesShowEmailToExternalUsers": "string",
    "UserPreferencesShowEmailToGuestUsers": "string",
    "UserPreferencesShowFaxToExternalUsers": "string",
    "UserPreferencesShowFaxToGuestUsers": "string",
    "UserPreferencesShowForecastingChangeSignals": "string",
    "UserPreferencesShowManagerToExternalUsers": "string",
    "UserPreferencesShowManagerToGuestUsers": "string",
    "UserPreferencesShowMobilePhoneToExternalUsers": "string",
    "UserPreferencesShowMobilePhoneToGuestUsers": "string",
    "UserPreferencesShowPostalCodeToExternalUsers": "string",
    "UserPreferencesShowPostalCodeToGuestUsers": "string",
    "UserPreferencesShowProfilePicToGuestUsers": "string",
    "UserPreferencesShowStateToExternalUsers": "string",
    "UserPreferencesShowStateToGuestUsers": "string",
    "UserPreferencesShowStreetAddressToExternalUsers": "string",
    "UserPreferencesShowStreetAddressToGuestUsers": "string",
    "UserPreferencesShowTitleToExternalUsers": "string",
    "UserPreferencesShowTitleToGuestUsers": "string",
    "UserPreferencesShowWorkPhoneToExternalUsers": "string",
    "UserPreferencesShowWorkPhoneToGuestUsers": "string",
    "UserPreferencesSortFeedByComment": "string",
    "UserPreferencesSuppressEventSFXReminders": "string",
    "UserPreferencesSuppressTaskSFXReminders": "string",
    "UserPreferencesTaskRemindersCheckboxDefault": "string",
    "UserPreferencesUserDebugModePref": "string",
    "UserRoleId": "string",
    "UserType": "string",
    "Username": "string",
    "dsfs__DSProSFMembershipStatus__c": "string",
    "dsfs__DSProSFPassword__c": "string",
    "dsfs__DSProSFUsername__c": "string",
    "dupcheck__dc3DisableDCTriggers__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "pi__Can_View_Not_Assigned_Prospects__c": "string",
    "pi__Pardot_Api_Key__c": "string",
    "pi__Pardot_Api_Version__c": "string",
    "pi__Pardot_User_Id__c": "string",
    "pi__Pardot_User_Key__c": "string",
    "pi__Pardot_User_Role__c": "string"
}

schema_name_id: 1456
schema_scan_id: 5671838
updated: 2024-05-01 08:55:10

Schema Scans: 3

Last at 2026-02-27 09:11:43

Scan 6391673

duration: 0:00:20.555225

exit_message:

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

id: 6391673

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/users/2026-02-27/1772205020",
        "key": "raw/users/2026-02-27/1772205020/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 10247352395389878788,
        "service_name": "drive-thru",
        "span_id": 6274915573769481045,
        "trace_id": 17714978197406914710
    }
}

running: False
schema_name_id: 1456
start_time: 2026-02-27 09:11:43
success: True
trace_id: 17714978197406914710

Scan 6197201

duration: 0:00:17.367463

exit_message:

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

id: 6197201

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/users/2025-01-09/1736457234",
        "key": "raw/users/2025-01-09/1736457234/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2818342769407836972,
        "service_name": "drive-thru",
        "span_id": 226932923362047783,
        "trace_id": 7449744904545251213
    }
}

running: False
schema_name_id: 1456
start_time: 2025-01-09 15:14:29
success: True
trace_id: 7449744904545251213

Scan 5671838

duration: 0:00:19.392478

exit_message:

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

id: 5671838

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-stage",
        "hive_path": "s3://sfdl-csv-salesforce-stage/raw/users/2024-05-01/1714571599",
        "key": "raw/users/2024-05-01/1714571599/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2411862592650727372,
        "service_name": "drive-thru",
        "span_id": 3592188764366808817,
        "trace_id": 7922551966041357283
    }
}

running: False
schema_name_id: 1456
start_time: 2024-05-01 08:54:50
success: True
trace_id: 7922551966041357283

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "AboutMe": "string",
    "AccountId": "string",
    "Admin_Deactivation_Date__c": "string",
    "Alias": "string",
    "Amount": "string",
    "BadgeText": "string",
    "BannerPhotoUrl": "string",
    "CallCenterId": "string",
    "City": "string",
    "CloseDate": "string",
    "CommunityNickname": "string",
    "CompanyName": "string",
    "Company_of_Origin__c": "string",
    "ContactId": "string",
    "Country": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "CurrencyIsoCode": "string",
    "Date_Training_Type_Set__c": "string",
    "DefaultCurrencyIsoCode": "string",
    "DefaultGroupNotificationFrequency": "string",
    "DelegatedApproverId": "string",
    "Department": "string",
    "DigestFrequency": "string",
    "Division": "string",
    "Email": "string",
    "EmailEncodingKey": "string",
    "EmailPreferencesAutoBcc": "string",
    "EmailPreferencesAutoBccStayInTouch": "string",
    "EmailPreferencesStayInTouchReminder": "string",
    "EmployeeNumber": "string",
    "EndDay": "string",
    "Escalate_Case__c": "string",
    "ExpectedRevenue": "string",
    "Extension": "string",
    "Fax": "string",
    "FederationIdentifier": "string",
    "FirstName": "string",
    "ForecastCategory": "string",
    "ForecastEnabled": "string",
    "FullPhotoUrl": "string",
    "GeocodeAccuracy": "string",
    "HasUserVerifiedEmail": "string",
    "HasUserVerifiedPhone": "string",
    "Id": "string",
    "IndividualId": "string",
    "IsActive": "string",
    "IsDeleted": "string",
    "IsExtIndicatorVisible": "string",
    "IsNotRecordOwner__c": "string",
    "IsProfilePhotoActive": "string",
    "LDR__c": "string",
    "LanguageLocaleKey": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LastName": "string",
    "Latitude": "string",
    "LocaleSidKey": "string",
    "Longitude": "string",
    "ManagerId": "string",
    "MediumBannerPhotoUrl": "string",
    "MediumPhotoUrl": "string",
    "MigrationId__c": "string",
    "MobilePhone": "string",
    "Name": "string",
    "NumberOfFailedLogins": "string",
    "OfflinePdaTrialExpirationDate": "string",
    "OfflineTrialExpirationDate": "string",
    "OpportunityId": "string",
    "OutOfOfficeMessage": "string",
    "Out_of_Office__c": "string",
    "PasswordExpirationDate": "string",
    "Phone": "string",
    "PostalCode": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Probability": "string",
    "ProfileId": "string",
    "ReceivesAdminInfoEmails": "string",
    "ReceivesInfoEmails": "string",
    "Sales_Admin__c": "string",
    "Sales_Segment__c": "string",
    "SenderEmail": "string",
    "SenderName": "string",
    "Signature": "string",
    "SmallBannerPhotoUrl": "string",
    "SmallPhotoUrl": "string",
    "StageName": "string",
    "StartDay": "string",
    "State": "string",
    "StayInTouchNote": "string",
    "StayInTouchSignature": "string",
    "StayInTouchSubject": "string",
    "Street": "string",
    "SuAccessExpirationDate": "string",
    "Support_Trainer__c": "string",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "string",
    "Training_Type__c": "string",
    "UConference__UberConferenceId__c": "string",
    "UserPermissionsAvantgoUser": "string",
    "UserPermissionsCallCenterAutoLogin": "string",
    "UserPermissionsInteractionUser": "string",
    "UserPermissionsKnowledgeUser": "string",
    "UserPermissionsLiveAgentUser": "string",
    "UserPermissionsMarketingUser": "string",
    "UserPermissionsOfflineUser": "string",
    "UserPermissionsSFContentUser": "string",
    "UserPermissionsSupportUser": "string",
    "UserPreferencesActionLauncherEinsteinGptConsent": "string",
    "UserPreferencesActivityRemindersPopup": "string",
    "UserPreferencesApexPagesDeveloperMode": "string",
    "UserPreferencesAssistiveActionsEnabledInActionLauncher": "string",
    "UserPreferencesBRELookupTableWelcomeMat": "string",
    "UserPreferencesCacheDiagnostics": "string",
    "UserPreferencesContentEmailAsAndWhen": "string",
    "UserPreferencesContentNoEmail": "string",
    "UserPreferencesCreateLEXAppsWTShown": "string",
    "UserPreferencesDisCommentAfterLikeEmail": "string",
    "UserPreferencesDisMentionsCommentEmail": "string",
    "UserPreferencesDisProfPostCommentEmail": "string",
    "UserPreferencesDisableAllFeedsEmail": "string",
    "UserPreferencesDisableBookmarkEmail": "string",
    "UserPreferencesDisableChangeCommentEmail": "string",
    "UserPreferencesDisableEndorsementEmail": "string",
    "UserPreferencesDisableFileShareNotificationsForApi": "string",
    "UserPreferencesDisableFollowersEmail": "string",
    "UserPreferencesDisableLaterCommentEmail": "string",
    "UserPreferencesDisableLikeEmail": "string",
    "UserPreferencesDisableMentionsPostEmail": "string",
    "UserPreferencesDisableMessageEmail": "string",
    "UserPreferencesDisableProfilePostEmail": "string",
    "UserPreferencesDisableSharePostEmail": "string",
    "UserPreferencesEnableAutoSubForFeeds": "string",
    "UserPreferencesEventRemindersCheckboxDefault": "string",
    "UserPreferencesExcludeMailAppAttachments": "string",
    "UserPreferencesFavoritesShowTopFavorites": "string",
    "UserPreferencesFavoritesWTShown": "string",
    "UserPreferencesGlobalNavBarWTShown": "string",
    "UserPreferencesGlobalNavGridMenuWTShown": "string",
    "UserPreferencesHasCelebrationBadge": "string",
    "UserPreferencesHasSentWarningEmail": "string",
    "UserPreferencesHasSentWarningEmail238": "string",
    "UserPreferencesHasSentWarningEmail240": "string",
    "UserPreferencesHideBiggerPhotoCallout": "string",
    "UserPreferencesHideBrowseProductRedirectConfirmation": "string",
    "UserPreferencesHideCSNDesktopTask": "string",
    "UserPreferencesHideCSNGetChatterMobileTask": "string",
    "UserPreferencesHideChatterOnboardingSplash": "string",
    "UserPreferencesHideEndUserOnboardingAssistantModal": "string",
    "UserPreferencesHideLightningMigrationModal": "string",
    "UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal": "string",
    "UserPreferencesHideOnlineSalesAppWelcomeMat": "string",
    "UserPreferencesHideS1BrowserUI": "string",
    "UserPreferencesHideSecondChatterOnboardingSplash": "string",
    "UserPreferencesHideSfxWelcomeMat": "string",
    "UserPreferencesLightningExperiencePreferred": "string",
    "UserPreferencesLiveAgentMiawSetupDeflection": "string",
    "UserPreferencesNativeEmailClient": "string",
    "UserPreferencesNewLightningReportRunPageEnabled": "string",
    "UserPreferencesPathAssistantCollapsed": "string",
    "UserPreferencesPreviewCustomTheme": "string",
    "UserPreferencesPreviewLightning": "string",
    "UserPreferencesReceiveNoNotificationsAsApprover": "string",
    "UserPreferencesReceiveNotificationsAsDelegatedApprover": "string",
    "UserPreferencesRecordHomeReservedWTShown": "string",
    "UserPreferencesRecordHomeSectionCollapseWTShown": "string",
    "UserPreferencesReminderSoundOff": "string",
    "UserPreferencesReverseOpenActivitiesView": "string",
    "UserPreferencesSRHOverrideActivities": "string",
    "UserPreferencesShowCityToExternalUsers": "string",
    "UserPreferencesShowCityToGuestUsers": "string",
    "UserPreferencesShowCountryToExternalUsers": "string",
    "UserPreferencesShowCountryToGuestUsers": "string",
    "UserPreferencesShowEmailToExternalUsers": "string",
    "UserPreferencesShowEmailToGuestUsers": "string",
    "UserPreferencesShowFaxToExternalUsers": "string",
    "UserPreferencesShowFaxToGuestUsers": "string",
    "UserPreferencesShowForecastingChangeSignals": "string",
    "UserPreferencesShowForecastingRoundedAmounts": "string",
    "UserPreferencesShowManagerToExternalUsers": "string",
    "UserPreferencesShowManagerToGuestUsers": "string",
    "UserPreferencesShowMobilePhoneToExternalUsers": "string",
    "UserPreferencesShowMobilePhoneToGuestUsers": "string",
    "UserPreferencesShowPostalCodeToExternalUsers": "string",
    "UserPreferencesShowPostalCodeToGuestUsers": "string",
    "UserPreferencesShowProfilePicToGuestUsers": "string",
    "UserPreferencesShowStateToExternalUsers": "string",
    "UserPreferencesShowStateToGuestUsers": "string",
    "UserPreferencesShowStreetAddressToExternalUsers": "string",
    "UserPreferencesShowStreetAddressToGuestUsers": "string",
    "UserPreferencesShowTitleToExternalUsers": "string",
    "UserPreferencesShowTitleToGuestUsers": "string",
    "UserPreferencesShowWorkPhoneToExternalUsers": "string",
    "UserPreferencesShowWorkPhoneToGuestUsers": "string",
    "UserPreferencesSortFeedByComment": "string",
    "UserPreferencesSuppressEventSFXReminders": "string",
    "UserPreferencesSuppressTaskSFXReminders": "string",
    "UserPreferencesTaskRemindersCheckboxDefault": "string",
    "UserPreferencesUserDebugModePref": "string",
    "UserRoleId": "string",
    "UserType": "string",
    "Username": "string",
    "dsfs__DSProSFMembershipStatus__c": "string",
    "dsfs__DSProSFPassword__c": "string",
    "dsfs__DSProSFUsername__c": "string",
    "dupcheck__dc3DisableDCTriggers__c": "string",
    "dupcheck__dc3DisableDuplicateCheck__c": "string",
    "pi__Can_View_Not_Assigned_Prospects__c": "string",
    "pi__Pardot_Api_Key__c": "string",
    "pi__Pardot_Api_Version__c": "string",
    "pi__Pardot_User_Id__c": "string",
    "pi__Pardot_User_Key__c": "string",
    "pi__Pardot_User_Role__c": "string"
}

created: 2026-02-27 09:11:50

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_users`\n(\n `Id`  string , `Username`  string , `LastName`  string , `FirstName`  string , `Name`  string , `CompanyName`  string , `Division`  string , `Department`  string , `Title`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Email`  string , `EmailPreferencesAutoBcc`  string , `EmailPreferencesAutoBccStayInTouch`  string , `EmailPreferencesStayInTouchReminder`  string , `SenderEmail`  string , `SenderName`  string , `Signature`  string , `StayInTouchSubject`  string , `StayInTouchSignature`  string , `StayInTouchNote`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `Alias`  string , `CommunityNickname`  string , `BadgeText`  string , `IsActive`  string , `TimeZoneSidKey`  string , `UserRoleId`  string , `LocaleSidKey`  string , `ReceivesInfoEmails`  string , `ReceivesAdminInfoEmails`  string , `EmailEncodingKey`  string , `DefaultCurrencyIsoCode`  string , `CurrencyIsoCode`  string , `ProfileId`  string , `UserType`  string , `StartDay`  string , `EndDay`  string , `LanguageLocaleKey`  string , `EmployeeNumber`  string , `DelegatedApproverId`  string , `ManagerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `PasswordExpirationDate`  string , `NumberOfFailedLogins`  string , `SuAccessExpirationDate`  string , `OfflineTrialExpirationDate`  string , `OfflinePdaTrialExpirationDate`  string , `UserPermissionsMarketingUser`  string , `UserPermissionsOfflineUser`  string , `UserPermissionsAvantgoUser`  string , `UserPermissionsCallCenterAutoLogin`  string , `UserPermissionsSFContentUser`  string , `UserPermissionsKnowledgeUser`  string , `UserPermissionsInteractionUser`  string , `UserPermissionsSupportUser`  string , `UserPermissionsLiveAgentUser`  string , `ForecastEnabled`  string , `UserPreferencesActivityRemindersPopup`  string , `UserPreferencesEventRemindersCheckboxDefault`  string , `UserPreferencesTaskRemindersCheckboxDefault`  string , `UserPreferencesReminderSoundOff`  string , `UserPreferencesDisableAllFeedsEmail`  string , `UserPreferencesDisableFollowersEmail`  string , `UserPreferencesDisableProfilePostEmail`  string , `UserPreferencesDisableChangeCommentEmail`  string , `UserPreferencesDisableLaterCommentEmail`  string , `UserPreferencesDisProfPostCommentEmail`  string , `UserPreferencesContentNoEmail`  string , `UserPreferencesContentEmailAsAndWhen`  string , `UserPreferencesApexPagesDeveloperMode`  string , `UserPreferencesReceiveNoNotificationsAsApprover`  string , `UserPreferencesReceiveNotificationsAsDelegatedApprover`  string , `UserPreferencesHideCSNGetChatterMobileTask`  string , `UserPreferencesDisableMentionsPostEmail`  string , `UserPreferencesDisMentionsCommentEmail`  string , `UserPreferencesHideCSNDesktopTask`  string , `UserPreferencesHideChatterOnboardingSplash`  string , `UserPreferencesHideSecondChatterOnboardingSplash`  string , `UserPreferencesDisCommentAfterLikeEmail`  string , `UserPreferencesDisableLikeEmail`  string , `UserPreferencesSortFeedByComment`  string , `UserPreferencesDisableMessageEmail`  string , `UserPreferencesDisableBookmarkEmail`  string , `UserPreferencesDisableSharePostEmail`  string , `UserPreferencesActionLauncherEinsteinGptConsent`  string , `UserPreferencesAssistiveActionsEnabledInActionLauncher`  string , `UserPreferencesEnableAutoSubForFeeds`  string , `UserPreferencesDisableFileShareNotificationsForApi`  string , `UserPreferencesShowTitleToExternalUsers`  string , `UserPreferencesShowManagerToExternalUsers`  string , `UserPreferencesShowEmailToExternalUsers`  string , `UserPreferencesShowWorkPhoneToExternalUsers`  string , `UserPreferencesShowMobilePhoneToExternalUsers`  string , `UserPreferencesShowFaxToExternalUsers`  string , `UserPreferencesShowStreetAddressToExternalUsers`  string , `UserPreferencesShowCityToExternalUsers`  string , `UserPreferencesShowStateToExternalUsers`  string , `UserPreferencesShowPostalCodeToExternalUsers`  string , `UserPreferencesShowCountryToExternalUsers`  string , `UserPreferencesShowProfilePicToGuestUsers`  string , `UserPreferencesShowTitleToGuestUsers`  string , `UserPreferencesShowCityToGuestUsers`  string , `UserPreferencesShowStateToGuestUsers`  string , `UserPreferencesShowPostalCodeToGuestUsers`  string , `UserPreferencesShowCountryToGuestUsers`  string , `UserPreferencesShowForecastingChangeSignals`  string , `UserPreferencesLiveAgentMiawSetupDeflection`  string , `UserPreferencesHideS1BrowserUI`  string , `UserPreferencesDisableEndorsementEmail`  string , `UserPreferencesPathAssistantCollapsed`  string , `UserPreferencesCacheDiagnostics`  string , `UserPreferencesShowEmailToGuestUsers`  string , `UserPreferencesShowManagerToGuestUsers`  string , `UserPreferencesShowWorkPhoneToGuestUsers`  string , `UserPreferencesShowMobilePhoneToGuestUsers`  string , `UserPreferencesShowFaxToGuestUsers`  string , `UserPreferencesShowStreetAddressToGuestUsers`  string , `UserPreferencesLightningExperiencePreferred`  string , `UserPreferencesPreviewLightning`  string , `UserPreferencesHideEndUserOnboardingAssistantModal`  string , `UserPreferencesHideLightningMigrationModal`  string , `UserPreferencesHideSfxWelcomeMat`  string , `UserPreferencesHideBiggerPhotoCallout`  string , `UserPreferencesGlobalNavBarWTShown`  string , `UserPreferencesGlobalNavGridMenuWTShown`  string , `UserPreferencesCreateLEXAppsWTShown`  string , `UserPreferencesFavoritesWTShown`  string , `UserPreferencesRecordHomeSectionCollapseWTShown`  string , `UserPreferencesRecordHomeReservedWTShown`  string , `UserPreferencesFavoritesShowTopFavorites`  string , `UserPreferencesExcludeMailAppAttachments`  string , `UserPreferencesSuppressTaskSFXReminders`  string , `UserPreferencesSuppressEventSFXReminders`  string , `UserPreferencesPreviewCustomTheme`  string , `UserPreferencesHasCelebrationBadge`  string , `UserPreferencesUserDebugModePref`  string , `UserPreferencesSRHOverrideActivities`  string , `UserPreferencesNewLightningReportRunPageEnabled`  string , `UserPreferencesReverseOpenActivitiesView`  string , `UserPreferencesHasSentWarningEmail`  string , `UserPreferencesHasSentWarningEmail238`  string , `UserPreferencesHasSentWarningEmail240`  string , `UserPreferencesNativeEmailClient`  string , `UserPreferencesBRELookupTableWelcomeMat`  string , `UserPreferencesHideBrowseProductRedirectConfirmation`  string , `UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal`  string , `UserPreferencesHideOnlineSalesAppWelcomeMat`  string , `UserPreferencesShowForecastingRoundedAmounts`  string , `HasUserVerifiedPhone`  string , `HasUserVerifiedEmail`  string , `ContactId`  string , `AccountId`  string , `CallCenterId`  string , `Extension`  string , `FederationIdentifier`  string , `AboutMe`  string , `FullPhotoUrl`  string , `SmallPhotoUrl`  string , `IsExtIndicatorVisible`  string , `OutOfOfficeMessage`  string , `MediumPhotoUrl`  string , `DigestFrequency`  string , `DefaultGroupNotificationFrequency`  string , `BannerPhotoUrl`  string , `SmallBannerPhotoUrl`  string , `MediumBannerPhotoUrl`  string , `IsProfilePhotoActive`  string , `IndividualId`  string , `Territory__c`  string , `Sales_Admin__c`  string , `LDR__c`  string , `dsfs__DSProSFMembershipStatus__c`  string , `dsfs__DSProSFPassword__c`  string , `dsfs__DSProSFUsername__c`  string , `pi__Can_View_Not_Assigned_Prospects__c`  string , `pi__Pardot_Api_Key__c`  string , `pi__Pardot_User_Id__c`  string , `pi__Pardot_User_Key__c`  string , `pi__Pardot_User_Role__c`  string , `pi__Pardot_Api_Version__c`  string , `dupcheck__dc3DisableDCTriggers__c`  string , `Out_of_Office__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `UConference__UberConferenceId__c`  string , `Date_Training_Type_Set__c`  string , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__c`  string , `Support_Trainer__c`  string , `Training_Type__c`  string , `MigrationId__c`  string , `Escalate_Case__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-stage/raw/users/2026-02-27/1772205020'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_users`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_users"
}

Server:

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

Raw:

{
    "name": {
        "created": "2022-10-24 15:16:25",
        "disabled": false,
        "format": "raw",
        "id": 1456,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "salesforce_users"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AboutMe": "string",
            "AccountId": "string",
            "Admin_Deactivation_Date__c": "string",
            "Alias": "string",
            "Amount": "string",
            "BadgeText": "string",
            "BannerPhotoUrl": "string",
            "CallCenterId": "string",
            "City": "string",
            "CloseDate": "string",
            "CommunityNickname": "string",
            "CompanyName": "string",
            "Company_of_Origin__c": "string",
            "ContactId": "string",
            "Country": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "CurrencyIsoCode": "string",
            "Date_Training_Type_Set__c": "string",
            "DefaultCurrencyIsoCode": "string",
            "DefaultGroupNotificationFrequency": "string",
            "DelegatedApproverId": "string",
            "Department": "string",
            "DigestFrequency": "string",
            "Division": "string",
            "Email": "string",
            "EmailEncodingKey": "string",
            "EmailPreferencesAutoBcc": "string",
            "EmailPreferencesAutoBccStayInTouch": "string",
            "EmailPreferencesStayInTouchReminder": "string",
            "EmployeeNumber": "string",
            "EndDay": "string",
            "Escalate_Case__c": "string",
            "ExpectedRevenue": "string",
            "Extension": "string",
            "Fax": "string",
            "FederationIdentifier": "string",
            "FirstName": "string",
            "ForecastCategory": "string",
            "ForecastEnabled": "string",
            "FullPhotoUrl": "string",
            "GeocodeAccuracy": "string",
            "HasUserVerifiedEmail": "string",
            "HasUserVerifiedPhone": "string",
            "Id": "string",
            "IndividualId": "string",
            "IsActive": "string",
            "IsDeleted": "string",
            "IsExtIndicatorVisible": "string",
            "IsNotRecordOwner__c": "string",
            "IsProfilePhotoActive": "string",
            "LDR__c": "string",
            "LanguageLocaleKey": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "LastName": "string",
            "Latitude": "string",
            "LocaleSidKey": "string",
            "Longitude": "string",
            "ManagerId": "string",
            "MediumBannerPhotoUrl": "string",
            "MediumPhotoUrl": "string",
            "MigrationId__c": "string",
            "MobilePhone": "string",
            "Name": "string",
            "NumberOfFailedLogins": "string",
            "OfflinePdaTrialExpirationDate": "string",
            "OfflineTrialExpirationDate": "string",
            "OpportunityId": "string",
            "OutOfOfficeMessage": "string",
            "Out_of_Office__c": "string",
            "PasswordExpirationDate": "string",
            "Phone": "string",
            "PostalCode": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Probability": "string",
            "ProfileId": "string",
            "ReceivesAdminInfoEmails": "string",
            "ReceivesInfoEmails": "string",
            "Sales_Admin__c": "string",
            "Sales_Segment__c": "string",
            "SenderEmail": "string",
            "SenderName": "string",
            "Signature": "string",
            "SmallBannerPhotoUrl": "string",
            "SmallPhotoUrl": "string",
            "StageName": "string",
            "StartDay": "string",
            "State": "string",
            "StayInTouchNote": "string",
            "StayInTouchSignature": "string",
            "StayInTouchSubject": "string",
            "Street": "string",
            "SuAccessExpirationDate": "string",
            "Support_Trainer__c": "string",
            "SystemModstamp": "string",
            "Territory__c": "string",
            "TimeZoneSidKey": "string",
            "Title": "string",
            "Training_Type__c": "string",
            "UConference__UberConferenceId__c": "string",
            "UserPermissionsAvantgoUser": "string",
            "UserPermissionsCallCenterAutoLogin": "string",
            "UserPermissionsInteractionUser": "string",
            "UserPermissionsKnowledgeUser": "string",
            "UserPermissionsLiveAgentUser": "string",
            "UserPermissionsMarketingUser": "string",
            "UserPermissionsOfflineUser": "string",
            "UserPermissionsSFContentUser": "string",
            "UserPermissionsSupportUser": "string",
            "UserPreferencesActionLauncherEinsteinGptConsent": "string",
            "UserPreferencesActivityRemindersPopup": "string",
            "UserPreferencesApexPagesDeveloperMode": "string",
            "UserPreferencesAssistiveActionsEnabledInActionLauncher": "string",
            "UserPreferencesBRELookupTableWelcomeMat": "string",
            "UserPreferencesCacheDiagnostics": "string",
            "UserPreferencesContentEmailAsAndWhen": "string",
            "UserPreferencesContentNoEmail": "string",
            "UserPreferencesCreateLEXAppsWTShown": "string",
            "UserPreferencesDisCommentAfterLikeEmail": "string",
            "UserPreferencesDisMentionsCommentEmail": "string",
            "UserPreferencesDisProfPostCommentEmail": "string",
            "UserPreferencesDisableAllFeedsEmail": "string",
            "UserPreferencesDisableBookmarkEmail": "string",
            "UserPreferencesDisableChangeCommentEmail": "string",
            "UserPreferencesDisableEndorsementEmail": "string",
            "UserPreferencesDisableFileShareNotificationsForApi": "string",
            "UserPreferencesDisableFollowersEmail": "string",
            "UserPreferencesDisableLaterCommentEmail": "string",
            "UserPreferencesDisableLikeEmail": "string",
            "UserPreferencesDisableMentionsPostEmail": "string",
            "UserPreferencesDisableMessageEmail": "string",
            "UserPreferencesDisableProfilePostEmail": "string",
            "UserPreferencesDisableSharePostEmail": "string",
            "UserPreferencesEnableAutoSubForFeeds": "string",
            "UserPreferencesEventRemindersCheckboxDefault": "string",
            "UserPreferencesExcludeMailAppAttachments": "string",
            "UserPreferencesFavoritesShowTopFavorites": "string",
            "UserPreferencesFavoritesWTShown": "string",
            "UserPreferencesGlobalNavBarWTShown": "string",
            "UserPreferencesGlobalNavGridMenuWTShown": "string",
            "UserPreferencesHasCelebrationBadge": "string",
            "UserPreferencesHasSentWarningEmail": "string",
            "UserPreferencesHasSentWarningEmail238": "string",
            "UserPreferencesHasSentWarningEmail240": "string",
            "UserPreferencesHideBiggerPhotoCallout": "string",
            "UserPreferencesHideBrowseProductRedirectConfirmation": "string",
            "UserPreferencesHideCSNDesktopTask": "string",
            "UserPreferencesHideCSNGetChatterMobileTask": "string",
            "UserPreferencesHideChatterOnboardingSplash": "string",
            "UserPreferencesHideEndUserOnboardingAssistantModal": "string",
            "UserPreferencesHideLightningMigrationModal": "string",
            "UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal": "string",
            "UserPreferencesHideOnlineSalesAppWelcomeMat": "string",
            "UserPreferencesHideS1BrowserUI": "string",
            "UserPreferencesHideSecondChatterOnboardingSplash": "string",
            "UserPreferencesHideSfxWelcomeMat": "string",
            "UserPreferencesLightningExperiencePreferred": "string",
            "UserPreferencesLiveAgentMiawSetupDeflection": "string",
            "UserPreferencesNativeEmailClient": "string",
            "UserPreferencesNewLightningReportRunPageEnabled": "string",
            "UserPreferencesPathAssistantCollapsed": "string",
            "UserPreferencesPreviewCustomTheme": "string",
            "UserPreferencesPreviewLightning": "string",
            "UserPreferencesReceiveNoNotificationsAsApprover": "string",
            "UserPreferencesReceiveNotificationsAsDelegatedApprover": "string",
            "UserPreferencesRecordHomeReservedWTShown": "string",
            "UserPreferencesRecordHomeSectionCollapseWTShown": "string",
            "UserPreferencesReminderSoundOff": "string",
            "UserPreferencesReverseOpenActivitiesView": "string",
            "UserPreferencesSRHOverrideActivities": "string",
            "UserPreferencesShowCityToExternalUsers": "string",
            "UserPreferencesShowCityToGuestUsers": "string",
            "UserPreferencesShowCountryToExternalUsers": "string",
            "UserPreferencesShowCountryToGuestUsers": "string",
            "UserPreferencesShowEmailToExternalUsers": "string",
            "UserPreferencesShowEmailToGuestUsers": "string",
            "UserPreferencesShowFaxToExternalUsers": "string",
            "UserPreferencesShowFaxToGuestUsers": "string",
            "UserPreferencesShowForecastingChangeSignals": "string",
            "UserPreferencesShowForecastingRoundedAmounts": "string",
            "UserPreferencesShowManagerToExternalUsers": "string",
            "UserPreferencesShowManagerToGuestUsers": "string",
            "UserPreferencesShowMobilePhoneToExternalUsers": "string",
            "UserPreferencesShowMobilePhoneToGuestUsers": "string",
            "UserPreferencesShowPostalCodeToExternalUsers": "string",
            "UserPreferencesShowPostalCodeToGuestUsers": "string",
            "UserPreferencesShowProfilePicToGuestUsers": "string",
            "UserPreferencesShowStateToExternalUsers": "string",
            "UserPreferencesShowStateToGuestUsers": "string",
            "UserPreferencesShowStreetAddressToExternalUsers": "string",
            "UserPreferencesShowStreetAddressToGuestUsers": "string",
            "UserPreferencesShowTitleToExternalUsers": "string",
            "UserPreferencesShowTitleToGuestUsers": "string",
            "UserPreferencesShowWorkPhoneToExternalUsers": "string",
            "UserPreferencesShowWorkPhoneToGuestUsers": "string",
            "UserPreferencesSortFeedByComment": "string",
            "UserPreferencesSuppressEventSFXReminders": "string",
            "UserPreferencesSuppressTaskSFXReminders": "string",
            "UserPreferencesTaskRemindersCheckboxDefault": "string",
            "UserPreferencesUserDebugModePref": "string",
            "UserRoleId": "string",
            "UserType": "string",
            "Username": "string",
            "dsfs__DSProSFMembershipStatus__c": "string",
            "dsfs__DSProSFPassword__c": "string",
            "dsfs__DSProSFUsername__c": "string",
            "dupcheck__dc3DisableDCTriggers__c": "string",
            "dupcheck__dc3DisableDuplicateCheck__c": "string",
            "pi__Can_View_Not_Assigned_Prospects__c": "string",
            "pi__Pardot_Api_Key__c": "string",
            "pi__Pardot_Api_Version__c": "string",
            "pi__Pardot_User_Id__c": "string",
            "pi__Pardot_User_Key__c": "string",
            "pi__Pardot_User_Role__c": "string"
        },
        "created": "2026-02-27 09:11:50",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.salesforce_users`\n(\n `Id`  string , `Username`  string , `LastName`  string , `FirstName`  string , `Name`  string , `CompanyName`  string , `Division`  string , `Department`  string , `Title`  string , `Street`  string , `City`  string , `State`  string , `PostalCode`  string , `Country`  string , `Latitude`  string , `Longitude`  string , `GeocodeAccuracy`  string , `Email`  string , `EmailPreferencesAutoBcc`  string , `EmailPreferencesAutoBccStayInTouch`  string , `EmailPreferencesStayInTouchReminder`  string , `SenderEmail`  string , `SenderName`  string , `Signature`  string , `StayInTouchSubject`  string , `StayInTouchSignature`  string , `StayInTouchNote`  string , `Phone`  string , `Fax`  string , `MobilePhone`  string , `Alias`  string , `CommunityNickname`  string , `BadgeText`  string , `IsActive`  string , `TimeZoneSidKey`  string , `UserRoleId`  string , `LocaleSidKey`  string , `ReceivesInfoEmails`  string , `ReceivesAdminInfoEmails`  string , `EmailEncodingKey`  string , `DefaultCurrencyIsoCode`  string , `CurrencyIsoCode`  string , `ProfileId`  string , `UserType`  string , `StartDay`  string , `EndDay`  string , `LanguageLocaleKey`  string , `EmployeeNumber`  string , `DelegatedApproverId`  string , `ManagerId`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `PasswordExpirationDate`  string , `NumberOfFailedLogins`  string , `SuAccessExpirationDate`  string , `OfflineTrialExpirationDate`  string , `OfflinePdaTrialExpirationDate`  string , `UserPermissionsMarketingUser`  string , `UserPermissionsOfflineUser`  string , `UserPermissionsAvantgoUser`  string , `UserPermissionsCallCenterAutoLogin`  string , `UserPermissionsSFContentUser`  string , `UserPermissionsKnowledgeUser`  string , `UserPermissionsInteractionUser`  string , `UserPermissionsSupportUser`  string , `UserPermissionsLiveAgentUser`  string , `ForecastEnabled`  string , `UserPreferencesActivityRemindersPopup`  string , `UserPreferencesEventRemindersCheckboxDefault`  string , `UserPreferencesTaskRemindersCheckboxDefault`  string , `UserPreferencesReminderSoundOff`  string , `UserPreferencesDisableAllFeedsEmail`  string , `UserPreferencesDisableFollowersEmail`  string , `UserPreferencesDisableProfilePostEmail`  string , `UserPreferencesDisableChangeCommentEmail`  string , `UserPreferencesDisableLaterCommentEmail`  string , `UserPreferencesDisProfPostCommentEmail`  string , `UserPreferencesContentNoEmail`  string , `UserPreferencesContentEmailAsAndWhen`  string , `UserPreferencesApexPagesDeveloperMode`  string , `UserPreferencesReceiveNoNotificationsAsApprover`  string , `UserPreferencesReceiveNotificationsAsDelegatedApprover`  string , `UserPreferencesHideCSNGetChatterMobileTask`  string , `UserPreferencesDisableMentionsPostEmail`  string , `UserPreferencesDisMentionsCommentEmail`  string , `UserPreferencesHideCSNDesktopTask`  string , `UserPreferencesHideChatterOnboardingSplash`  string , `UserPreferencesHideSecondChatterOnboardingSplash`  string , `UserPreferencesDisCommentAfterLikeEmail`  string , `UserPreferencesDisableLikeEmail`  string , `UserPreferencesSortFeedByComment`  string , `UserPreferencesDisableMessageEmail`  string , `UserPreferencesDisableBookmarkEmail`  string , `UserPreferencesDisableSharePostEmail`  string , `UserPreferencesActionLauncherEinsteinGptConsent`  string , `UserPreferencesAssistiveActionsEnabledInActionLauncher`  string , `UserPreferencesEnableAutoSubForFeeds`  string , `UserPreferencesDisableFileShareNotificationsForApi`  string , `UserPreferencesShowTitleToExternalUsers`  string , `UserPreferencesShowManagerToExternalUsers`  string , `UserPreferencesShowEmailToExternalUsers`  string , `UserPreferencesShowWorkPhoneToExternalUsers`  string , `UserPreferencesShowMobilePhoneToExternalUsers`  string , `UserPreferencesShowFaxToExternalUsers`  string , `UserPreferencesShowStreetAddressToExternalUsers`  string , `UserPreferencesShowCityToExternalUsers`  string , `UserPreferencesShowStateToExternalUsers`  string , `UserPreferencesShowPostalCodeToExternalUsers`  string , `UserPreferencesShowCountryToExternalUsers`  string , `UserPreferencesShowProfilePicToGuestUsers`  string , `UserPreferencesShowTitleToGuestUsers`  string , `UserPreferencesShowCityToGuestUsers`  string , `UserPreferencesShowStateToGuestUsers`  string , `UserPreferencesShowPostalCodeToGuestUsers`  string , `UserPreferencesShowCountryToGuestUsers`  string , `UserPreferencesShowForecastingChangeSignals`  string , `UserPreferencesLiveAgentMiawSetupDeflection`  string , `UserPreferencesHideS1BrowserUI`  string , `UserPreferencesDisableEndorsementEmail`  string , `UserPreferencesPathAssistantCollapsed`  string , `UserPreferencesCacheDiagnostics`  string , `UserPreferencesShowEmailToGuestUsers`  string , `UserPreferencesShowManagerToGuestUsers`  string , `UserPreferencesShowWorkPhoneToGuestUsers`  string , `UserPreferencesShowMobilePhoneToGuestUsers`  string , `UserPreferencesShowFaxToGuestUsers`  string , `UserPreferencesShowStreetAddressToGuestUsers`  string , `UserPreferencesLightningExperiencePreferred`  string , `UserPreferencesPreviewLightning`  string , `UserPreferencesHideEndUserOnboardingAssistantModal`  string , `UserPreferencesHideLightningMigrationModal`  string , `UserPreferencesHideSfxWelcomeMat`  string , `UserPreferencesHideBiggerPhotoCallout`  string , `UserPreferencesGlobalNavBarWTShown`  string , `UserPreferencesGlobalNavGridMenuWTShown`  string , `UserPreferencesCreateLEXAppsWTShown`  string , `UserPreferencesFavoritesWTShown`  string , `UserPreferencesRecordHomeSectionCollapseWTShown`  string , `UserPreferencesRecordHomeReservedWTShown`  string , `UserPreferencesFavoritesShowTopFavorites`  string , `UserPreferencesExcludeMailAppAttachments`  string , `UserPreferencesSuppressTaskSFXReminders`  string , `UserPreferencesSuppressEventSFXReminders`  string , `UserPreferencesPreviewCustomTheme`  string , `UserPreferencesHasCelebrationBadge`  string , `UserPreferencesUserDebugModePref`  string , `UserPreferencesSRHOverrideActivities`  string , `UserPreferencesNewLightningReportRunPageEnabled`  string , `UserPreferencesReverseOpenActivitiesView`  string , `UserPreferencesHasSentWarningEmail`  string , `UserPreferencesHasSentWarningEmail238`  string , `UserPreferencesHasSentWarningEmail240`  string , `UserPreferencesNativeEmailClient`  string , `UserPreferencesBRELookupTableWelcomeMat`  string , `UserPreferencesHideBrowseProductRedirectConfirmation`  string , `UserPreferencesHideOnlineSalesAppTabVisibilityRequirementsModal`  string , `UserPreferencesHideOnlineSalesAppWelcomeMat`  string , `UserPreferencesShowForecastingRoundedAmounts`  string , `HasUserVerifiedPhone`  string , `HasUserVerifiedEmail`  string , `ContactId`  string , `AccountId`  string , `CallCenterId`  string , `Extension`  string , `FederationIdentifier`  string , `AboutMe`  string , `FullPhotoUrl`  string , `SmallPhotoUrl`  string , `IsExtIndicatorVisible`  string , `OutOfOfficeMessage`  string , `MediumPhotoUrl`  string , `DigestFrequency`  string , `DefaultGroupNotificationFrequency`  string , `BannerPhotoUrl`  string , `SmallBannerPhotoUrl`  string , `MediumBannerPhotoUrl`  string , `IsProfilePhotoActive`  string , `IndividualId`  string , `Territory__c`  string , `Sales_Admin__c`  string , `LDR__c`  string , `dsfs__DSProSFMembershipStatus__c`  string , `dsfs__DSProSFPassword__c`  string , `dsfs__DSProSFUsername__c`  string , `pi__Can_View_Not_Assigned_Prospects__c`  string , `pi__Pardot_Api_Key__c`  string , `pi__Pardot_User_Id__c`  string , `pi__Pardot_User_Key__c`  string , `pi__Pardot_User_Role__c`  string , `pi__Pardot_Api_Version__c`  string , `dupcheck__dc3DisableDCTriggers__c`  string , `Out_of_Office__c`  string , `dupcheck__dc3DisableDuplicateCheck__c`  string , `UConference__UberConferenceId__c`  string , `Date_Training_Type_Set__c`  string , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__c`  string , `Support_Trainer__c`  string , `Training_Type__c`  string , `MigrationId__c`  string , `Escalate_Case__c`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-salesforce-stage/raw/users/2026-02-27/1772205020'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.salesforce_users`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.salesforce_users"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}