Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_calls

created: 2023-02-09 07:19:35
disabled: False
format: raw
id: 1788
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_drivethru",
    "table": "hubspot_molo_calls"
}

type: drivethrujson

Schema Versions: 15

Version 906680

created: 2026-04-17 07:26:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-17/1776428277'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-17/1776428277
id: 906680
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.

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: 1788
schema_scan_id: 6415289
updated: 2026-04-17 07:26:38

Version 906462

created: 2026-04-16 07:22:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-16/1776341612'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-16/1776341612
id: 906462
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6414736
updated: 2026-04-16 07:22:26

Version 906249

created: 2026-04-15 07:30:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-15/1776255770'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-15/1776255770
id: 906249
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6414260
updated: 2026-04-15 07:30:46

Version 906035

created: 2026-04-14 07:23:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-14/1776168952'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-14/1776168952
id: 906035
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6413761
updated: 2026-04-14 07:23:38

Version 905820

created: 2026-04-13 07:25:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-13/1776082685'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-13/1776082685
id: 905820
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6413205
updated: 2026-04-13 07:26:03

Version 905616

created: 2026-04-12 07:23:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-12/1775996116'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-12/1775996116
id: 905616
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6412796
updated: 2026-04-12 07:23:53

Version 905413

created: 2026-04-11 07:21:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-11/1775909640'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-11/1775909640
id: 905413
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6412414
updated: 2026-04-11 07:21:50

Version 905202

created: 2026-04-10 07:29:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-10/1775823682'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-10/1775823682
id: 905202
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6411949
updated: 2026-04-10 07:29:33

Version 904988

created: 2026-04-09 07:28:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-09/1775737279'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-09/1775737279
id: 904988
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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.

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: 1788
schema_scan_id: 6411435
updated: 2026-04-09 07:29:04

Version 904774

created: 2026-04-08 07:21:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-08/1775650375'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-08/1775650375
id: 904774
processed: 1

raw_data:

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: 1788
schema_scan_id: 6410920
updated: 2026-04-08 07:21:54

Version 904559

created: 2026-04-07 07:24:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-07/1775564191'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-07/1775564191
id: 904559
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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: 1788
schema_scan_id: 6410412
updated: 2026-04-07 07:24:32

Version 904346

created: 2026-04-06 07:26:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-06/1775477876'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-06/1775477876
id: 904346
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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: 1788
schema_scan_id: 6409869
updated: 2026-04-06 07:26:32

Version 904142

created: 2026-04-05 07:19:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-05/1775391162'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-05/1775391162
id: 904142
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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: 1788
schema_scan_id: 6409458
updated: 2026-04-05 07:20:02

Version 903939

created: 2026-04-04 07:21:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-04/1775304840'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-04/1775304840
id: 903939
processed: 1

raw_data:

Left a message for managers either Christina or Cole.

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: 1788
schema_scan_id: 6409078
updated: 2026-04-04 07:21:40

Version 903728

created: 2026-04-03 07:25:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-03/1775218602'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
]

hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-03/1775218602
id: 903728
processed: 1

raw_data:

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: 1788
schema_scan_id: 6408618
updated: 2026-04-03 07:25:35

Schema Scans: 15

Last at 2026-04-17 07:18:31

Scan 6415289

duration: 0:08:07.146870

exit_message:

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

id: 6415289

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-17/1776428277",
        "key": "raw/hubspot_molo_calls/2026-04-17/1776428277/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10479771303900884312,
        "service_name": "drive-thru",
        "span_id": 7977281805236344731,
        "trace_id": 16381411365432187924
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-17 07:18:31
success: True
trace_id: 16381411365432187924

Scan 6414736

duration: 0:08:41.669828

exit_message:

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

id: 6414736

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-16/1776341612",
        "key": "raw/hubspot_molo_calls/2026-04-16/1776341612/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5201923964999614217,
        "service_name": "drive-thru",
        "span_id": 2784074209495759571,
        "trace_id": 9103155853372555903
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-16 07:13:44
success: True
trace_id: 9103155853372555903

Scan 6414260

duration: 0:07:31.218044

exit_message:

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

id: 6414260

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-15/1776255770",
        "key": "raw/hubspot_molo_calls/2026-04-15/1776255770/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16935494780296336644,
        "service_name": "drive-thru",
        "span_id": 3175295735468838199,
        "trace_id": 11273572051501107097
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-15 07:23:15
success: True
trace_id: 11273572051501107097

Scan 6413761

duration: 0:07:14.976473

exit_message:

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

id: 6413761

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-14/1776168952",
        "key": "raw/hubspot_molo_calls/2026-04-14/1776168952/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15351656408684843752,
        "service_name": "drive-thru",
        "span_id": 17207338532608185188,
        "trace_id": 5950795184536370195
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-14 07:16:23
success: True
trace_id: 5950795184536370195

Scan 6413205

duration: 0:07:28.731122

exit_message:

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

id: 6413205

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-13/1776082685",
        "key": "raw/hubspot_molo_calls/2026-04-13/1776082685/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6015403379581831945,
        "service_name": "drive-thru",
        "span_id": 1553785579238871916,
        "trace_id": 13569010347354333410
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-13 07:18:35
success: True
trace_id: 13569010347354333410

Scan 6412796

duration: 0:07:35.850703

exit_message:

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

id: 6412796

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-12/1775996116",
        "key": "raw/hubspot_molo_calls/2026-04-12/1775996116/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4360734025385627749,
        "service_name": "drive-thru",
        "span_id": 16038534548774343498,
        "trace_id": 6596228258922371287
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-12 07:16:17
success: True
trace_id: 6596228258922371287

Scan 6412414

duration: 0:07:43.117405

exit_message:

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

id: 6412414

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-11/1775909640",
        "key": "raw/hubspot_molo_calls/2026-04-11/1775909640/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6715014140107646339,
        "service_name": "drive-thru",
        "span_id": 10458506752019695842,
        "trace_id": 16794543829928596204
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-11 07:14:07
success: True
trace_id: 16794543829928596204

Scan 6411949

duration: 0:08:01.750614

exit_message:

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

id: 6411949

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-10/1775823682",
        "key": "raw/hubspot_molo_calls/2026-04-10/1775823682/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 12165414781638173342,
        "service_name": "drive-thru",
        "span_id": 11373612446051628377,
        "trace_id": 8765386655678462350
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-10 07:21:31
success: True
trace_id: 8765386655678462350

Scan 6411435

duration: 0:07:26.937166

exit_message:

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

id: 6411435

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-09/1775737279",
        "key": "raw/hubspot_molo_calls/2026-04-09/1775737279/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4970850454597353220,
        "service_name": "drive-thru",
        "span_id": 392137128819576480,
        "trace_id": 3155636560978557398
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-09 07:21:37
success: True
trace_id: 3155636560978557398

Scan 6410920

duration: 0:08:48.271592

exit_message:

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

id: 6410920

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-08/1775650375",
        "key": "raw/hubspot_molo_calls/2026-04-08/1775650375/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 7387365554060195126,
        "service_name": "drive-thru",
        "span_id": 17407368715698492496,
        "trace_id": 9281089453574185108
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-08 07:13:06
success: True
trace_id: 9281089453574185108

Scan 6410412

duration: 0:07:55.061833

exit_message:

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

id: 6410412

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-07/1775564191",
        "key": "raw/hubspot_molo_calls/2026-04-07/1775564191/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10228939666289111639,
        "service_name": "drive-thru",
        "span_id": 10767424420411208554,
        "trace_id": 6411523556104116153
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-07 07:16:37
success: True
trace_id: 6411523556104116153

Scan 6409869

duration: 0:08:17.868675

exit_message:

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

id: 6409869

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-06/1775477876",
        "key": "raw/hubspot_molo_calls/2026-04-06/1775477876/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10348769376901388565,
        "service_name": "drive-thru",
        "span_id": 7344490343548968203,
        "trace_id": 2343630045780204629
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-06 07:18:14
success: True
trace_id: 2343630045780204629

Scan 6409458

duration: 0:07:15.815723

exit_message:

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

id: 6409458

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-05/1775391162",
        "key": "raw/hubspot_molo_calls/2026-04-05/1775391162/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6089067329954943177,
        "service_name": "drive-thru",
        "span_id": 7498071736565847412,
        "trace_id": 9276737537330892200
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-05 07:12:46
success: True
trace_id: 9276737537330892200

Scan 6409078

duration: 0:07:34.694656

exit_message:

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

id: 6409078

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-04/1775304840",
        "key": "raw/hubspot_molo_calls/2026-04-04/1775304840/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5095438168108657025,
        "service_name": "drive-thru",
        "span_id": 1162538705668326606,
        "trace_id": 13384828351021125050
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-04 07:14:05
success: True
trace_id: 13384828351021125050

Scan 6408618

duration: 0:07:58.067664

exit_message:

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

id: 6408618

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_calls/2026-04-03/1775218602",
        "key": "raw/hubspot_molo_calls/2026-04-03/1775218602/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_calls",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5386732503561529899,
        "service_name": "drive-thru",
        "span_id": 4176758779932077626,
        "trace_id": 11156809120262657195
    }
}

running: False
schema_name_id: 1788
start_time: 2026-04-03 07:17:37
success: True
trace_id: 11156809120262657195

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:26:27

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-17/1776428277'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-09 07:19:35",
        "disabled": false,
        "format": "raw",
        "id": 1788,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_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:26:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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-stage/raw/hubspot_molo_calls/2026-04-17/1776428277'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_calls`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_calls"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}