Schema Info

Schema Name: sfdl_dev_csv.salesforce_users
  • created: 2022-10-24 14:52:39
  • disabled: False
  • format: raw
  • id: 2062
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_csv",
    "table": "salesforce_users"
}
  • type: csv
Schema Versions: 5
    • created: 2024-06-10 15:29:36
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/users/2024-06-10/1718051307'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/users/2024-06-10/1718051307
    • id: 4706430
    • 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: 2062
    • schema_scan_id: 6510671
    • updated: 2024-06-10 15:29:47
    • created: 2024-01-11 09:11:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__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-dev/raw/users/2024-01-11/1704985746'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/users/2024-01-11/1704985746
    • id: 4700491
    • processed: 1
    • raw_data: 
      {
    "AboutMe": 156,
    "AccountId": 152,
    "Admin_Deactivation_Date__c": 188,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 164,
    "CallCenterId": 153,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 187,
    "ContactId": 151,
    "Country": 13,
    "CreatedById": 49,
    "CreatedDate": 48,
    "CurrencyIsoCode": 41,
    "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": 186,
    "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": 185,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 165,
    "SmallPhotoUrl": 158,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "SystemModstamp": 52,
    "Territory__c": 169,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "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",
    "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",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "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: 2062
    • schema_scan_id: 6402635
    • updated: 2024-01-11 09:12:03
    • created: 2023-08-16 11:15:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `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 , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__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-dev/raw/users/2023-08-16/1692202321'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/users/2023-08-16/1692202321
    • id: 4697497
    • processed: 1
    • raw_data: 
      {
    "AboutMe": 154,
    "AccountId": 150,
    "Admin_Deactivation_Date__c": 185,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 162,
    "CallCenterId": 151,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 184,
    "ContactId": 149,
    "Country": 13,
    "CreatedById": 49,
    "CreatedDate": 48,
    "CurrencyIsoCode": 41,
    "DefaultCurrencyIsoCode": 40,
    "DefaultGroupNotificationFrequency": 161,
    "DelegatedApproverId": 46,
    "Department": 7,
    "DigestFrequency": 160,
    "Division": 6,
    "Email": 17,
    "EmailEncodingKey": 39,
    "EmailPreferencesAutoBcc": 18,
    "EmailPreferencesAutoBccStayInTouch": 19,
    "EmailPreferencesStayInTouchReminder": 20,
    "EmployeeNumber": 45,
    "Extension": 152,
    "Fax": 28,
    "FederationIdentifier": 153,
    "FirstName": 3,
    "ForecastEnabled": 65,
    "FullPhotoUrl": 155,
    "GeocodeAccuracy": 16,
    "Id": 0,
    "IndividualId": 166,
    "IsActive": 33,
    "IsExtIndicatorVisible": 157,
    "IsNotRecordOwner__c": 183,
    "IsProfilePhotoActive": 165,
    "LDR__c": 169,
    "LanguageLocaleKey": 44,
    "LastModifiedById": 51,
    "LastModifiedDate": 50,
    "LastName": 2,
    "Latitude": 14,
    "LocaleSidKey": 36,
    "Longitude": 15,
    "ManagerId": 47,
    "MediumBannerPhotoUrl": 164,
    "MediumPhotoUrl": 159,
    "MobilePhone": 29,
    "Name": 4,
    "NumberOfFailedLogins": 53,
    "OfflinePdaTrialExpirationDate": 55,
    "OfflineTrialExpirationDate": 54,
    "OutOfOfficeMessage": 158,
    "Out_of_Office__c": 180,
    "Phone": 27,
    "PostalCode": 12,
    "ProfileId": 42,
    "ReceivesAdminInfoEmails": 38,
    "ReceivesInfoEmails": 37,
    "Sales_Admin__c": 168,
    "Sales_Segment__c": 182,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 163,
    "SmallPhotoUrl": 156,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "SystemModstamp": 52,
    "Territory__c": 167,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "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,
    "UserPreferencesHideBiggerPhotoCallout": 128,
    "UserPreferencesHideBrowseProductRedirectConfirmation": 147,
    "UserPreferencesHideCSNDesktopTask": 84,
    "UserPreferencesHideCSNGetChatterMobileTask": 81,
    "UserPreferencesHideChatterOnboardingSplash": 85,
    "UserPreferencesHideEndUserOnboardingAssistantModal": 125,
    "UserPreferencesHideLightningMigrationModal": 126,
    "UserPreferencesHideOnlineSalesAppWelcomeMat": 148,
    "UserPreferencesHideS1BrowserUI": 113,
    "UserPreferencesHideSecondChatterOnboardingSplash": 86,
    "UserPreferencesHideSfxWelcomeMat": 127,
    "UserPreferencesLightningExperiencePreferred": 123,
    "UserPreferencesNativeEmailClient": 146,
    "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": 170,
    "dsfs__DSProSFPassword__c": 171,
    "dsfs__DSProSFUsername__c": 172,
    "dupcheck__dc3DisableDCTriggers__c": 179,
    "dupcheck__dc3DisableDuplicateCheck__c": 181,
    "pi__Can_View_Not_Assigned_Prospects__c": 173,
    "pi__Pardot_Api_Key__c": 174,
    "pi__Pardot_Api_Version__c": 178,
    "pi__Pardot_User_Id__c": 175,
    "pi__Pardot_User_Key__c": 176,
    "pi__Pardot_User_Role__c": 177
}
    • 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",
    "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",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "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",
    "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: 2062
    • schema_scan_id: 6251503
    • updated: 2023-08-16 11:15:19
    • created: 2023-08-16 10:26:23
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `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 , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__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-dev/raw/users/2023-08-16/1692199526'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/users/2023-08-16/1692199526
    • id: 4697417
    • processed: 1
    • raw_data: 
      {
    "AboutMe": 154,
    "AccountId": 150,
    "Admin_Deactivation_Date__c": 185,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 162,
    "CallCenterId": 151,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 184,
    "ContactId": 149,
    "Country": 13,
    "CreatedById": 49,
    "CreatedDate": 48,
    "CurrencyIsoCode": 41,
    "DefaultCurrencyIsoCode": 40,
    "DefaultGroupNotificationFrequency": 161,
    "DelegatedApproverId": 46,
    "Department": 7,
    "DigestFrequency": 160,
    "Division": 6,
    "Email": 17,
    "EmailEncodingKey": 39,
    "EmailPreferencesAutoBcc": 18,
    "EmailPreferencesAutoBccStayInTouch": 19,
    "EmailPreferencesStayInTouchReminder": 20,
    "EmployeeNumber": 45,
    "Extension": 152,
    "Fax": 28,
    "FederationIdentifier": 153,
    "FirstName": 3,
    "ForecastEnabled": 65,
    "FullPhotoUrl": 155,
    "GeocodeAccuracy": 16,
    "Id": 0,
    "IndividualId": 166,
    "IsActive": 33,
    "IsExtIndicatorVisible": 157,
    "IsNotRecordOwner__c": 183,
    "IsProfilePhotoActive": 165,
    "LDR__c": 169,
    "LanguageLocaleKey": 44,
    "LastModifiedById": 51,
    "LastModifiedDate": 50,
    "LastName": 2,
    "Latitude": 14,
    "LocaleSidKey": 36,
    "Longitude": 15,
    "ManagerId": 47,
    "MediumBannerPhotoUrl": 164,
    "MediumPhotoUrl": 159,
    "MobilePhone": 29,
    "Name": 4,
    "NumberOfFailedLogins": 53,
    "OfflinePdaTrialExpirationDate": 55,
    "OfflineTrialExpirationDate": 54,
    "OutOfOfficeMessage": 158,
    "Out_of_Office__c": 180,
    "Phone": 27,
    "PostalCode": 12,
    "ProfileId": 42,
    "ReceivesAdminInfoEmails": 38,
    "ReceivesInfoEmails": 37,
    "Sales_Admin__c": 168,
    "Sales_Segment__c": 182,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 163,
    "SmallPhotoUrl": 156,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "SystemModstamp": 52,
    "Territory__c": 167,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "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,
    "UserPreferencesHideBiggerPhotoCallout": 128,
    "UserPreferencesHideBrowseProductRedirectConfirmation": 147,
    "UserPreferencesHideCSNDesktopTask": 84,
    "UserPreferencesHideCSNGetChatterMobileTask": 81,
    "UserPreferencesHideChatterOnboardingSplash": 85,
    "UserPreferencesHideEndUserOnboardingAssistantModal": 125,
    "UserPreferencesHideLightningMigrationModal": 126,
    "UserPreferencesHideOnlineSalesAppWelcomeMat": 148,
    "UserPreferencesHideS1BrowserUI": 113,
    "UserPreferencesHideSecondChatterOnboardingSplash": 86,
    "UserPreferencesHideSfxWelcomeMat": 127,
    "UserPreferencesLightningExperiencePreferred": 123,
    "UserPreferencesNativeEmailClient": 146,
    "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": 170,
    "dsfs__DSProSFPassword__c": 171,
    "dsfs__DSProSFUsername__c": 172,
    "dupcheck__dc3DisableDCTriggers__c": 179,
    "dupcheck__dc3DisableDuplicateCheck__c": 181,
    "pi__Can_View_Not_Assigned_Prospects__c": 173,
    "pi__Pardot_Api_Key__c": 174,
    "pi__Pardot_Api_Version__c": 178,
    "pi__Pardot_User_Id__c": 175,
    "pi__Pardot_User_Key__c": 176,
    "pi__Pardot_User_Role__c": 177
}
    • 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",
    "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",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "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",
    "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: 2062
    • schema_scan_id: 6251344
    • updated: 2023-08-16 10:26:34
    • created: 2023-08-16 09:27:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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 , `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 , `Sales_Segment__c`  string , `IsNotRecordOwner__c`  string , `Company_of_Origin__c`  string , `Admin_Deactivation_Date__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-dev/raw/users/2023-08-16/1692195951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
]
    • hive_path: s3://sfdl-csv-salesforce-dev/raw/users/2023-08-16/1692195951
    • id: 4697368
    • processed: 1
    • raw_data: 
      {
    "AboutMe": 154,
    "AccountId": 150,
    "Admin_Deactivation_Date__c": 185,
    "Alias": 30,
    "BadgeText": 32,
    "BannerPhotoUrl": 162,
    "CallCenterId": 151,
    "City": 10,
    "CommunityNickname": 31,
    "CompanyName": 5,
    "Company_of_Origin__c": 184,
    "ContactId": 149,
    "Country": 13,
    "CreatedById": 49,
    "CreatedDate": 48,
    "CurrencyIsoCode": 41,
    "DefaultCurrencyIsoCode": 40,
    "DefaultGroupNotificationFrequency": 161,
    "DelegatedApproverId": 46,
    "Department": 7,
    "DigestFrequency": 160,
    "Division": 6,
    "Email": 17,
    "EmailEncodingKey": 39,
    "EmailPreferencesAutoBcc": 18,
    "EmailPreferencesAutoBccStayInTouch": 19,
    "EmailPreferencesStayInTouchReminder": 20,
    "EmployeeNumber": 45,
    "Extension": 152,
    "Fax": 28,
    "FederationIdentifier": 153,
    "FirstName": 3,
    "ForecastEnabled": 65,
    "FullPhotoUrl": 155,
    "GeocodeAccuracy": 16,
    "Id": 0,
    "IndividualId": 166,
    "IsActive": 33,
    "IsExtIndicatorVisible": 157,
    "IsNotRecordOwner__c": 183,
    "IsProfilePhotoActive": 165,
    "LDR__c": 169,
    "LanguageLocaleKey": 44,
    "LastModifiedById": 51,
    "LastModifiedDate": 50,
    "LastName": 2,
    "Latitude": 14,
    "LocaleSidKey": 36,
    "Longitude": 15,
    "ManagerId": 47,
    "MediumBannerPhotoUrl": 164,
    "MediumPhotoUrl": 159,
    "MobilePhone": 29,
    "Name": 4,
    "NumberOfFailedLogins": 53,
    "OfflinePdaTrialExpirationDate": 55,
    "OfflineTrialExpirationDate": 54,
    "OutOfOfficeMessage": 158,
    "Out_of_Office__c": 180,
    "Phone": 27,
    "PostalCode": 12,
    "ProfileId": 42,
    "ReceivesAdminInfoEmails": 38,
    "ReceivesInfoEmails": 37,
    "Sales_Admin__c": 168,
    "Sales_Segment__c": 182,
    "SenderEmail": 21,
    "SenderName": 22,
    "Signature": 23,
    "SmallBannerPhotoUrl": 163,
    "SmallPhotoUrl": 156,
    "State": 11,
    "StayInTouchNote": 26,
    "StayInTouchSignature": 25,
    "StayInTouchSubject": 24,
    "Street": 9,
    "SystemModstamp": 52,
    "Territory__c": 167,
    "TimeZoneSidKey": 34,
    "Title": 8,
    "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,
    "UserPreferencesHideBiggerPhotoCallout": 128,
    "UserPreferencesHideBrowseProductRedirectConfirmation": 147,
    "UserPreferencesHideCSNDesktopTask": 84,
    "UserPreferencesHideCSNGetChatterMobileTask": 81,
    "UserPreferencesHideChatterOnboardingSplash": 85,
    "UserPreferencesHideEndUserOnboardingAssistantModal": 125,
    "UserPreferencesHideLightningMigrationModal": 126,
    "UserPreferencesHideOnlineSalesAppWelcomeMat": 148,
    "UserPreferencesHideS1BrowserUI": 113,
    "UserPreferencesHideSecondChatterOnboardingSplash": 86,
    "UserPreferencesHideSfxWelcomeMat": 127,
    "UserPreferencesLightningExperiencePreferred": 123,
    "UserPreferencesNativeEmailClient": 146,
    "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": 170,
    "dsfs__DSProSFPassword__c": 171,
    "dsfs__DSProSFUsername__c": 172,
    "dupcheck__dc3DisableDCTriggers__c": 179,
    "dupcheck__dc3DisableDuplicateCheck__c": 181,
    "pi__Can_View_Not_Assigned_Prospects__c": 173,
    "pi__Pardot_Api_Key__c": 174,
    "pi__Pardot_Api_Version__c": 178,
    "pi__Pardot_User_Id__c": 175,
    "pi__Pardot_User_Key__c": 176,
    "pi__Pardot_User_Role__c": 177
}
    • 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",
    "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",
    "SystemModstamp": "string",
    "Territory__c": "string",
    "TimeZoneSidKey": "string",
    "Title": "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",
    "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: 2062
    • schema_scan_id: 6251251
    • updated: 2023-08-16 09:27:31
Schema Scans: 5
Last at 2024-06-10 15:29:30
    • duration: 0:00:17.297840
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6510671
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/users/2024-06-10/1718051307",
        "key": "raw/users/2024-06-10/1718051307/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16827239799802485871,
        "service_name": "drive-thru",
        "span_id": 4958582965495081469,
        "trace_id": 13577714685741962748
    }
}
    • running: False
    • schema_name_id: 2062
    • start_time: 2024-06-10 15:29:30
    • success: True
    • trace_id: 13577714685741962748
    • duration: 0:00:16.885339
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6402635
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/users/2024-01-11/1704985746",
        "key": "raw/users/2024-01-11/1704985746/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8002034406619478564,
        "service_name": "drive-thru",
        "span_id": 11663147648035194240,
        "trace_id": 6982319594252577719
    }
}
    • running: False
    • schema_name_id: 2062
    • start_time: 2024-01-11 09:11:46
    • success: True
    • trace_id: 6982319594252577719
    • duration: 0:00:16.769824
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251503
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/users/2023-08-16/1692202321",
        "key": "raw/users/2023-08-16/1692202321/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16191791541599888937,
        "service_name": "drive-thru",
        "span_id": 15215574255297931266,
        "trace_id": 6378699667620412407
    }
}
    • running: False
    • schema_name_id: 2062
    • start_time: 2023-08-16 11:15:02
    • success: True
    • trace_id: 6378699667620412407
    • duration: 0:00:16.572016
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251344
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/users/2023-08-16/1692199526",
        "key": "raw/users/2023-08-16/1692199526/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12726040698279143263,
        "service_name": "drive-thru",
        "span_id": 3761251868612010339,
        "trace_id": 9823638840061269434
    }
}
    • running: False
    • schema_name_id: 2062
    • start_time: 2023-08-16 10:26:18
    • success: True
    • trace_id: 9823638840061269434
    • duration: 0:00:16.770839
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6251251
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-dev",
        "hive_path": "s3://sfdl-csv-salesforce-dev/raw/users/2023-08-16/1692195951",
        "key": "raw/users/2023-08-16/1692195951/users.csv.gz"
    },
    "schema": {
        "name": "sfdl_dev_csv.salesforce_users",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13402977380243729282,
        "service_name": "drive-thru",
        "span_id": 9514886804979683269,
        "trace_id": 17744987508625140641
    }
}
    • running: False
    • schema_name_id: 2062
    • start_time: 2023-08-16 09:27:14
    • success: True
    • trace_id: 17744987508625140641
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",
    "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"
}
  • created: 2024-06-10 15:29:36
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/users/2024-06-10/1718051307'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
}
Server:
  • hostname: schemamanager-5447774fc6-4w58v
  • name: schema_manager
  • process_start: 2026-04-02 21:43:44
  • sf_env: dev
  • version: 2427328685
Raw: 
{
    "name": {
        "created": "2022-10-24 14:52:39",
        "disabled": false,
        "format": "raw",
        "id": 2062,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_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",
            "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"
        },
        "created": "2024-06-10 15:29:36",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_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-dev/raw/users/2024-06-10/1718051307'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_csv.salesforce_users`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_csv.salesforce_users"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform