Schema Info

Schema Name: sfdl_prod_csv.salesforce_events
  • created: 2022-10-10 16:23:20
  • disabled: False
  • format: raw
  • id: 1192
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_csv",
    "table": "salesforce_events"
}
  • type: csv
Schema Versions: 15
    • created: 2026-04-17 07:07:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-17/1776427521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-17/1776427521
    • id: 1718107
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 162173077
    • updated: 2026-04-17 07:07:19
    • created: 2026-04-16 07:06:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-16/1776341127'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-16/1776341127
    • id: 1716868
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 162117348
    • updated: 2026-04-16 07:07:00
    • created: 2026-04-15 07:07:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-15/1776254742'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-15/1776254742
    • id: 1715642
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 162061778
    • updated: 2026-04-15 07:07:38
    • created: 2026-04-14 07:06:13
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-14/1776168327'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-14/1776168327
    • id: 1714455
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 162006371
    • updated: 2026-04-14 07:06:24
    • created: 2026-04-13 07:06:45
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-13/1776081893'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-13/1776081893
    • id: 1713241
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161948319
    • updated: 2026-04-13 07:06:59
    • created: 2026-04-12 07:07:50
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-12/1775995656'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-12/1775995656
    • id: 1712052
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161899534
    • updated: 2026-04-12 07:08:04
    • created: 2026-04-11 07:04:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-11/1775909048'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-11/1775909048
    • id: 1710832
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161846840
    • updated: 2026-04-11 07:05:03
    • created: 2026-04-10 07:04:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-10/1775822661'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-10/1775822661
    • id: 1709643
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161792033
    • updated: 2026-04-10 07:05:02
    • created: 2026-04-09 07:05:51
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-09/1775736314'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-09/1775736314
    • id: 1708513
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161736238
    • updated: 2026-04-09 07:06:04
    • created: 2026-04-08 07:07:16
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-08/1775649931'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-08/1775649931
    • id: 1707353
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161681415
    • updated: 2026-04-08 07:07:27
    • created: 2026-04-07 07:06:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-07/1775563500'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-07/1775563500
    • id: 1706149
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161625187
    • updated: 2026-04-07 07:06:52
    • created: 2026-04-06 07:07:49
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-06/1775477109'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-06/1775477109
    • id: 1704912
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161567322
    • updated: 2026-04-06 07:08:00
    • created: 2026-04-05 07:06:12
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-05/1775390670'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-05/1775390670
    • id: 1703709
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161519992
    • updated: 2026-04-05 07:06:25
    • created: 2026-04-04 07:08:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-04/1775304397'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-04/1775304397
    • id: 1702556
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161466427
    • updated: 2026-04-04 07:08:46
    • created: 2026-04-03 07:06:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-03/1775217848'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
]
    • hive_path: s3://sfdl-csv-salesforce-prod/raw/events/2026-04-03/1775217848
    • id: 1701366
    • processed: 1
    • raw_data: 
      {
    "AccountId": 15,
    "ActivityDate": 9,
    "ActivityDateTime": 8,
    "BDRStatus__c": 94,
    "CP_A2P_Status__c": 86,
    "CP_A2P_Twilio_Account_Sid__c": 87,
    "Call_Disposition__c": 98,
    "CreatedById": 26,
    "CreatedDate": 25,
    "Created_By_Send_Task_to_Sales__c": 69,
    "Created_by_CP_A2P_Process__c": 88,
    "CurrencyIsoCode": 17,
    "Data_Load_By__c": 112,
    "Date_CP_A2P_Brand_Approved__c": 89,
    "Date_CP_A2P_Campaign_Approved__c": 90,
    "Date_CP_A2P_Submitted_to_Twilio__c": 91,
    "Description": 14,
    "Dialpad__CallId__c": 71,
    "Dialpad__Call_End_Time__c": 72,
    "Dialpad__Call_Recording_URL__c": 73,
    "Dialpad__Call_Start_Time__c": 74,
    "Dialpad__Dialpad_Agents__c": 75,
    "Dialpad__Dialpad_Call_Center__c": 76,
    "Dialpad__Dialpad_List__c": 77,
    "Dialpad__IsDialpadCallLog__c": 78,
    "Dialpad__PhoneNumber__c": 79,
    "DurationInMinutes": 10,
    "EndDate": 13,
    "EndDateTime": 12,
    "End_Time__c": 63,
    "EventSubtype": 45,
    "Follow_up_Event__c": 56,
    "Follow_up_Task__c": 57,
    "Gong__Activity_Source__c": 99,
    "Gong__Associated_Accounts__c": 100,
    "Gong__Associated_Opportunities__c": 101,
    "Gong__Call_Outcome__c": 102,
    "Gong__Current_Flow_ID__c": 103,
    "Gong__Current_Flow_Name__c": 104,
    "Gong__Current_Flow_Step_Number__c": 105,
    "Gong__Flow_Execution_ID__c": 106,
    "Gong__Gong_Activity_Id__c": 107,
    "Gong__Gong_Participants_Emails__c": 108,
    "Gong__Meeting_Prospect_Canceled__c": 109,
    "Gong__Meeting_Reschedule_Count__c": 110,
    "GroupEventType": 24,
    "Id": 0,
    "ImplementationCommitmentReceived__c": 55,
    "Initially_Worked__c": 96,
    "Interaction_Type__c": 64,
    "IsAllDayEvent": 7,
    "IsArchived": 30,
    "IsChild": 22,
    "IsDeleted": 21,
    "IsGroupEvent": 23,
    "IsPrivate": 19,
    "IsRecurrence": 33,
    "IsRecurrence2": 49,
    "IsRecurrence2Exception": 50,
    "IsRecurrence2Exclusion": 46,
    "IsReminderSet": 44,
    "IsVisibleInSelfService": 31,
    "LastModifiedById": 28,
    "LastModifiedDate": 27,
    "LeadGenQuality__c": 95,
    "Location": 6,
    "Marine_Hubspot_Activity_ID__c": 97,
    "Marketing_Feedback__c": 54,
    "MigrationId__c": 111,
    "New_Construction__c": 58,
    "Opportunity__c": 70,
    "Outbound_Reason__c": 59,
    "OwnerId": 16,
    "Primary_Campaign__c": 60,
    "Queue__c": 65,
    "Recurrence2PatternStartDate": 51,
    "Recurrence2PatternText": 47,
    "Recurrence2PatternTimeZone": 52,
    "Recurrence2PatternVersion": 48,
    "RecurrenceActivityId": 32,
    "RecurrenceDayOfMonth": 40,
    "RecurrenceDayOfWeekMask": 39,
    "RecurrenceEndDateOnly": 35,
    "RecurrenceInstance": 41,
    "RecurrenceInterval": 38,
    "RecurrenceMonthOfYear": 42,
    "RecurrenceStartDateTime": 34,
    "RecurrenceTimeZoneSidKey": 36,
    "RecurrenceType": 37,
    "Related_Case__c": 92,
    "Related_Form_Response__c": 93,
    "ReminderDateTime": 43,
    "SMSID__c": 85,
    "ShowAs": 20,
    "StartDateTime": 11,
    "Start_Time__c": 66,
    "Subject": 5,
    "SystemModstamp": 29,
    "Temperature__c": 61,
    "Time_Zone__c": 68,
    "Trash_Reason__c": 62,
    "Type": 18,
    "UConference__Call_Summary_URL__c": 80,
    "UConference__End_Time__c": 81,
    "UConference__IsUberConference__c": 82,
    "UConference__Start_Time__c": 83,
    "UConference__UberConferenceId__c": 84,
    "WhatCount": 4,
    "WhatId": 2,
    "WhoCount": 3,
    "WhoId": 1,
    "Wrap_Up_Code__c": 67,
    "pi__pardot_source_id__c": 53
}
    • schema_attributes: 
      {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
    • schema_name_id: 1192
    • schema_scan_id: 161408573
    • updated: 2026-04-03 07:06:16
Schema Scans: 15
Last at 2026-04-17 07:07:05
    • duration: 0:00:14.573806
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173077
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-17/1776427521",
        "key": "raw/events/2026-04-17/1776427521/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13157510574912958487,
        "service_name": "drive-thru",
        "span_id": 6013479635330965971,
        "trace_id": 6100342948330282707
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-17 07:07:05
    • success: True
    • trace_id: 6100342948330282707
    • duration: 0:00:14.595160
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117348
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-16/1776341127",
        "key": "raw/events/2026-04-16/1776341127/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16339373684094714340,
        "service_name": "drive-thru",
        "span_id": 5164652692967023132,
        "trace_id": 2436991690527959899
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-16 07:06:46
    • success: True
    • trace_id: 2436991690527959899
    • duration: 0:00:17.363276
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061778
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-15/1776254742",
        "key": "raw/events/2026-04-15/1776254742/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17349885405040575424,
        "service_name": "drive-thru",
        "span_id": 11482046747300032092,
        "trace_id": 3509389306914048898
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-15 07:07:21
    • success: True
    • trace_id: 3509389306914048898
    • duration: 0:00:14.612188
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006371
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-14/1776168327",
        "key": "raw/events/2026-04-14/1776168327/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15119183362610627319,
        "service_name": "drive-thru",
        "span_id": 9951828122239162917,
        "trace_id": 14606455496288572352
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-14 07:06:09
    • success: True
    • trace_id: 14606455496288572352
    • duration: 0:00:17.493962
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948319
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-13/1776081893",
        "key": "raw/events/2026-04-13/1776081893/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6015206094884589894,
        "service_name": "drive-thru",
        "span_id": 17862449194087028029,
        "trace_id": 68764145255750732
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-13 07:06:41
    • success: True
    • trace_id: 68764145255750732
    • duration: 0:00:17.492614
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899534
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-12/1775995656",
        "key": "raw/events/2026-04-12/1775995656/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12694165716937216611,
        "service_name": "drive-thru",
        "span_id": 14166230871429541341,
        "trace_id": 3292029374726528067
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-12 07:07:46
    • success: True
    • trace_id: 3292029374726528067
    • duration: 0:00:17.154887
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846840
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-11/1775909048",
        "key": "raw/events/2026-04-11/1775909048/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5630472728036590580,
        "service_name": "drive-thru",
        "span_id": 2852936351105523430,
        "trace_id": 11306393891542228082
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-11 07:04:46
    • success: True
    • trace_id: 11306393891542228082
    • duration: 0:00:17.338404
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792033
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-10/1775822661",
        "key": "raw/events/2026-04-10/1775822661/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 3651603450405821562,
        "service_name": "drive-thru",
        "span_id": 7412868474245312149,
        "trace_id": 2385807519678261004
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-10 07:04:45
    • success: True
    • trace_id: 2385807519678261004
    • duration: 0:00:17.418742
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736238
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-09/1775736314",
        "key": "raw/events/2026-04-09/1775736314/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17150347175660731717,
        "service_name": "drive-thru",
        "span_id": 8322009931475005063,
        "trace_id": 14111644300938563267
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-09 07:05:47
    • success: True
    • trace_id: 14111644300938563267
    • duration: 0:00:14.779321
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681415
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-08/1775649931",
        "key": "raw/events/2026-04-08/1775649931/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17531006927694459383,
        "service_name": "drive-thru",
        "span_id": 14800976090104628267,
        "trace_id": 14115046213274818989
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-08 07:07:12
    • success: True
    • trace_id: 14115046213274818989
    • duration: 0:00:17.064730
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625187
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-07/1775563500",
        "key": "raw/events/2026-04-07/1775563500/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8955032490530505996,
        "service_name": "drive-thru",
        "span_id": 16358431591689925366,
        "trace_id": 1766845982583874509
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-07 07:06:35
    • success: True
    • trace_id: 1766845982583874509
    • duration: 0:00:14.667016
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567322
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-06/1775477109",
        "key": "raw/events/2026-04-06/1775477109/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 5842189909918701833,
        "service_name": "drive-thru",
        "span_id": 8467946226896258213,
        "trace_id": 11469207354050087606
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-06 07:07:46
    • success: True
    • trace_id: 11469207354050087606
    • duration: 0:00:17.052837
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161519992
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-05/1775390670",
        "key": "raw/events/2026-04-05/1775390670/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16801127657476152275,
        "service_name": "drive-thru",
        "span_id": 13343766365210239355,
        "trace_id": 378323122902798039
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-05 07:06:08
    • success: True
    • trace_id: 378323122902798039
    • duration: 0:00:14.754178
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466427
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-04/1775304397",
        "key": "raw/events/2026-04-04/1775304397/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17603670033647269371,
        "service_name": "drive-thru",
        "span_id": 4220904294267597758,
        "trace_id": 8754401932681414894
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-04 07:08:31
    • success: True
    • trace_id: 8754401932681414894
    • duration: 0:00:14.938751
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408573
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-salesforce-prod",
        "hive_path": "s3://sfdl-csv-salesforce-prod/raw/events/2026-04-03/1775217848",
        "key": "raw/events/2026-04-03/1775217848/events.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_csv.salesforce_events",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 9574108767772462343,
        "service_name": "drive-thru",
        "span_id": 14514709666572368105,
        "trace_id": 3650109763528268102
    }
}
    • running: False
    • schema_name_id: 1192
    • start_time: 2026-04-03 07:06:01
    • success: True
    • trace_id: 3650109763528268102
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "AccountId": "string",
    "ActivityDate": "string",
    "ActivityDateTime": "string",
    "Amount": "string",
    "BDRStatus__c": "string",
    "CP_A2P_Status__c": "string",
    "CP_A2P_Twilio_Account_Sid__c": "string",
    "Call_Disposition__c": "string",
    "CloseDate": "string",
    "Contact__c": "string",
    "CreatedById": "string",
    "CreatedDate": "string",
    "Created_By_Send_Task_to_Sales__c": "string",
    "Created_by_CP_A2P_Process__c": "string",
    "CurrencyIsoCode": "string",
    "Data_Load_By__c": "string",
    "Date_CP_A2P_Brand_Approved__c": "string",
    "Date_CP_A2P_Campaign_Approved__c": "string",
    "Date_CP_A2P_Submitted_to_Twilio__c": "string",
    "Description": "string",
    "Dialpad__CallId__c": "string",
    "Dialpad__Call_End_Time__c": "string",
    "Dialpad__Call_Recording_URL__c": "string",
    "Dialpad__Call_Start_Time__c": "string",
    "Dialpad__Dialpad_Agents__c": "string",
    "Dialpad__Dialpad_Call_Center__c": "string",
    "Dialpad__Dialpad_List__c": "string",
    "Dialpad__IsDialpadCallLog__c": "string",
    "Dialpad__PhoneNumber__c": "string",
    "DurationInMinutes": "string",
    "EndDate": "string",
    "EndDateTime": "string",
    "End_Time__c": "string",
    "EventSubtype": "string",
    "ExpectedRevenue": "string",
    "Follow_up_Event__c": "string",
    "Follow_up_Task__c": "string",
    "ForecastCategory": "string",
    "Gong__Activity_Source__c": "string",
    "Gong__Associated_Accounts__c": "string",
    "Gong__Associated_Opportunities__c": "string",
    "Gong__Call_Outcome__c": "string",
    "Gong__Current_Flow_ID__c": "string",
    "Gong__Current_Flow_Name__c": "string",
    "Gong__Current_Flow_Step_Number__c": "string",
    "Gong__Flow_Execution_ID__c": "string",
    "Gong__Gong_Activity_Id__c": "string",
    "Gong__Gong_Participants_Emails__c": "string",
    "Gong__Meeting_Prospect_Canceled__c": "string",
    "Gong__Meeting_Reschedule_Count__c": "string",
    "GroupEventType": "string",
    "Id": "string",
    "ImplementationCommitmentReceived__c": "string",
    "Initially_Worked__c": "string",
    "Interaction_Type__c": "string",
    "IsAllDayEvent": "string",
    "IsArchived": "string",
    "IsChild": "string",
    "IsDeleted": "string",
    "IsGroupEvent": "string",
    "IsPrivate": "string",
    "IsRecurrence": "string",
    "IsRecurrence2": "string",
    "IsRecurrence2Exception": "string",
    "IsRecurrence2Exclusion": "string",
    "IsReminderSet": "string",
    "IsVisibleInSelfService": "string",
    "LastModifiedById": "string",
    "LastModifiedDate": "string",
    "LeadGenQuality__c": "string",
    "Location": "string",
    "Marine_Hubspot_Activity_ID__c": "string",
    "Marketing_Feedback__c": "string",
    "MigrationId__c": "string",
    "New_Construction__c": "string",
    "OpportunityId": "string",
    "Opportunity__c": "string",
    "Outbound_Reason__c": "string",
    "OwnerId": "string",
    "PrevAmount": "string",
    "PrevCloseDate": "string",
    "Primary_Campaign__c": "string",
    "Probability": "string",
    "Queue__c": "string",
    "Recurrence2PatternStartDate": "string",
    "Recurrence2PatternText": "string",
    "Recurrence2PatternTimeZone": "string",
    "Recurrence2PatternVersion": "string",
    "RecurrenceActivityId": "string",
    "RecurrenceDayOfMonth": "string",
    "RecurrenceDayOfWeekMask": "string",
    "RecurrenceEndDateOnly": "string",
    "RecurrenceInstance": "string",
    "RecurrenceInterval": "string",
    "RecurrenceMonthOfYear": "string",
    "RecurrenceStartDateTime": "string",
    "RecurrenceTimeZoneSidKey": "string",
    "RecurrenceType": "string",
    "Related_Case__c": "string",
    "Related_Form_Response__c": "string",
    "ReminderDateTime": "string",
    "SMSID__c": "string",
    "ShowAs": "string",
    "StageName": "string",
    "StartDateTime": "string",
    "Start_Time__c": "string",
    "Subject": "string",
    "SystemModstamp": "string",
    "Temperature__c": "string",
    "Time_Zone__c": "string",
    "Trash_Reason__c": "string",
    "Type": "string",
    "UConference__Call_Summary_URL__c": "string",
    "UConference__End_Time__c": "string",
    "UConference__IsUberConference__c": "string",
    "UConference__Start_Time__c": "string",
    "UConference__UberConferenceId__c": "string",
    "WhatCount": "string",
    "WhatId": "string",
    "WhoCount": "string",
    "WhoId": "string",
    "Wrap_Up_Code__c": "string",
    "pi__pardot_source_id__c": "string"
}
  • created: 2026-04-17 07:07:08
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-17/1776427521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-10-10 16:23:20",
        "disabled": false,
        "format": "raw",
        "id": 1192,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_csv",
            "table": "salesforce_events"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "AccountId": "string",
            "ActivityDate": "string",
            "ActivityDateTime": "string",
            "Amount": "string",
            "BDRStatus__c": "string",
            "CP_A2P_Status__c": "string",
            "CP_A2P_Twilio_Account_Sid__c": "string",
            "Call_Disposition__c": "string",
            "CloseDate": "string",
            "Contact__c": "string",
            "CreatedById": "string",
            "CreatedDate": "string",
            "Created_By_Send_Task_to_Sales__c": "string",
            "Created_by_CP_A2P_Process__c": "string",
            "CurrencyIsoCode": "string",
            "Data_Load_By__c": "string",
            "Date_CP_A2P_Brand_Approved__c": "string",
            "Date_CP_A2P_Campaign_Approved__c": "string",
            "Date_CP_A2P_Submitted_to_Twilio__c": "string",
            "Description": "string",
            "Dialpad__CallId__c": "string",
            "Dialpad__Call_End_Time__c": "string",
            "Dialpad__Call_Recording_URL__c": "string",
            "Dialpad__Call_Start_Time__c": "string",
            "Dialpad__Dialpad_Agents__c": "string",
            "Dialpad__Dialpad_Call_Center__c": "string",
            "Dialpad__Dialpad_List__c": "string",
            "Dialpad__IsDialpadCallLog__c": "string",
            "Dialpad__PhoneNumber__c": "string",
            "DurationInMinutes": "string",
            "EndDate": "string",
            "EndDateTime": "string",
            "End_Time__c": "string",
            "EventSubtype": "string",
            "ExpectedRevenue": "string",
            "Follow_up_Event__c": "string",
            "Follow_up_Task__c": "string",
            "ForecastCategory": "string",
            "Gong__Activity_Source__c": "string",
            "Gong__Associated_Accounts__c": "string",
            "Gong__Associated_Opportunities__c": "string",
            "Gong__Call_Outcome__c": "string",
            "Gong__Current_Flow_ID__c": "string",
            "Gong__Current_Flow_Name__c": "string",
            "Gong__Current_Flow_Step_Number__c": "string",
            "Gong__Flow_Execution_ID__c": "string",
            "Gong__Gong_Activity_Id__c": "string",
            "Gong__Gong_Participants_Emails__c": "string",
            "Gong__Meeting_Prospect_Canceled__c": "string",
            "Gong__Meeting_Reschedule_Count__c": "string",
            "GroupEventType": "string",
            "Id": "string",
            "ImplementationCommitmentReceived__c": "string",
            "Initially_Worked__c": "string",
            "Interaction_Type__c": "string",
            "IsAllDayEvent": "string",
            "IsArchived": "string",
            "IsChild": "string",
            "IsDeleted": "string",
            "IsGroupEvent": "string",
            "IsPrivate": "string",
            "IsRecurrence": "string",
            "IsRecurrence2": "string",
            "IsRecurrence2Exception": "string",
            "IsRecurrence2Exclusion": "string",
            "IsReminderSet": "string",
            "IsVisibleInSelfService": "string",
            "LastModifiedById": "string",
            "LastModifiedDate": "string",
            "LeadGenQuality__c": "string",
            "Location": "string",
            "Marine_Hubspot_Activity_ID__c": "string",
            "Marketing_Feedback__c": "string",
            "MigrationId__c": "string",
            "New_Construction__c": "string",
            "OpportunityId": "string",
            "Opportunity__c": "string",
            "Outbound_Reason__c": "string",
            "OwnerId": "string",
            "PrevAmount": "string",
            "PrevCloseDate": "string",
            "Primary_Campaign__c": "string",
            "Probability": "string",
            "Queue__c": "string",
            "Recurrence2PatternStartDate": "string",
            "Recurrence2PatternText": "string",
            "Recurrence2PatternTimeZone": "string",
            "Recurrence2PatternVersion": "string",
            "RecurrenceActivityId": "string",
            "RecurrenceDayOfMonth": "string",
            "RecurrenceDayOfWeekMask": "string",
            "RecurrenceEndDateOnly": "string",
            "RecurrenceInstance": "string",
            "RecurrenceInterval": "string",
            "RecurrenceMonthOfYear": "string",
            "RecurrenceStartDateTime": "string",
            "RecurrenceTimeZoneSidKey": "string",
            "RecurrenceType": "string",
            "Related_Case__c": "string",
            "Related_Form_Response__c": "string",
            "ReminderDateTime": "string",
            "SMSID__c": "string",
            "ShowAs": "string",
            "StageName": "string",
            "StartDateTime": "string",
            "Start_Time__c": "string",
            "Subject": "string",
            "SystemModstamp": "string",
            "Temperature__c": "string",
            "Time_Zone__c": "string",
            "Trash_Reason__c": "string",
            "Type": "string",
            "UConference__Call_Summary_URL__c": "string",
            "UConference__End_Time__c": "string",
            "UConference__IsUberConference__c": "string",
            "UConference__Start_Time__c": "string",
            "UConference__UberConferenceId__c": "string",
            "WhatCount": "string",
            "WhatId": "string",
            "WhoCount": "string",
            "WhoId": "string",
            "Wrap_Up_Code__c": "string",
            "pi__pardot_source_id__c": "string"
        },
        "created": "2026-04-17 07:07:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.salesforce_events`\n(\n `Id`  string , `WhoId`  string , `WhatId`  string , `WhoCount`  string , `WhatCount`  string , `Subject`  string , `Location`  string , `IsAllDayEvent`  string , `ActivityDateTime`  string , `ActivityDate`  string , `DurationInMinutes`  string , `StartDateTime`  string , `EndDateTime`  string , `EndDate`  string , `Description`  string , `AccountId`  string , `OwnerId`  string , `CurrencyIsoCode`  string , `Type`  string , `IsPrivate`  string , `ShowAs`  string , `IsDeleted`  string , `IsChild`  string , `IsGroupEvent`  string , `GroupEventType`  string , `CreatedDate`  string , `CreatedById`  string , `LastModifiedDate`  string , `LastModifiedById`  string , `SystemModstamp`  string , `IsArchived`  string , `IsVisibleInSelfService`  string , `RecurrenceActivityId`  string , `IsRecurrence`  string , `RecurrenceStartDateTime`  string , `RecurrenceEndDateOnly`  string , `RecurrenceTimeZoneSidKey`  string , `RecurrenceType`  string , `RecurrenceInterval`  string , `RecurrenceDayOfWeekMask`  string , `RecurrenceDayOfMonth`  string , `RecurrenceInstance`  string , `RecurrenceMonthOfYear`  string , `ReminderDateTime`  string , `IsReminderSet`  string , `EventSubtype`  string , `IsRecurrence2Exclusion`  string , `Recurrence2PatternText`  string , `Recurrence2PatternVersion`  string , `IsRecurrence2`  string , `IsRecurrence2Exception`  string , `Recurrence2PatternStartDate`  string , `Recurrence2PatternTimeZone`  string , `pi__pardot_source_id__c`  string , `Marketing_Feedback__c`  string , `ImplementationCommitmentReceived__c`  string , `Follow_up_Event__c`  string , `Follow_up_Task__c`  string , `New_Construction__c`  string , `Outbound_Reason__c`  string , `Primary_Campaign__c`  string , `Temperature__c`  string , `Trash_Reason__c`  string , `End_Time__c`  string , `Interaction_Type__c`  string , `Queue__c`  string , `Start_Time__c`  string , `Wrap_Up_Code__c`  string , `Time_Zone__c`  string , `Created_By_Send_Task_to_Sales__c`  string , `Opportunity__c`  string , `Dialpad__CallId__c`  string , `Dialpad__Call_End_Time__c`  string , `Dialpad__Call_Recording_URL__c`  string , `Dialpad__Call_Start_Time__c`  string , `Dialpad__Dialpad_Agents__c`  string , `Dialpad__Dialpad_Call_Center__c`  string , `Dialpad__Dialpad_List__c`  string , `Dialpad__IsDialpadCallLog__c`  string , `Dialpad__PhoneNumber__c`  string , `UConference__Call_Summary_URL__c`  string , `UConference__End_Time__c`  string , `UConference__IsUberConference__c`  string , `UConference__Start_Time__c`  string , `UConference__UberConferenceId__c`  string , `SMSID__c`  string , `CP_A2P_Status__c`  string , `CP_A2P_Twilio_Account_Sid__c`  string , `Created_by_CP_A2P_Process__c`  string , `Date_CP_A2P_Brand_Approved__c`  string , `Date_CP_A2P_Campaign_Approved__c`  string , `Date_CP_A2P_Submitted_to_Twilio__c`  string , `Related_Case__c`  string , `Related_Form_Response__c`  string , `BDRStatus__c`  string , `LeadGenQuality__c`  string , `Initially_Worked__c`  string , `Marine_Hubspot_Activity_ID__c`  string , `Call_Disposition__c`  string , `Gong__Activity_Source__c`  string , `Gong__Associated_Accounts__c`  string , `Gong__Associated_Opportunities__c`  string , `Gong__Call_Outcome__c`  string , `Gong__Current_Flow_ID__c`  string , `Gong__Current_Flow_Name__c`  string , `Gong__Current_Flow_Step_Number__c`  string , `Gong__Flow_Execution_ID__c`  string , `Gong__Gong_Activity_Id__c`  string , `Gong__Gong_Participants_Emails__c`  string , `Gong__Meeting_Prospect_Canceled__c`  string , `Gong__Meeting_Reschedule_Count__c`  string , `MigrationId__c`  string , `Data_Load_By__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-prod/raw/events/2026-04-17/1776427521'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.salesforce_events`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.salesforce_events"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform