Schema Info

Schema Name: sfdl_prod_drivethru.hubspot_molo_calls
  • created: 2023-02-09 16:02:54
  • disabled: False
  • format: raw
  • id: 1513
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_drivethru",
    "table": "hubspot_molo_calls"
}
  • type: drivethrujson
Schema Versions: 15
    • created: 2026-04-17 07:29:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-17/1776428523'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-17/1776428523
    • id: 1718134
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 162173169
    • updated: 2026-04-17 07:29:21
    • created: 2026-04-16 07:24:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-16/1776341832'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-16/1776341832
    • id: 1716904
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 162117417
    • updated: 2026-04-16 07:24:47
    • created: 2026-04-15 07:29:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-15/1776255761'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-15/1776255761
    • id: 1715707
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 162061883
    • updated: 2026-04-15 07:29:52
    • created: 2026-04-14 07:22:39
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-14/1776168948'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-14/1776168948
    • id: 1714510
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 162006443
    • updated: 2026-04-14 07:22:52
    • created: 2026-04-13 07:23:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-13/1776082633'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-13/1776082633
    • id: 1713288
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161948399
    • updated: 2026-04-13 07:24:10
    • created: 2026-04-12 07:28:00
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-12/1775996407'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-12/1775996407
    • id: 1712108
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161899608
    • updated: 2026-04-12 07:28:13
    • created: 2026-04-11 07:21:13
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-11/1775909664'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-11/1775909664
    • id: 1710888
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161846900
    • updated: 2026-04-11 07:21:27
    • created: 2026-04-10 07:25:53
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-10/1775823462'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-10/1775823462
    • id: 1709717
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161792146
    • updated: 2026-04-10 07:26:05
    • created: 2026-04-09 07:26:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-09/1775737198'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-09/1775737198
    • id: 1708575
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_summary": "
      Summary
      The call was initiated by Twin Lakes Anglers Club to First Capital Business Services, but there is no detailed information available regarding the conversation or its outcome.
      ",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161736328
    • updated: 2026-04-09 07:26:50
    • created: 2026-04-08 07:23:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-08/1775650593'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-08/1775650593
    • id: 1707384
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161681495
    • updated: 2026-04-08 07:23:21
    • created: 2026-04-07 07:32:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-07/1775564751'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-07/1775564751
    • id: 1706195
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161625306
    • updated: 2026-04-07 07:32:43
    • created: 2026-04-06 07:26:25
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-06/1775477960'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-06/1775477960
    • id: 1704978
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161567416
    • updated: 2026-04-06 07:26:39
    • created: 2026-04-05 07:26:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-05/1775391594'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-05/1775391594
    • id: 1703742
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161520030
    • updated: 2026-04-05 07:26:38
    • created: 2026-04-04 07:24:32
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-04/1775304914'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-04/1775304914
    • id: 1702605
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_owning_teams": "242125",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161466494
    • updated: 2026-04-04 07:24:43
    • created: 2026-04-03 07:29:11
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-03/1775218955'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-03/1775218955
    • id: 1701408
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-29T23:02:47.437Z",
    "id": "388966406",
    "properties": {
        "hs_activity_type": "",
        "hs_all_accessible_team_ids": "242125;75124100",
        "hs_all_owner_ids": "27148789",
        "hs_all_team_ids": "242125",
        "hs_at_mentioned_owner_ids": "27160654",
        "hs_attachment_ids": "",
        "hs_body_preview": "Left a message for managers either Christina or Cole.",
        "hs_body_preview_html": "\n \n \n 
      Left a message for managers either Christina or Cole. 
      \n \n",
        "hs_body_preview_is_truncated": "false",
        "hs_call_body": "",
        "hs_call_callee_object_id": "846151",
        "hs_call_callee_object_type": "CONTACT",
        "hs_call_deal_stage_during_call": "decisionmakerboughtin",
        "hs_call_direction": "OUTBOUND",
        "hs_call_disposition": "",
        "hs_call_duration": "20000",
        "hs_call_external_account_id": "AC136841700d47832e8c2be00ec05204ff",
        "hs_call_external_id": "CAb88def2710677d4345f31073245d6c6e",
        "hs_call_from_number": "+1 (909) 273-8937",
        "hs_call_from_number_nickname": "Lizzie Miller",
        "hs_call_has_transcript": "false",
        "hs_call_has_voicemail": "false",
        "hs_call_location": "CRM",
        "hs_call_phone_number_source": "EXTERNAL",
        "hs_call_primary_deal": "0-3-2008480664",
        "hs_call_recording_url": "",
        "hs_call_routing_strategy_type": "NO_ROUTING",
        "hs_call_source": "VOIP",
        "hs_call_status": "COMPLETED",
        "hs_call_title": "Call with unknown contact",
        "hs_call_to_number": "17603892299",
        "hs_call_transcript_audio_num_channels": "2",
        "hs_call_transcription_id": "",
        "hs_calls_service_call_id": "1127605103",
        "hs_connected_count": "0",
        "hs_created_by": "4428096",
        "hs_created_by_user_id": "4428096",
        "hs_createdate": "2017-06-29T23:02:47.437Z",
        "hs_engagement_source": "",
        "hs_engagement_source_id": "",
        "hs_engagements_last_contacted": "2017-06-29T23:02:47.394Z",
        "hs_follow_up_action": "",
        "hs_gdpr_deleted": "false",
        "hs_lastmodifieddate": "2022-02-19T05:48:39.559Z",
        "hs_modified_by": "4428096",
        "hs_obj_coords": "0-48-388966406",
        "hs_object_id": "388966406",
        "hs_object_source": "CRM_UI",
        "hs_object_source_id": "[email protected]",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "7813131",
        "hs_product_name": "",
        "hs_timestamp": "2017-06-29T23:02:47.394Z",
        "hs_unique_id": "",
        "hs_unknown_visitor_conversation": "false",
        "hs_updated_by_user_id": "4428096",
        "hs_user_ids_of_all_owners": "4428097",
        "hs_voicemail_count": "0",
        "hubspot_owner_assigneddate": "2018-07-17T19:34:05.704Z",
        "hubspot_owner_id": "27148789",
        "hubspot_team_id": ""
    },
    "updatedAt": "2022-02-19T05:48:39.559Z",
    "url": "https://app.hubspot.com/calls/2753955/review/388966406"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
    • schema_name_id: 1513
    • schema_scan_id: 161408666
    • updated: 2026-04-03 07:29:25
Schema Scans: 15
Last at 2026-04-17 07:22:34
    • duration: 0:06:47.376065
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162173169
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-17/1776428523",
        "key": "raw/hubspot_molo_calls/2026-04-17/1776428523/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6273402664246001095,
        "service_name": "drive-thru",
        "span_id": 18341088697445900887,
        "trace_id": 3996398888266747993
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-17 07:22:34
    • success: True
    • trace_id: 3996398888266747993
    • duration: 0:07:20.144796
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162117417
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-16/1776341832",
        "key": "raw/hubspot_molo_calls/2026-04-16/1776341832/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12312665177078768103,
        "service_name": "drive-thru",
        "span_id": 13654711455683576215,
        "trace_id": 7574547258582885889
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-16 07:17:26
    • success: True
    • trace_id: 7574547258582885889
    • duration: 0:06:42.539010
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162061883
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-15/1776255761",
        "key": "raw/hubspot_molo_calls/2026-04-15/1776255761/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13287450265323648151,
        "service_name": "drive-thru",
        "span_id": 11350772043567022945,
        "trace_id": 10429901435255654103
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-15 07:23:10
    • success: True
    • trace_id: 10429901435255654103
    • duration: 0:06:50.350114
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162006443
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-14/1776168948",
        "key": "raw/hubspot_molo_calls/2026-04-14/1776168948/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8492029832862703078,
        "service_name": "drive-thru",
        "span_id": 16354059080470460503,
        "trace_id": 9018045674732581344
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-14 07:16:02
    • success: True
    • trace_id: 9018045674732581344
    • duration: 0:06:48.782228
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161948399
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-13/1776082633",
        "key": "raw/hubspot_molo_calls/2026-04-13/1776082633/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12653090529598700772,
        "service_name": "drive-thru",
        "span_id": 15869750729648462203,
        "trace_id": 2136379461183883887
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-13 07:17:21
    • success: True
    • trace_id: 2136379461183883887
    • duration: 0:08:02.306117
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161899608
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-12/1775996407",
        "key": "raw/hubspot_molo_calls/2026-04-12/1775996407/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 429430476344487562,
        "service_name": "drive-thru",
        "span_id": 2340254809818987168,
        "trace_id": 8239971786563239567
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-12 07:20:11
    • success: True
    • trace_id: 8239971786563239567
    • duration: 0:06:58.164223
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161846900
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-11/1775909664",
        "key": "raw/hubspot_molo_calls/2026-04-11/1775909664/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5452189157422065581,
        "service_name": "drive-thru",
        "span_id": 5012070768342594856,
        "trace_id": 6206804202820987768
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-11 07:14:29
    • success: True
    • trace_id: 6206804202820987768
    • duration: 0:08:10.267750
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161792146
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-10/1775823462",
        "key": "raw/hubspot_molo_calls/2026-04-10/1775823462/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4809627142443027049,
        "service_name": "drive-thru",
        "span_id": 11229837341999303105,
        "trace_id": 10555882701905543842
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-10 07:17:54
    • success: True
    • trace_id: 10555882701905543842
    • duration: 0:06:39.100423
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161736328
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-09/1775737198",
        "key": "raw/hubspot_molo_calls/2026-04-09/1775737198/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 532116781999753022,
        "service_name": "drive-thru",
        "span_id": 8242051575129319362,
        "trace_id": 5349291785389714598
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-09 07:20:11
    • success: True
    • trace_id: 5349291785389714598
    • duration: 0:06:39.186105
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161681495
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-08/1775650593",
        "key": "raw/hubspot_molo_calls/2026-04-08/1775650593/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14409623992367159139,
        "service_name": "drive-thru",
        "span_id": 4946595103193076817,
        "trace_id": 11989792069139341684
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-08 07:16:42
    • success: True
    • trace_id: 11989792069139341684
    • duration: 0:06:39.987584
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161625306
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-07/1775564751",
        "key": "raw/hubspot_molo_calls/2026-04-07/1775564751/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9183428681636739138,
        "service_name": "drive-thru",
        "span_id": 5423288135421519793,
        "trace_id": 17764907921514476667
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-07 07:26:03
    • success: True
    • trace_id: 17764907921514476667
    • duration: 0:07:06.376479
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161567416
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-06/1775477960",
        "key": "raw/hubspot_molo_calls/2026-04-06/1775477960/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13169242087193604423,
        "service_name": "drive-thru",
        "span_id": 16848496377288787450,
        "trace_id": 10614558983706697802
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-06 07:19:32
    • success: True
    • trace_id: 10614558983706697802
    • duration: 0:06:31.864575
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161520030
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-05/1775391594",
        "key": "raw/hubspot_molo_calls/2026-04-05/1775391594/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4241154568690366332,
        "service_name": "drive-thru",
        "span_id": 5437856383069093656,
        "trace_id": 8918570076546568980
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-05 07:20:06
    • success: True
    • trace_id: 8918570076546568980
    • duration: 0:06:30.159170
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161466494
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-04/1775304914",
        "key": "raw/hubspot_molo_calls/2026-04-04/1775304914/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11657615136214570834,
        "service_name": "drive-thru",
        "span_id": 1331977141375767777,
        "trace_id": 14309730336690514416
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-04 07:18:13
    • success: True
    • trace_id: 14309730336690514416
    • duration: 0:06:44.848656
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161408666
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-03/1775218955",
        "key": "raw/hubspot_molo_calls/2026-04-03/1775218955/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11159470030013458628,
        "service_name": "drive-thru",
        "span_id": 6916356856026924430,
        "trace_id": 16878727203521517393
    }
}
    • running: False
    • schema_name_id: 1513
    • start_time: 2026-04-03 07:22:40
    • success: True
    • trace_id: 16878727203521517393
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.hs_activity_type": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_at_mentioned_owner_ids": "string",
    "properties.hs_attachment_ids": "string",
    "properties.hs_body_preview": "string",
    "properties.hs_body_preview_html": "string",
    "properties.hs_body_preview_is_truncated": "string",
    "properties.hs_call_body": "string",
    "properties.hs_call_callee_object_id": "string",
    "properties.hs_call_callee_object_type": "string",
    "properties.hs_call_deal_stage_during_call": "string",
    "properties.hs_call_direction": "string",
    "properties.hs_call_disposition": "string",
    "properties.hs_call_duration": "string",
    "properties.hs_call_external_account_id": "string",
    "properties.hs_call_external_id": "string",
    "properties.hs_call_from_number": "string",
    "properties.hs_call_from_number_nickname": "string",
    "properties.hs_call_has_transcript": "string",
    "properties.hs_call_has_voicemail": "string",
    "properties.hs_call_location": "string",
    "properties.hs_call_phone_number_source": "string",
    "properties.hs_call_primary_deal": "string",
    "properties.hs_call_recording_url": "string",
    "properties.hs_call_routing_strategy_type": "string",
    "properties.hs_call_source": "string",
    "properties.hs_call_status": "string",
    "properties.hs_call_summary": "string",
    "properties.hs_call_title": "string",
    "properties.hs_call_to_number": "string",
    "properties.hs_call_transcript_audio_num_channels": "string",
    "properties.hs_call_transcription_id": "string",
    "properties.hs_calls_service_call_id": "string",
    "properties.hs_connected_count": "string",
    "properties.hs_created_by": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_engagement_source": "string",
    "properties.hs_engagement_source_id": "string",
    "properties.hs_engagements_last_contacted": "string",
    "properties.hs_follow_up_action": "string",
    "properties.hs_gdpr_deleted": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_modified_by": "string",
    "properties.hs_obj_coords": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_owning_teams": "string",
    "properties.hs_product_name": "string",
    "properties.hs_timestamp": "string",
    "properties.hs_unique_id": "string",
    "properties.hs_unknown_visitor_conversation": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_voicemail_count": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "updatedAt": "string",
    "url": "string"
}
  • created: 2026-04-17 07:29:10
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-17/1776428523'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
}
Server:
  • hostname: schemamanager-5475496c57-7dpqb
  • name: schema_manager
  • process_start: 2026-01-09 11:27:47
  • sf_env: prod
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2023-02-09 16:02:54",
        "disabled": false,
        "format": "raw",
        "id": 1513,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "hubspot_molo_calls"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "createdAt": "string",
            "id": "string",
            "properties.hs_activity_type": "string",
            "properties.hs_all_accessible_team_ids": "string",
            "properties.hs_all_owner_ids": "string",
            "properties.hs_all_team_ids": "string",
            "properties.hs_at_mentioned_owner_ids": "string",
            "properties.hs_attachment_ids": "string",
            "properties.hs_body_preview": "string",
            "properties.hs_body_preview_html": "string",
            "properties.hs_body_preview_is_truncated": "string",
            "properties.hs_call_body": "string",
            "properties.hs_call_callee_object_id": "string",
            "properties.hs_call_callee_object_type": "string",
            "properties.hs_call_deal_stage_during_call": "string",
            "properties.hs_call_direction": "string",
            "properties.hs_call_disposition": "string",
            "properties.hs_call_duration": "string",
            "properties.hs_call_external_account_id": "string",
            "properties.hs_call_external_id": "string",
            "properties.hs_call_from_number": "string",
            "properties.hs_call_from_number_nickname": "string",
            "properties.hs_call_has_transcript": "string",
            "properties.hs_call_has_voicemail": "string",
            "properties.hs_call_location": "string",
            "properties.hs_call_phone_number_source": "string",
            "properties.hs_call_primary_deal": "string",
            "properties.hs_call_recording_url": "string",
            "properties.hs_call_routing_strategy_type": "string",
            "properties.hs_call_source": "string",
            "properties.hs_call_status": "string",
            "properties.hs_call_summary": "string",
            "properties.hs_call_title": "string",
            "properties.hs_call_to_number": "string",
            "properties.hs_call_transcript_audio_num_channels": "string",
            "properties.hs_call_transcription_id": "string",
            "properties.hs_calls_service_call_id": "string",
            "properties.hs_connected_count": "string",
            "properties.hs_created_by": "string",
            "properties.hs_created_by_user_id": "string",
            "properties.hs_createdate": "string",
            "properties.hs_engagement_source": "string",
            "properties.hs_engagement_source_id": "string",
            "properties.hs_engagements_last_contacted": "string",
            "properties.hs_follow_up_action": "string",
            "properties.hs_gdpr_deleted": "string",
            "properties.hs_lastmodifieddate": "string",
            "properties.hs_modified_by": "string",
            "properties.hs_obj_coords": "string",
            "properties.hs_object_id": "string",
            "properties.hs_object_source": "string",
            "properties.hs_object_source_id": "string",
            "properties.hs_object_source_label": "string",
            "properties.hs_object_source_user_id": "string",
            "properties.hs_owning_teams": "string",
            "properties.hs_product_name": "string",
            "properties.hs_timestamp": "string",
            "properties.hs_unique_id": "string",
            "properties.hs_unknown_visitor_conversation": "string",
            "properties.hs_updated_by_user_id": "string",
            "properties.hs_user_ids_of_all_owners": "string",
            "properties.hs_voicemail_count": "string",
            "properties.hubspot_owner_assigneddate": "string",
            "properties.hubspot_owner_id": "string",
            "properties.hubspot_team_id": "string",
            "updatedAt": "string",
            "url": "string"
        },
        "created": "2026-04-17 07:29:10",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_calls`\n(\n`id`STRING,`properties`struct<`hs_activity_type`:STRING,`hs_all_owner_ids`:STRING,`hs_attachment_ids`:STRING,`hs_call_body`:STRING,`hs_call_disposition`:STRING,`hs_call_duration`:STRING,`hs_call_external_account_id`:STRING,`hs_call_external_id`:STRING,`hs_call_from_number`:STRING,`hs_call_has_transcript`:STRING,`hs_call_recording_url`:STRING,`hs_call_source`:STRING,`hs_call_status`:STRING,`hs_call_title`:STRING,`hs_call_to_number`:STRING,`hs_connected_count`:STRING,`hs_created_by`:STRING,`hs_created_by_user_id`:STRING,`hs_createdate`:STRING,`hs_engagement_source`:STRING,`hs_engagement_source_id`:STRING,`hs_engagements_last_contacted`:STRING,`hs_lastmodifieddate`:STRING,`hs_modified_by`:STRING,`hs_obj_coords`:STRING,`hs_object_id`:STRING,`hs_timestamp`:STRING,`hs_unique_id`:STRING,`hs_unknown_visitor_conversation`:STRING,`hs_updated_by_user_id`:STRING,`hs_voicemail_count`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`hs_body_preview`:STRING,`hs_body_preview_html`:STRING,`hs_body_preview_is_truncated`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_call_deal_stage_during_call`:STRING,`hs_call_primary_deal`:STRING,`hs_calls_service_call_id`:STRING,`hs_at_mentioned_owner_ids`:STRING,`hs_follow_up_action`:STRING,`hs_product_name`:STRING,`hs_call_callee_object_id`:STRING,`hs_call_callee_object_type`:STRING,`hs_call_transcription_id`:STRING,`hubspot_owner_assigneddate`:STRING,`hs_call_transcript_audio_num_channels`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_team_ids`:STRING,`hs_owning_teams`:STRING,`hs_gdpr_deleted`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_user_id`:STRING,`hs_call_direction`:STRING,`hs_call_from_number_nickname`:STRING,`hs_call_has_voicemail`:STRING,`hs_call_location`:STRING,`hs_call_phone_number_source`:STRING,`hs_call_routing_strategy_type`:STRING,`hs_call_summary`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`url`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_calls/2026-04-17/1776428523'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_calls`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_calls"
        }
    },
    "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