Schema Info

Schema Name: sfdl_dev_drivethru.hubspot_molo_contacts

created: 2022-11-30 12:59:40
disabled: False
format: raw
id: 2175
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_drivethru",
    "table": "hubspot_molo_contacts"
}

type: drivethrujson

Schema Versions: 4

Version 4692838

created: 2023-02-09 09:30:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`: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_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_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_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_user_ids_of_all_owners`: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,`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,`state`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`hs_first_engagement_object_id`: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,`city`: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,`services_offered`:STRING,`associated_show_event`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_sales_email_last_clicked`: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_actively_enrolled_count`:STRING,`hs_sequences_enrolled_count`:STRING,`hs_sequences_is_enrolled`: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,`hs_additional_emails`:STRING,`closedate`:STRING,`days_to_close`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_in_customer`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`base_tags`:STRING,`jobtitle`:STRING,`fax`:STRING,`trade_show`:STRING,`website`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`must_haves`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_calculated_merged_vids`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_last_sales_activity_type`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_updated_by_user_id`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`inactive`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`skype_username`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d`:STRING,`hs_legal_basis`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`nickname`:STRING,`hs_google_click_id`:STRING,`hs_facebook_ad_clicked`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`hs_created_by_user_id`:STRING,`work_email`:STRING,`actively_working_lead`: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-dev/raw/hubspot_molo_contacts/2023-02-09/1675956440'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_contacts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-02-09/1675956440
id: 4692838
processed: 1

raw_data:

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "false",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "Docks Expo 2019",
        "associatedcompanyid": "482462801",
        "associatedcompanylastupdated": "299495218326961",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "Key West",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Stock Island Marina Village",
        "country": "United States",
        "createdate": "2017-01-10T21:02:46.777Z",
        "current_software": "Dockwa",
        "current_vendor_new": "Dockwa",
        "currentlyinworkflow": "false",
        "days_to_close": "151",
        "direct_phone_number": "(972) 771-8865",
        "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-01-10T21:02:46.777Z",
        "first_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "first_deal_created_date": "",
        "firstname": "Jordan",
        "followercount": "17",
        "how_heard_about_us": "Capterra",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_contact_vids": "116651",
        "hs_all_owner_ids": "36256868",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "2",
        "hs_analytics_first_referrer": "https://www.google.com/",
        "hs_analytics_first_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_last_referrer": "http://getmolo.com/thanks.html",
        "hs_analytics_last_timestamp": "2017-01-10T21:02:46.838Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/index.html",
        "hs_analytics_last_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "2",
        "hs_analytics_num_visits": "1",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1484082166777",
        "hs_calculated_merged_vids": "714351:1642086081544;533105:1642086012088",
        "hs_calculated_mobile_number": "+12817403174",
        "hs_calculated_phone_number": "+17066150732",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_created_by_user_id": "44786584",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2017-01-10T21:02:50.413Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2017-06-26T15:33:10.809Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2020-04-21T19:01:59.413Z",
        "hs_date_exited_lead": "2017-06-26T15:33:10.809Z",
        "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": "2020-04-23T17:05:27.034Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "3",
        "hs_email_domain": "stockislandmarina.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_first_send_date": "2021-06-22T19:03:52.909Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Stellar Acquisition Email",
        "hs_email_last_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_last_send_date": "2022-10-31T13:33:40.155Z",
        "hs_email_open": "1",
        "hs_email_optout": "",
        "hs_email_optout_4048048": "",
        "hs_email_optout_4049846": "",
        "hs_email_optout_4049889": "",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "3",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "3003983559",
        "hs_google_click_id": "EAIaIQobChMImsrbirfG9gIVMwPnCh2SiAPgEAAYASAAEgKSifD_BwE",
        "hs_ip_timezone": "america_slash_new_york",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-19T08:09:03.898Z",
        "hs_last_sales_activity_timestamp": "2020-03-18T15:04:58.409Z",
        "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": "ORGANIC_SEARCH",
        "hs_latest_source_data_1": "Unknown keywords (SSL)",
        "hs_latest_source_data_2": "GOOGLE",
        "hs_latest_source_timestamp": "2017-01-10",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Freely given consent from contact",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2017-01-10T21:02:50.413Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2017-06-26T15:33:10.809Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2020-04-21T19:01:59.413Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_object_id": "116651",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_2",
        "hs_sa_first_engagement_date": "2019-08-08T21:18:24.325Z",
        "hs_sa_first_engagement_descr": "SENT",
        "hs_sa_first_engagement_object_type": "EMAIL",
        "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": "false",
        "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_time_between_contact_creation_and_deal_close": "13012042872",
        "hs_time_between_contact_creation_and_deal_creation": "90887367510",
        "hs_time_in_customer": "166317697312",
        "hs_time_in_evangelist": "154743653891",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "177464804657",
        "hs_time_in_other": "156273394602",
        "hs_time_in_salesqualifiedlead": "166480185774",
        "hs_time_in_subscriber": "165807621",
        "hs_time_to_first_engagement": "13820669226",
        "hs_time_to_move_from_lead_to_customer": "13012040533",
        "hs_time_to_move_from_opportunity_to_customer": "11147105882",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "3039174918",
        "hs_time_to_move_from_subscriber_to_customer": "87950091667",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "9780165",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "13491447",
        "hubspot_owner_assigneddate": "2022-08-03T14:01:46.230Z",
        "hubspot_owner_id": "60367669",
        "hubspot_team_id": "242125",
        "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": "Owner/Founder",
        "kloutscoregeneral": "13",
        "lastmodifieddate": "2022-11-29T06:46:14.149Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "Jason George",
        "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_size_linear_feet_": "12100",
        "mobilephone": "(281) 740-3174",
        "must_haves": "PO Process",
        "new_lead_status": "Prospect",
        "nickname": "tear a",
        "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": "302",
        "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": "",
        "salutation": "Mr.",
        "services_offered": "Service",
        "skype_username": "sergio.peterlin",
        "state": "CA",
        "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": "",
        "website": "http://www.anchoragemarina.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2022-11-29T07:06:36.240Z"
}

schema_attributes:

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.annualrevenue": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.association": "string",
    "properties.base_tags": "string",
    "properties.blog_default_hubspot_blog_5218978500_subscription": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.company_size": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.date_of_birth": "string",
    "properties.days_to_close": "string",
    "properties.degree": "string",
    "properties.direct_phone_number": "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.fb_ad_clicked": "string",
    "properties.field_of_study": "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.gender": "string",
    "properties.graduation_date": "string",
    "properties.how_heard_about_us": "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_avatar_filemanager_key": "string",
    "properties.hs_buying_role": "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_area_code": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_calculated_phone_number_region_code": "string",
    "properties.hs_clicked_linkedin_ad": "string",
    "properties.hs_content_membership_email_confirmed": "string",
    "properties.hs_content_membership_follow_up_enqueued_at": "string",
    "properties.hs_content_membership_notes": "string",
    "properties.hs_content_membership_registered_at": "string",
    "properties.hs_content_membership_registration_domain_sent_to": "string",
    "properties.hs_content_membership_registration_email_sent_at": "string",
    "properties.hs_content_membership_status": "string",
    "properties.hs_conversations_visitor_email": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_created_by_conversations": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "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_customer": "string",
    "properties.hs_date_exited_evangelist": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_other": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_document_last_revisited": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_customer_quarantined_reason": "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_reply_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_is_ineligible": "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_reply_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_replied": "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_feedback_last_nps_follow_up": "string",
    "properties.hs_feedback_last_nps_rating": "string",
    "properties.hs_feedback_last_survey_date": "string",
    "properties.hs_feedback_show_nps_web_survey": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_subscription_create_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_googleplusid": "string",
    "properties.hs_has_active_subscription": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_language": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_lastmodifieddate": "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_latest_subscription_create_date": "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_linkedin_ad_clicked": "string",
    "properties.hs_linkedinid": "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_merged_object_ids": "string",
    "properties.hs_object_id": "string",
    "properties.hs_persona": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscorebucket": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_read_only": "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_international_mobile_number": "string",
    "properties.hs_searchable_calculated_international_phone_number": "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_testpurge": "string",
    "properties.hs_testrollback": "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_unique_creation_key": "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_whatsapp_phone_number": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.hurricane_irma": "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.job_function": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "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_size_linear_feet_": "string",
    "properties.marital_status": "string",
    "properties.message": "string",
    "properties.military_status": "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.numemployees": "string",
    "properties.other_vendor": "string",
    "properties.owneremail": "string",
    "properties.ownername": "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.relationship_status": "string",
    "properties.salutation": "string",
    "properties.school": "string",
    "properties.send_me_updates": "string",
    "properties.seniority": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.start_date": "string",
    "properties.state": "string",
    "properties.supplemental_email": "string",
    "properties.surveymonkeyeventlastupdated": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.webinareventlastupdated": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

schema_name_id: 2175
schema_scan_id: 6108987
updated: 2023-02-09 09:30:38

Version 4692794

created: 2023-02-08 11:00:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`: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_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_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_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_user_ids_of_all_owners`: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,`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,`state`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`hs_first_engagement_object_id`: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,`city`: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,`services_offered`:STRING,`associated_show_event`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_sales_email_last_clicked`: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_actively_enrolled_count`:STRING,`hs_sequences_enrolled_count`:STRING,`hs_sequences_is_enrolled`: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,`hs_additional_emails`:STRING,`closedate`:STRING,`days_to_close`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_in_customer`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`base_tags`:STRING,`jobtitle`:STRING,`fax`:STRING,`trade_show`:STRING,`website`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`must_haves`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_calculated_merged_vids`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_last_sales_activity_type`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_updated_by_user_id`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`inactive`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`skype_username`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d`:STRING,`hs_legal_basis`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`nickname`:STRING,`hs_google_click_id`:STRING,`hs_facebook_ad_clicked`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`hs_created_by_user_id`:STRING,`work_email`:STRING,`actively_working_lead`: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-dev/raw/hubspot_molo_contacts/2023-02-08/1675875478'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_contacts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-02-08/1675875478
id: 4692794
processed: 1

raw_data:

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "false",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "Docks Expo 2019",
        "associatedcompanyid": "482462801",
        "associatedcompanylastupdated": "299495218326961",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "Key West",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Stock Island Marina Village",
        "country": "United States",
        "createdate": "2017-01-10T21:02:46.777Z",
        "current_software": "Dockwa",
        "current_vendor_new": "Dockwa",
        "currentlyinworkflow": "false",
        "days_to_close": "151",
        "direct_phone_number": "(972) 771-8865",
        "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-01-10T21:02:46.777Z",
        "first_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "first_deal_created_date": "",
        "firstname": "Jordan",
        "followercount": "17",
        "how_heard_about_us": "Capterra",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_contact_vids": "116651",
        "hs_all_owner_ids": "36256868",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "2",
        "hs_analytics_first_referrer": "https://www.google.com/",
        "hs_analytics_first_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_last_referrer": "http://getmolo.com/thanks.html",
        "hs_analytics_last_timestamp": "2017-01-10T21:02:46.838Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/index.html",
        "hs_analytics_last_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "2",
        "hs_analytics_num_visits": "1",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1484082166777",
        "hs_calculated_merged_vids": "714351:1642086081544;533105:1642086012088",
        "hs_calculated_mobile_number": "+12817403174",
        "hs_calculated_phone_number": "+17066150732",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_created_by_user_id": "44786584",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2017-01-10T21:02:50.413Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2017-06-26T15:33:10.809Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2020-04-21T19:01:59.413Z",
        "hs_date_exited_lead": "2017-06-26T15:33:10.809Z",
        "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": "2020-04-23T17:05:27.034Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "3",
        "hs_email_domain": "stockislandmarina.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_first_send_date": "2021-06-22T19:03:52.909Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Stellar Acquisition Email",
        "hs_email_last_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_last_send_date": "2022-10-31T13:33:40.155Z",
        "hs_email_open": "1",
        "hs_email_optout": "",
        "hs_email_optout_4048048": "",
        "hs_email_optout_4049846": "",
        "hs_email_optout_4049889": "",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "3",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "3003983559",
        "hs_google_click_id": "EAIaIQobChMImsrbirfG9gIVMwPnCh2SiAPgEAAYASAAEgKSifD_BwE",
        "hs_ip_timezone": "america_slash_new_york",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-19T08:09:03.898Z",
        "hs_last_sales_activity_timestamp": "2020-03-18T15:04:58.409Z",
        "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": "ORGANIC_SEARCH",
        "hs_latest_source_data_1": "Unknown keywords (SSL)",
        "hs_latest_source_data_2": "GOOGLE",
        "hs_latest_source_timestamp": "2017-01-10",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Freely given consent from contact",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2017-01-10T21:02:50.413Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2017-06-26T15:33:10.809Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2020-04-21T19:01:59.413Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_object_id": "116651",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_2",
        "hs_sa_first_engagement_date": "2019-08-08T21:18:24.325Z",
        "hs_sa_first_engagement_descr": "SENT",
        "hs_sa_first_engagement_object_type": "EMAIL",
        "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": "false",
        "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_time_between_contact_creation_and_deal_close": "13012042872",
        "hs_time_between_contact_creation_and_deal_creation": "90887367510",
        "hs_time_in_customer": "166236703166",
        "hs_time_in_evangelist": "154662659838",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "177383810513",
        "hs_time_in_other": "156192400134",
        "hs_time_in_salesqualifiedlead": "166399191669",
        "hs_time_in_subscriber": "165807621",
        "hs_time_to_first_engagement": "13820669226",
        "hs_time_to_move_from_lead_to_customer": "13012040533",
        "hs_time_to_move_from_opportunity_to_customer": "11147105882",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "3039174918",
        "hs_time_to_move_from_subscriber_to_customer": "87950091667",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "9780165",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "13491447",
        "hubspot_owner_assigneddate": "2022-08-03T14:01:46.230Z",
        "hubspot_owner_id": "60367669",
        "hubspot_team_id": "242125",
        "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": "Owner/Founder",
        "kloutscoregeneral": "13",
        "lastmodifieddate": "2022-11-29T06:46:14.149Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "Jason George",
        "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_size_linear_feet_": "12100",
        "mobilephone": "(281) 740-3174",
        "must_haves": "PO Process",
        "new_lead_status": "Prospect",
        "nickname": "tear a",
        "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": "302",
        "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": "",
        "salutation": "Mr.",
        "services_offered": "Service",
        "skype_username": "sergio.peterlin",
        "state": "CA",
        "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": "",
        "website": "http://www.anchoragemarina.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2022-11-29T07:06:36.240Z"
}

schema_attributes:

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.annualrevenue": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.association": "string",
    "properties.base_tags": "string",
    "properties.blog_default_hubspot_blog_5218978500_subscription": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.company_size": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.date_of_birth": "string",
    "properties.days_to_close": "string",
    "properties.degree": "string",
    "properties.direct_phone_number": "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.fb_ad_clicked": "string",
    "properties.field_of_study": "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.gender": "string",
    "properties.graduation_date": "string",
    "properties.how_heard_about_us": "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_avatar_filemanager_key": "string",
    "properties.hs_buying_role": "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_area_code": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_calculated_phone_number_region_code": "string",
    "properties.hs_clicked_linkedin_ad": "string",
    "properties.hs_content_membership_email_confirmed": "string",
    "properties.hs_content_membership_follow_up_enqueued_at": "string",
    "properties.hs_content_membership_notes": "string",
    "properties.hs_content_membership_registered_at": "string",
    "properties.hs_content_membership_registration_domain_sent_to": "string",
    "properties.hs_content_membership_registration_email_sent_at": "string",
    "properties.hs_content_membership_status": "string",
    "properties.hs_conversations_visitor_email": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_created_by_conversations": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "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_customer": "string",
    "properties.hs_date_exited_evangelist": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_other": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_document_last_revisited": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_customer_quarantined_reason": "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_reply_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_is_ineligible": "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_reply_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_replied": "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_feedback_last_nps_follow_up": "string",
    "properties.hs_feedback_last_nps_rating": "string",
    "properties.hs_feedback_last_survey_date": "string",
    "properties.hs_feedback_show_nps_web_survey": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_subscription_create_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_googleplusid": "string",
    "properties.hs_has_active_subscription": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_language": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_lastmodifieddate": "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_latest_subscription_create_date": "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_linkedin_ad_clicked": "string",
    "properties.hs_linkedinid": "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_merged_object_ids": "string",
    "properties.hs_object_id": "string",
    "properties.hs_persona": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscorebucket": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_read_only": "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_international_mobile_number": "string",
    "properties.hs_searchable_calculated_international_phone_number": "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_testpurge": "string",
    "properties.hs_testrollback": "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_unique_creation_key": "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_whatsapp_phone_number": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.hurricane_irma": "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.job_function": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "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_size_linear_feet_": "string",
    "properties.marital_status": "string",
    "properties.message": "string",
    "properties.military_status": "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.numemployees": "string",
    "properties.other_vendor": "string",
    "properties.owneremail": "string",
    "properties.ownername": "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.relationship_status": "string",
    "properties.salutation": "string",
    "properties.school": "string",
    "properties.send_me_updates": "string",
    "properties.seniority": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.start_date": "string",
    "properties.state": "string",
    "properties.supplemental_email": "string",
    "properties.surveymonkeyeventlastupdated": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.webinareventlastupdated": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

schema_name_id: 2175
schema_scan_id: 6106925
updated: 2023-02-08 11:00:48

Version 4692010

created: 2023-01-09 16:27:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`: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_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_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_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_user_ids_of_all_owners`: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,`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,`state`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`hs_first_engagement_object_id`: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,`city`: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,`services_offered`:STRING,`associated_show_event`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_sales_email_last_clicked`: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_actively_enrolled_count`:STRING,`hs_sequences_enrolled_count`:STRING,`hs_sequences_is_enrolled`: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,`hs_additional_emails`:STRING,`closedate`:STRING,`days_to_close`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_in_customer`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`base_tags`:STRING,`jobtitle`:STRING,`fax`:STRING,`trade_show`:STRING,`website`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`must_haves`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_calculated_merged_vids`: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_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_updated_by_user_id`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`inactive`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`hs_last_sales_activity_type`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`skype_username`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d`:STRING,`hs_legal_basis`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`nickname`:STRING,`hs_google_click_id`:STRING,`hs_facebook_ad_clicked`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`hs_created_by_user_id`:STRING,`work_email`:STRING,`actively_working_lead`: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-dev/raw/hubspot_molo_contacts/2023-01-09/1673303121'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_contacts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-01-09/1673303121
id: 4692010
processed: 1

raw_data:

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "false",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "Docks Expo 2019",
        "associatedcompanyid": "482462801",
        "associatedcompanylastupdated": "299495218326961",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "Key West",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Stock Island Marina Village",
        "country": "United States",
        "createdate": "2017-01-10T21:02:46.777Z",
        "current_software": "Dockwa",
        "current_vendor_new": "Dockwa",
        "currentlyinworkflow": "false",
        "days_to_close": "151",
        "direct_phone_number": "(972) 771-8865",
        "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-01-10T21:02:46.777Z",
        "first_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "first_deal_created_date": "",
        "firstname": "Jordan",
        "followercount": "17",
        "how_heard_about_us": "Capterra",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_contact_vids": "116651",
        "hs_all_owner_ids": "36256868",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "2",
        "hs_analytics_first_referrer": "https://www.google.com/",
        "hs_analytics_first_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_last_referrer": "http://getmolo.com/thanks.html",
        "hs_analytics_last_timestamp": "2017-01-10T21:02:46.838Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/index.html",
        "hs_analytics_last_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "2",
        "hs_analytics_num_visits": "1",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1484082166777",
        "hs_calculated_merged_vids": "714351:1642086081544;533105:1642086012088",
        "hs_calculated_mobile_number": "+12817403174",
        "hs_calculated_phone_number": "+17066150732",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_created_by_user_id": "44786584",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2017-01-10T21:02:50.413Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2017-06-26T15:33:10.809Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2020-04-21T19:01:59.413Z",
        "hs_date_exited_lead": "2017-06-26T15:33:10.809Z",
        "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": "2020-04-23T17:05:27.034Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "3",
        "hs_email_domain": "stockislandmarina.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_first_send_date": "2021-06-22T19:03:52.909Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Stellar Acquisition Email",
        "hs_email_last_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_last_send_date": "2022-10-31T13:33:40.155Z",
        "hs_email_open": "1",
        "hs_email_optout": "",
        "hs_email_optout_4048048": "",
        "hs_email_optout_4049846": "",
        "hs_email_optout_4049889": "",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "3",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "3003983559",
        "hs_google_click_id": "EAIaIQobChMImsrbirfG9gIVMwPnCh2SiAPgEAAYASAAEgKSifD_BwE",
        "hs_ip_timezone": "america_slash_new_york",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-19T08:09:03.898Z",
        "hs_last_sales_activity_timestamp": "2020-03-18T15:04:58.409Z",
        "hs_last_sales_activity_type": "EMAIL_OPEN",
        "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": "ORGANIC_SEARCH",
        "hs_latest_source_data_1": "Unknown keywords (SSL)",
        "hs_latest_source_data_2": "GOOGLE",
        "hs_latest_source_timestamp": "2017-01-10",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Freely given consent from contact",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2017-01-10T21:02:50.413Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2017-06-26T15:33:10.809Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2020-04-21T19:01:59.413Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_object_id": "116651",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_2",
        "hs_sa_first_engagement_date": "2019-08-08T21:18:24.325Z",
        "hs_sa_first_engagement_descr": "SENT",
        "hs_sa_first_engagement_object_type": "EMAIL",
        "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": "false",
        "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_time_between_contact_creation_and_deal_close": "13012042872",
        "hs_time_between_contact_creation_and_deal_creation": "90887367510",
        "hs_time_in_customer": "163664696464",
        "hs_time_in_evangelist": "152090650576",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "174811803786",
        "hs_time_in_other": "153620392848",
        "hs_time_in_salesqualifiedlead": "163827185089",
        "hs_time_in_subscriber": "165807621",
        "hs_time_to_first_engagement": "13820669226",
        "hs_time_to_move_from_lead_to_customer": "13012040533",
        "hs_time_to_move_from_opportunity_to_customer": "11147105882",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "3039174918",
        "hs_time_to_move_from_subscriber_to_customer": "87950091667",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "44691737",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "13491447",
        "hubspot_owner_assigneddate": "2022-08-03T14:01:46.230Z",
        "hubspot_owner_id": "60367669",
        "hubspot_team_id": "242125",
        "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": "Owner/Founder",
        "kloutscoregeneral": "13",
        "lastmodifieddate": "2022-11-29T06:46:14.149Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "Jason George",
        "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_size_linear_feet_": "12100",
        "mobilephone": "(281) 740-3174",
        "must_haves": "PO Process",
        "new_lead_status": "Prospect",
        "nickname": "tear a",
        "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": "302",
        "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": "",
        "salutation": "Mr.",
        "services_offered": "Service",
        "skype_username": "sergio.peterlin",
        "state": "CA",
        "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": "",
        "website": "http://www.anchoragemarina.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2022-11-29T07:06:36.240Z"
}

schema_attributes:

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.annualrevenue": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.association": "string",
    "properties.base_tags": "string",
    "properties.blog_default_hubspot_blog_5218978500_subscription": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.company_size": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.date_of_birth": "string",
    "properties.days_to_close": "string",
    "properties.degree": "string",
    "properties.direct_phone_number": "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.fb_ad_clicked": "string",
    "properties.field_of_study": "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.gender": "string",
    "properties.graduation_date": "string",
    "properties.how_heard_about_us": "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_avatar_filemanager_key": "string",
    "properties.hs_buying_role": "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_area_code": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_calculated_phone_number_region_code": "string",
    "properties.hs_clicked_linkedin_ad": "string",
    "properties.hs_content_membership_email_confirmed": "string",
    "properties.hs_content_membership_follow_up_enqueued_at": "string",
    "properties.hs_content_membership_notes": "string",
    "properties.hs_content_membership_registered_at": "string",
    "properties.hs_content_membership_registration_domain_sent_to": "string",
    "properties.hs_content_membership_registration_email_sent_at": "string",
    "properties.hs_content_membership_status": "string",
    "properties.hs_conversations_visitor_email": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_created_by_conversations": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "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_customer": "string",
    "properties.hs_date_exited_evangelist": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_other": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_document_last_revisited": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_customer_quarantined_reason": "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_reply_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_is_ineligible": "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_reply_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_replied": "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_feedback_last_nps_follow_up": "string",
    "properties.hs_feedback_last_nps_rating": "string",
    "properties.hs_feedback_last_survey_date": "string",
    "properties.hs_feedback_show_nps_web_survey": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_subscription_create_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_googleplusid": "string",
    "properties.hs_has_active_subscription": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_language": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_lastmodifieddate": "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_latest_subscription_create_date": "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_linkedin_ad_clicked": "string",
    "properties.hs_linkedinid": "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_merged_object_ids": "string",
    "properties.hs_object_id": "string",
    "properties.hs_persona": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscorebucket": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_read_only": "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_international_mobile_number": "string",
    "properties.hs_searchable_calculated_international_phone_number": "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_testpurge": "string",
    "properties.hs_testrollback": "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_unique_creation_key": "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_whatsapp_phone_number": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.hurricane_irma": "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.job_function": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "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_size_linear_feet_": "string",
    "properties.marital_status": "string",
    "properties.message": "string",
    "properties.military_status": "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.numemployees": "string",
    "properties.other_vendor": "string",
    "properties.owneremail": "string",
    "properties.ownername": "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.relationship_status": "string",
    "properties.salutation": "string",
    "properties.school": "string",
    "properties.send_me_updates": "string",
    "properties.seniority": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.start_date": "string",
    "properties.state": "string",
    "properties.supplemental_email": "string",
    "properties.surveymonkeyeventlastupdated": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.webinareventlastupdated": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

schema_name_id: 2175
schema_scan_id: 6067199
updated: 2023-01-09 16:27:36

Version 4692000

created: 2023-01-09 15:53:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_contacts`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`: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_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_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_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_user_ids_of_all_owners`: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,`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,`state`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`hs_first_engagement_object_id`: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,`city`: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,`services_offered`:STRING,`associated_show_event`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_sales_email_last_clicked`: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_actively_enrolled_count`:STRING,`hs_sequences_enrolled_count`:STRING,`hs_sequences_is_enrolled`: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,`hs_additional_emails`:STRING,`closedate`:STRING,`days_to_close`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_in_customer`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`base_tags`:STRING,`jobtitle`:STRING,`fax`:STRING,`trade_show`:STRING,`website`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`must_haves`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_calculated_merged_vids`: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_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_updated_by_user_id`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`inactive`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`hs_last_sales_activity_type`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`skype_username`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d`:STRING,`hs_legal_basis`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`nickname`:STRING,`hs_google_click_id`:STRING,`hs_facebook_ad_clicked`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`hs_created_by_user_id`:STRING,`work_email`:STRING,`actively_working_lead`: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-dev/raw/hubspot_molo_contacts/2023-01-09/1673301057'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_contacts"
]

hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-01-09/1673301057
id: 4692000
processed: 1

raw_data:

{
    "archived": false,
    "createdAt": "2016-12-15T17:56:53.529Z",
    "id": "4001",
    "properties": {
        "actively_working_lead": "false",
        "address": "7009 Shrimp Rd, Key West, FL 33040",
        "associated_show_event": "Docks Expo 2019",
        "associatedcompanyid": "482462801",
        "associatedcompanylastupdated": "299495218326961",
        "base_tags": "Marinas.Com NY Scrape by Impact Enterprises",
        "city": "Key West",
        "closedate": "2017-11-02T15:58:17.778Z",
        "company": "Stock Island Marina Village",
        "country": "United States",
        "createdate": "2017-01-10T21:02:46.777Z",
        "current_software": "Dockwa",
        "current_vendor_new": "Dockwa",
        "currentlyinworkflow": "false",
        "days_to_close": "151",
        "direct_phone_number": "(972) 771-8865",
        "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-01-10T21:02:46.777Z",
        "first_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "first_deal_created_date": "",
        "firstname": "Jordan",
        "followercount": "17",
        "how_heard_about_us": "Capterra",
        "hs_additional_emails": "[email protected]",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_contact_vids": "116651",
        "hs_all_owner_ids": "36256868",
        "hs_all_team_ids": "242125",
        "hs_analytics_average_page_views": "2",
        "hs_analytics_first_referrer": "https://www.google.com/",
        "hs_analytics_first_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_url": "http://getmolo.com/",
        "hs_analytics_first_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_last_referrer": "http://getmolo.com/thanks.html",
        "hs_analytics_last_timestamp": "2017-01-10T21:02:46.838Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_url": "http://getmolo.com/index.html",
        "hs_analytics_last_visit_timestamp": "2017-01-10T21:02:06.776Z",
        "hs_analytics_num_event_completions": "0",
        "hs_analytics_num_page_views": "2",
        "hs_analytics_num_visits": "1",
        "hs_analytics_revenue": "0.0",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_calculated_form_submissions": "b6020c8f-a9ae-4e89-a38f-02d9c71dbfd1::1484082166777",
        "hs_calculated_merged_vids": "714351:1642086081544;533105:1642086012088",
        "hs_calculated_mobile_number": "+12817403174",
        "hs_calculated_phone_number": "+17066150732",
        "hs_calculated_phone_number_country_code": "US",
        "hs_count_is_unworked": "0",
        "hs_count_is_worked": "1",
        "hs_created_by_user_id": "44786584",
        "hs_date_entered_customer": "2017-11-02T15:58:17.778Z",
        "hs_date_entered_evangelist": "2018-03-16T14:59:17.152Z",
        "hs_date_entered_lead": "2017-01-10T21:02:50.413Z",
        "hs_date_entered_marketingqualifiedlead": "2018-01-31T16:30:24.808Z",
        "hs_date_entered_opportunity": "2017-06-26T15:33:10.809Z",
        "hs_date_entered_other": "2018-02-26T22:03:27.727Z",
        "hs_date_entered_salesqualifiedlead": "2017-10-31T18:50:10.223Z",
        "hs_date_entered_subscriber": "2020-04-21T19:01:59.413Z",
        "hs_date_exited_lead": "2017-06-26T15:33:10.809Z",
        "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": "2020-04-23T17:05:27.034Z",
        "hs_email_bad_address": "true",
        "hs_email_bounce": "1",
        "hs_email_click": "1",
        "hs_email_delivered": "3",
        "hs_email_domain": "stockislandmarina.com",
        "hs_email_first_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_first_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_first_send_date": "2021-06-22T19:03:52.909Z",
        "hs_email_hard_bounce_reason_enum": "SPAM",
        "hs_email_last_click_date": "2022-11-02T23:49:09.644Z",
        "hs_email_last_email_name": "Stellar Acquisition Email",
        "hs_email_last_open_date": "2021-06-22T19:31:49.361Z",
        "hs_email_last_send_date": "2022-10-31T13:33:40.155Z",
        "hs_email_open": "1",
        "hs_email_optout": "",
        "hs_email_optout_4048048": "",
        "hs_email_optout_4049846": "",
        "hs_email_optout_4049889": "",
        "hs_email_quarantined": "",
        "hs_email_quarantined_reason": "UNDELIVERABLE_ADDRESS",
        "hs_email_recipient_fatigue_recovery_time": "",
        "hs_email_sends_since_last_engagement": "3",
        "hs_emailconfirmationstatus": "",
        "hs_facebook_ad_clicked": "true",
        "hs_facebookid": "100000489990032",
        "hs_first_engagement_object_id": "3003983559",
        "hs_google_click_id": "EAIaIQobChMImsrbirfG9gIVMwPnCh2SiAPgEAAYASAAEgKSifD_BwE",
        "hs_ip_timezone": "america_slash_new_york",
        "hs_is_contact": "true",
        "hs_is_unworked": "false",
        "hs_last_sales_activity_date": "1970-01-19T08:09:03.898Z",
        "hs_last_sales_activity_timestamp": "2020-03-18T15:04:58.409Z",
        "hs_last_sales_activity_type": "EMAIL_OPEN",
        "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": "ORGANIC_SEARCH",
        "hs_latest_source_data_1": "Unknown keywords (SSL)",
        "hs_latest_source_data_2": "GOOGLE",
        "hs_latest_source_timestamp": "2017-01-10",
        "hs_lead_status": "UNQUALIFIED",
        "hs_legal_basis": "Freely given consent from contact",
        "hs_lifecyclestage_customer_date": "2017-11-02T15:58:17.778Z",
        "hs_lifecyclestage_evangelist_date": "2018-03-16T14:59:17.152Z",
        "hs_lifecyclestage_lead_date": "2017-01-10T21:02:50.413Z",
        "hs_lifecyclestage_marketingqualifiedlead_date": "2018-01-31T16:30:24.808Z",
        "hs_lifecyclestage_opportunity_date": "2017-06-26T15:33:10.809Z",
        "hs_lifecyclestage_other_date": "2018-02-26T22:03:27.727Z",
        "hs_lifecyclestage_salesqualifiedlead_date": "2017-10-31T18:50:10.223Z",
        "hs_lifecyclestage_subscriber_date": "2020-04-21T19:01:59.413Z",
        "hs_marketable_reason_id": "",
        "hs_marketable_reason_type": "",
        "hs_marketable_status": "false",
        "hs_marketable_until_renewal": "false",
        "hs_object_id": "116651",
        "hs_pinned_engagement_id": "17807299221",
        "hs_pipeline": "contacts-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "0.22",
        "hs_predictivescoringtier": "tier_2",
        "hs_sa_first_engagement_date": "2019-08-08T21:18:24.325Z",
        "hs_sa_first_engagement_descr": "SENT",
        "hs_sa_first_engagement_object_type": "EMAIL",
        "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": "false",
        "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_time_between_contact_creation_and_deal_close": "13012042872",
        "hs_time_between_contact_creation_and_deal_creation": "90887367510",
        "hs_time_in_customer": "163662616209",
        "hs_time_in_evangelist": "152088570509",
        "hs_time_in_lead": "13031429927",
        "hs_time_in_marketingqualifiedlead": "41056978272",
        "hs_time_in_opportunity": "174809723557",
        "hs_time_in_other": "153618312811",
        "hs_time_in_salesqualifiedlead": "163825104701",
        "hs_time_in_subscriber": "165807621",
        "hs_time_to_first_engagement": "13820669226",
        "hs_time_to_move_from_lead_to_customer": "13012040533",
        "hs_time_to_move_from_opportunity_to_customer": "11147105882",
        "hs_time_to_move_from_salesqualifiedlead_to_customer": "3039174918",
        "hs_time_to_move_from_subscriber_to_customer": "87950091667",
        "hs_timezone": "america_slash_vancouver",
        "hs_twitterid": "139621773",
        "hs_updated_by_user_id": "44691737",
        "hs_user_ids_of_all_notification_followers": "13491447",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "13491447",
        "hubspot_owner_assigneddate": "2022-08-03T14:01:46.230Z",
        "hubspot_owner_id": "60367669",
        "hubspot_team_id": "242125",
        "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": "Owner/Founder",
        "kloutscoregeneral": "13",
        "lastmodifieddate": "2022-11-29T06:46:14.149Z",
        "lastname": "Davis",
        "leadin_comearzua_cf0ed29b40d97e829f053fe895fde87e": "Diego Alves de Macedo",
        "leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d": "Jason George",
        "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_size_linear_feet_": "12100",
        "mobilephone": "(281) 740-3174",
        "must_haves": "PO Process",
        "new_lead_status": "Prospect",
        "nickname": "tear a",
        "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": "302",
        "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": "",
        "salutation": "Mr.",
        "services_offered": "Service",
        "skype_username": "sergio.peterlin",
        "state": "CA",
        "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": "",
        "website": "http://www.anchoragemarina.com",
        "work_email": "\t [email protected]",
        "zip": "33040"
    },
    "updatedAt": "2022-11-29T07:06:36.240Z"
}

schema_attributes:

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.annualrevenue": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.association": "string",
    "properties.base_tags": "string",
    "properties.blog_default_hubspot_blog_5218978500_subscription": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.company_size": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.date_of_birth": "string",
    "properties.days_to_close": "string",
    "properties.degree": "string",
    "properties.direct_phone_number": "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.fb_ad_clicked": "string",
    "properties.field_of_study": "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.gender": "string",
    "properties.graduation_date": "string",
    "properties.how_heard_about_us": "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_avatar_filemanager_key": "string",
    "properties.hs_buying_role": "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_area_code": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_calculated_phone_number_region_code": "string",
    "properties.hs_clicked_linkedin_ad": "string",
    "properties.hs_content_membership_email_confirmed": "string",
    "properties.hs_content_membership_follow_up_enqueued_at": "string",
    "properties.hs_content_membership_notes": "string",
    "properties.hs_content_membership_registered_at": "string",
    "properties.hs_content_membership_registration_domain_sent_to": "string",
    "properties.hs_content_membership_registration_email_sent_at": "string",
    "properties.hs_content_membership_status": "string",
    "properties.hs_conversations_visitor_email": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_created_by_conversations": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "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_customer": "string",
    "properties.hs_date_exited_evangelist": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_other": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_document_last_revisited": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_customer_quarantined_reason": "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_reply_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_is_ineligible": "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_reply_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_replied": "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_feedback_last_nps_follow_up": "string",
    "properties.hs_feedback_last_nps_rating": "string",
    "properties.hs_feedback_last_survey_date": "string",
    "properties.hs_feedback_show_nps_web_survey": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_subscription_create_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_googleplusid": "string",
    "properties.hs_has_active_subscription": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_language": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_lastmodifieddate": "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_latest_subscription_create_date": "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_linkedin_ad_clicked": "string",
    "properties.hs_linkedinid": "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_merged_object_ids": "string",
    "properties.hs_object_id": "string",
    "properties.hs_persona": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscorebucket": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_read_only": "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_international_mobile_number": "string",
    "properties.hs_searchable_calculated_international_phone_number": "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_testpurge": "string",
    "properties.hs_testrollback": "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_unique_creation_key": "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_whatsapp_phone_number": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.hurricane_irma": "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.job_function": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "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_size_linear_feet_": "string",
    "properties.marital_status": "string",
    "properties.message": "string",
    "properties.military_status": "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.numemployees": "string",
    "properties.other_vendor": "string",
    "properties.owneremail": "string",
    "properties.ownername": "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.relationship_status": "string",
    "properties.salutation": "string",
    "properties.school": "string",
    "properties.send_me_updates": "string",
    "properties.seniority": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.start_date": "string",
    "properties.state": "string",
    "properties.supplemental_email": "string",
    "properties.surveymonkeyeventlastupdated": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.webinareventlastupdated": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

schema_name_id: 2175
schema_scan_id: 6067142
updated: 2023-01-09 15:53:21

Schema Scans: 4

Last at 2023-02-09 09:28:49

Scan 6108987

duration: 0:01:48.969096

exit_message:

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

id: 6108987

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-02-09/1675956440",
        "key": "raw/hubspot_molo_contacts/2023-02-09/1675956440/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11876885825970748444,
        "service_name": "drive-thru",
        "span_id": 11793635836313520228,
        "trace_id": 8340351729000863682
    }
}

running: False
schema_name_id: 2175
start_time: 2023-02-09 09:28:49
success: True
trace_id: 8340351729000863682

Scan 6106925

duration: 0:01:47.027738

exit_message:

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

id: 6106925

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-02-08/1675875478",
        "key": "raw/hubspot_molo_contacts/2023-02-08/1675875478/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 14263350723357120298,
        "service_name": "drive-thru",
        "span_id": 14512901488418653790,
        "trace_id": 9423826068388363569
    }
}

running: False
schema_name_id: 2175
start_time: 2023-02-08 10:59:01
success: True
trace_id: 9423826068388363569

Scan 6067199

duration: 0:01:41.643306

exit_message:

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

id: 6067199

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-01-09/1673303121",
        "key": "raw/hubspot_molo_contacts/2023-01-09/1673303121/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6088583766127315352,
        "service_name": "drive-thru",
        "span_id": 11286659028514722490,
        "trace_id": 17448028369397447534
    }
}

running: False
schema_name_id: 2175
start_time: 2023-01-09 16:25:55
success: True
trace_id: 17448028369397447534

Scan 6067142

duration: 0:01:41.117586

exit_message:

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

id: 6067142

payload:

{
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-dev",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_contacts/2023-01-09/1673301057",
        "key": "raw/hubspot_molo_contacts/2023-01-09/1673301057/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_contacts",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 5705532863140466487,
        "service_name": "drive-thru",
        "span_id": 9949281707401451106,
        "trace_id": 15369477960123107319
    }
}

running: False
schema_name_id: 2175
start_time: 2023-01-09 15:51:40
success: True
trace_id: 15369477960123107319

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.actively_working_lead": "string",
    "properties.address": "string",
    "properties.annualrevenue": "string",
    "properties.associated_show_event": "string",
    "properties.associatedcompanyid": "string",
    "properties.associatedcompanylastupdated": "string",
    "properties.association": "string",
    "properties.base_tags": "string",
    "properties.blog_default_hubspot_blog_5218978500_subscription": "string",
    "properties.city": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.company_size": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.currentlyinworkflow": "string",
    "properties.date_of_birth": "string",
    "properties.days_to_close": "string",
    "properties.degree": "string",
    "properties.direct_phone_number": "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.fb_ad_clicked": "string",
    "properties.field_of_study": "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.gender": "string",
    "properties.graduation_date": "string",
    "properties.how_heard_about_us": "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_avatar_filemanager_key": "string",
    "properties.hs_buying_role": "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_area_code": "string",
    "properties.hs_calculated_phone_number_country_code": "string",
    "properties.hs_calculated_phone_number_region_code": "string",
    "properties.hs_clicked_linkedin_ad": "string",
    "properties.hs_content_membership_email_confirmed": "string",
    "properties.hs_content_membership_follow_up_enqueued_at": "string",
    "properties.hs_content_membership_notes": "string",
    "properties.hs_content_membership_registered_at": "string",
    "properties.hs_content_membership_registration_domain_sent_to": "string",
    "properties.hs_content_membership_registration_email_sent_at": "string",
    "properties.hs_content_membership_status": "string",
    "properties.hs_conversations_visitor_email": "string",
    "properties.hs_count_is_unworked": "string",
    "properties.hs_count_is_worked": "string",
    "properties.hs_created_by_conversations": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "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_customer": "string",
    "properties.hs_date_exited_evangelist": "string",
    "properties.hs_date_exited_lead": "string",
    "properties.hs_date_exited_marketingqualifiedlead": "string",
    "properties.hs_date_exited_opportunity": "string",
    "properties.hs_date_exited_other": "string",
    "properties.hs_date_exited_salesqualifiedlead": "string",
    "properties.hs_date_exited_subscriber": "string",
    "properties.hs_document_last_revisited": "string",
    "properties.hs_email_bad_address": "string",
    "properties.hs_email_bounce": "string",
    "properties.hs_email_click": "string",
    "properties.hs_email_customer_quarantined_reason": "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_reply_date": "string",
    "properties.hs_email_first_send_date": "string",
    "properties.hs_email_hard_bounce_reason": "string",
    "properties.hs_email_hard_bounce_reason_enum": "string",
    "properties.hs_email_is_ineligible": "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_reply_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_replied": "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_feedback_last_nps_follow_up": "string",
    "properties.hs_feedback_last_nps_rating": "string",
    "properties.hs_feedback_last_survey_date": "string",
    "properties.hs_feedback_show_nps_web_survey": "string",
    "properties.hs_first_engagement_object_id": "string",
    "properties.hs_first_subscription_create_date": "string",
    "properties.hs_google_click_id": "string",
    "properties.hs_googleplusid": "string",
    "properties.hs_has_active_subscription": "string",
    "properties.hs_ip_timezone": "string",
    "properties.hs_is_contact": "string",
    "properties.hs_is_unworked": "string",
    "properties.hs_language": "string",
    "properties.hs_last_sales_activity_date": "string",
    "properties.hs_last_sales_activity_timestamp": "string",
    "properties.hs_last_sales_activity_type": "string",
    "properties.hs_lastmodifieddate": "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_latest_subscription_create_date": "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_linkedin_ad_clicked": "string",
    "properties.hs_linkedinid": "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_merged_object_ids": "string",
    "properties.hs_object_id": "string",
    "properties.hs_persona": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscorebucket": "string",
    "properties.hs_predictivescoringtier": "string",
    "properties.hs_read_only": "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_international_mobile_number": "string",
    "properties.hs_searchable_calculated_international_phone_number": "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_testpurge": "string",
    "properties.hs_testrollback": "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_unique_creation_key": "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_whatsapp_phone_number": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.hurricane_irma": "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.job_function": "string",
    "properties.jobtitle": "string",
    "properties.kloutscoregeneral": "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_size_linear_feet_": "string",
    "properties.marital_status": "string",
    "properties.message": "string",
    "properties.military_status": "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.numemployees": "string",
    "properties.other_vendor": "string",
    "properties.owneremail": "string",
    "properties.ownername": "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.relationship_status": "string",
    "properties.salutation": "string",
    "properties.school": "string",
    "properties.send_me_updates": "string",
    "properties.seniority": "string",
    "properties.services_offered": "string",
    "properties.skype_username": "string",
    "properties.start_date": "string",
    "properties.state": "string",
    "properties.supplemental_email": "string",
    "properties.surveymonkeyeventlastupdated": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterhandle": "string",
    "properties.twitterprofilephoto": "string",
    "properties.webinareventlastupdated": "string",
    "properties.website": "string",
    "properties.work_email": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}

created: 2023-02-09 09:30:27

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`: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_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_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_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_user_ids_of_all_owners`: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,`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,`state`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`hs_first_engagement_object_id`: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,`city`: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,`services_offered`:STRING,`associated_show_event`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_sales_email_last_clicked`: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_actively_enrolled_count`:STRING,`hs_sequences_enrolled_count`:STRING,`hs_sequences_is_enrolled`: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,`hs_additional_emails`:STRING,`closedate`:STRING,`days_to_close`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_in_customer`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`base_tags`:STRING,`jobtitle`:STRING,`fax`:STRING,`trade_show`:STRING,`website`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`must_haves`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_calculated_merged_vids`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_last_sales_activity_type`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_updated_by_user_id`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`inactive`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`skype_username`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d`:STRING,`hs_legal_basis`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`nickname`:STRING,`hs_google_click_id`:STRING,`hs_facebook_ad_clicked`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`hs_created_by_user_id`:STRING,`work_email`:STRING,`actively_working_lead`: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-dev/raw/hubspot_molo_contacts/2023-02-09/1675956440'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_contacts`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_contacts"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2022-11-30 12:59:40",
        "disabled": false,
        "format": "raw",
        "id": 2175,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "hubspot_molo_contacts"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "createdAt": "string",
            "id": "string",
            "properties.actively_working_lead": "string",
            "properties.address": "string",
            "properties.annualrevenue": "string",
            "properties.associated_show_event": "string",
            "properties.associatedcompanyid": "string",
            "properties.associatedcompanylastupdated": "string",
            "properties.association": "string",
            "properties.base_tags": "string",
            "properties.blog_default_hubspot_blog_5218978500_subscription": "string",
            "properties.city": "string",
            "properties.closedate": "string",
            "properties.company": "string",
            "properties.company_size": "string",
            "properties.country": "string",
            "properties.createdate": "string",
            "properties.current_software": "string",
            "properties.current_vendor_new": "string",
            "properties.currentlyinworkflow": "string",
            "properties.date_of_birth": "string",
            "properties.days_to_close": "string",
            "properties.degree": "string",
            "properties.direct_phone_number": "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.fb_ad_clicked": "string",
            "properties.field_of_study": "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.gender": "string",
            "properties.graduation_date": "string",
            "properties.how_heard_about_us": "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_avatar_filemanager_key": "string",
            "properties.hs_buying_role": "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_area_code": "string",
            "properties.hs_calculated_phone_number_country_code": "string",
            "properties.hs_calculated_phone_number_region_code": "string",
            "properties.hs_clicked_linkedin_ad": "string",
            "properties.hs_content_membership_email_confirmed": "string",
            "properties.hs_content_membership_follow_up_enqueued_at": "string",
            "properties.hs_content_membership_notes": "string",
            "properties.hs_content_membership_registered_at": "string",
            "properties.hs_content_membership_registration_domain_sent_to": "string",
            "properties.hs_content_membership_registration_email_sent_at": "string",
            "properties.hs_content_membership_status": "string",
            "properties.hs_conversations_visitor_email": "string",
            "properties.hs_count_is_unworked": "string",
            "properties.hs_count_is_worked": "string",
            "properties.hs_created_by_conversations": "string",
            "properties.hs_created_by_user_id": "string",
            "properties.hs_createdate": "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_customer": "string",
            "properties.hs_date_exited_evangelist": "string",
            "properties.hs_date_exited_lead": "string",
            "properties.hs_date_exited_marketingqualifiedlead": "string",
            "properties.hs_date_exited_opportunity": "string",
            "properties.hs_date_exited_other": "string",
            "properties.hs_date_exited_salesqualifiedlead": "string",
            "properties.hs_date_exited_subscriber": "string",
            "properties.hs_document_last_revisited": "string",
            "properties.hs_email_bad_address": "string",
            "properties.hs_email_bounce": "string",
            "properties.hs_email_click": "string",
            "properties.hs_email_customer_quarantined_reason": "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_reply_date": "string",
            "properties.hs_email_first_send_date": "string",
            "properties.hs_email_hard_bounce_reason": "string",
            "properties.hs_email_hard_bounce_reason_enum": "string",
            "properties.hs_email_is_ineligible": "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_reply_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_replied": "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_feedback_last_nps_follow_up": "string",
            "properties.hs_feedback_last_nps_rating": "string",
            "properties.hs_feedback_last_survey_date": "string",
            "properties.hs_feedback_show_nps_web_survey": "string",
            "properties.hs_first_engagement_object_id": "string",
            "properties.hs_first_subscription_create_date": "string",
            "properties.hs_google_click_id": "string",
            "properties.hs_googleplusid": "string",
            "properties.hs_has_active_subscription": "string",
            "properties.hs_ip_timezone": "string",
            "properties.hs_is_contact": "string",
            "properties.hs_is_unworked": "string",
            "properties.hs_language": "string",
            "properties.hs_last_sales_activity_date": "string",
            "properties.hs_last_sales_activity_timestamp": "string",
            "properties.hs_last_sales_activity_type": "string",
            "properties.hs_lastmodifieddate": "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_latest_subscription_create_date": "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_linkedin_ad_clicked": "string",
            "properties.hs_linkedinid": "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_merged_object_ids": "string",
            "properties.hs_object_id": "string",
            "properties.hs_persona": "string",
            "properties.hs_pinned_engagement_id": "string",
            "properties.hs_pipeline": "string",
            "properties.hs_predictivecontactscore": "string",
            "properties.hs_predictivecontactscore_v2": "string",
            "properties.hs_predictivecontactscorebucket": "string",
            "properties.hs_predictivescoringtier": "string",
            "properties.hs_read_only": "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_international_mobile_number": "string",
            "properties.hs_searchable_calculated_international_phone_number": "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_testpurge": "string",
            "properties.hs_testrollback": "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_unique_creation_key": "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_whatsapp_phone_number": "string",
            "properties.hubspot_owner_assigneddate": "string",
            "properties.hubspot_owner_id": "string",
            "properties.hubspot_team_id": "string",
            "properties.hubspotscore": "string",
            "properties.hurricane_irma": "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.job_function": "string",
            "properties.jobtitle": "string",
            "properties.kloutscoregeneral": "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_size_linear_feet_": "string",
            "properties.marital_status": "string",
            "properties.message": "string",
            "properties.military_status": "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.numemployees": "string",
            "properties.other_vendor": "string",
            "properties.owneremail": "string",
            "properties.ownername": "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.relationship_status": "string",
            "properties.salutation": "string",
            "properties.school": "string",
            "properties.send_me_updates": "string",
            "properties.seniority": "string",
            "properties.services_offered": "string",
            "properties.skype_username": "string",
            "properties.start_date": "string",
            "properties.state": "string",
            "properties.supplemental_email": "string",
            "properties.surveymonkeyeventlastupdated": "string",
            "properties.total_revenue": "string",
            "properties.trade_show": "string",
            "properties.twitterbio": "string",
            "properties.twitterhandle": "string",
            "properties.twitterprofilephoto": "string",
            "properties.webinareventlastupdated": "string",
            "properties.website": "string",
            "properties.work_email": "string",
            "properties.zip": "string",
            "updatedAt": "string"
        },
        "created": "2023-02-09 09:30:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_contacts`\n(\n`id`STRING,`properties`struct<`associatedcompanyid`:STRING,`associatedcompanylastupdated`:STRING,`company`:STRING,`country`:STRING,`createdate`:STRING,`currentlyinworkflow`:STRING,`email`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`firstname`: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_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_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_time_in_lead`:STRING,`hs_time_in_opportunity`:STRING,`hs_timezone`:STRING,`hs_user_ids_of_all_owners`: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,`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,`state`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`leadin_message_4c2a8fe7eaf24721cc7a9f0175115bd4`:STRING,`number_of_slips`:STRING,`hs_first_engagement_object_id`: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,`city`: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,`services_offered`:STRING,`associated_show_event`:STRING,`hs_time_between_contact_creation_and_deal_creation`:STRING,`hs_email_optout_4048048`:STRING,`hs_email_recipient_fatigue_recovery_time`:STRING,`hs_sales_email_last_clicked`: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_actively_enrolled_count`:STRING,`hs_sequences_enrolled_count`:STRING,`hs_sequences_is_enrolled`: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,`hs_additional_emails`:STRING,`closedate`:STRING,`days_to_close`:STRING,`hs_date_entered_customer`:STRING,`hs_date_exited_opportunity`:STRING,`hs_lifecyclestage_customer_date`:STRING,`hs_time_between_contact_creation_and_deal_close`:STRING,`hs_time_in_customer`:STRING,`hs_time_to_move_from_lead_to_customer`:STRING,`hs_time_to_move_from_opportunity_to_customer`:STRING,`base_tags`:STRING,`jobtitle`:STRING,`fax`:STRING,`trade_show`:STRING,`website`:STRING,`hs_latest_sequence_unenrolled_date`:STRING,`industry`:STRING,`supplemental_email`:STRING,`must_haves`:STRING,`direct_phone_number`:STRING,`twitterprofilephoto`:STRING,`hs_calculated_merged_vids`:STRING,`hs_lead_status`:STRING,`kloutscoregeneral`:STRING,`hs_latest_meeting_activity`:STRING,`linkedinbio`:STRING,`linkedinconnections`:STRING,`hs_last_sales_activity_type`:STRING,`hs_date_entered_salesqualifiedlead`:STRING,`hs_lifecyclestage_salesqualifiedlead_date`:STRING,`hs_time_in_salesqualifiedlead`:STRING,`hs_email_click`:STRING,`hs_email_first_click_date`:STRING,`hs_email_last_click_date`:STRING,`hs_date_exited_salesqualifiedlead`:STRING,`hs_emailconfirmationstatus`:STRING,`hs_date_entered_marketingqualifiedlead`:STRING,`hs_date_exited_marketingqualifiedlead`:STRING,`hs_lifecyclestage_marketingqualifiedlead_date`:STRING,`hs_time_in_marketingqualifiedlead`:STRING,`hs_updated_by_user_id`:STRING,`hs_time_to_move_from_salesqualifiedlead_to_customer`:STRING,`inactive`:STRING,`hs_pinned_engagement_id`:STRING,`leadin_submit_a4d3b161ce1309df1c4e25df28694b7b`:STRING,`marina_size_linear_feet_`:STRING,`salutation`:STRING,`hs_email_quarantined_reason`:STRING,`skype_username`:STRING,`hs_date_entered_other`:STRING,`hs_lifecyclestage_other_date`:STRING,`hs_time_in_other`:STRING,`leadin_dear_sales_teamwould_you_please_provide_us_a_quotation_for_t_0a3f341b6048eee7384301657deafb4a`:STRING,`leadin_evaluating_the_application_213ad9386ef1d196e20b9ae0feb9f0fe`:STRING,`hs_date_entered_subscriber`:STRING,`hs_date_exited_subscriber`:STRING,`hs_lifecyclestage_subscriber_date`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_entered_evangelist`:STRING,`hs_lifecyclestage_evangelist_date`:STRING,`hs_time_in_evangelist`:STRING,`leadin_dear_customer_service_we_are_a_uae_based_group_of_companies__aee9baf1b7773ec8eb2edad6b8de149d`:STRING,`hs_legal_basis`:STRING,`hs_time_to_move_from_subscriber_to_customer`:STRING,`nickname`:STRING,`hs_google_click_id`:STRING,`hs_facebook_ad_clicked`:STRING,`hs_user_ids_of_all_notification_followers`:STRING,`engagements_last_meeting_booked_campaign`:STRING,`engagements_last_meeting_booked_source`:STRING,`engagements_last_meeting_booked_medium`:STRING,`hs_created_by_user_id`:STRING,`work_email`:STRING,`actively_working_lead`: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-dev/raw/hubspot_molo_contacts/2023-02-09/1675956440'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_contacts`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_contacts"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}