Schema Info

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`city`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`:STRING,`form_submission_date`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_contact_vids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_average_page_views`:STRING,`hs_analytics_first_referrer`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_url`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_referrer`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_url`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_num_event_completions`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_revenue`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_calculated_form_submissions`:STRING,`hs_calculated_phone_number`:STRING,`hs_calculated_phone_number_country_code`:STRING,`hs_count_is_unworked`:STRING,`hs_count_is_worked`:STRING,`hs_country_region_code`:STRING,`hs_date_entered_lead`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_lead`:STRING,`hs_email_delivered`:STRING,`hs_email_domain`:STRING,`hs_email_first_send_date`:STRING,`hs_email_last_email_name`:STRING,`hs_email_last_send_date`:STRING,`hs_email_optout`:STRING,`hs_email_optout_4049846`:STRING,`hs_email_optout_4049889`:STRING,`hs_email_sends_since_last_engagement`:STRING,`hs_ip_timezone`:STRING,`hs_is_contact`:STRING,`hs_is_unworked`:STRING,`hs_latest_source`:STRING,`hs_latest_source_data_1`:STRING,`hs_latest_source_data_2`:STRING,`hs_latest_source_timestamp`:STRING,`hs_lifecyclestage_lead_date`:STRING,`hs_lifecyclestage_opportunity_date`:STRING,`hs_marketable_reason_id`:STRING,`hs_marketable_reason_type`:STRING,`hs_marketable_status`:STRING,`hs_marketable_until_renewal`:STRING,`hs_object_id`:STRING,`hs_pipeline`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_predictivescoringtier`:STRING,`hs_registered_member`:STRING,`hs_searchable_calculated_phone_number`:STRING,`hs_social_facebook_clicks`:STRING,`hs_social_google_plus_clicks`:STRING,`hs_social_last_engagement`:STRING,`hs_social_linkedin_clicks`:STRING,`hs_social_num_broadcast_clicks`:STRING,`hs_social_twitter_clicks`:STRING,`hs_state_code`:STRING,`hs_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_updated_by_user_id`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_v2_cumulative_time_in_lead`:STRING,`hs_v2_date_entered_lead`:STRING,`hs_v2_date_entered_opportunity`:STRING,`hs_v2_date_exited_lead`:STRING,`hs_v2_latest_time_in_lead`:STRING,`hs_was_imported`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`ip_city`:STRING,`ip_country`:STRING,`ip_country_code`:STRING,`ip_latlon`:STRING,`ip_state`:STRING,`ip_state_code`:STRING,`ip_zipcode`:STRING,`last_login_date`:STRING,`lastmodifieddate`:STRING,`lastname`:STRING,`lifecyclestage`:STRING,`new_lead_status`:STRING,`num_conversion_events`:STRING,`num_unique_conversion_events`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`salesforce_contacts_id`:STRING,`state`:STRING,`hs_associated_target_accounts`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_first_engagement_object_id`:STRING,`hs_first_outreach_date`:STRING,`hs_notes_last_activity`:STRING,`hs_sa_first_engagement_date`:STRING,`hs_sa_first_engagement_descr`:STRING,`hs_sa_first_engagement_object_type`:STRING,`hs_time_to_first_engagement`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`photo`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`address`:STRING,`current_software`:STRING,`current_vendor_new`:STRING,`engagements_last_meeting_booked`:STRING,`hs_sales_email_last_opened`:STRING,`hs_sales_email_last_replied`:STRING,`notes_next_activity_date`:STRING,`other_vendor`:STRING,`zip`:STRING,`hs_email_first_open_date`:STRING,`hs_email_last_open_date`:STRING,`hs_email_open`:STRING,`leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e`:STRING,`first_deal_created_date`:STRING,`how_heard_about_us`:STRING,`hs_calculated_mobile_number`:STRING,`hs_email_bounce`:STRING,`hs_email_hard_bounce_reason_enum`:STRING,`hs_searchable_calculated_mobile_number`:STRING,`mobilephone`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`total_revenue`:STRING,`hs_email_quarantined`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`leadin_phone_optional_324d7459684ca0b489279d4e48644441`:STRING,`days_to_close`:STRING,`hs_additional_emails`:STRING,`hs_calculated_merged_vids`:STRING,`hs_created_by_user_id`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_merged_object_ids`:STRING,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_object_source`:STRING,`hs_object_source_id`:STRING,`hs_object_source_label`:STRING,`hs_object_source_user_id`:STRING,`hs_sales_email_last_clicked`:STRING,`hs_sequences_actively_enrolled_count`:STRING,`hs_sequences_is_enrolled`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`hs_v2_cumulative_time_in_opportunity`:STRING,`jobtitle`:STRING,`must_haves`:STRING,`followercount`:STRING,`hs_twitterid`:STRING,`twitterbio`:STRING,`twitterhandle`:STRING,`hs_facebookid`:STRING,`hs_email_bad_address`:STRING,`hs_latest_sequence_ended_date`:STRING,`hs_latest_sequence_enrolled`:STRING,`hs_latest_sequence_enrolled_date`:STRING,`hs_latest_sequence_finished_date`:STRING,`hs_sequences_enrolled_count`:STRING,`leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970`:STRING,`leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a`:STRING,`closedate`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_in_customer`:STRING,`hs_v2_date_entered_customer`:STRING,`hs_v2_date_exited_opportunity`:STRING,`hs_v2_latest_time_in_opportunity`:STRING,`base_tags`:STRING,`website`:STRING,`fax`:STRING,`trade_show`:STRING,`hs_last_sales_activity_type`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`hs_v2_cumulative_time_in_subscriber`:STRING,`hs_v2_date_entered_subscriber`:STRING,`hs_v2_date_exited_subscriber`:STRING,`hs_v2_latest_time_in_subscriber`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_v2_date_entered_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`hs_v2_cumulative_time_in_salesqualifiedlead`:STRING,`hs_v2_date_exited_salesqualifiedlead`:STRING,`hs_v2_latest_time_in_salesqualifiedlead`:STRING,`hs_currently_enrolled_in_prospecting_agent`:STRING,`hs_membership_has_accessed_private_content`:STRING,`hs_prospecting_agent_actively_enrolled_count`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_google_click_id`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_v2_cumulative_time_in_marketingqualifiedlead`:STRING,`hs_v2_date_entered_marketingqualifiedlead`:STRING,`hs_v2_date_exited_marketingqualifiedlead`:STRING,`hs_v2_latest_time_in_marketingqualifiedlead`:STRING,`associated_show_event`:STRING,`inactive`:STRING,`skype_username`:STRING,`hs_time_to_move_from_marketingqualifiedlead_to_customer`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`hs_quarantined_emails`:STRING,`hs_v2_cumulative_time_in_customer`:STRING,`hs_object_source_detail_1`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`hs_legal_basis`:STRING,`marina_job_title`:STRING,`marina_name`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`hs_v2_date_entered_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_v2_date_exited_customer`:STRING,`hs_v2_latest_time_in_customer`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`hs_v2_date_entered_evangelist`:STRING,`do_not_sync_to_sfdc`:STRING,`hs_facebook_ad_clicked`:STRING,`nickname`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`how_many_boats_do_you_manage_`:STRING,`message`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`actively_working_lead`:STRING,`hs_facebook_click_id`:STRING,`work_email`:STRING,`stellar_invalid_email_address`:STRING,`send_me_updates`:STRING,`utm_campaign`:STRING,`utm_content`:STRING,`utm_medium`:STRING,`utm_source`:STRING,`utm_term`:STRING,`services`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contacts/2024-12-16/1734355127'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contacts"
]

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "true",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "NY Boat Show 2014",
        "associatedcompanyid": "5749919313",
        "associatedcompanylastupdated": "1109426470201051",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Erwin Marine Sales",
        "country": "united states",
        "createdate": "2017-02-07T14:08:17.112Z",
        "current_software": "Fareharbor",
        "current_vendor_new": "Fareharbor;Other",
        "currentlyinworkflow": "false",
        "days_to_close": "",
        "direct_phone_number": "(972) 771-8865",
        "do_not_sync_to_sfdc": "true",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "engagements_last_meeting_booked_campaign": "capterra-general-link",
        "engagements_last_meeting_booked_medium": "email",
        "engagements_last_meeting_booked_source": "capterra",
        "fax": "(315) 482-5434",
        "first_conversion_date": "2017-02-07T14:08:17.112Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_deal_created_date": "2019-02-13T21:40:32.145Z",
        "firstname": "Marc",
        "followercount": "17",
        "form_submission_date": "2024-09-17",
        "how_heard_about_us": "Capterra",
        "how_many_boats_do_you_manage_": "10",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_assigned_business_unit_ids": "0",
        "hs_all_contact_vids": "154701;4360951",
        "hs_all_owner_ids": "378624067",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "1",
        "hs_analytics_first_referrer": "",
        "hs_analytics_first_timestamp": "2017-01-27T19:51:37.330Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-27T19:51:37.330Z",
        "hs_analytics_last_referrer": "https://www.google.com/",
        "hs_analytics_last_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/",
        "hs_analytics_last_visit_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "5",
        "hs_analytics_num_visits": "5",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "DIRECT_TRAFFIC",
        "hs_analytics_source_data_1": "getmolo.com/",
        "hs_analytics_source_data_2": "",
        "hs_associated_target_accounts": "0",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1486476497112",
        "hs_calculated_merged_vids": "4360951:1712157436659",
        "hs_calculated_mobile_number": "+14232876026",
        "hs_calculated_phone_number": "+14236221978",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_country_region_code": "us",
        "hs_created_by_user_id": "60918476",
        "hs_currently_enrolled_in_prospecting_agent": "false",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2024-01-17T17:33:04.536Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2024-01-17T17:33:12.962Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2017-06-26T15:25:16.056Z",
        "hs_date_exited_lead": "2024-01-17T17:33:12.962Z",
        "hs_date_exited_marketingqualifiedlead": "2019-05-21T21:13:23.080Z",
        "hs_date_exited_opportunity": "2017-11-02T15:58:17.778Z",
        "hs_date_exited_salesqualifiedlead": "2022-03-24T19:45:06.188Z",
        "hs_date_exited_subscriber": "2017-06-26T15:25:16.057Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "17",
        "hs_email_domain": "erwinmarinesales.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T22:08:11.344Z",
        "hs_email_first_send_date": "2021-06-22T19:00:06.786Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Molo- DO MORE - 11",
        "hs_email_last_open_date": "2023-04-13T17:59:09.437Z",
        "hs_email_last_send_date": "2023-04-13T17:35:30.651Z",
        "hs_email_open": "11",
        "hs_email_optout": "true",
        "hs_email_optout_4048048": "true",
        "hs_email_optout_4049846": "true",
        "hs_email_optout_4049889": "true",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "0",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebook_click_id": "IwAR3IJOBN3hiZtmkix6spTUkm62myrO-uraEPg76pll3eoSXyu1TP0DVPia8",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "56729670948",
        "hs_first_outreach_date": "2019-02-21T19:04:14.681Z",
        "hs_google_click_id": "CjwKCAjw1MajBhAcEiwAagW9MWZgEK41bOr0umJqRfoSWyvoCHC6XNhCRXCOwTX-2eVUFQhJxIFXgBoC1n8QAvD_BwE",
        "hs_ip_timezone": "america_slash_chicago",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-20T03:15:25.227Z",
        "hs_last_sales_activity_timestamp": "2022-05-23T17:00:27.882Z",
        "hs_last_sales_activity_type": "EMAIL_REPLY",
        "hs_latest_meeting_activity": "2021-08-27T20:00:00Z",
        "hs_latest_sequence_ended_date": "2021-08-19T13:51:35.032Z",
        "hs_latest_sequence_enrolled": "37318635",
        "hs_latest_sequence_enrolled_date": "2021-08-03T15:00:08.771Z",
        "hs_latest_sequence_finished_date": "2021-08-19T13:51:35.032Z",
        "hs_latest_sequence_unenrolled_date": "2021-10-15T20:24:34.667Z",
        "hs_latest_source": "DIRECT_TRAFFIC",
        "hs_latest_source_data_1": "getmolo.com/",
        "hs_latest_source_data_2": "",
        "hs_latest_source_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Legitimate interest \u2013 prospect/lead",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2024-01-17T17:33:04.536Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2024-01-17T17:33:12.962Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2017-06-26T15:25:16.056Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_membership_has_accessed_private_content": "0",
        "hs_merged_object_ids": "4360951",
        "hs_notes_last_activity": "0-48-56966494099",
        "hs_notes_next_activity": "",
        "hs_notes_next_activity_type": "",
        "hs_object_id": "154701",
        "hs_object_source": "CRM_UI",
        "hs_object_source_detail_1": "",
        "hs_object_source_detail_2": "",
        "hs_object_source_detail_3": "",
        "hs_object_source_id": "userId:60918476",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "60918476",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_3",
        "hs_prospecting_agent_actively_enrolled_count": "0",
        "hs_quarantined_emails": "[email protected] - HubSpot\nReason: Undeliverable Address",
        "hs_registered_member": "0",
        "hs_sa_first_engagement_date": "",
        "hs_sa_first_engagement_descr": "",
        "hs_sa_first_engagement_object_type": "",
        "hs_sales_email_last_clicked": "2022-05-23T15:12:34.315Z",
        "hs_sales_email_last_opened": "2020-03-18T15:04:58.409Z",
        "hs_sales_email_last_replied": "",
        "hs_searchable_calculated_mobile_number": "2817403174",
        "hs_searchable_calculated_phone_number": "2504685364",
        "hs_sequences_actively_enrolled_count": "0",
        "hs_sequences_enrolled_count": "1",
        "hs_sequences_is_enrolled": "",
        "hs_social_facebook_clicks": "0",
        "hs_social_google_plus_clicks": "0",
        "hs_social_last_engagement": "",
        "hs_social_linkedin_clicks": "0",
        "hs_social_num_broadcast_clicks": "0",
        "hs_social_twitter_clicks": "0",
        "hs_state_code": "bc",
        "hs_time_between_contact_creation_and_deal_close": "",
        "hs_time_between_contact_creation_and_deal_creation": "63617535033",
        "hs_time_in_customer": "224715912188",
        "hs_time_in_evangelist": "213141872753",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "235863019543",
        "hs_time_in_other": "214671611848",
        "hs_time_in_salesqualifiedlead": "224878401160",
        "hs_time_in_subscriber": "1",
        "hs_time_to_first_engagement": "",
        "hs_time_to_move_from_lead_to_customer": "",
        "hs_time_to_move_from_marketingqualifiedlead_to_customer": "",
        "hs_time_to_move_from_opportunity_to_customer": "",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "",
        "hs_time_to_move_from_subscriber_to_customer": "",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "68170421",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "44200137",
        "hs_v2_cumulative_time_in_customer": "11915836662",
        "hs_v2_cumulative_time_in_lead": "13031429927",
        "hs_v2_cumulative_time_in_marketingqualifiedlead": "41056978272",
        "hs_v2_cumulative_time_in_opportunity": "207021593420",
        "hs_v2_cumulative_time_in_salesqualifiedlead": "139012859744",
        "hs_v2_cumulative_time_in_subscriber": "1",
        "hs_v2_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_v2_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_v2_date_entered_lead": "2017-01-26T19:42:40.513Z",
        "hs_v2_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_v2_date_entered_opportunity": "2017-06-26T15:33:10.440Z",
        "hs_v2_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_v2_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_v2_date_entered_subscriber": "2017-06-26T15:25:16.056Z",
        "hs_v2_date_exited_customer": "2018-03-07T15:43:55.128Z",
        "hs_v2_date_exited_lead": "2017-06-26T15:33:10.440Z",
        "hs_v2_date_exited_marketingqualifiedlead": "2019-05-21T21:13:23.080Z",
        "hs_v2_date_exited_opportunity": "2017-11-02T15:58:17.778Z",
        "hs_v2_date_exited_salesqualifiedlead": "2022-03-24T19:45:06.188Z",
        "hs_v2_date_exited_subscriber": "2017-06-26T15:25:16.057Z",
        "hs_v2_latest_time_in_customer": "1902328509",
        "hs_v2_latest_time_in_lead": "13031429927",
        "hs_v2_latest_time_in_marketingqualifiedlead": "41056978272",
        "hs_v2_latest_time_in_opportunity": "11147105882",
        "hs_v2_latest_time_in_salesqualifiedlead": "139012859744",
        "hs_v2_latest_time_in_subscriber": "1",
        "hs_was_imported": "true",
        "hubspot_owner_assigneddate": "2024-07-10T13:20:24.054Z",
        "hubspot_owner_id": "162039666",
        "hubspot_team_id": "",
        "inactive": "true",
        "industry": "Pedestals, Marina Electricity",
        "ip_city": "",
        "ip_country": "canada",
        "ip_country_code": "ca",
        "ip_latlon": "",
        "ip_state": "british columbia",
        "ip_state_code": "bc",
        "ip_zipcode": "",
        "jobtitle": "GM",
        "kloutscoregeneral": "13",
        "last_login_date": "2024-09-17",
        "lastmodifieddate": "2024-12-11T21:07:27.188Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a": "Khalid Elbashir",
        "leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe": "Nitin",
        "leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970": "Amanda",
        "leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4": "looking for anymore information and possibly a demo    thanks Glenn.",
        "leadin_phone_optional_324d7459684ca0b489279d4e48644441": "Name",
        "leadin_submit_a4d3b161ce1309df1c4e25df28694b7b": "I have a meeting with our Finance Director this morning. I would like to try to schedule a conference call for any questions so we can try to make a decision to move forward with MOLO",
        "leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a": "Amanda",
        "lifecyclestage": "opportunity",
        "linkedinbio": "",
        "linkedinconnections": "0",
        "marina_job_title": "Other Marina Staff",
        "marina_name": "Sunnyside Marina",
        "marina_size_linear_feet_": "12100",
        "message": "https://swingingbridgemarina.com/",
        "mobilephone": "(281) 740-3174",
        "must_haves": "Brokerage/Sales",
        "new_lead_status": "Prospect",
        "nickname": "",
        "notes_last_contacted": "2022-10-03T18:58:17.273Z",
        "notes_last_updated": "2022-10-03T18:58:17.273Z",
        "notes_next_activity_date": "",
        "num_associated_deals": "",
        "num_contacted_notes": "2",
        "num_conversion_events": "1",
        "num_notes": "2",
        "num_unique_conversion_events": "1",
        "number_of_slips": "250",
        "other_vendor": "",
        "phone": "(310) 305-9503",
        "photo": "https://d2ojpxxtu63wzl.cloudfront.net/static/9e55d7e95d716ad09a098ab2e007be6f_58b0f0526ccd73c7f03ca54a4a1ba0b5f72ebedb33077d36afe5e5117bc5c720",
        "recent_conversion_date": "2016-12-15T17:56:53.529Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: #subForm .registration-form",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "salesforce_contacts_id": "003PJ00000AliniYAB",
        "salutation": "Mr.",
        "send_me_updates": "true",
        "services": "Molo + Stellar",
        "services_offered": "Slips",
        "skype_username": "sergio.peterlin",
        "state": "california",
        "stellar_invalid_email_address": "false",
        "supplemental_email": "[email protected]",
        "total_revenue": "",
        "trade_show": "AMI",
        "twitterbio": "Premier marine paradise. Summer dockage, heated winter storage, largest accessory store, fuel, full service, boat sales.",
        "twitterhandle": "HORIZONMARINA",
        "twitterprofilephoto": "",
        "utm_campaign": "BFO | StellarIMS | Leads",
        "utm_content": "Stellar Boat Rental Management",
        "utm_medium": "paid_social",
        "utm_source": "ig",
        "utm_term": "120212710771870337",
        "website": "http://www.americanwharf.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2024-12-11T21:06:11.887Z"
}

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.base_tags": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.days_to_close": "string",
    "properties.direct_phone_number": "string",
    "properties.do_not_sync_to_sfdc": "string",
    "properties.email": "string",
    "properties.engagements_last_meeting_booked": "string",
    "properties.engagements_last_meeting_booked_campaign": "string",
    "properties.engagements_last_meeting_booked_medium": "string",
    "properties.engagements_last_meeting_booked_source": "string",
    "properties.fax": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_deal_created_date": "string",
    "properties.firstname": "string",
    "properties.followercount": "string",
    "properties.form_submission_date": "string",
    "properties.how_heard_about_us": "string",
    "properties.how_many_boats_do_you_manage_": "string",
    "properties.hs_additional_emails": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_contact_vids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_average_page_views": "string",
    "properties.hs_analytics_first_referrer": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_url": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_last_referrer": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_url": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_num_event_completions": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_revenue": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_associated_target_accounts": "string",
    "properties.hs_calculated_form_submissions": "string",
    "properties.hs_calculated_merged_vids": "string",
    "properties.hs_calculated_mobile_number": "string",
    "properties.hs_calculated_phone_number": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_country_region_code": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_currently_enrolled_in_prospecting_agent": "string",
    "properties.hs_date_entered_customer": "string",
    "properties.hs_date_entered_evangelist": "string",
    "properties.hs_date_entered_lead": "string",
    "properties.hs_date_entered_marketingqualifiedlead": "string",
    "properties.hs_date_entered_opportunity": "string",
    "properties.hs_date_entered_other": "string",
    "properties.hs_date_entered_salesqualifiedlead": "string",
    "properties.hs_date_entered_subscriber": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_delivered": "string",
    "properties.hs_email_domain": "string",
    "properties.hs_email_first_click_date": "string",
    "properties.hs_email_first_open_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_last_click_date": "string",
    "properties.hs_email_last_email_name": "string",
    "properties.hs_email_last_open_date": "string",
    "properties.hs_email_last_send_date": "string",
    "properties.hs_email_open": "string",
    "properties.hs_email_optout": "string",
    "properties.hs_email_optout_4048048": "string",
    "properties.hs_email_optout_4049846": "string",
    "properties.hs_email_optout_4049889": "string",
    "properties.hs_email_quarantined": "string",
    "properties.hs_email_quarantined_reason": "string",
    "properties.hs_email_recipient_fatigue_recovery_time": "string",
    "properties.hs_email_sends_since_last_engagement": "string",
    "properties.hs_emailconfirmationstatus": "string",
    "properties.hs_facebook_ad_clicked": "string",
    "properties.hs_facebook_click_id": "string",
    "properties.hs_facebookid": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_outreach_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_latest_sequence_ended_date": "string",
    "properties.hs_latest_sequence_enrolled": "string",
    "properties.hs_latest_sequence_enrolled_date": "string",
    "properties.hs_latest_sequence_finished_date": "string",
    "properties.hs_latest_sequence_unenrolled_date": "string",
    "properties.hs_latest_source": "string",
    "properties.hs_latest_source_data_1": "string",
    "properties.hs_latest_source_data_2": "string",
    "properties.hs_latest_source_timestamp": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_legal_basis": "string",
    "properties.hs_lifecyclestage_customer_date": "string",
    "properties.hs_lifecyclestage_evangelist_date": "string",
    "properties.hs_lifecyclestage_lead_date": "string",
    "properties.hs_lifecyclestage_marketingqualifiedlead_date": "string",
    "properties.hs_lifecyclestage_opportunity_date": "string",
    "properties.hs_lifecyclestage_other_date": "string",
    "properties.hs_lifecyclestage_salesqualifiedlead_date": "string",
    "properties.hs_lifecyclestage_subscriber_date": "string",
    "properties.hs_marketable_reason_id": "string",
    "properties.hs_marketable_reason_type": "string",
    "properties.hs_marketable_status": "string",
    "properties.hs_marketable_until_renewal": "string",
    "properties.hs_membership_has_accessed_private_content": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_tmp": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_predictivescoringtier_tmp": "string",
    "properties.hs_prospecting_agent_actively_enrolled_count": "string",
    "properties.hs_quarantined_emails": "string",
    "properties.hs_registered_member": "string",
    "properties.hs_sa_first_engagement_date": "string",
    "properties.hs_sa_first_engagement_descr": "string",
    "properties.hs_sa_first_engagement_object_type": "string",
    "properties.hs_sales_email_last_clicked": "string",
    "properties.hs_sales_email_last_opened": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_searchable_calculated_mobile_number": "string",
    "properties.hs_searchable_calculated_phone_number": "string",
    "properties.hs_sequences_actively_enrolled_count": "string",
    "properties.hs_sequences_enrolled_count": "string",
    "properties.hs_sequences_is_enrolled": "string",
    "properties.hs_social_facebook_clicks": "string",
    "properties.hs_social_google_plus_clicks": "string",
    "properties.hs_social_last_engagement": "string",
    "properties.hs_social_linkedin_clicks": "string",
    "properties.hs_social_num_broadcast_clicks": "string",
    "properties.hs_social_twitter_clicks": "string",
    "properties.hs_state_code": "string",
    "properties.hs_time_between_contact_creation_and_deal_close": "string",
    "properties.hs_time_between_contact_creation_and_deal_creation": "string",
    "properties.hs_time_in_customer": "string",
    "properties.hs_time_in_evangelist": "string",
    "properties.hs_time_in_lead": "string",
    "properties.hs_time_in_marketingqualifiedlead": "string",
    "properties.hs_time_in_opportunity": "string",
    "properties.hs_time_in_other": "string",
    "properties.hs_time_in_salesqualifiedlead": "string",
    "properties.hs_time_in_subscriber": "string",
    "properties.hs_time_to_first_engagement": "string",
    "properties.hs_time_to_move_from_lead_to_customer": "string",
    "properties.hs_time_to_move_from_marketingqualifiedlead_to_customer": "string",
    "properties.hs_time_to_move_from_opportunity_to_customer": "string",
    "properties.hs_time_to_move_from_salesqualifiedlead_to_customer": "string",
    "properties.hs_time_to_move_from_subscriber_to_customer": "string",
    "properties.hs_timezone": "string",
    "properties.hs_twitterid": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_notification_followers": "string",
    "properties.hs_user_ids_of_all_notification_unfollowers": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_v2_cumulative_time_in_customer": "string",
    "properties.hs_v2_cumulative_time_in_evangelist": "string",
    "properties.hs_v2_cumulative_time_in_lead": "string",
    "properties.hs_v2_cumulative_time_in_marketingqualifiedlead": "string",
    "properties.hs_v2_cumulative_time_in_opportunity": "string",
    "properties.hs_v2_cumulative_time_in_other": "string",
    "properties.hs_v2_cumulative_time_in_salesqualifiedlead": "string",
    "properties.hs_v2_cumulative_time_in_subscriber": "string",
    "properties.hs_v2_date_entered_customer": "string",
    "properties.hs_v2_date_entered_evangelist": "string",
    "properties.hs_v2_date_entered_lead": "string",
    "properties.hs_v2_date_entered_marketingqualifiedlead": "string",
    "properties.hs_v2_date_entered_opportunity": "string",
    "properties.hs_v2_date_entered_other": "string",
    "properties.hs_v2_date_entered_salesqualifiedlead": "string",
    "properties.hs_v2_date_entered_subscriber": "string",
    "properties.hs_v2_date_exited_customer": "string",
    "properties.hs_v2_date_exited_lead": "string",
    "properties.hs_v2_date_exited_marketingqualifiedlead": "string",
    "properties.hs_v2_date_exited_opportunity": "string",
    "properties.hs_v2_date_exited_salesqualifiedlead": "string",
    "properties.hs_v2_date_exited_subscriber": "string",
    "properties.hs_v2_latest_time_in_customer": "string",
    "properties.hs_v2_latest_time_in_evangelist": "string",
    "properties.hs_v2_latest_time_in_lead": "string",
    "properties.hs_v2_latest_time_in_marketingqualifiedlead": "string",
    "properties.hs_v2_latest_time_in_opportunity": "string",
    "properties.hs_v2_latest_time_in_other": "string",
    "properties.hs_v2_latest_time_in_salesqualifiedlead": "string",
    "properties.hs_v2_latest_time_in_subscriber": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.ip_city": "string",
    "properties.ip_country": "string",
    "properties.ip_country_code": "string",
    "properties.ip_latlon": "string",
    "properties.ip_state": "string",
    "properties.ip_state_code": "string",
    "properties.ip_zipcode": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "string",
    "properties.last_login_date": "string",
    "properties.lastmodifieddate": "string",
    "properties.lastname": "string",
    "properties.leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "string",
    "properties.leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "string",
    "properties.leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a": "string",
    "properties.leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe": "string",
    "properties.leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970": "string",
    "properties.leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4": "string",
    "properties.leadin_phone_optional_324d7459684ca0b489279d4e48644441": "string",
    "properties.leadin_submit_a4d3b161ce1309df1c4e25df28694b7b": "string",
    "properties.leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedinbio": "string",
    "properties.linkedinconnections": "string",
    "properties.marina_job_title": "string",
    "properties.marina_name": "string",
    "properties.marina_size_linear_feet_": "string",
    "properties.message": "string",
    "properties.mobilephone": "string",
    "properties.must_haves": "string",
    "properties.new_lead_status": "string",
    "properties.nickname": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_notes": "string",
    "properties.num_unique_conversion_events": "string",
    "properties.number_of_slips": "string",
    "properties.other_vendor": "string",
    "properties.phone": "string",
    "properties.photo": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.salesforce_contacts_id": "string",
    "properties.salutation": "string",
    "properties.send_me_updates": "string",
    "properties.services": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.state": "string",
    "properties.stellar_invalid_email_address": "string",
    "properties.supplemental_email": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.utm_campaign": "string",
    "properties.utm_content": "string",
    "properties.utm_medium": "string",
    "properties.utm_source": "string",
    "properties.utm_term": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`city`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`:STRING,`form_submission_date`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_contact_vids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_average_page_views`:STRING,`hs_analytics_first_referrer`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_url`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_referrer`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_url`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_num_event_completions`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_revenue`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_calculated_form_submissions`:STRING,`hs_calculated_phone_number`:STRING,`hs_calculated_phone_number_country_code`:STRING,`hs_count_is_unworked`:STRING,`hs_count_is_worked`:STRING,`hs_country_region_code`:STRING,`hs_date_entered_lead`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_lead`:STRING,`hs_email_delivered`:STRING,`hs_email_domain`:STRING,`hs_email_first_send_date`:STRING,`hs_email_last_email_name`:STRING,`hs_email_last_send_date`:STRING,`hs_email_optout`:STRING,`hs_email_optout_4049846`:STRING,`hs_email_optout_4049889`:STRING,`hs_email_sends_since_last_engagement`:STRING,`hs_ip_timezone`:STRING,`hs_is_contact`:STRING,`hs_is_unworked`:STRING,`hs_latest_source`:STRING,`hs_latest_source_data_1`:STRING,`hs_latest_source_data_2`:STRING,`hs_latest_source_timestamp`:STRING,`hs_lifecyclestage_lead_date`:STRING,`hs_lifecyclestage_opportunity_date`:STRING,`hs_marketable_reason_id`:STRING,`hs_marketable_reason_type`:STRING,`hs_marketable_status`:STRING,`hs_marketable_until_renewal`:STRING,`hs_object_id`:STRING,`hs_pipeline`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_predictivescoringtier`:STRING,`hs_registered_member`:STRING,`hs_searchable_calculated_phone_number`:STRING,`hs_social_facebook_clicks`:STRING,`hs_social_google_plus_clicks`:STRING,`hs_social_last_engagement`:STRING,`hs_social_linkedin_clicks`:STRING,`hs_social_num_broadcast_clicks`:STRING,`hs_social_twitter_clicks`:STRING,`hs_state_code`:STRING,`hs_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_updated_by_user_id`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_v2_cumulative_time_in_lead`:STRING,`hs_v2_date_entered_lead`:STRING,`hs_v2_date_entered_opportunity`:STRING,`hs_v2_date_exited_lead`:STRING,`hs_v2_latest_time_in_lead`:STRING,`hs_was_imported`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`ip_city`:STRING,`ip_country`:STRING,`ip_country_code`:STRING,`ip_latlon`:STRING,`ip_state`:STRING,`ip_state_code`:STRING,`ip_zipcode`:STRING,`last_login_date`:STRING,`lastmodifieddate`:STRING,`lastname`:STRING,`lifecyclestage`:STRING,`new_lead_status`:STRING,`num_conversion_events`:STRING,`num_unique_conversion_events`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`salesforce_contacts_id`:STRING,`state`:STRING,`hs_associated_target_accounts`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_first_engagement_object_id`:STRING,`hs_first_outreach_date`:STRING,`hs_notes_last_activity`:STRING,`hs_sa_first_engagement_date`:STRING,`hs_sa_first_engagement_descr`:STRING,`hs_sa_first_engagement_object_type`:STRING,`hs_time_to_first_engagement`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`photo`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`address`:STRING,`current_software`:STRING,`current_vendor_new`:STRING,`engagements_last_meeting_booked`:STRING,`hs_sales_email_last_opened`:STRING,`hs_sales_email_last_replied`:STRING,`notes_next_activity_date`:STRING,`other_vendor`:STRING,`zip`:STRING,`hs_email_first_open_date`:STRING,`hs_email_last_open_date`:STRING,`hs_email_open`:STRING,`leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e`:STRING,`first_deal_created_date`:STRING,`how_heard_about_us`:STRING,`hs_calculated_mobile_number`:STRING,`hs_email_bounce`:STRING,`hs_email_hard_bounce_reason_enum`:STRING,`hs_searchable_calculated_mobile_number`:STRING,`mobilephone`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`total_revenue`:STRING,`hs_email_quarantined`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`leadin_phone_optional_324d7459684ca0b489279d4e48644441`:STRING,`days_to_close`:STRING,`hs_additional_emails`:STRING,`hs_calculated_merged_vids`:STRING,`hs_created_by_user_id`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_merged_object_ids`:STRING,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_object_source`:STRING,`hs_object_source_id`:STRING,`hs_object_source_label`:STRING,`hs_object_source_user_id`:STRING,`hs_sales_email_last_clicked`:STRING,`hs_sequences_actively_enrolled_count`:STRING,`hs_sequences_is_enrolled`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`hs_v2_cumulative_time_in_opportunity`:STRING,`jobtitle`:STRING,`must_haves`:STRING,`followercount`:STRING,`hs_twitterid`:STRING,`twitterbio`:STRING,`twitterhandle`:STRING,`hs_facebookid`:STRING,`hs_email_bad_address`:STRING,`hs_latest_sequence_ended_date`:STRING,`hs_latest_sequence_enrolled`:STRING,`hs_latest_sequence_enrolled_date`:STRING,`hs_latest_sequence_finished_date`:STRING,`hs_sequences_enrolled_count`:STRING,`leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970`:STRING,`leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a`:STRING,`closedate`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_in_customer`:STRING,`hs_v2_date_entered_customer`:STRING,`hs_v2_date_exited_opportunity`:STRING,`hs_v2_latest_time_in_opportunity`:STRING,`base_tags`:STRING,`website`:STRING,`fax`:STRING,`trade_show`:STRING,`hs_last_sales_activity_type`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`hs_v2_cumulative_time_in_subscriber`:STRING,`hs_v2_date_entered_subscriber`:STRING,`hs_v2_date_exited_subscriber`:STRING,`hs_v2_latest_time_in_subscriber`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_v2_date_entered_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`hs_v2_cumulative_time_in_salesqualifiedlead`:STRING,`hs_v2_date_exited_salesqualifiedlead`:STRING,`hs_v2_latest_time_in_salesqualifiedlead`:STRING,`hs_currently_enrolled_in_prospecting_agent`:STRING,`hs_membership_has_accessed_private_content`:STRING,`hs_prospecting_agent_actively_enrolled_count`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_google_click_id`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_v2_cumulative_time_in_marketingqualifiedlead`:STRING,`hs_v2_date_entered_marketingqualifiedlead`:STRING,`hs_v2_date_exited_marketingqualifiedlead`:STRING,`hs_v2_latest_time_in_marketingqualifiedlead`:STRING,`associated_show_event`:STRING,`inactive`:STRING,`skype_username`:STRING,`hs_time_to_move_from_marketingqualifiedlead_to_customer`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`hs_quarantined_emails`:STRING,`hs_v2_cumulative_time_in_customer`:STRING,`hs_object_source_detail_1`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`hs_legal_basis`:STRING,`marina_job_title`:STRING,`marina_name`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`hs_v2_date_entered_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_v2_date_exited_customer`:STRING,`hs_v2_latest_time_in_customer`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`hs_v2_date_entered_evangelist`:STRING,`do_not_sync_to_sfdc`:STRING,`hs_facebook_ad_clicked`:STRING,`nickname`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`how_many_boats_do_you_manage_`:STRING,`message`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`actively_working_lead`:STRING,`hs_facebook_click_id`:STRING,`work_email`:STRING,`stellar_invalid_email_address`:STRING,`send_me_updates`:STRING,`utm_campaign`:STRING,`utm_content`:STRING,`utm_medium`:STRING,`utm_source`:STRING,`utm_term`:STRING,`services`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contacts/2024-12-15/1734268634'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contacts"
]

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "true",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "NY Boat Show 2014",
        "associatedcompanyid": "5749919313",
        "associatedcompanylastupdated": "1109426470201051",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Erwin Marine Sales",
        "country": "united states",
        "createdate": "2017-02-07T14:08:17.112Z",
        "current_software": "Fareharbor",
        "current_vendor_new": "Fareharbor;Other",
        "currentlyinworkflow": "false",
        "days_to_close": "",
        "direct_phone_number": "(972) 771-8865",
        "do_not_sync_to_sfdc": "true",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "engagements_last_meeting_booked_campaign": "capterra-general-link",
        "engagements_last_meeting_booked_medium": "email",
        "engagements_last_meeting_booked_source": "capterra",
        "fax": "(315) 482-5434",
        "first_conversion_date": "2017-02-07T14:08:17.112Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_deal_created_date": "2019-02-13T21:40:32.145Z",
        "firstname": "Marc",
        "followercount": "17",
        "form_submission_date": "2024-09-17",
        "how_heard_about_us": "Capterra",
        "how_many_boats_do_you_manage_": "10",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_assigned_business_unit_ids": "0",
        "hs_all_contact_vids": "154701;4360951",
        "hs_all_owner_ids": "378624067",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "1",
        "hs_analytics_first_referrer": "",
        "hs_analytics_first_timestamp": "2017-01-27T19:51:37.330Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-27T19:51:37.330Z",
        "hs_analytics_last_referrer": "https://www.google.com/",
        "hs_analytics_last_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/",
        "hs_analytics_last_visit_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "5",
        "hs_analytics_num_visits": "5",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "DIRECT_TRAFFIC",
        "hs_analytics_source_data_1": "getmolo.com/",
        "hs_analytics_source_data_2": "",
        "hs_associated_target_accounts": "0",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1486476497112",
        "hs_calculated_merged_vids": "4360951:1712157436659",
        "hs_calculated_mobile_number": "+14232876026",
        "hs_calculated_phone_number": "+14236221978",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_country_region_code": "us",
        "hs_created_by_user_id": "60918476",
        "hs_currently_enrolled_in_prospecting_agent": "false",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2024-01-17T17:33:04.536Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2024-01-17T17:33:12.962Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2017-06-26T15:25:16.056Z",
        "hs_date_exited_lead": "2024-01-17T17:33:12.962Z",
        "hs_date_exited_marketingqualifiedlead": "2019-05-21T21:13:23.080Z",
        "hs_date_exited_opportunity": "2017-11-02T15:58:17.778Z",
        "hs_date_exited_salesqualifiedlead": "2022-03-24T19:45:06.188Z",
        "hs_date_exited_subscriber": "2017-06-26T15:25:16.057Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "17",
        "hs_email_domain": "erwinmarinesales.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T22:08:11.344Z",
        "hs_email_first_send_date": "2021-06-22T19:00:06.786Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Molo- DO MORE - 11",
        "hs_email_last_open_date": "2023-04-13T17:59:09.437Z",
        "hs_email_last_send_date": "2023-04-13T17:35:30.651Z",
        "hs_email_open": "11",
        "hs_email_optout": "true",
        "hs_email_optout_4048048": "true",
        "hs_email_optout_4049846": "true",
        "hs_email_optout_4049889": "true",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "0",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebook_click_id": "IwAR3IJOBN3hiZtmkix6spTUkm62myrO-uraEPg76pll3eoSXyu1TP0DVPia8",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "56729670948",
        "hs_first_outreach_date": "2019-02-21T19:04:14.681Z",
        "hs_google_click_id": "CjwKCAjw1MajBhAcEiwAagW9MWZgEK41bOr0umJqRfoSWyvoCHC6XNhCRXCOwTX-2eVUFQhJxIFXgBoC1n8QAvD_BwE",
        "hs_ip_timezone": "america_slash_chicago",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-20T03:15:25.227Z",
        "hs_last_sales_activity_timestamp": "2022-05-23T17:00:27.882Z",
        "hs_last_sales_activity_type": "EMAIL_REPLY",
        "hs_latest_meeting_activity": "2021-08-27T20:00:00Z",
        "hs_latest_sequence_ended_date": "2021-08-19T13:51:35.032Z",
        "hs_latest_sequence_enrolled": "37318635",
        "hs_latest_sequence_enrolled_date": "2021-08-03T15:00:08.771Z",
        "hs_latest_sequence_finished_date": "2021-08-19T13:51:35.032Z",
        "hs_latest_sequence_unenrolled_date": "2021-10-15T20:24:34.667Z",
        "hs_latest_source": "DIRECT_TRAFFIC",
        "hs_latest_source_data_1": "getmolo.com/",
        "hs_latest_source_data_2": "",
        "hs_latest_source_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Legitimate interest \u2013 prospect/lead",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2024-01-17T17:33:04.536Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2024-01-17T17:33:12.962Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2017-06-26T15:25:16.056Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_membership_has_accessed_private_content": "0",
        "hs_merged_object_ids": "4360951",
        "hs_notes_last_activity": "0-48-56966494099",
        "hs_notes_next_activity": "",
        "hs_notes_next_activity_type": "",
        "hs_object_id": "154701",
        "hs_object_source": "CRM_UI",
        "hs_object_source_detail_1": "",
        "hs_object_source_detail_2": "",
        "hs_object_source_detail_3": "",
        "hs_object_source_id": "userId:60918476",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "60918476",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_3",
        "hs_prospecting_agent_actively_enrolled_count": "0",
        "hs_quarantined_emails": "[email protected] - HubSpot\nReason: Undeliverable Address",
        "hs_registered_member": "0",
        "hs_sa_first_engagement_date": "",
        "hs_sa_first_engagement_descr": "",
        "hs_sa_first_engagement_object_type": "",
        "hs_sales_email_last_clicked": "2022-05-23T15:12:34.315Z",
        "hs_sales_email_last_opened": "2020-03-18T15:04:58.409Z",
        "hs_sales_email_last_replied": "",
        "hs_searchable_calculated_mobile_number": "2817403174",
        "hs_searchable_calculated_phone_number": "2504685364",
        "hs_sequences_actively_enrolled_count": "0",
        "hs_sequences_enrolled_count": "1",
        "hs_sequences_is_enrolled": "",
        "hs_social_facebook_clicks": "0",
        "hs_social_google_plus_clicks": "0",
        "hs_social_last_engagement": "",
        "hs_social_linkedin_clicks": "0",
        "hs_social_num_broadcast_clicks": "0",
        "hs_social_twitter_clicks": "0",
        "hs_state_code": "bc",
        "hs_time_between_contact_creation_and_deal_close": "",
        "hs_time_between_contact_creation_and_deal_creation": "63617535033",
        "hs_time_in_customer": "224629538206",
        "hs_time_in_evangelist": "213055498187",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "235776645565",
        "hs_time_in_other": "214585237811",
        "hs_time_in_salesqualifiedlead": "224792027066",
        "hs_time_in_subscriber": "1",
        "hs_time_to_first_engagement": "",
        "hs_time_to_move_from_lead_to_customer": "",
        "hs_time_to_move_from_marketingqualifiedlead_to_customer": "",
        "hs_time_to_move_from_opportunity_to_customer": "",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "",
        "hs_time_to_move_from_subscriber_to_customer": "",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "68170421",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "44200137",
        "hs_v2_cumulative_time_in_customer": "11915836662",
        "hs_v2_cumulative_time_in_lead": "13031429927",
        "hs_v2_cumulative_time_in_marketingqualifiedlead": "41056978272",
        "hs_v2_cumulative_time_in_opportunity": "207021593420",
        "hs_v2_cumulative_time_in_salesqualifiedlead": "139012859744",
        "hs_v2_cumulative_time_in_subscriber": "1",
        "hs_v2_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_v2_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_v2_date_entered_lead": "2017-01-26T19:42:40.513Z",
        "hs_v2_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_v2_date_entered_opportunity": "2017-06-26T15:33:10.440Z",
        "hs_v2_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_v2_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_v2_date_entered_subscriber": "2017-06-26T15:25:16.056Z",
        "hs_v2_date_exited_customer": "2018-03-07T15:43:55.128Z",
        "hs_v2_date_exited_lead": "2017-06-26T15:33:10.440Z",
        "hs_v2_date_exited_marketingqualifiedlead": "2019-05-21T21:13:23.080Z",
        "hs_v2_date_exited_opportunity": "2017-11-02T15:58:17.778Z",
        "hs_v2_date_exited_salesqualifiedlead": "2022-03-24T19:45:06.188Z",
        "hs_v2_date_exited_subscriber": "2017-06-26T15:25:16.057Z",
        "hs_v2_latest_time_in_customer": "1902328509",
        "hs_v2_latest_time_in_lead": "13031429927",
        "hs_v2_latest_time_in_marketingqualifiedlead": "41056978272",
        "hs_v2_latest_time_in_opportunity": "11147105882",
        "hs_v2_latest_time_in_salesqualifiedlead": "139012859744",
        "hs_v2_latest_time_in_subscriber": "1",
        "hs_was_imported": "true",
        "hubspot_owner_assigneddate": "2024-07-10T13:20:24.054Z",
        "hubspot_owner_id": "162039666",
        "hubspot_team_id": "",
        "inactive": "true",
        "industry": "Pedestals, Marina Electricity",
        "ip_city": "",
        "ip_country": "canada",
        "ip_country_code": "ca",
        "ip_latlon": "",
        "ip_state": "british columbia",
        "ip_state_code": "bc",
        "ip_zipcode": "",
        "jobtitle": "GM",
        "kloutscoregeneral": "13",
        "last_login_date": "2024-09-17",
        "lastmodifieddate": "2024-12-11T21:07:27.188Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a": "Khalid Elbashir",
        "leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe": "Nitin",
        "leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970": "Amanda",
        "leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4": "looking for anymore information and possibly a demo    thanks Glenn.",
        "leadin_phone_optional_324d7459684ca0b489279d4e48644441": "Name",
        "leadin_submit_a4d3b161ce1309df1c4e25df28694b7b": "I have a meeting with our Finance Director this morning. I would like to try to schedule a conference call for any questions so we can try to make a decision to move forward with MOLO",
        "leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a": "Amanda",
        "lifecyclestage": "opportunity",
        "linkedinbio": "",
        "linkedinconnections": "0",
        "marina_job_title": "Other Marina Staff",
        "marina_name": "Sunnyside Marina",
        "marina_size_linear_feet_": "12100",
        "message": "https://swingingbridgemarina.com/",
        "mobilephone": "(281) 740-3174",
        "must_haves": "Brokerage/Sales",
        "new_lead_status": "Prospect",
        "nickname": "",
        "notes_last_contacted": "2022-10-03T18:58:17.273Z",
        "notes_last_updated": "2022-10-03T18:58:17.273Z",
        "notes_next_activity_date": "",
        "num_associated_deals": "",
        "num_contacted_notes": "2",
        "num_conversion_events": "1",
        "num_notes": "2",
        "num_unique_conversion_events": "1",
        "number_of_slips": "250",
        "other_vendor": "",
        "phone": "(310) 305-9503",
        "photo": "https://d2ojpxxtu63wzl.cloudfront.net/static/9e55d7e95d716ad09a098ab2e007be6f_58b0f0526ccd73c7f03ca54a4a1ba0b5f72ebedb33077d36afe5e5117bc5c720",
        "recent_conversion_date": "2016-12-15T17:56:53.529Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: #subForm .registration-form",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "salesforce_contacts_id": "003PJ00000AliniYAB",
        "salutation": "Mr.",
        "send_me_updates": "true",
        "services": "Molo + Stellar",
        "services_offered": "Slips",
        "skype_username": "sergio.peterlin",
        "state": "california",
        "stellar_invalid_email_address": "false",
        "supplemental_email": "[email protected]",
        "total_revenue": "",
        "trade_show": "AMI",
        "twitterbio": "Premier marine paradise. Summer dockage, heated winter storage, largest accessory store, fuel, full service, boat sales.",
        "twitterhandle": "HORIZONMARINA",
        "twitterprofilephoto": "",
        "utm_campaign": "BFO | StellarIMS | Leads",
        "utm_content": "Stellar Boat Rental Management",
        "utm_medium": "paid_social",
        "utm_source": "ig",
        "utm_term": "120212710771870337",
        "website": "http://www.americanwharf.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2024-12-11T21:06:11.887Z"
}

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.base_tags": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.days_to_close": "string",
    "properties.direct_phone_number": "string",
    "properties.do_not_sync_to_sfdc": "string",
    "properties.email": "string",
    "properties.engagements_last_meeting_booked": "string",
    "properties.engagements_last_meeting_booked_campaign": "string",
    "properties.engagements_last_meeting_booked_medium": "string",
    "properties.engagements_last_meeting_booked_source": "string",
    "properties.fax": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_deal_created_date": "string",
    "properties.firstname": "string",
    "properties.followercount": "string",
    "properties.form_submission_date": "string",
    "properties.how_heard_about_us": "string",
    "properties.how_many_boats_do_you_manage_": "string",
    "properties.hs_additional_emails": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_contact_vids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_average_page_views": "string",
    "properties.hs_analytics_first_referrer": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_url": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_last_referrer": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_url": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_num_event_completions": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_revenue": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_associated_target_accounts": "string",
    "properties.hs_calculated_form_submissions": "string",
    "properties.hs_calculated_merged_vids": "string",
    "properties.hs_calculated_mobile_number": "string",
    "properties.hs_calculated_phone_number": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_country_region_code": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_currently_enrolled_in_prospecting_agent": "string",
    "properties.hs_date_entered_customer": "string",
    "properties.hs_date_entered_evangelist": "string",
    "properties.hs_date_entered_lead": "string",
    "properties.hs_date_entered_marketingqualifiedlead": "string",
    "properties.hs_date_entered_opportunity": "string",
    "properties.hs_date_entered_other": "string",
    "properties.hs_date_entered_salesqualifiedlead": "string",
    "properties.hs_date_entered_subscriber": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_delivered": "string",
    "properties.hs_email_domain": "string",
    "properties.hs_email_first_click_date": "string",
    "properties.hs_email_first_open_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_last_click_date": "string",
    "properties.hs_email_last_email_name": "string",
    "properties.hs_email_last_open_date": "string",
    "properties.hs_email_last_send_date": "string",
    "properties.hs_email_open": "string",
    "properties.hs_email_optout": "string",
    "properties.hs_email_optout_4048048": "string",
    "properties.hs_email_optout_4049846": "string",
    "properties.hs_email_optout_4049889": "string",
    "properties.hs_email_quarantined": "string",
    "properties.hs_email_quarantined_reason": "string",
    "properties.hs_email_recipient_fatigue_recovery_time": "string",
    "properties.hs_email_sends_since_last_engagement": "string",
    "properties.hs_emailconfirmationstatus": "string",
    "properties.hs_facebook_ad_clicked": "string",
    "properties.hs_facebook_click_id": "string",
    "properties.hs_facebookid": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_outreach_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_latest_sequence_ended_date": "string",
    "properties.hs_latest_sequence_enrolled": "string",
    "properties.hs_latest_sequence_enrolled_date": "string",
    "properties.hs_latest_sequence_finished_date": "string",
    "properties.hs_latest_sequence_unenrolled_date": "string",
    "properties.hs_latest_source": "string",
    "properties.hs_latest_source_data_1": "string",
    "properties.hs_latest_source_data_2": "string",
    "properties.hs_latest_source_timestamp": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_legal_basis": "string",
    "properties.hs_lifecyclestage_customer_date": "string",
    "properties.hs_lifecyclestage_evangelist_date": "string",
    "properties.hs_lifecyclestage_lead_date": "string",
    "properties.hs_lifecyclestage_marketingqualifiedlead_date": "string",
    "properties.hs_lifecyclestage_opportunity_date": "string",
    "properties.hs_lifecyclestage_other_date": "string",
    "properties.hs_lifecyclestage_salesqualifiedlead_date": "string",
    "properties.hs_lifecyclestage_subscriber_date": "string",
    "properties.hs_marketable_reason_id": "string",
    "properties.hs_marketable_reason_type": "string",
    "properties.hs_marketable_status": "string",
    "properties.hs_marketable_until_renewal": "string",
    "properties.hs_membership_has_accessed_private_content": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_tmp": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_predictivescoringtier_tmp": "string",
    "properties.hs_prospecting_agent_actively_enrolled_count": "string",
    "properties.hs_quarantined_emails": "string",
    "properties.hs_registered_member": "string",
    "properties.hs_sa_first_engagement_date": "string",
    "properties.hs_sa_first_engagement_descr": "string",
    "properties.hs_sa_first_engagement_object_type": "string",
    "properties.hs_sales_email_last_clicked": "string",
    "properties.hs_sales_email_last_opened": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_searchable_calculated_mobile_number": "string",
    "properties.hs_searchable_calculated_phone_number": "string",
    "properties.hs_sequences_actively_enrolled_count": "string",
    "properties.hs_sequences_enrolled_count": "string",
    "properties.hs_sequences_is_enrolled": "string",
    "properties.hs_social_facebook_clicks": "string",
    "properties.hs_social_google_plus_clicks": "string",
    "properties.hs_social_last_engagement": "string",
    "properties.hs_social_linkedin_clicks": "string",
    "properties.hs_social_num_broadcast_clicks": "string",
    "properties.hs_social_twitter_clicks": "string",
    "properties.hs_state_code": "string",
    "properties.hs_time_between_contact_creation_and_deal_close": "string",
    "properties.hs_time_between_contact_creation_and_deal_creation": "string",
    "properties.hs_time_in_customer": "string",
    "properties.hs_time_in_evangelist": "string",
    "properties.hs_time_in_lead": "string",
    "properties.hs_time_in_marketingqualifiedlead": "string",
    "properties.hs_time_in_opportunity": "string",
    "properties.hs_time_in_other": "string",
    "properties.hs_time_in_salesqualifiedlead": "string",
    "properties.hs_time_in_subscriber": "string",
    "properties.hs_time_to_first_engagement": "string",
    "properties.hs_time_to_move_from_lead_to_customer": "string",
    "properties.hs_time_to_move_from_marketingqualifiedlead_to_customer": "string",
    "properties.hs_time_to_move_from_opportunity_to_customer": "string",
    "properties.hs_time_to_move_from_salesqualifiedlead_to_customer": "string",
    "properties.hs_time_to_move_from_subscriber_to_customer": "string",
    "properties.hs_timezone": "string",
    "properties.hs_twitterid": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_notification_followers": "string",
    "properties.hs_user_ids_of_all_notification_unfollowers": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_v2_cumulative_time_in_customer": "string",
    "properties.hs_v2_cumulative_time_in_evangelist": "string",
    "properties.hs_v2_cumulative_time_in_lead": "string",
    "properties.hs_v2_cumulative_time_in_marketingqualifiedlead": "string",
    "properties.hs_v2_cumulative_time_in_opportunity": "string",
    "properties.hs_v2_cumulative_time_in_other": "string",
    "properties.hs_v2_cumulative_time_in_salesqualifiedlead": "string",
    "properties.hs_v2_cumulative_time_in_subscriber": "string",
    "properties.hs_v2_date_entered_customer": "string",
    "properties.hs_v2_date_entered_evangelist": "string",
    "properties.hs_v2_date_entered_lead": "string",
    "properties.hs_v2_date_entered_marketingqualifiedlead": "string",
    "properties.hs_v2_date_entered_opportunity": "string",
    "properties.hs_v2_date_entered_other": "string",
    "properties.hs_v2_date_entered_salesqualifiedlead": "string",
    "properties.hs_v2_date_entered_subscriber": "string",
    "properties.hs_v2_date_exited_customer": "string",
    "properties.hs_v2_date_exited_lead": "string",
    "properties.hs_v2_date_exited_marketingqualifiedlead": "string",
    "properties.hs_v2_date_exited_opportunity": "string",
    "properties.hs_v2_date_exited_salesqualifiedlead": "string",
    "properties.hs_v2_date_exited_subscriber": "string",
    "properties.hs_v2_latest_time_in_customer": "string",
    "properties.hs_v2_latest_time_in_evangelist": "string",
    "properties.hs_v2_latest_time_in_lead": "string",
    "properties.hs_v2_latest_time_in_marketingqualifiedlead": "string",
    "properties.hs_v2_latest_time_in_opportunity": "string",
    "properties.hs_v2_latest_time_in_other": "string",
    "properties.hs_v2_latest_time_in_salesqualifiedlead": "string",
    "properties.hs_v2_latest_time_in_subscriber": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.ip_city": "string",
    "properties.ip_country": "string",
    "properties.ip_country_code": "string",
    "properties.ip_latlon": "string",
    "properties.ip_state": "string",
    "properties.ip_state_code": "string",
    "properties.ip_zipcode": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "string",
    "properties.last_login_date": "string",
    "properties.lastmodifieddate": "string",
    "properties.lastname": "string",
    "properties.leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "string",
    "properties.leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "string",
    "properties.leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a": "string",
    "properties.leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe": "string",
    "properties.leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970": "string",
    "properties.leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4": "string",
    "properties.leadin_phone_optional_324d7459684ca0b489279d4e48644441": "string",
    "properties.leadin_submit_a4d3b161ce1309df1c4e25df28694b7b": "string",
    "properties.leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedinbio": "string",
    "properties.linkedinconnections": "string",
    "properties.marina_job_title": "string",
    "properties.marina_name": "string",
    "properties.marina_size_linear_feet_": "string",
    "properties.message": "string",
    "properties.mobilephone": "string",
    "properties.must_haves": "string",
    "properties.new_lead_status": "string",
    "properties.nickname": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_notes": "string",
    "properties.num_unique_conversion_events": "string",
    "properties.number_of_slips": "string",
    "properties.other_vendor": "string",
    "properties.phone": "string",
    "properties.photo": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.salesforce_contacts_id": "string",
    "properties.salutation": "string",
    "properties.send_me_updates": "string",
    "properties.services": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.state": "string",
    "properties.stellar_invalid_email_address": "string",
    "properties.supplemental_email": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.utm_campaign": "string",
    "properties.utm_content": "string",
    "properties.utm_medium": "string",
    "properties.utm_source": "string",
    "properties.utm_term": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`city`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`:STRING,`form_submission_date`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_contact_vids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_average_page_views`:STRING,`hs_analytics_first_referrer`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_url`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_referrer`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_url`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_num_event_completions`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_revenue`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_calculated_form_submissions`:STRING,`hs_calculated_phone_number`:STRING,`hs_calculated_phone_number_country_code`:STRING,`hs_count_is_unworked`:STRING,`hs_count_is_worked`:STRING,`hs_country_region_code`:STRING,`hs_date_entered_lead`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_lead`:STRING,`hs_email_delivered`:STRING,`hs_email_domain`:STRING,`hs_email_first_send_date`:STRING,`hs_email_last_email_name`:STRING,`hs_email_last_send_date`:STRING,`hs_email_optout`:STRING,`hs_email_optout_4049846`:STRING,`hs_email_optout_4049889`:STRING,`hs_email_sends_since_last_engagement`:STRING,`hs_ip_timezone`:STRING,`hs_is_contact`:STRING,`hs_is_unworked`:STRING,`hs_latest_source`:STRING,`hs_latest_source_data_1`:STRING,`hs_latest_source_data_2`:STRING,`hs_latest_source_timestamp`:STRING,`hs_lifecyclestage_lead_date`:STRING,`hs_lifecyclestage_opportunity_date`:STRING,`hs_marketable_reason_id`:STRING,`hs_marketable_reason_type`:STRING,`hs_marketable_status`:STRING,`hs_marketable_until_renewal`:STRING,`hs_object_id`:STRING,`hs_pipeline`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_predictivescoringtier`:STRING,`hs_registered_member`:STRING,`hs_searchable_calculated_phone_number`:STRING,`hs_social_facebook_clicks`:STRING,`hs_social_google_plus_clicks`:STRING,`hs_social_last_engagement`:STRING,`hs_social_linkedin_clicks`:STRING,`hs_social_num_broadcast_clicks`:STRING,`hs_social_twitter_clicks`:STRING,`hs_state_code`:STRING,`hs_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_updated_by_user_id`:STRING,`hs_user_ids_of_all_owners`:STRING,`hs_v2_cumulative_time_in_lead`:STRING,`hs_v2_date_entered_lead`:STRING,`hs_v2_date_entered_opportunity`:STRING,`hs_v2_date_exited_lead`:STRING,`hs_v2_latest_time_in_lead`:STRING,`hs_was_imported`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`ip_city`:STRING,`ip_country`:STRING,`ip_country_code`:STRING,`ip_latlon`:STRING,`ip_state`:STRING,`ip_state_code`:STRING,`ip_zipcode`:STRING,`last_login_date`:STRING,`lastmodifieddate`:STRING,`lastname`:STRING,`lifecyclestage`:STRING,`new_lead_status`:STRING,`num_conversion_events`:STRING,`num_unique_conversion_events`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`salesforce_contacts_id`:STRING,`state`:STRING,`hs_associated_target_accounts`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_first_engagement_object_id`:STRING,`hs_first_outreach_date`:STRING,`hs_notes_last_activity`:STRING,`hs_sa_first_engagement_date`:STRING,`hs_sa_first_engagement_descr`:STRING,`hs_sa_first_engagement_object_type`:STRING,`hs_time_to_first_engagement`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`photo`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`address`:STRING,`current_software`:STRING,`current_vendor_new`:STRING,`engagements_last_meeting_booked`:STRING,`hs_sales_email_last_opened`:STRING,`hs_sales_email_last_replied`:STRING,`notes_next_activity_date`:STRING,`other_vendor`:STRING,`zip`:STRING,`hs_email_first_open_date`:STRING,`hs_email_last_open_date`:STRING,`hs_email_open`:STRING,`leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e`:STRING,`first_deal_created_date`:STRING,`how_heard_about_us`:STRING,`hs_calculated_mobile_number`:STRING,`hs_email_bounce`:STRING,`hs_email_hard_bounce_reason_enum`:STRING,`hs_searchable_calculated_mobile_number`:STRING,`mobilephone`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`total_revenue`:STRING,`hs_email_quarantined`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`leadin_phone_optional_324d7459684ca0b489279d4e48644441`:STRING,`days_to_close`:STRING,`hs_additional_emails`:STRING,`hs_calculated_merged_vids`:STRING,`hs_created_by_user_id`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_merged_object_ids`:STRING,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_object_source`:STRING,`hs_object_source_id`:STRING,`hs_object_source_label`:STRING,`hs_object_source_user_id`:STRING,`hs_sales_email_last_clicked`:STRING,`hs_sequences_actively_enrolled_count`:STRING,`hs_sequences_is_enrolled`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`hs_v2_cumulative_time_in_opportunity`:STRING,`jobtitle`:STRING,`must_haves`:STRING,`followercount`:STRING,`hs_twitterid`:STRING,`twitterbio`:STRING,`twitterhandle`:STRING,`hs_facebookid`:STRING,`hs_email_bad_address`:STRING,`hs_latest_sequence_ended_date`:STRING,`hs_latest_sequence_enrolled`:STRING,`hs_latest_sequence_enrolled_date`:STRING,`hs_latest_sequence_finished_date`:STRING,`hs_sequences_enrolled_count`:STRING,`leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970`:STRING,`leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a`:STRING,`closedate`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_in_customer`:STRING,`hs_v2_date_entered_customer`:STRING,`hs_v2_date_exited_opportunity`:STRING,`hs_v2_latest_time_in_opportunity`:STRING,`base_tags`:STRING,`website`:STRING,`fax`:STRING,`trade_show`:STRING,`hs_last_sales_activity_type`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`hs_v2_cumulative_time_in_subscriber`:STRING,`hs_v2_date_entered_subscriber`:STRING,`hs_v2_date_exited_subscriber`:STRING,`hs_v2_latest_time_in_subscriber`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_v2_date_entered_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`hs_v2_cumulative_time_in_salesqualifiedlead`:STRING,`hs_v2_date_exited_salesqualifiedlead`:STRING,`hs_v2_latest_time_in_salesqualifiedlead`:STRING,`hs_currently_enrolled_in_prospecting_agent`:STRING,`hs_membership_has_accessed_private_content`:STRING,`hs_prospecting_agent_actively_enrolled_count`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_google_click_id`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_v2_cumulative_time_in_marketingqualifiedlead`:STRING,`hs_v2_date_entered_marketingqualifiedlead`:STRING,`hs_v2_date_exited_marketingqualifiedlead`:STRING,`hs_v2_latest_time_in_marketingqualifiedlead`:STRING,`associated_show_event`:STRING,`inactive`:STRING,`skype_username`:STRING,`hs_time_to_move_from_marketingqualifiedlead_to_customer`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`hs_quarantined_emails`:STRING,`hs_v2_cumulative_time_in_customer`:STRING,`hs_object_source_detail_1`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`hs_legal_basis`:STRING,`marina_job_title`:STRING,`marina_name`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`hs_v2_date_entered_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_v2_date_exited_customer`:STRING,`hs_v2_latest_time_in_customer`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`hs_v2_date_entered_evangelist`:STRING,`do_not_sync_to_sfdc`:STRING,`hs_facebook_ad_clicked`:STRING,`nickname`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`how_many_boats_do_you_manage_`:STRING,`message`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`actively_working_lead`:STRING,`hs_facebook_click_id`:STRING,`work_email`:STRING,`stellar_invalid_email_address`:STRING,`send_me_updates`:STRING,`utm_campaign`:STRING,`utm_content`:STRING,`utm_medium`:STRING,`utm_source`:STRING,`utm_term`:STRING,`services`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contacts/2024-12-14/1734182446'\n",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.hubspot_molo_contacts"
]

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "true",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "NY Boat Show 2014",
        "associatedcompanyid": "5749919313",
        "associatedcompanylastupdated": "1109426470201051",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Erwin Marine Sales",
        "country": "united states",
        "createdate": "2017-02-07T14:08:17.112Z",
        "current_software": "Fareharbor",
        "current_vendor_new": "Fareharbor;Other",
        "currentlyinworkflow": "false",
        "days_to_close": "",
        "direct_phone_number": "(972) 771-8865",
        "do_not_sync_to_sfdc": "true",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "engagements_last_meeting_booked_campaign": "capterra-general-link",
        "engagements_last_meeting_booked_medium": "email",
        "engagements_last_meeting_booked_source": "capterra",
        "fax": "(315) 482-5434",
        "first_conversion_date": "2017-02-07T14:08:17.112Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_deal_created_date": "2019-02-13T21:40:32.145Z",
        "firstname": "Marc",
        "followercount": "17",
        "form_submission_date": "2024-09-17",
        "how_heard_about_us": "Capterra",
        "how_many_boats_do_you_manage_": "10",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_assigned_business_unit_ids": "0",
        "hs_all_contact_vids": "154701;4360951",
        "hs_all_owner_ids": "378624067",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "1",
        "hs_analytics_first_referrer": "",
        "hs_analytics_first_timestamp": "2017-01-27T19:51:37.330Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-27T19:51:37.330Z",
        "hs_analytics_last_referrer": "https://www.google.com/",
        "hs_analytics_last_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/",
        "hs_analytics_last_visit_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "5",
        "hs_analytics_num_visits": "5",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "DIRECT_TRAFFIC",
        "hs_analytics_source_data_1": "getmolo.com/",
        "hs_analytics_source_data_2": "",
        "hs_associated_target_accounts": "0",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1486476497112",
        "hs_calculated_merged_vids": "4360951:1712157436659",
        "hs_calculated_mobile_number": "+14232876026",
        "hs_calculated_phone_number": "+14236221978",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_country_region_code": "us",
        "hs_created_by_user_id": "60918476",
        "hs_currently_enrolled_in_prospecting_agent": "false",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2024-01-17T17:33:04.536Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2024-01-17T17:33:12.962Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2017-06-26T15:25:16.056Z",
        "hs_date_exited_lead": "2024-01-17T17:33:12.962Z",
        "hs_date_exited_marketingqualifiedlead": "2019-05-21T21:13:23.080Z",
        "hs_date_exited_opportunity": "2017-11-02T15:58:17.778Z",
        "hs_date_exited_salesqualifiedlead": "2022-03-24T19:45:06.188Z",
        "hs_date_exited_subscriber": "2017-06-26T15:25:16.057Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "17",
        "hs_email_domain": "erwinmarinesales.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T22:08:11.344Z",
        "hs_email_first_send_date": "2021-06-22T19:00:06.786Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Molo- DO MORE - 11",
        "hs_email_last_open_date": "2023-04-13T17:59:09.437Z",
        "hs_email_last_send_date": "2023-04-13T17:35:30.651Z",
        "hs_email_open": "11",
        "hs_email_optout": "true",
        "hs_email_optout_4048048": "true",
        "hs_email_optout_4049846": "true",
        "hs_email_optout_4049889": "true",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "0",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebook_click_id": "IwAR3IJOBN3hiZtmkix6spTUkm62myrO-uraEPg76pll3eoSXyu1TP0DVPia8",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "56729670948",
        "hs_first_outreach_date": "2019-02-21T19:04:14.681Z",
        "hs_google_click_id": "CjwKCAjw1MajBhAcEiwAagW9MWZgEK41bOr0umJqRfoSWyvoCHC6XNhCRXCOwTX-2eVUFQhJxIFXgBoC1n8QAvD_BwE",
        "hs_ip_timezone": "america_slash_chicago",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-20T03:15:25.227Z",
        "hs_last_sales_activity_timestamp": "2022-05-23T17:00:27.882Z",
        "hs_last_sales_activity_type": "EMAIL_REPLY",
        "hs_latest_meeting_activity": "2021-08-27T20:00:00Z",
        "hs_latest_sequence_ended_date": "2021-08-19T13:51:35.032Z",
        "hs_latest_sequence_enrolled": "37318635",
        "hs_latest_sequence_enrolled_date": "2021-08-03T15:00:08.771Z",
        "hs_latest_sequence_finished_date": "2021-08-19T13:51:35.032Z",
        "hs_latest_sequence_unenrolled_date": "2021-10-15T20:24:34.667Z",
        "hs_latest_source": "DIRECT_TRAFFIC",
        "hs_latest_source_data_1": "getmolo.com/",
        "hs_latest_source_data_2": "",
        "hs_latest_source_timestamp": "2017-06-07T16:21:43.814Z",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Legitimate interest \u2013 prospect/lead",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2024-01-17T17:33:04.536Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2024-01-17T17:33:12.962Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2017-06-26T15:25:16.056Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_membership_has_accessed_private_content": "0",
        "hs_merged_object_ids": "4360951",
        "hs_notes_last_activity": "0-48-56966494099",
        "hs_notes_next_activity": "",
        "hs_notes_next_activity_type": "",
        "hs_object_id": "154701",
        "hs_object_source": "CRM_UI",
        "hs_object_source_detail_1": "",
        "hs_object_source_detail_2": "",
        "hs_object_source_detail_3": "",
        "hs_object_source_id": "userId:60918476",
        "hs_object_source_label": "CRM_UI",
        "hs_object_source_user_id": "60918476",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_3",
        "hs_prospecting_agent_actively_enrolled_count": "0",
        "hs_quarantined_emails": "[email protected] - HubSpot\nReason: Undeliverable Address",
        "hs_registered_member": "0",
        "hs_sa_first_engagement_date": "",
        "hs_sa_first_engagement_descr": "",
        "hs_sa_first_engagement_object_type": "",
        "hs_sales_email_last_clicked": "2022-05-23T15:12:34.315Z",
        "hs_sales_email_last_opened": "2020-03-18T15:04:58.409Z",
        "hs_sales_email_last_replied": "",
        "hs_searchable_calculated_mobile_number": "2817403174",
        "hs_searchable_calculated_phone_number": "2504685364",
        "hs_sequences_actively_enrolled_count": "0",
        "hs_sequences_enrolled_count": "1",
        "hs_sequences_is_enrolled": "",
        "hs_social_facebook_clicks": "0",
        "hs_social_google_plus_clicks": "0",
        "hs_social_last_engagement": "",
        "hs_social_linkedin_clicks": "0",
        "hs_social_num_broadcast_clicks": "0",
        "hs_social_twitter_clicks": "0",
        "hs_state_code": "bc",
        "hs_time_between_contact_creation_and_deal_close": "",
        "hs_time_between_contact_creation_and_deal_creation": "63617535033",
        "hs_time_in_customer": "224543890634",
        "hs_time_in_evangelist": "212969850061",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "235690997953",
        "hs_time_in_other": "214499589577",
        "hs_time_in_salesqualifiedlead": "224706379536",
        "hs_time_in_subscriber": "1",
        "hs_time_to_first_engagement": "",
        "hs_time_to_move_from_lead_to_customer": "",
        "hs_time_to_move_from_marketingqualifiedlead_to_customer": "",
        "hs_time_to_move_from_opportunity_to_customer": "",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "",
        "hs_time_to_move_from_subscriber_to_customer": "",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "68170421",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "44200137",
        "hs_v2_cumulative_time_in_customer": "11915836662",
        "hs_v2_cumulative_time_in_lead": "13031429927",
        "hs_v2_cumulative_time_in_marketingqualifiedlead": "41056978272",
        "hs_v2_cumulative_time_in_opportunity": "207021593420",
        "hs_v2_cumulative_time_in_salesqualifiedlead": "139012859744",
        "hs_v2_cumulative_time_in_subscriber": "1",
        "hs_v2_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_v2_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_v2_date_entered_lead": "2017-01-26T19:42:40.513Z",
        "hs_v2_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_v2_date_entered_opportunity": "2017-06-26T15:33:10.440Z",
        "hs_v2_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_v2_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_v2_date_entered_subscriber": "2017-06-26T15:25:16.056Z",
        "hs_v2_date_exited_customer": "2018-03-07T15:43:55.128Z",
        "hs_v2_date_exited_lead": "2017-06-26T15:33:10.440Z",
        "hs_v2_date_exited_marketingqualifiedlead": "2019-05-21T21:13:23.080Z",
        "hs_v2_date_exited_opportunity": "2017-11-02T15:58:17.778Z",
        "hs_v2_date_exited_salesqualifiedlead": "2022-03-24T19:45:06.188Z",
        "hs_v2_date_exited_subscriber": "2017-06-26T15:25:16.057Z",
        "hs_v2_latest_time_in_customer": "1902328509",
        "hs_v2_latest_time_in_lead": "13031429927",
        "hs_v2_latest_time_in_marketingqualifiedlead": "41056978272",
        "hs_v2_latest_time_in_opportunity": "11147105882",
        "hs_v2_latest_time_in_salesqualifiedlead": "139012859744",
        "hs_v2_latest_time_in_subscriber": "1",
        "hs_was_imported": "true",
        "hubspot_owner_assigneddate": "2024-07-10T13:20:24.054Z",
        "hubspot_owner_id": "162039666",
        "hubspot_team_id": "",
        "inactive": "true",
        "industry": "Pedestals, Marina Electricity",
        "ip_city": "",
        "ip_country": "canada",
        "ip_country_code": "ca",
        "ip_latlon": "",
        "ip_state": "british columbia",
        "ip_state_code": "bc",
        "ip_zipcode": "",
        "jobtitle": "GM",
        "kloutscoregeneral": "13",
        "last_login_date": "2024-09-17",
        "lastmodifieddate": "2024-12-11T21:07:27.188Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a": "Khalid Elbashir",
        "leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe": "Nitin",
        "leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970": "Amanda",
        "leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4": "looking for anymore information and possibly a demo    thanks Glenn.",
        "leadin_phone_optional_324d7459684ca0b489279d4e48644441": "Name",
        "leadin_submit_a4d3b161ce1309df1c4e25df28694b7b": "I have a meeting with our Finance Director this morning. I would like to try to schedule a conference call for any questions so we can try to make a decision to move forward with MOLO",
        "leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a": "Amanda",
        "lifecyclestage": "opportunity",
        "linkedinbio": "",
        "linkedinconnections": "0",
        "marina_job_title": "Other Marina Staff",
        "marina_name": "Sunnyside Marina",
        "marina_size_linear_feet_": "12100",
        "message": "https://swingingbridgemarina.com/",
        "mobilephone": "(281) 740-3174",
        "must_haves": "Brokerage/Sales",
        "new_lead_status": "Prospect",
        "nickname": "",
        "notes_last_contacted": "2022-10-03T18:58:17.273Z",
        "notes_last_updated": "2022-10-03T18:58:17.273Z",
        "notes_next_activity_date": "",
        "num_associated_deals": "",
        "num_contacted_notes": "2",
        "num_conversion_events": "1",
        "num_notes": "2",
        "num_unique_conversion_events": "1",
        "number_of_slips": "250",
        "other_vendor": "",
        "phone": "(310) 305-9503",
        "photo": "https://d2ojpxxtu63wzl.cloudfront.net/static/9e55d7e95d716ad09a098ab2e007be6f_58b0f0526ccd73c7f03ca54a4a1ba0b5f72ebedb33077d36afe5e5117bc5c720",
        "recent_conversion_date": "2016-12-15T17:56:53.529Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: #subForm .registration-form",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "salesforce_contacts_id": "003PJ00000AliniYAB",
        "salutation": "Mr.",
        "send_me_updates": "true",
        "services": "Molo + Stellar",
        "services_offered": "Slips",
        "skype_username": "sergio.peterlin",
        "state": "california",
        "stellar_invalid_email_address": "false",
        "supplemental_email": "[email protected]",
        "total_revenue": "",
        "trade_show": "AMI",
        "twitterbio": "Premier marine paradise. Summer dockage, heated winter storage, largest accessory store, fuel, full service, boat sales.",
        "twitterhandle": "HORIZONMARINA",
        "twitterprofilephoto": "",
        "utm_campaign": "BFO | StellarIMS | Leads",
        "utm_content": "Stellar Boat Rental Management",
        "utm_medium": "paid_social",
        "utm_source": "ig",
        "utm_term": "120212710771870337",
        "website": "http://www.americanwharf.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2024-12-11T21:06:11.887Z"
}

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.base_tags": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.days_to_close": "string",
    "properties.direct_phone_number": "string",
    "properties.do_not_sync_to_sfdc": "string",
    "properties.email": "string",
    "properties.engagements_last_meeting_booked": "string",
    "properties.engagements_last_meeting_booked_campaign": "string",
    "properties.engagements_last_meeting_booked_medium": "string",
    "properties.engagements_last_meeting_booked_source": "string",
    "properties.fax": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_deal_created_date": "string",
    "properties.firstname": "string",
    "properties.followercount": "string",
    "properties.form_submission_date": "string",
    "properties.how_heard_about_us": "string",
    "properties.how_many_boats_do_you_manage_": "string",
    "properties.hs_additional_emails": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_contact_vids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_average_page_views": "string",
    "properties.hs_analytics_first_referrer": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_url": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_last_referrer": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_url": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_num_event_completions": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_revenue": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_associated_target_accounts": "string",
    "properties.hs_calculated_form_submissions": "string",
    "properties.hs_calculated_merged_vids": "string",
    "properties.hs_calculated_mobile_number": "string",
    "properties.hs_calculated_phone_number": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_country_region_code": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_currently_enrolled_in_prospecting_agent": "string",
    "properties.hs_date_entered_customer": "string",
    "properties.hs_date_entered_evangelist": "string",
    "properties.hs_date_entered_lead": "string",
    "properties.hs_date_entered_marketingqualifiedlead": "string",
    "properties.hs_date_entered_opportunity": "string",
    "properties.hs_date_entered_other": "string",
    "properties.hs_date_entered_salesqualifiedlead": "string",
    "properties.hs_date_entered_subscriber": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_delivered": "string",
    "properties.hs_email_domain": "string",
    "properties.hs_email_first_click_date": "string",
    "properties.hs_email_first_open_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_last_click_date": "string",
    "properties.hs_email_last_email_name": "string",
    "properties.hs_email_last_open_date": "string",
    "properties.hs_email_last_send_date": "string",
    "properties.hs_email_open": "string",
    "properties.hs_email_optout": "string",
    "properties.hs_email_optout_4048048": "string",
    "properties.hs_email_optout_4049846": "string",
    "properties.hs_email_optout_4049889": "string",
    "properties.hs_email_quarantined": "string",
    "properties.hs_email_quarantined_reason": "string",
    "properties.hs_email_recipient_fatigue_recovery_time": "string",
    "properties.hs_email_sends_since_last_engagement": "string",
    "properties.hs_emailconfirmationstatus": "string",
    "properties.hs_facebook_ad_clicked": "string",
    "properties.hs_facebook_click_id": "string",
    "properties.hs_facebookid": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_outreach_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_latest_sequence_ended_date": "string",
    "properties.hs_latest_sequence_enrolled": "string",
    "properties.hs_latest_sequence_enrolled_date": "string",
    "properties.hs_latest_sequence_finished_date": "string",
    "properties.hs_latest_sequence_unenrolled_date": "string",
    "properties.hs_latest_source": "string",
    "properties.hs_latest_source_data_1": "string",
    "properties.hs_latest_source_data_2": "string",
    "properties.hs_latest_source_timestamp": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_legal_basis": "string",
    "properties.hs_lifecyclestage_customer_date": "string",
    "properties.hs_lifecyclestage_evangelist_date": "string",
    "properties.hs_lifecyclestage_lead_date": "string",
    "properties.hs_lifecyclestage_marketingqualifiedlead_date": "string",
    "properties.hs_lifecyclestage_opportunity_date": "string",
    "properties.hs_lifecyclestage_other_date": "string",
    "properties.hs_lifecyclestage_salesqualifiedlead_date": "string",
    "properties.hs_lifecyclestage_subscriber_date": "string",
    "properties.hs_marketable_reason_id": "string",
    "properties.hs_marketable_reason_type": "string",
    "properties.hs_marketable_status": "string",
    "properties.hs_marketable_until_renewal": "string",
    "properties.hs_membership_has_accessed_private_content": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_tmp": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_predictivescoringtier_tmp": "string",
    "properties.hs_prospecting_agent_actively_enrolled_count": "string",
    "properties.hs_quarantined_emails": "string",
    "properties.hs_registered_member": "string",
    "properties.hs_sa_first_engagement_date": "string",
    "properties.hs_sa_first_engagement_descr": "string",
    "properties.hs_sa_first_engagement_object_type": "string",
    "properties.hs_sales_email_last_clicked": "string",
    "properties.hs_sales_email_last_opened": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_searchable_calculated_mobile_number": "string",
    "properties.hs_searchable_calculated_phone_number": "string",
    "properties.hs_sequences_actively_enrolled_count": "string",
    "properties.hs_sequences_enrolled_count": "string",
    "properties.hs_sequences_is_enrolled": "string",
    "properties.hs_social_facebook_clicks": "string",
    "properties.hs_social_google_plus_clicks": "string",
    "properties.hs_social_last_engagement": "string",
    "properties.hs_social_linkedin_clicks": "string",
    "properties.hs_social_num_broadcast_clicks": "string",
    "properties.hs_social_twitter_clicks": "string",
    "properties.hs_state_code": "string",
    "properties.hs_time_between_contact_creation_and_deal_close": "string",
    "properties.hs_time_between_contact_creation_and_deal_creation": "string",
    "properties.hs_time_in_customer": "string",
    "properties.hs_time_in_evangelist": "string",
    "properties.hs_time_in_lead": "string",
    "properties.hs_time_in_marketingqualifiedlead": "string",
    "properties.hs_time_in_opportunity": "string",
    "properties.hs_time_in_other": "string",
    "properties.hs_time_in_salesqualifiedlead": "string",
    "properties.hs_time_in_subscriber": "string",
    "properties.hs_time_to_first_engagement": "string",
    "properties.hs_time_to_move_from_lead_to_customer": "string",
    "properties.hs_time_to_move_from_marketingqualifiedlead_to_customer": "string",
    "properties.hs_time_to_move_from_opportunity_to_customer": "string",
    "properties.hs_time_to_move_from_salesqualifiedlead_to_customer": "string",
    "properties.hs_time_to_move_from_subscriber_to_customer": "string",
    "properties.hs_timezone": "string",
    "properties.hs_twitterid": "string",
    "properties.hs_updated_by_user_id": "string",
    "properties.hs_user_ids_of_all_notification_followers": "string",
    "properties.hs_user_ids_of_all_notification_unfollowers": "string",
    "properties.hs_user_ids_of_all_owners": "string",
    "properties.hs_v2_cumulative_time_in_customer": "string",
    "properties.hs_v2_cumulative_time_in_evangelist": "string",
    "properties.hs_v2_cumulative_time_in_lead": "string",
    "properties.hs_v2_cumulative_time_in_marketingqualifiedlead": "string",
    "properties.hs_v2_cumulative_time_in_opportunity": "string",
    "properties.hs_v2_cumulative_time_in_other": "string",
    "properties.hs_v2_cumulative_time_in_salesqualifiedlead": "string",
    "properties.hs_v2_cumulative_time_in_subscriber": "string",
    "properties.hs_v2_date_entered_customer": "string",
    "properties.hs_v2_date_entered_evangelist": "string",
    "properties.hs_v2_date_entered_lead": "string",
    "properties.hs_v2_date_entered_marketingqualifiedlead": "string",
    "properties.hs_v2_date_entered_opportunity": "string",
    "properties.hs_v2_date_entered_other": "string",
    "properties.hs_v2_date_entered_salesqualifiedlead": "string",
    "properties.hs_v2_date_entered_subscriber": "string",
    "properties.hs_v2_date_exited_customer": "string",
    "properties.hs_v2_date_exited_lead": "string",
    "properties.hs_v2_date_exited_marketingqualifiedlead": "string",
    "properties.hs_v2_date_exited_opportunity": "string",
    "properties.hs_v2_date_exited_salesqualifiedlead": "string",
    "properties.hs_v2_date_exited_subscriber": "string",
    "properties.hs_v2_latest_time_in_customer": "string",
    "properties.hs_v2_latest_time_in_evangelist": "string",
    "properties.hs_v2_latest_time_in_lead": "string",
    "properties.hs_v2_latest_time_in_marketingqualifiedlead": "string",
    "properties.hs_v2_latest_time_in_opportunity": "string",
    "properties.hs_v2_latest_time_in_other": "string",
    "properties.hs_v2_latest_time_in_salesqualifiedlead": "string",
    "properties.hs_v2_latest_time_in_subscriber": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.ip_city": "string",
    "properties.ip_country": "string",
    "properties.ip_country_code": "string",
    "properties.ip_latlon": "string",
    "properties.ip_state": "string",
    "properties.ip_state_code": "string",
    "properties.ip_zipcode": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "string",
    "properties.last_login_date": "string",
    "properties.lastmodifieddate": "string",
    "properties.lastname": "string",
    "properties.leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "string",
    "properties.leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "string",
    "properties.leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a": "string",
    "properties.leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe": "string",
    "properties.leadin_insterested_in_free_trial_of_molo_for_our_boatyard_and_marin_b441293ad9518ccbb2d0072b9caa3970": "string",
    "properties.leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4": "string",
    "properties.leadin_phone_optional_324d7459684ca0b489279d4e48644441": "string",
    "properties.leadin_submit_a4d3b161ce1309df1c4e25df28694b7b": "string",
    "properties.leadin_very_interested_in_trying_out_molo_for_our_boatyard_and_mari_deb5e6afdff98645402c73aece98013a": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedinbio": "string",
    "properties.linkedinconnections": "string",
    "properties.marina_job_title": "string",
    "properties.marina_name": "string",
    "properties.marina_size_linear_feet_": "string",
    "properties.message": "string",
    "properties.mobilephone": "string",
    "properties.must_haves": "string",
    "properties.new_lead_status": "string",
    "properties.nickname": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_notes": "string",
    "properties.num_unique_conversion_events": "string",
    "properties.number_of_slips": "string",
    "properties.other_vendor": "string",
    "properties.phone": "string",
    "properties.photo": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.salesforce_contacts_id": "string",
    "properties.salutation": "string",
    "properties.send_me_updates": "string",
    "properties.services": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.state": "string",
    "properties.stellar_invalid_email_address": "string",
    "properties.supplemental_email": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.utm_campaign": "string",
    "properties.utm_content": "string",
    "properties.utm_medium": "string",
    "properties.utm_source": "string",
    "properties.utm_term": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

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

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contacts/2024-12-16/1734355127",
        "key": "raw/hubspot_molo_contacts/2024-12-16/1734355127/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6477814519270462274,
        "service_name": "drive-thru",
        "span_id": 6626928868476564457,
        "trace_id": 886135664232212835
    }
}

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

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contacts/2024-12-15/1734268634",
        "key": "raw/hubspot_molo_contacts/2024-12-15/1734268634/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8738140291904362554,
        "service_name": "drive-thru",
        "span_id": 1492646949895623986,
        "trace_id": 10143974836263892944
    }
}

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

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-prod/raw/hubspot_molo_contacts/2024-12-14/1734182446",
        "key": "raw/hubspot_molo_contacts/2024-12-14/1734182446/data.json.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 4459355401703682304,
        "service_name": "drive-thru",
        "span_id": 6043653931011868234,
        "trace_id": 10043877323670048065
    }
}