Schema Info

Schema Name: sfdl_dev_drivethru.hubspot_molo_companies
  • created: 2022-11-30 12:59:20
  • disabled: False
  • format: raw
  • id: 2174
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "hubspot_molo_companies"
}
  • type: drivethrujson
Schema Versions: 4
    • created: 2023-02-09 09:28:37
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_companies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_companies`\n(\n`id`STRING,`properties`struct<`address`:STRING,`annualrevenue`:STRING,`city`:STRING,`country`:STRING,`createdate`:STRING,`description`:STRING,`domain`:STRING,`engagements_last_meeting_booked`:STRING,`facebook_company_page`:STRING,`first_contact_createdate`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_last_booked_meeting_date`:STRING,`hs_last_logged_call_date`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`hs_lastmodifieddate`:STRING,`hs_latest_meeting_activity`:STRING,`hs_num_blockers`:STRING,`hs_num_contacts_with_buying_roles`:STRING,`hs_num_decision_makers`:STRING,`hs_num_open_deals`:STRING,`hs_object_id`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_sales_email_last_replied`:STRING,`hs_target_account_probability`:STRING,`hs_total_deal_value`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`industry`:STRING,`is_public`:STRING,`linkedin_company_page`:STRING,`linkedinbio`:STRING,`name`:STRING,`new_lead_status`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_associated_contacts`:STRING,`num_contacted_notes`:STRING,`num_conversion_events`:STRING,`num_notes`:STRING,`number_of_slips_new`:STRING,`numberofemployees`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`size`:STRING,`state`:STRING,`timezone`:STRING,`twitterhandle`:STRING,`web_technologies`:STRING,`website`:STRING,`zip`:STRING,`closedate`:STRING,`days_to_close`:STRING,`first_deal_created_date`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`hs_date_entered_customer`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_opportunity`:STRING,`hs_last_open_task_date`:STRING,`hs_pinned_engagement_id`:STRING,`hs_time_in_customer`:STRING,`hs_time_in_opportunity`:STRING,`hs_updated_by_user_id`:STRING,`lifecyclestage`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`services_offered`:STRING,`total_revenue`:STRING,`current_vendor_new`:STRING,`founded_year`:STRING,`address2`:STRING,`hs_num_child_companies`:STRING,`current_software`:STRING,`hs_last_sales_activity_type`:STRING,`hs_parent_company_id`:STRING,`hs_pipeline`:STRING,`hs_lead_status`:STRING,`hs_merged_object_ids`:STRING,`trade_show`:STRING,`client_or_churned`:STRING,`must_haves`:STRING,`enterprise_opportunity`:STRING,`total_money_raised`:STRING,`email`:STRING,`hs_additional_domains`:STRING,`hs_created_by_user_id`:STRING,`inactive`:STRING,`dockwa_url`:STRING,`municipality`:STRING,`first_contact_createdate_timestamp_earliest_value_78b50eea`:STRING,`first_conversion_date_timestamp_earliest_value_61f58f2c`:STRING,`first_conversion_event_name_timestamp_earliest_value_68ddae0a`:STRING,`recent_conversion_date_timestamp_latest_value_72856da1`:STRING,`recent_conversion_event_name_timestamp_latest_value_66c820bf`:STRING,`cross_sell_deal_owner`:STRING,`cross_sell_opportunity`:STRING,`type`:STRING,`hs_is_target_account`:STRING,`qualified`:STRING,`hs_date_entered_lead`:STRING,`hs_time_in_lead`:STRING,`about_us`:STRING,`associated_company`:STRING,`mobile_phone_number`:STRING,`snag_a_slip_url`:STRING,`hs_avatar_filemanager_key`:STRING,`hs_date_exited_lead`:STRING,`marina_type`:STRING,`hs_date_entered_subscriber`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_exited_subscriber`: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_companies/2023-02-09/1675956420'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_companies"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_companies/2023-02-09/1675956420
    • id: 4692834
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-26T15:15:21.630Z",
    "id": "482395255",
    "properties": {
        "about_us": "260-833-2536",
        "address": "5 Bay Avenue",
        "address2": "E-51, INDUSTRIAL AREA, PHASE - 8",
        "annualrevenue": "10000000",
        "associated_company": "Harborlight Yacht Club - Long Beach",
        "city": "Oyster Bay",
        "client_or_churned": "Client",
        "closedate": "2019-02-01T02:55:32.878Z",
        "country": "United States",
        "createdate": "2017-06-26T15:15:21.633Z",
        "cross_sell_deal_owner": "Brian Steinman",
        "cross_sell_opportunity": "Active Stellar Deal",
        "current_software": "BiT",
        "current_vendor_new": "Lightspeed",
        "days_to_close": "584",
        "description": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "dockwa_url": "https://dockwa.com/explore/destination/qpcm5z-treasure-cove-resort-marina/referral?form=transient",
        "domain": "obmc.com",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "enterprise_opportunity": "true",
        "facebook_company_page": "https://facebook.com/fairwindsgolf",
        "first_contact_createdate": "2017-05-08T20:01:00.460Z",
        "first_contact_createdate_timestamp_earliest_value_78b50eea": "2017-06-26T15:25:18.152Z",
        "first_conversion_date": "2017-05-08T20:01:00.460Z",
        "first_conversion_date_timestamp_earliest_value_61f58f2c": "2018-11-29T13:07:39.656Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_conversion_event_name_timestamp_earliest_value_68ddae0a": "2018-11-29T13:07:39.656Z",
        "first_deal_created_date": "2017-06-27T18:08:34.219Z",
        "founded_year": "1962",
        "hs_additional_domains": "",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_owner_ids": "143909472",
        "hs_all_team_ids": "242125",
        "hs_analytics_first_timestamp": "2017-05-08T19:59:30.455Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_latest_source": "EMAIL_MARKETING",
        "hs_analytics_latest_source_data_1": "hs_email",
        "hs_analytics_latest_source_data_2": "231896277",
        "hs_analytics_latest_source_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_num_page_views": "1",
        "hs_analytics_num_visits": "1",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_avatar_filemanager_key": "hubfs/2459647/defaults/company.png",
        "hs_created_by_user_id": "4428097",
        "hs_date_entered_customer": "2019-02-01T02:55:32.878Z",
        "hs_date_entered_lead": "2022-10-11T15:08:14.835Z",
        "hs_date_entered_opportunity": "2018-04-25T17:28:31.654Z",
        "hs_date_entered_subscriber": "2022-09-07T20:47:57.402Z",
        "hs_date_exited_lead": "2022-12-01T17:49:59.172Z",
        "hs_date_exited_opportunity": "2019-02-01T02:55:32.878Z",
        "hs_date_exited_subscriber": "2022-09-13T14:08:21.108Z",
        "hs_is_target_account": "true",
        "hs_last_booked_meeting_date": "2021-03-30T19:00:00Z",
        "hs_last_logged_call_date": "2022-09-27T17:26:42.381Z",
        "hs_last_open_task_date": "",
        "hs_last_sales_activity_date": "1970-01-19T22:28:37.605Z",
        "hs_last_sales_activity_timestamp": "2021-11-05T13:06:45.023Z",
        "hs_last_sales_activity_type": "EMAIL_OPEN",
        "hs_lastmodifieddate": "2022-10-31T16:11:26.581Z",
        "hs_latest_meeting_activity": "2021-03-30T19:00:00Z",
        "hs_lead_status": "",
        "hs_merged_object_ids": "493670335",
        "hs_num_blockers": "0",
        "hs_num_child_companies": "1",
        "hs_num_contacts_with_buying_roles": "0",
        "hs_num_decision_makers": "0",
        "hs_num_open_deals": "0",
        "hs_object_id": "482395256",
        "hs_parent_company_id": "5381607886",
        "hs_pinned_engagement_id": "12127112285",
        "hs_pipeline": "companies-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "1.53",
        "hs_sales_email_last_replied": "2021-03-31T21:30:17Z",
        "hs_target_account_probability": "0.598552942276001",
        "hs_time_in_customer": "126966384044",
        "hs_time_in_lead": "10455224299",
        "hs_time_in_opportunity": "24312421224",
        "hs_time_in_subscriber": "13372505173",
        "hs_total_deal_value": "",
        "hs_updated_by_user_id": "27059645",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "28353587",
        "hubspot_owner_assigneddate": "2022-02-17T14:24:51.814Z",
        "hubspot_owner_id": "143909472",
        "hubspot_team_id": "242125",
        "inactive": "true",
        "industry": "",
        "is_public": "false",
        "lifecyclestage": "customer",
        "linkedin_company_page": "https://www.linkedin.com/company/oyster-bay-marine-center-inc",
        "linkedinbio": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "marina_type": "Slips",
        "mobile_phone_number": "(619) 807-7245",
        "municipality": "true",
        "must_haves": "PO Process",
        "name": "Oyster Bay Marine Center - OBMC",
        "new_lead_status": "Demoed;Prospect",
        "notes_last_contacted": "2022-09-27T17:26:42.381Z",
        "notes_last_updated": "2022-09-27T18:45:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "1",
        "num_associated_deals": "1",
        "num_contacted_notes": "56",
        "num_conversion_events": "2",
        "num_notes": "77",
        "number_of_slips_new": "282",
        "numberofemployees": "25",
        "phone": "+1 516-624-2400",
        "qualified": "false",
        "recent_conversion_date": "2018-04-25T16:59:29.483Z",
        "recent_conversion_date_timestamp_latest_value_72856da1": "2018-11-29T13:07:39.656Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "recent_conversion_event_name_timestamp_latest_value_66c820bf": "2018-11-29T13:07:39.656Z",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "services_offered": "Dry Storage;Slips",
        "size": "ENT",
        "snag_a_slip_url": "https://www.snagaslip.com/gulf-coast-marinas/louisiana/lake-catherine-island-marina",
        "state": "FL",
        "timezone": "America/Vancouver",
        "total_money_raised": "3M",
        "total_revenue": "",
        "trade_show": "MRA",
        "twitterhandle": "fairwindsgolf",
        "type": "PROSPECT",
        "web_technologies": "microsoft_exchange_online;mailchimp;wordpress;google_tag_manager;salesforce;woo_commerce;amazon_s3;microsoft_office_365;apache;go_squared;google_analytics;outlook",
        "website": "fairwinds.ca",
        "zip": "V9P 9J6"
    },
    "updatedAt": "2023-01-15T06:16:29.640Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.about_us": "string",
    "properties.address": "string",
    "properties.address2": "string",
    "properties.annualrevenue": "string",
    "properties.associated_company": "string",
    "properties.city": "string",
    "properties.client_or_churned": "string",
    "properties.closedate": "string",
    "properties.closedate_timestamp_earliest_value_a2a17e6e": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.cross_sell_deal_owner": "string",
    "properties.cross_sell_opportunity": "string",
    "properties.current_product": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.description": "string",
    "properties.dockwa_url": "string",
    "properties.domain": "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.enterprise_opportunity": "string",
    "properties.facebook_company_page": "string",
    "properties.facebookfans": "string",
    "properties.first_contact_createdate": "string",
    "properties.first_contact_createdate_timestamp_earliest_value_78b50eea": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_date_timestamp_earliest_value_61f58f2c": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a": "string",
    "properties.first_deal_created_date": "string",
    "properties.founded_year": "string",
    "properties.googleplus_page": "string",
    "properties.hs_additional_domains": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_num_visits_cardinality_sum_53d952a6": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400": "string",
    "properties.hs_analytics_source_timestamp_earliest_value_25a3a52c": "string",
    "properties.hs_avatar_filemanager_key": "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_ideal_customer_profile": "string",
    "properties.hs_is_target_account": "string",
    "properties.hs_last_booked_meeting_date": "string",
    "properties.hs_last_logged_call_date": "string",
    "properties.hs_last_open_task_date": "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_createdate_of_active_subscriptions": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_num_blockers": "string",
    "properties.hs_num_child_companies": "string",
    "properties.hs_num_contacts_with_buying_roles": "string",
    "properties.hs_num_decision_makers": "string",
    "properties.hs_num_open_deals": "string",
    "properties.hs_object_id": "string",
    "properties.hs_parent_company_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_target_account": "string",
    "properties.hs_target_account_probability": "string",
    "properties.hs_target_account_recommendation_snooze_time": "string",
    "properties.hs_target_account_recommendation_state": "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_total_deal_value": "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.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.is_public": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedin_company_page": "string",
    "properties.linkedinbio": "string",
    "properties.marina_type": "string",
    "properties.mobile_phone_number": "string",
    "properties.municipality": "string",
    "properties.must_haves": "string",
    "properties.name": "string",
    "properties.new_lead_status": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_conversion_events_cardinality_sum_d095f14b": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips_new": "string",
    "properties.numberofemployees": "string",
    "properties.owneremail": "string",
    "properties.ownername": "string",
    "properties.phone": "string",
    "properties.qualified": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_date_timestamp_latest_value_72856da1": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_conversion_event_name_timestamp_latest_value_66c820bf": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.requested_feature": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slips__service_or_both": "string",
    "properties.snag_a_slip_url": "string",
    "properties.state": "string",
    "properties.timezone": "string",
    "properties.total_money_raised": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterfollowers": "string",
    "properties.twitterhandle": "string",
    "properties.type": "string",
    "properties.web_technologies": "string",
    "properties.website": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2174
    • schema_scan_id: 6108979
    • updated: 2023-02-09 09:28:48
    • created: 2023-02-08 10:58:48
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_companies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_companies`\n(\n`id`STRING,`properties`struct<`address`:STRING,`annualrevenue`:STRING,`city`:STRING,`country`:STRING,`createdate`:STRING,`description`:STRING,`domain`:STRING,`engagements_last_meeting_booked`:STRING,`facebook_company_page`:STRING,`first_contact_createdate`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_last_booked_meeting_date`:STRING,`hs_last_logged_call_date`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`hs_lastmodifieddate`:STRING,`hs_latest_meeting_activity`:STRING,`hs_num_blockers`:STRING,`hs_num_contacts_with_buying_roles`:STRING,`hs_num_decision_makers`:STRING,`hs_num_open_deals`:STRING,`hs_object_id`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_sales_email_last_replied`:STRING,`hs_target_account_probability`:STRING,`hs_total_deal_value`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`industry`:STRING,`is_public`:STRING,`linkedin_company_page`:STRING,`linkedinbio`:STRING,`name`:STRING,`new_lead_status`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_associated_contacts`:STRING,`num_contacted_notes`:STRING,`num_conversion_events`:STRING,`num_notes`:STRING,`number_of_slips_new`:STRING,`numberofemployees`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`size`:STRING,`state`:STRING,`timezone`:STRING,`twitterhandle`:STRING,`web_technologies`:STRING,`website`:STRING,`zip`:STRING,`closedate`:STRING,`days_to_close`:STRING,`first_deal_created_date`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`hs_date_entered_customer`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_opportunity`:STRING,`hs_last_open_task_date`:STRING,`hs_pinned_engagement_id`:STRING,`hs_time_in_customer`:STRING,`hs_time_in_opportunity`:STRING,`hs_updated_by_user_id`:STRING,`lifecyclestage`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`services_offered`:STRING,`total_revenue`:STRING,`current_vendor_new`:STRING,`founded_year`:STRING,`address2`:STRING,`hs_num_child_companies`:STRING,`current_software`:STRING,`hs_last_sales_activity_type`:STRING,`hs_parent_company_id`:STRING,`hs_pipeline`:STRING,`hs_lead_status`:STRING,`hs_merged_object_ids`:STRING,`trade_show`:STRING,`client_or_churned`:STRING,`must_haves`:STRING,`enterprise_opportunity`:STRING,`total_money_raised`:STRING,`email`:STRING,`hs_additional_domains`:STRING,`hs_created_by_user_id`:STRING,`inactive`:STRING,`dockwa_url`:STRING,`municipality`:STRING,`first_contact_createdate_timestamp_earliest_value_78b50eea`:STRING,`first_conversion_date_timestamp_earliest_value_61f58f2c`:STRING,`first_conversion_event_name_timestamp_earliest_value_68ddae0a`:STRING,`recent_conversion_date_timestamp_latest_value_72856da1`:STRING,`recent_conversion_event_name_timestamp_latest_value_66c820bf`:STRING,`cross_sell_deal_owner`:STRING,`cross_sell_opportunity`:STRING,`type`:STRING,`hs_is_target_account`:STRING,`qualified`:STRING,`hs_date_entered_lead`:STRING,`hs_time_in_lead`:STRING,`about_us`:STRING,`associated_company`:STRING,`mobile_phone_number`:STRING,`snag_a_slip_url`:STRING,`hs_avatar_filemanager_key`:STRING,`hs_date_exited_lead`:STRING,`marina_type`:STRING,`hs_date_entered_subscriber`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_exited_subscriber`: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_companies/2023-02-08/1675875468'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_companies"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_companies/2023-02-08/1675875468
    • id: 4692793
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-26T15:15:21.630Z",
    "id": "482395255",
    "properties": {
        "about_us": "260-833-2536",
        "address": "5 Bay Avenue",
        "address2": "E-51, INDUSTRIAL AREA, PHASE - 8",
        "annualrevenue": "10000000",
        "associated_company": "Harborlight Yacht Club - Long Beach",
        "city": "Oyster Bay",
        "client_or_churned": "Client",
        "closedate": "2019-02-01T02:55:32.878Z",
        "country": "United States",
        "createdate": "2017-06-26T15:15:21.633Z",
        "cross_sell_deal_owner": "Brian Steinman",
        "cross_sell_opportunity": "Active Stellar Deal",
        "current_software": "BiT",
        "current_vendor_new": "Lightspeed",
        "days_to_close": "584",
        "description": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "dockwa_url": "https://dockwa.com/explore/destination/qpcm5z-treasure-cove-resort-marina/referral?form=transient",
        "domain": "obmc.com",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "enterprise_opportunity": "true",
        "facebook_company_page": "https://facebook.com/fairwindsgolf",
        "first_contact_createdate": "2017-05-08T20:01:00.460Z",
        "first_contact_createdate_timestamp_earliest_value_78b50eea": "2017-06-26T15:25:18.152Z",
        "first_conversion_date": "2017-05-08T20:01:00.460Z",
        "first_conversion_date_timestamp_earliest_value_61f58f2c": "2018-11-29T13:07:39.656Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_conversion_event_name_timestamp_earliest_value_68ddae0a": "2018-11-29T13:07:39.656Z",
        "first_deal_created_date": "2017-06-27T18:08:34.219Z",
        "founded_year": "1962",
        "hs_additional_domains": "",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_owner_ids": "143909472",
        "hs_all_team_ids": "242125",
        "hs_analytics_first_timestamp": "2017-05-08T19:59:30.455Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_latest_source": "EMAIL_MARKETING",
        "hs_analytics_latest_source_data_1": "hs_email",
        "hs_analytics_latest_source_data_2": "231896277",
        "hs_analytics_latest_source_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_num_page_views": "1",
        "hs_analytics_num_visits": "1",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_avatar_filemanager_key": "hubfs/2459647/defaults/company.png",
        "hs_created_by_user_id": "4428097",
        "hs_date_entered_customer": "2019-02-01T02:55:32.878Z",
        "hs_date_entered_lead": "2022-10-11T15:08:14.835Z",
        "hs_date_entered_opportunity": "2018-04-25T17:28:31.654Z",
        "hs_date_entered_subscriber": "2022-09-07T20:47:57.402Z",
        "hs_date_exited_lead": "2022-12-01T17:49:59.172Z",
        "hs_date_exited_opportunity": "2019-02-01T02:55:32.878Z",
        "hs_date_exited_subscriber": "2022-09-13T14:08:21.108Z",
        "hs_is_target_account": "true",
        "hs_last_booked_meeting_date": "2021-03-30T19:00:00Z",
        "hs_last_logged_call_date": "2022-09-27T17:26:42.381Z",
        "hs_last_open_task_date": "",
        "hs_last_sales_activity_date": "1970-01-19T22:28:37.605Z",
        "hs_last_sales_activity_timestamp": "2021-11-05T13:06:45.023Z",
        "hs_last_sales_activity_type": "EMAIL_OPEN",
        "hs_lastmodifieddate": "2022-10-31T16:11:26.581Z",
        "hs_latest_meeting_activity": "2021-03-30T19:00:00Z",
        "hs_lead_status": "",
        "hs_merged_object_ids": "493670335",
        "hs_num_blockers": "0",
        "hs_num_child_companies": "1",
        "hs_num_contacts_with_buying_roles": "0",
        "hs_num_decision_makers": "0",
        "hs_num_open_deals": "0",
        "hs_object_id": "482395256",
        "hs_parent_company_id": "5381607886",
        "hs_pinned_engagement_id": "12127112285",
        "hs_pipeline": "companies-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "1.53",
        "hs_sales_email_last_replied": "2021-03-31T21:30:17Z",
        "hs_target_account_probability": "0.598552942276001",
        "hs_time_in_customer": "126885644876",
        "hs_time_in_lead": "10374485137",
        "hs_time_in_opportunity": "24312421224",
        "hs_time_in_subscriber": "13291761672",
        "hs_total_deal_value": "",
        "hs_updated_by_user_id": "27059645",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "28353587",
        "hubspot_owner_assigneddate": "2022-02-17T14:24:51.814Z",
        "hubspot_owner_id": "143909472",
        "hubspot_team_id": "242125",
        "inactive": "true",
        "industry": "",
        "is_public": "false",
        "lifecyclestage": "customer",
        "linkedin_company_page": "https://www.linkedin.com/company/oyster-bay-marine-center-inc",
        "linkedinbio": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "marina_type": "Slips",
        "mobile_phone_number": "(619) 807-7245",
        "municipality": "true",
        "must_haves": "PO Process",
        "name": "Oyster Bay Marine Center - OBMC",
        "new_lead_status": "Demoed;Prospect",
        "notes_last_contacted": "2022-09-27T17:26:42.381Z",
        "notes_last_updated": "2022-09-27T18:45:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "1",
        "num_associated_deals": "1",
        "num_contacted_notes": "56",
        "num_conversion_events": "2",
        "num_notes": "77",
        "number_of_slips_new": "282",
        "numberofemployees": "25",
        "phone": "+1 516-624-2400",
        "qualified": "false",
        "recent_conversion_date": "2018-04-25T16:59:29.483Z",
        "recent_conversion_date_timestamp_latest_value_72856da1": "2018-11-29T13:07:39.656Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "recent_conversion_event_name_timestamp_latest_value_66c820bf": "2018-11-29T13:07:39.656Z",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "services_offered": "Dry Storage;Slips",
        "size": "ENT",
        "snag_a_slip_url": "https://www.snagaslip.com/gulf-coast-marinas/louisiana/lake-catherine-island-marina",
        "state": "FL",
        "timezone": "America/Vancouver",
        "total_money_raised": "3M",
        "total_revenue": "",
        "trade_show": "MRA",
        "twitterhandle": "fairwindsgolf",
        "type": "PROSPECT",
        "web_technologies": "microsoft_exchange_online;mailchimp;wordpress;google_tag_manager;salesforce;woo_commerce;amazon_s3;microsoft_office_365;apache;go_squared;google_analytics;outlook",
        "website": "fairwinds.ca",
        "zip": "V9P 9J6"
    },
    "updatedAt": "2023-01-15T06:16:29.640Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.about_us": "string",
    "properties.address": "string",
    "properties.address2": "string",
    "properties.annualrevenue": "string",
    "properties.associated_company": "string",
    "properties.city": "string",
    "properties.client_or_churned": "string",
    "properties.closedate": "string",
    "properties.closedate_timestamp_earliest_value_a2a17e6e": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.cross_sell_deal_owner": "string",
    "properties.cross_sell_opportunity": "string",
    "properties.current_product": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.description": "string",
    "properties.dockwa_url": "string",
    "properties.domain": "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.enterprise_opportunity": "string",
    "properties.facebook_company_page": "string",
    "properties.facebookfans": "string",
    "properties.first_contact_createdate": "string",
    "properties.first_contact_createdate_timestamp_earliest_value_78b50eea": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_date_timestamp_earliest_value_61f58f2c": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a": "string",
    "properties.first_deal_created_date": "string",
    "properties.founded_year": "string",
    "properties.googleplus_page": "string",
    "properties.hs_additional_domains": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_num_visits_cardinality_sum_53d952a6": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400": "string",
    "properties.hs_analytics_source_timestamp_earliest_value_25a3a52c": "string",
    "properties.hs_avatar_filemanager_key": "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_ideal_customer_profile": "string",
    "properties.hs_is_target_account": "string",
    "properties.hs_last_booked_meeting_date": "string",
    "properties.hs_last_logged_call_date": "string",
    "properties.hs_last_open_task_date": "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_createdate_of_active_subscriptions": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_num_blockers": "string",
    "properties.hs_num_child_companies": "string",
    "properties.hs_num_contacts_with_buying_roles": "string",
    "properties.hs_num_decision_makers": "string",
    "properties.hs_num_open_deals": "string",
    "properties.hs_object_id": "string",
    "properties.hs_parent_company_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_target_account": "string",
    "properties.hs_target_account_probability": "string",
    "properties.hs_target_account_recommendation_snooze_time": "string",
    "properties.hs_target_account_recommendation_state": "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_total_deal_value": "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.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.is_public": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedin_company_page": "string",
    "properties.linkedinbio": "string",
    "properties.marina_type": "string",
    "properties.mobile_phone_number": "string",
    "properties.municipality": "string",
    "properties.must_haves": "string",
    "properties.name": "string",
    "properties.new_lead_status": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_conversion_events_cardinality_sum_d095f14b": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips_new": "string",
    "properties.numberofemployees": "string",
    "properties.owneremail": "string",
    "properties.ownername": "string",
    "properties.phone": "string",
    "properties.qualified": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_date_timestamp_latest_value_72856da1": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_conversion_event_name_timestamp_latest_value_66c820bf": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.requested_feature": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slips__service_or_both": "string",
    "properties.snag_a_slip_url": "string",
    "properties.state": "string",
    "properties.timezone": "string",
    "properties.total_money_raised": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterfollowers": "string",
    "properties.twitterhandle": "string",
    "properties.type": "string",
    "properties.web_technologies": "string",
    "properties.website": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2174
    • schema_scan_id: 6106923
    • updated: 2023-02-08 10:58:59
    • created: 2023-01-09 16:27:56
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_companies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_companies`\n(\n`id`STRING,`properties`struct<`address`:STRING,`annualrevenue`:STRING,`city`:STRING,`country`:STRING,`createdate`:STRING,`description`:STRING,`domain`:STRING,`engagements_last_meeting_booked`:STRING,`facebook_company_page`:STRING,`first_contact_createdate`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_last_booked_meeting_date`:STRING,`hs_last_logged_call_date`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`hs_lastmodifieddate`:STRING,`hs_latest_meeting_activity`:STRING,`hs_num_blockers`:STRING,`hs_num_contacts_with_buying_roles`:STRING,`hs_num_decision_makers`:STRING,`hs_num_open_deals`:STRING,`hs_object_id`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_sales_email_last_replied`:STRING,`hs_target_account_probability`:STRING,`hs_total_deal_value`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`industry`:STRING,`is_public`:STRING,`linkedin_company_page`:STRING,`linkedinbio`:STRING,`name`:STRING,`new_lead_status`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_associated_contacts`:STRING,`num_contacted_notes`:STRING,`num_conversion_events`:STRING,`num_notes`:STRING,`number_of_slips_new`:STRING,`numberofemployees`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`size`:STRING,`state`:STRING,`timezone`:STRING,`twitterhandle`:STRING,`web_technologies`:STRING,`website`:STRING,`zip`:STRING,`closedate`:STRING,`days_to_close`:STRING,`first_deal_created_date`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`hs_date_entered_customer`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_opportunity`:STRING,`hs_last_open_task_date`:STRING,`hs_pinned_engagement_id`:STRING,`hs_time_in_customer`:STRING,`hs_time_in_opportunity`:STRING,`hs_updated_by_user_id`:STRING,`lifecyclestage`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`services_offered`:STRING,`total_revenue`:STRING,`current_vendor_new`:STRING,`founded_year`:STRING,`address2`:STRING,`hs_num_child_companies`:STRING,`current_software`:STRING,`hs_last_sales_activity_type`:STRING,`hs_parent_company_id`:STRING,`hs_pipeline`:STRING,`hs_lead_status`:STRING,`hs_merged_object_ids`:STRING,`trade_show`:STRING,`client_or_churned`:STRING,`must_haves`:STRING,`enterprise_opportunity`:STRING,`total_money_raised`:STRING,`email`:STRING,`hs_additional_domains`:STRING,`hs_created_by_user_id`:STRING,`inactive`:STRING,`dockwa_url`:STRING,`municipality`:STRING,`first_contact_createdate_timestamp_earliest_value_78b50eea`:STRING,`first_conversion_date_timestamp_earliest_value_61f58f2c`:STRING,`first_conversion_event_name_timestamp_earliest_value_68ddae0a`:STRING,`recent_conversion_date_timestamp_latest_value_72856da1`:STRING,`recent_conversion_event_name_timestamp_latest_value_66c820bf`:STRING,`cross_sell_deal_owner`:STRING,`cross_sell_opportunity`:STRING,`type`:STRING,`hs_is_target_account`:STRING,`qualified`:STRING,`hs_date_entered_lead`:STRING,`hs_time_in_lead`:STRING,`about_us`:STRING,`associated_company`:STRING,`mobile_phone_number`:STRING,`snag_a_slip_url`:STRING,`hs_avatar_filemanager_key`:STRING,`hs_date_exited_lead`:STRING,`marina_type`:STRING,`hs_date_entered_subscriber`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_exited_subscriber`: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_companies/2023-01-09/1673303135'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_companies"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_companies/2023-01-09/1673303135
    • id: 4692011
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-26T15:15:21.630Z",
    "id": "482395255",
    "properties": {
        "about_us": "260-833-2536",
        "address": "5 Bay Avenue",
        "address2": "E-51, INDUSTRIAL AREA, PHASE - 8",
        "annualrevenue": "10000000",
        "associated_company": "Harborlight Yacht Club - Long Beach",
        "city": "Oyster Bay",
        "client_or_churned": "Client",
        "closedate": "2019-02-01T02:55:32.878Z",
        "country": "United States",
        "createdate": "2017-06-26T15:15:21.633Z",
        "cross_sell_deal_owner": "Brian Steinman",
        "cross_sell_opportunity": "Active Stellar Deal",
        "current_software": "BiT",
        "current_vendor_new": "Lightspeed",
        "days_to_close": "584",
        "description": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "dockwa_url": "https://dockwa.com/explore/destination/qpcm5z-treasure-cove-resort-marina/referral?form=transient",
        "domain": "obmc.com",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "enterprise_opportunity": "true",
        "facebook_company_page": "https://facebook.com/fairwindsgolf",
        "first_contact_createdate": "2017-05-08T20:01:00.460Z",
        "first_contact_createdate_timestamp_earliest_value_78b50eea": "2017-06-26T15:25:18.152Z",
        "first_conversion_date": "2017-05-08T20:01:00.460Z",
        "first_conversion_date_timestamp_earliest_value_61f58f2c": "2018-11-29T13:07:39.656Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_conversion_event_name_timestamp_earliest_value_68ddae0a": "2018-11-29T13:07:39.656Z",
        "first_deal_created_date": "2017-06-27T18:08:34.219Z",
        "founded_year": "1962",
        "hs_additional_domains": "",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_owner_ids": "143909472",
        "hs_all_team_ids": "242125",
        "hs_analytics_first_timestamp": "2017-05-08T19:59:30.455Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_latest_source": "EMAIL_MARKETING",
        "hs_analytics_latest_source_data_1": "hs_email",
        "hs_analytics_latest_source_data_2": "231896277",
        "hs_analytics_latest_source_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_num_page_views": "1",
        "hs_analytics_num_visits": "1",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_avatar_filemanager_key": "hubfs/2459647/defaults/company.png",
        "hs_created_by_user_id": "4428097",
        "hs_date_entered_customer": "2019-02-01T02:55:32.878Z",
        "hs_date_entered_lead": "2022-10-11T15:08:14.835Z",
        "hs_date_entered_opportunity": "2018-04-25T17:28:31.654Z",
        "hs_date_entered_subscriber": "2022-09-07T20:47:57.402Z",
        "hs_date_exited_lead": "2022-12-01T17:49:59.172Z",
        "hs_date_exited_opportunity": "2019-02-01T02:55:32.878Z",
        "hs_date_exited_subscriber": "2022-09-13T14:08:21.108Z",
        "hs_is_target_account": "true",
        "hs_last_booked_meeting_date": "2021-03-30T19:00:00Z",
        "hs_last_logged_call_date": "2022-09-27T17:26:42.381Z",
        "hs_last_open_task_date": "",
        "hs_last_sales_activity_date": "1970-01-19T22:28:37.605Z",
        "hs_last_sales_activity_timestamp": "2021-11-05T13:06:45.023Z",
        "hs_last_sales_activity_type": "EMAIL_OPEN",
        "hs_lastmodifieddate": "2022-10-31T16:11:26.581Z",
        "hs_latest_meeting_activity": "2021-03-30T19:00:00Z",
        "hs_lead_status": "",
        "hs_merged_object_ids": "493670335",
        "hs_num_blockers": "0",
        "hs_num_child_companies": "1",
        "hs_num_contacts_with_buying_roles": "0",
        "hs_num_decision_makers": "0",
        "hs_num_open_deals": "0",
        "hs_object_id": "482395256",
        "hs_parent_company_id": "5381607886",
        "hs_pinned_engagement_id": "12127112285",
        "hs_pipeline": "companies-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "1.53",
        "hs_sales_email_last_replied": "2021-03-31T21:30:17Z",
        "hs_target_account_probability": "0.598552942276001",
        "hs_time_in_customer": "124313018081",
        "hs_time_in_lead": "7801858161",
        "hs_time_in_opportunity": "24312421224",
        "hs_time_in_subscriber": "10719141753",
        "hs_total_deal_value": "",
        "hs_updated_by_user_id": "27059645",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "28353587",
        "hubspot_owner_assigneddate": "2022-02-17T14:24:51.814Z",
        "hubspot_owner_id": "143909472",
        "hubspot_team_id": "242125",
        "inactive": "true",
        "industry": "",
        "is_public": "false",
        "lifecyclestage": "customer",
        "linkedin_company_page": "https://www.linkedin.com/company/oyster-bay-marine-center-inc",
        "linkedinbio": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "marina_type": "Slips",
        "mobile_phone_number": "(619) 807-7245",
        "municipality": "true",
        "must_haves": "PO Process",
        "name": "Oyster Bay Marine Center - OBMC",
        "new_lead_status": "Demoed;Prospect",
        "notes_last_contacted": "2022-09-27T17:26:42.381Z",
        "notes_last_updated": "2022-09-27T18:45:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "1",
        "num_associated_deals": "1",
        "num_contacted_notes": "56",
        "num_conversion_events": "2",
        "num_notes": "77",
        "number_of_slips_new": "282",
        "numberofemployees": "25",
        "phone": "+1 516-624-2400",
        "qualified": "false",
        "recent_conversion_date": "2018-04-25T16:59:29.483Z",
        "recent_conversion_date_timestamp_latest_value_72856da1": "2018-11-29T13:07:39.656Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "recent_conversion_event_name_timestamp_latest_value_66c820bf": "2018-11-29T13:07:39.656Z",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "services_offered": "Dry Storage;Slips",
        "size": "ENT",
        "snag_a_slip_url": "https://www.snagaslip.com/gulf-coast-marinas/louisiana/lake-catherine-island-marina",
        "state": "FL",
        "timezone": "America/Vancouver",
        "total_money_raised": "3M",
        "total_revenue": "",
        "trade_show": "MRA",
        "twitterhandle": "fairwindsgolf",
        "type": "PROSPECT",
        "web_technologies": "microsoft_exchange_online;mailchimp;wordpress;google_tag_manager;salesforce;woo_commerce;amazon_s3;microsoft_office_365;apache;go_squared;google_analytics;outlook",
        "website": "fairwinds.ca",
        "zip": "V9P 9J6"
    },
    "updatedAt": "2022-12-15T14:23:21.577Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.about_us": "string",
    "properties.address": "string",
    "properties.address2": "string",
    "properties.annualrevenue": "string",
    "properties.associated_company": "string",
    "properties.city": "string",
    "properties.client_or_churned": "string",
    "properties.closedate": "string",
    "properties.closedate_timestamp_earliest_value_a2a17e6e": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.cross_sell_deal_owner": "string",
    "properties.cross_sell_opportunity": "string",
    "properties.current_product": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.description": "string",
    "properties.dockwa_url": "string",
    "properties.domain": "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.enterprise_opportunity": "string",
    "properties.facebook_company_page": "string",
    "properties.facebookfans": "string",
    "properties.first_contact_createdate": "string",
    "properties.first_contact_createdate_timestamp_earliest_value_78b50eea": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_date_timestamp_earliest_value_61f58f2c": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a": "string",
    "properties.first_deal_created_date": "string",
    "properties.founded_year": "string",
    "properties.googleplus_page": "string",
    "properties.hs_additional_domains": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_num_visits_cardinality_sum_53d952a6": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400": "string",
    "properties.hs_analytics_source_timestamp_earliest_value_25a3a52c": "string",
    "properties.hs_avatar_filemanager_key": "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_ideal_customer_profile": "string",
    "properties.hs_is_target_account": "string",
    "properties.hs_last_booked_meeting_date": "string",
    "properties.hs_last_logged_call_date": "string",
    "properties.hs_last_open_task_date": "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_createdate_of_active_subscriptions": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_num_blockers": "string",
    "properties.hs_num_child_companies": "string",
    "properties.hs_num_contacts_with_buying_roles": "string",
    "properties.hs_num_decision_makers": "string",
    "properties.hs_num_open_deals": "string",
    "properties.hs_object_id": "string",
    "properties.hs_parent_company_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_target_account": "string",
    "properties.hs_target_account_probability": "string",
    "properties.hs_target_account_recommendation_snooze_time": "string",
    "properties.hs_target_account_recommendation_state": "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_total_deal_value": "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.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.is_public": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedin_company_page": "string",
    "properties.linkedinbio": "string",
    "properties.marina_type": "string",
    "properties.mobile_phone_number": "string",
    "properties.municipality": "string",
    "properties.must_haves": "string",
    "properties.name": "string",
    "properties.new_lead_status": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_conversion_events_cardinality_sum_d095f14b": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips_new": "string",
    "properties.numberofemployees": "string",
    "properties.owneremail": "string",
    "properties.ownername": "string",
    "properties.phone": "string",
    "properties.qualified": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_date_timestamp_latest_value_72856da1": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_conversion_event_name_timestamp_latest_value_66c820bf": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.requested_feature": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slips__service_or_both": "string",
    "properties.snag_a_slip_url": "string",
    "properties.state": "string",
    "properties.timezone": "string",
    "properties.total_money_raised": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterfollowers": "string",
    "properties.twitterhandle": "string",
    "properties.type": "string",
    "properties.web_technologies": "string",
    "properties.website": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2174
    • schema_scan_id: 6067205
    • updated: 2023-01-09 16:28:07
    • created: 2023-01-09 15:52:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_companies`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_companies`\n(\n`id`STRING,`properties`struct<`address`:STRING,`annualrevenue`:STRING,`city`:STRING,`country`:STRING,`createdate`:STRING,`description`:STRING,`domain`:STRING,`engagements_last_meeting_booked`:STRING,`facebook_company_page`:STRING,`first_contact_createdate`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_last_booked_meeting_date`:STRING,`hs_last_logged_call_date`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`hs_lastmodifieddate`:STRING,`hs_latest_meeting_activity`:STRING,`hs_num_blockers`:STRING,`hs_num_contacts_with_buying_roles`:STRING,`hs_num_decision_makers`:STRING,`hs_num_open_deals`:STRING,`hs_object_id`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_sales_email_last_replied`:STRING,`hs_target_account_probability`:STRING,`hs_total_deal_value`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`industry`:STRING,`is_public`:STRING,`linkedin_company_page`:STRING,`linkedinbio`:STRING,`name`:STRING,`new_lead_status`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_associated_contacts`:STRING,`num_contacted_notes`:STRING,`num_conversion_events`:STRING,`num_notes`:STRING,`number_of_slips_new`:STRING,`numberofemployees`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`size`:STRING,`state`:STRING,`timezone`:STRING,`twitterhandle`:STRING,`web_technologies`:STRING,`website`:STRING,`zip`:STRING,`closedate`:STRING,`days_to_close`:STRING,`first_deal_created_date`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`hs_date_entered_customer`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_opportunity`:STRING,`hs_last_open_task_date`:STRING,`hs_pinned_engagement_id`:STRING,`hs_time_in_customer`:STRING,`hs_time_in_opportunity`:STRING,`hs_updated_by_user_id`:STRING,`lifecyclestage`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`services_offered`:STRING,`total_revenue`:STRING,`current_vendor_new`:STRING,`founded_year`:STRING,`address2`:STRING,`hs_num_child_companies`:STRING,`current_software`:STRING,`hs_last_sales_activity_type`:STRING,`hs_parent_company_id`:STRING,`hs_pipeline`:STRING,`hs_lead_status`:STRING,`hs_merged_object_ids`:STRING,`trade_show`:STRING,`client_or_churned`:STRING,`must_haves`:STRING,`enterprise_opportunity`:STRING,`total_money_raised`:STRING,`email`:STRING,`hs_additional_domains`:STRING,`hs_created_by_user_id`:STRING,`inactive`:STRING,`dockwa_url`:STRING,`municipality`:STRING,`first_contact_createdate_timestamp_earliest_value_78b50eea`:STRING,`first_conversion_date_timestamp_earliest_value_61f58f2c`:STRING,`first_conversion_event_name_timestamp_earliest_value_68ddae0a`:STRING,`recent_conversion_date_timestamp_latest_value_72856da1`:STRING,`recent_conversion_event_name_timestamp_latest_value_66c820bf`:STRING,`cross_sell_deal_owner`:STRING,`cross_sell_opportunity`:STRING,`type`:STRING,`hs_is_target_account`:STRING,`qualified`:STRING,`hs_date_entered_lead`:STRING,`hs_time_in_lead`:STRING,`about_us`:STRING,`associated_company`:STRING,`mobile_phone_number`:STRING,`snag_a_slip_url`:STRING,`hs_avatar_filemanager_key`:STRING,`hs_date_exited_lead`:STRING,`marina_type`:STRING,`hs_date_entered_subscriber`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_exited_subscriber`: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_companies/2023-01-09/1673301043'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_companies"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_companies/2023-01-09/1673301043
    • id: 4691996
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-26T15:15:21.630Z",
    "id": "482395255",
    "properties": {
        "about_us": "260-833-2536",
        "address": "5 Bay Avenue",
        "address2": "E-51, INDUSTRIAL AREA, PHASE - 8",
        "annualrevenue": "10000000",
        "associated_company": "Harborlight Yacht Club - Long Beach",
        "city": "Oyster Bay",
        "client_or_churned": "Client",
        "closedate": "2019-02-01T02:55:32.878Z",
        "country": "United States",
        "createdate": "2017-06-26T15:15:21.633Z",
        "cross_sell_deal_owner": "Brian Steinman",
        "cross_sell_opportunity": "Active Stellar Deal",
        "current_software": "BiT",
        "current_vendor_new": "Lightspeed",
        "days_to_close": "584",
        "description": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "dockwa_url": "https://dockwa.com/explore/destination/qpcm5z-treasure-cove-resort-marina/referral?form=transient",
        "domain": "obmc.com",
        "email": "[email protected]",
        "engagements_last_meeting_booked": "",
        "enterprise_opportunity": "true",
        "facebook_company_page": "https://facebook.com/fairwindsgolf",
        "first_contact_createdate": "2017-05-08T20:01:00.460Z",
        "first_contact_createdate_timestamp_earliest_value_78b50eea": "2017-06-26T15:25:18.152Z",
        "first_conversion_date": "2017-05-08T20:01:00.460Z",
        "first_conversion_date_timestamp_earliest_value_61f58f2c": "2018-11-29T13:07:39.656Z",
        "first_conversion_event_name": "Molo - Marina Management: Learn More, Website Signup",
        "first_conversion_event_name_timestamp_earliest_value_68ddae0a": "2018-11-29T13:07:39.656Z",
        "first_deal_created_date": "2017-06-27T18:08:34.219Z",
        "founded_year": "1962",
        "hs_additional_domains": "",
        "hs_all_accessible_team_ids": "242125",
        "hs_all_owner_ids": "143909472",
        "hs_all_team_ids": "242125",
        "hs_analytics_first_timestamp": "2017-05-08T19:59:30.455Z",
        "hs_analytics_first_touch_converting_campaign": "",
        "hs_analytics_first_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_last_touch_converting_campaign": "",
        "hs_analytics_last_visit_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_latest_source": "EMAIL_MARKETING",
        "hs_analytics_latest_source_data_1": "hs_email",
        "hs_analytics_latest_source_data_2": "231896277",
        "hs_analytics_latest_source_timestamp": "2022-10-31T16:10:54.230Z",
        "hs_analytics_num_page_views": "1",
        "hs_analytics_num_visits": "1",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_avatar_filemanager_key": "hubfs/2459647/defaults/company.png",
        "hs_created_by_user_id": "4428097",
        "hs_date_entered_customer": "2019-02-01T02:55:32.878Z",
        "hs_date_entered_lead": "2022-10-11T15:08:14.835Z",
        "hs_date_entered_opportunity": "2018-04-25T17:28:31.654Z",
        "hs_date_entered_subscriber": "2022-09-07T20:47:57.402Z",
        "hs_date_exited_lead": "2022-12-01T17:49:59.172Z",
        "hs_date_exited_opportunity": "2019-02-01T02:55:32.878Z",
        "hs_date_exited_subscriber": "2022-09-13T14:08:21.108Z",
        "hs_is_target_account": "true",
        "hs_last_booked_meeting_date": "2021-03-30T19:00:00Z",
        "hs_last_logged_call_date": "2022-09-27T17:26:42.381Z",
        "hs_last_open_task_date": "",
        "hs_last_sales_activity_date": "1970-01-19T22:28:37.605Z",
        "hs_last_sales_activity_timestamp": "2021-11-05T13:06:45.023Z",
        "hs_last_sales_activity_type": "EMAIL_OPEN",
        "hs_lastmodifieddate": "2022-10-31T16:11:26.581Z",
        "hs_latest_meeting_activity": "2021-03-30T19:00:00Z",
        "hs_lead_status": "",
        "hs_merged_object_ids": "493670335",
        "hs_num_blockers": "0",
        "hs_num_child_companies": "1",
        "hs_num_contacts_with_buying_roles": "0",
        "hs_num_decision_makers": "0",
        "hs_num_open_deals": "0",
        "hs_object_id": "482395256",
        "hs_parent_company_id": "5381607886",
        "hs_pinned_engagement_id": "12127112285",
        "hs_pipeline": "companies-lifecycle-pipeline",
        "hs_predictivecontactscore_v2": "1.53",
        "hs_sales_email_last_replied": "2021-03-31T21:30:17Z",
        "hs_target_account_probability": "0.598552942276001",
        "hs_time_in_customer": "124310950568",
        "hs_time_in_lead": "7799790567",
        "hs_time_in_opportunity": "24312421224",
        "hs_time_in_subscriber": "10717066666",
        "hs_total_deal_value": "",
        "hs_updated_by_user_id": "27059645",
        "hs_user_ids_of_all_notification_unfollowers": "",
        "hs_user_ids_of_all_owners": "28353587",
        "hubspot_owner_assigneddate": "2022-02-17T14:24:51.814Z",
        "hubspot_owner_id": "143909472",
        "hubspot_team_id": "242125",
        "inactive": "true",
        "industry": "",
        "is_public": "false",
        "lifecyclestage": "customer",
        "linkedin_company_page": "https://www.linkedin.com/company/oyster-bay-marine-center-inc",
        "linkedinbio": "Oyster Bay Marine Center is located in the uniquely beautiful Oyster Bay Harbor. We offer slips, moorings, launch service, winter storage, and are capable of performing any maintenance or repair your vessel requires. Come visit us today!",
        "marina_type": "Slips",
        "mobile_phone_number": "(619) 807-7245",
        "municipality": "true",
        "must_haves": "PO Process",
        "name": "Oyster Bay Marine Center - OBMC",
        "new_lead_status": "Demoed;Prospect",
        "notes_last_contacted": "2022-09-27T17:26:42.381Z",
        "notes_last_updated": "2022-09-27T18:45:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "1",
        "num_associated_deals": "1",
        "num_contacted_notes": "56",
        "num_conversion_events": "2",
        "num_notes": "77",
        "number_of_slips_new": "282",
        "numberofemployees": "25",
        "phone": "+1 516-624-2400",
        "qualified": "false",
        "recent_conversion_date": "2018-04-25T16:59:29.483Z",
        "recent_conversion_date_timestamp_latest_value_72856da1": "2018-11-29T13:07:39.656Z",
        "recent_conversion_event_name": "Molo - Marina Management: Collected form: Learn More, Website Signup",
        "recent_conversion_event_name_timestamp_latest_value_66c820bf": "2018-11-29T13:07:39.656Z",
        "recent_deal_amount": "",
        "recent_deal_close_date": "",
        "services_offered": "Dry Storage;Slips",
        "size": "ENT",
        "snag_a_slip_url": "https://www.snagaslip.com/gulf-coast-marinas/louisiana/lake-catherine-island-marina",
        "state": "FL",
        "timezone": "America/Vancouver",
        "total_money_raised": "3M",
        "total_revenue": "",
        "trade_show": "MRA",
        "twitterhandle": "fairwindsgolf",
        "type": "PROSPECT",
        "web_technologies": "microsoft_exchange_online;mailchimp;wordpress;google_tag_manager;salesforce;woo_commerce;amazon_s3;microsoft_office_365;apache;go_squared;google_analytics;outlook",
        "website": "fairwinds.ca",
        "zip": "V9P 9J6"
    },
    "updatedAt": "2022-12-15T14:23:21.577Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.about_us": "string",
    "properties.address": "string",
    "properties.address2": "string",
    "properties.annualrevenue": "string",
    "properties.associated_company": "string",
    "properties.city": "string",
    "properties.client_or_churned": "string",
    "properties.closedate": "string",
    "properties.closedate_timestamp_earliest_value_a2a17e6e": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.cross_sell_deal_owner": "string",
    "properties.cross_sell_opportunity": "string",
    "properties.current_product": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.description": "string",
    "properties.dockwa_url": "string",
    "properties.domain": "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.enterprise_opportunity": "string",
    "properties.facebook_company_page": "string",
    "properties.facebookfans": "string",
    "properties.first_contact_createdate": "string",
    "properties.first_contact_createdate_timestamp_earliest_value_78b50eea": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_date_timestamp_earliest_value_61f58f2c": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a": "string",
    "properties.first_deal_created_date": "string",
    "properties.founded_year": "string",
    "properties.googleplus_page": "string",
    "properties.hs_additional_domains": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_num_visits_cardinality_sum_53d952a6": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400": "string",
    "properties.hs_analytics_source_timestamp_earliest_value_25a3a52c": "string",
    "properties.hs_avatar_filemanager_key": "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_ideal_customer_profile": "string",
    "properties.hs_is_target_account": "string",
    "properties.hs_last_booked_meeting_date": "string",
    "properties.hs_last_logged_call_date": "string",
    "properties.hs_last_open_task_date": "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_createdate_of_active_subscriptions": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_num_blockers": "string",
    "properties.hs_num_child_companies": "string",
    "properties.hs_num_contacts_with_buying_roles": "string",
    "properties.hs_num_decision_makers": "string",
    "properties.hs_num_open_deals": "string",
    "properties.hs_object_id": "string",
    "properties.hs_parent_company_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_target_account": "string",
    "properties.hs_target_account_probability": "string",
    "properties.hs_target_account_recommendation_snooze_time": "string",
    "properties.hs_target_account_recommendation_state": "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_total_deal_value": "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.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.is_public": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedin_company_page": "string",
    "properties.linkedinbio": "string",
    "properties.marina_type": "string",
    "properties.mobile_phone_number": "string",
    "properties.municipality": "string",
    "properties.must_haves": "string",
    "properties.name": "string",
    "properties.new_lead_status": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_conversion_events_cardinality_sum_d095f14b": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips_new": "string",
    "properties.numberofemployees": "string",
    "properties.owneremail": "string",
    "properties.ownername": "string",
    "properties.phone": "string",
    "properties.qualified": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_date_timestamp_latest_value_72856da1": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_conversion_event_name_timestamp_latest_value_66c820bf": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.requested_feature": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slips__service_or_both": "string",
    "properties.snag_a_slip_url": "string",
    "properties.state": "string",
    "properties.timezone": "string",
    "properties.total_money_raised": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterfollowers": "string",
    "properties.twitterhandle": "string",
    "properties.type": "string",
    "properties.web_technologies": "string",
    "properties.website": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2174
    • schema_scan_id: 6067140
    • updated: 2023-01-09 15:52:19
Schema Scans: 4
Last at 2023-02-09 09:27:47
    • duration: 0:01:01.640060
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6108979
    • 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_companies/2023-02-09/1675956420",
        "key": "raw/hubspot_molo_companies/2023-02-09/1675956420/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_companies",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 10305142884184989510,
        "service_name": "drive-thru",
        "span_id": 5250918752493563460,
        "trace_id": 377594491488941905
    }
}
    • running: False
    • schema_name_id: 2174
    • start_time: 2023-02-09 09:27:47
    • success: True
    • trace_id: 377594491488941905
    • duration: 0:01:00.865036
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6106923
    • 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_companies/2023-02-08/1675875468",
        "key": "raw/hubspot_molo_companies/2023-02-08/1675875468/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_companies",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8205074849216264857,
        "service_name": "drive-thru",
        "span_id": 8158038098654902188,
        "trace_id": 8300171915214850714
    }
}
    • running: False
    • schema_name_id: 2174
    • start_time: 2023-02-08 10:57:58
    • success: True
    • trace_id: 8300171915214850714
    • duration: 0:00:58.123613
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6067205
    • 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_companies/2023-01-09/1673303135",
        "key": "raw/hubspot_molo_companies/2023-01-09/1673303135/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_companies",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 15240424531143312613,
        "service_name": "drive-thru",
        "span_id": 12965118747775008675,
        "trace_id": 14443713936410002835
    }
}
    • running: False
    • schema_name_id: 2174
    • start_time: 2023-01-09 16:27:09
    • success: True
    • trace_id: 14443713936410002835
    • duration: 0:00:58.376206
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6067140
    • 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_companies/2023-01-09/1673301043",
        "key": "raw/hubspot_molo_companies/2023-01-09/1673301043/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_companies",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 2139031034418122891,
        "service_name": "drive-thru",
        "span_id": 5046664378351313980,
        "trace_id": 2739566000440751634
    }
}
    • running: False
    • schema_name_id: 2174
    • start_time: 2023-01-09 15:51:21
    • success: True
    • trace_id: 2739566000440751634
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.about_us": "string",
    "properties.address": "string",
    "properties.address2": "string",
    "properties.annualrevenue": "string",
    "properties.associated_company": "string",
    "properties.city": "string",
    "properties.client_or_churned": "string",
    "properties.closedate": "string",
    "properties.closedate_timestamp_earliest_value_a2a17e6e": "string",
    "properties.country": "string",
    "properties.createdate": "string",
    "properties.cross_sell_deal_owner": "string",
    "properties.cross_sell_opportunity": "string",
    "properties.current_product": "string",
    "properties.current_software": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.description": "string",
    "properties.dockwa_url": "string",
    "properties.domain": "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.enterprise_opportunity": "string",
    "properties.facebook_company_page": "string",
    "properties.facebookfans": "string",
    "properties.first_contact_createdate": "string",
    "properties.first_contact_createdate_timestamp_earliest_value_78b50eea": "string",
    "properties.first_conversion_date": "string",
    "properties.first_conversion_date_timestamp_earliest_value_61f58f2c": "string",
    "properties.first_conversion_event_name": "string",
    "properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a": "string",
    "properties.first_deal_created_date": "string",
    "properties.founded_year": "string",
    "properties.googleplus_page": "string",
    "properties.hs_additional_domains": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_first_timestamp": "string",
    "properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a": "string",
    "properties.hs_analytics_first_touch_converting_campaign": "string",
    "properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10": "string",
    "properties.hs_analytics_first_visit_timestamp": "string",
    "properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae": "string",
    "properties.hs_analytics_last_timestamp": "string",
    "properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a": "string",
    "properties.hs_analytics_last_touch_converting_campaign": "string",
    "properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30": "string",
    "properties.hs_analytics_last_visit_timestamp": "string",
    "properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_num_page_views": "string",
    "properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0": "string",
    "properties.hs_analytics_num_visits": "string",
    "properties.hs_analytics_num_visits_cardinality_sum_53d952a6": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400": "string",
    "properties.hs_analytics_source_timestamp_earliest_value_25a3a52c": "string",
    "properties.hs_avatar_filemanager_key": "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_ideal_customer_profile": "string",
    "properties.hs_is_target_account": "string",
    "properties.hs_last_booked_meeting_date": "string",
    "properties.hs_last_logged_call_date": "string",
    "properties.hs_last_open_task_date": "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_createdate_of_active_subscriptions": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_lead_status": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_num_blockers": "string",
    "properties.hs_num_child_companies": "string",
    "properties.hs_num_contacts_with_buying_roles": "string",
    "properties.hs_num_decision_makers": "string",
    "properties.hs_num_open_deals": "string",
    "properties.hs_object_id": "string",
    "properties.hs_parent_company_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_pipeline": "string",
    "properties.hs_predictivecontactscore_v2": "string",
    "properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_target_account": "string",
    "properties.hs_target_account_probability": "string",
    "properties.hs_target_account_recommendation_snooze_time": "string",
    "properties.hs_target_account_recommendation_state": "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_total_deal_value": "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.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.hubspotscore": "string",
    "properties.inactive": "string",
    "properties.industry": "string",
    "properties.is_public": "string",
    "properties.lifecyclestage": "string",
    "properties.linkedin_company_page": "string",
    "properties.linkedinbio": "string",
    "properties.marina_type": "string",
    "properties.mobile_phone_number": "string",
    "properties.municipality": "string",
    "properties.must_haves": "string",
    "properties.name": "string",
    "properties.new_lead_status": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_associated_deals": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_conversion_events": "string",
    "properties.num_conversion_events_cardinality_sum_d095f14b": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips_new": "string",
    "properties.numberofemployees": "string",
    "properties.owneremail": "string",
    "properties.ownername": "string",
    "properties.phone": "string",
    "properties.qualified": "string",
    "properties.recent_conversion_date": "string",
    "properties.recent_conversion_date_timestamp_latest_value_72856da1": "string",
    "properties.recent_conversion_event_name": "string",
    "properties.recent_conversion_event_name_timestamp_latest_value_66c820bf": "string",
    "properties.recent_deal_amount": "string",
    "properties.recent_deal_close_date": "string",
    "properties.requested_feature": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slips__service_or_both": "string",
    "properties.snag_a_slip_url": "string",
    "properties.state": "string",
    "properties.timezone": "string",
    "properties.total_money_raised": "string",
    "properties.total_revenue": "string",
    "properties.trade_show": "string",
    "properties.twitterbio": "string",
    "properties.twitterfollowers": "string",
    "properties.twitterhandle": "string",
    "properties.type": "string",
    "properties.web_technologies": "string",
    "properties.website": "string",
    "properties.zip": "string",
    "updatedAt": "string"
}
  • created: 2023-02-09 09:28:37
  • 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_companies`\n(\n`id`STRING,`properties`struct<`address`:STRING,`annualrevenue`:STRING,`city`:STRING,`country`:STRING,`createdate`:STRING,`description`:STRING,`domain`:STRING,`engagements_last_meeting_booked`:STRING,`facebook_company_page`:STRING,`first_contact_createdate`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_last_booked_meeting_date`:STRING,`hs_last_logged_call_date`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`hs_lastmodifieddate`:STRING,`hs_latest_meeting_activity`:STRING,`hs_num_blockers`:STRING,`hs_num_contacts_with_buying_roles`:STRING,`hs_num_decision_makers`:STRING,`hs_num_open_deals`:STRING,`hs_object_id`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_sales_email_last_replied`:STRING,`hs_target_account_probability`:STRING,`hs_total_deal_value`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`industry`:STRING,`is_public`:STRING,`linkedin_company_page`:STRING,`linkedinbio`:STRING,`name`:STRING,`new_lead_status`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_associated_contacts`:STRING,`num_contacted_notes`:STRING,`num_conversion_events`:STRING,`num_notes`:STRING,`number_of_slips_new`:STRING,`numberofemployees`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`size`:STRING,`state`:STRING,`timezone`:STRING,`twitterhandle`:STRING,`web_technologies`:STRING,`website`:STRING,`zip`:STRING,`closedate`:STRING,`days_to_close`:STRING,`first_deal_created_date`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`hs_date_entered_customer`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_opportunity`:STRING,`hs_last_open_task_date`:STRING,`hs_pinned_engagement_id`:STRING,`hs_time_in_customer`:STRING,`hs_time_in_opportunity`:STRING,`hs_updated_by_user_id`:STRING,`lifecyclestage`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`services_offered`:STRING,`total_revenue`:STRING,`current_vendor_new`:STRING,`founded_year`:STRING,`address2`:STRING,`hs_num_child_companies`:STRING,`current_software`:STRING,`hs_last_sales_activity_type`:STRING,`hs_parent_company_id`:STRING,`hs_pipeline`:STRING,`hs_lead_status`:STRING,`hs_merged_object_ids`:STRING,`trade_show`:STRING,`client_or_churned`:STRING,`must_haves`:STRING,`enterprise_opportunity`:STRING,`total_money_raised`:STRING,`email`:STRING,`hs_additional_domains`:STRING,`hs_created_by_user_id`:STRING,`inactive`:STRING,`dockwa_url`:STRING,`municipality`:STRING,`first_contact_createdate_timestamp_earliest_value_78b50eea`:STRING,`first_conversion_date_timestamp_earliest_value_61f58f2c`:STRING,`first_conversion_event_name_timestamp_earliest_value_68ddae0a`:STRING,`recent_conversion_date_timestamp_latest_value_72856da1`:STRING,`recent_conversion_event_name_timestamp_latest_value_66c820bf`:STRING,`cross_sell_deal_owner`:STRING,`cross_sell_opportunity`:STRING,`type`:STRING,`hs_is_target_account`:STRING,`qualified`:STRING,`hs_date_entered_lead`:STRING,`hs_time_in_lead`:STRING,`about_us`:STRING,`associated_company`:STRING,`mobile_phone_number`:STRING,`snag_a_slip_url`:STRING,`hs_avatar_filemanager_key`:STRING,`hs_date_exited_lead`:STRING,`marina_type`:STRING,`hs_date_entered_subscriber`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_exited_subscriber`: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_companies/2023-02-09/1675956420'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_companies`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_companies"
}
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:20",
        "disabled": false,
        "format": "raw",
        "id": 2174,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "hubspot_molo_companies"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "createdAt": "string",
            "id": "string",
            "properties.about_us": "string",
            "properties.address": "string",
            "properties.address2": "string",
            "properties.annualrevenue": "string",
            "properties.associated_company": "string",
            "properties.city": "string",
            "properties.client_or_churned": "string",
            "properties.closedate": "string",
            "properties.closedate_timestamp_earliest_value_a2a17e6e": "string",
            "properties.country": "string",
            "properties.createdate": "string",
            "properties.cross_sell_deal_owner": "string",
            "properties.cross_sell_opportunity": "string",
            "properties.current_product": "string",
            "properties.current_software": "string",
            "properties.current_vendor_new": "string",
            "properties.days_to_close": "string",
            "properties.description": "string",
            "properties.dockwa_url": "string",
            "properties.domain": "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.enterprise_opportunity": "string",
            "properties.facebook_company_page": "string",
            "properties.facebookfans": "string",
            "properties.first_contact_createdate": "string",
            "properties.first_contact_createdate_timestamp_earliest_value_78b50eea": "string",
            "properties.first_conversion_date": "string",
            "properties.first_conversion_date_timestamp_earliest_value_61f58f2c": "string",
            "properties.first_conversion_event_name": "string",
            "properties.first_conversion_event_name_timestamp_earliest_value_68ddae0a": "string",
            "properties.first_deal_created_date": "string",
            "properties.founded_year": "string",
            "properties.googleplus_page": "string",
            "properties.hs_additional_domains": "string",
            "properties.hs_all_accessible_team_ids": "string",
            "properties.hs_all_assigned_business_unit_ids": "string",
            "properties.hs_all_owner_ids": "string",
            "properties.hs_all_team_ids": "string",
            "properties.hs_analytics_first_timestamp": "string",
            "properties.hs_analytics_first_timestamp_timestamp_earliest_value_11e3a63a": "string",
            "properties.hs_analytics_first_touch_converting_campaign": "string",
            "properties.hs_analytics_first_touch_converting_campaign_timestamp_earliest_value_4757fe10": "string",
            "properties.hs_analytics_first_visit_timestamp": "string",
            "properties.hs_analytics_first_visit_timestamp_timestamp_earliest_value_accc17ae": "string",
            "properties.hs_analytics_last_timestamp": "string",
            "properties.hs_analytics_last_timestamp_timestamp_latest_value_4e16365a": "string",
            "properties.hs_analytics_last_touch_converting_campaign": "string",
            "properties.hs_analytics_last_touch_converting_campaign_timestamp_latest_value_81a64e30": "string",
            "properties.hs_analytics_last_visit_timestamp": "string",
            "properties.hs_analytics_last_visit_timestamp_timestamp_latest_value_999a0fce": "string",
            "properties.hs_analytics_latest_source": "string",
            "properties.hs_analytics_latest_source_data_1": "string",
            "properties.hs_analytics_latest_source_data_2": "string",
            "properties.hs_analytics_latest_source_timestamp": "string",
            "properties.hs_analytics_num_page_views": "string",
            "properties.hs_analytics_num_page_views_cardinality_sum_e46e85b0": "string",
            "properties.hs_analytics_num_visits": "string",
            "properties.hs_analytics_num_visits_cardinality_sum_53d952a6": "string",
            "properties.hs_analytics_source": "string",
            "properties.hs_analytics_source_data_1": "string",
            "properties.hs_analytics_source_data_1_timestamp_earliest_value_9b2f1fa1": "string",
            "properties.hs_analytics_source_data_2": "string",
            "properties.hs_analytics_source_data_2_timestamp_earliest_value_9b2f9400": "string",
            "properties.hs_analytics_source_timestamp_earliest_value_25a3a52c": "string",
            "properties.hs_avatar_filemanager_key": "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_ideal_customer_profile": "string",
            "properties.hs_is_target_account": "string",
            "properties.hs_last_booked_meeting_date": "string",
            "properties.hs_last_logged_call_date": "string",
            "properties.hs_last_open_task_date": "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_createdate_of_active_subscriptions": "string",
            "properties.hs_latest_meeting_activity": "string",
            "properties.hs_lead_status": "string",
            "properties.hs_merged_object_ids": "string",
            "properties.hs_num_blockers": "string",
            "properties.hs_num_child_companies": "string",
            "properties.hs_num_contacts_with_buying_roles": "string",
            "properties.hs_num_decision_makers": "string",
            "properties.hs_num_open_deals": "string",
            "properties.hs_object_id": "string",
            "properties.hs_parent_company_id": "string",
            "properties.hs_pinned_engagement_id": "string",
            "properties.hs_pipeline": "string",
            "properties.hs_predictivecontactscore_v2": "string",
            "properties.hs_predictivecontactscore_v2_next_max_max_d4e58c1e": "string",
            "properties.hs_read_only": "string",
            "properties.hs_sales_email_last_replied": "string",
            "properties.hs_target_account": "string",
            "properties.hs_target_account_probability": "string",
            "properties.hs_target_account_recommendation_snooze_time": "string",
            "properties.hs_target_account_recommendation_state": "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_total_deal_value": "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.hubspot_owner_assigneddate": "string",
            "properties.hubspot_owner_id": "string",
            "properties.hubspot_team_id": "string",
            "properties.hubspotscore": "string",
            "properties.inactive": "string",
            "properties.industry": "string",
            "properties.is_public": "string",
            "properties.lifecyclestage": "string",
            "properties.linkedin_company_page": "string",
            "properties.linkedinbio": "string",
            "properties.marina_type": "string",
            "properties.mobile_phone_number": "string",
            "properties.municipality": "string",
            "properties.must_haves": "string",
            "properties.name": "string",
            "properties.new_lead_status": "string",
            "properties.notes_last_contacted": "string",
            "properties.notes_last_updated": "string",
            "properties.notes_next_activity_date": "string",
            "properties.num_associated_contacts": "string",
            "properties.num_associated_deals": "string",
            "properties.num_contacted_notes": "string",
            "properties.num_conversion_events": "string",
            "properties.num_conversion_events_cardinality_sum_d095f14b": "string",
            "properties.num_notes": "string",
            "properties.number_of_slips_new": "string",
            "properties.numberofemployees": "string",
            "properties.owneremail": "string",
            "properties.ownername": "string",
            "properties.phone": "string",
            "properties.qualified": "string",
            "properties.recent_conversion_date": "string",
            "properties.recent_conversion_date_timestamp_latest_value_72856da1": "string",
            "properties.recent_conversion_event_name": "string",
            "properties.recent_conversion_event_name_timestamp_latest_value_66c820bf": "string",
            "properties.recent_deal_amount": "string",
            "properties.recent_deal_close_date": "string",
            "properties.requested_feature": "string",
            "properties.services_offered": "string",
            "properties.size": "string",
            "properties.slips__service_or_both": "string",
            "properties.snag_a_slip_url": "string",
            "properties.state": "string",
            "properties.timezone": "string",
            "properties.total_money_raised": "string",
            "properties.total_revenue": "string",
            "properties.trade_show": "string",
            "properties.twitterbio": "string",
            "properties.twitterfollowers": "string",
            "properties.twitterhandle": "string",
            "properties.type": "string",
            "properties.web_technologies": "string",
            "properties.website": "string",
            "properties.zip": "string",
            "updatedAt": "string"
        },
        "created": "2023-02-09 09:28:37",
        "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_companies`\n(\n`id`STRING,`properties`struct<`address`:STRING,`annualrevenue`:STRING,`city`:STRING,`country`:STRING,`createdate`:STRING,`description`:STRING,`domain`:STRING,`engagements_last_meeting_booked`:STRING,`facebook_company_page`:STRING,`first_contact_createdate`:STRING,`first_conversion_date`:STRING,`first_conversion_event_name`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_analytics_first_timestamp`:STRING,`hs_analytics_first_visit_timestamp`:STRING,`hs_analytics_last_timestamp`:STRING,`hs_analytics_last_visit_timestamp`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_num_page_views`:STRING,`hs_analytics_num_visits`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_last_booked_meeting_date`:STRING,`hs_last_logged_call_date`:STRING,`hs_last_sales_activity_date`:STRING,`hs_last_sales_activity_timestamp`:STRING,`hs_lastmodifieddate`:STRING,`hs_latest_meeting_activity`:STRING,`hs_num_blockers`:STRING,`hs_num_contacts_with_buying_roles`:STRING,`hs_num_decision_makers`:STRING,`hs_num_open_deals`:STRING,`hs_object_id`:STRING,`hs_predictivecontactscore_v2`:STRING,`hs_sales_email_last_replied`:STRING,`hs_target_account_probability`:STRING,`hs_total_deal_value`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`industry`:STRING,`is_public`:STRING,`linkedin_company_page`:STRING,`linkedinbio`:STRING,`name`:STRING,`new_lead_status`:STRING,`notes_last_contacted`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_associated_contacts`:STRING,`num_contacted_notes`:STRING,`num_conversion_events`:STRING,`num_notes`:STRING,`number_of_slips_new`:STRING,`numberofemployees`:STRING,`phone`:STRING,`recent_conversion_date`:STRING,`recent_conversion_event_name`:STRING,`size`:STRING,`state`:STRING,`timezone`:STRING,`twitterhandle`:STRING,`web_technologies`:STRING,`website`:STRING,`zip`:STRING,`closedate`:STRING,`days_to_close`:STRING,`first_deal_created_date`:STRING,`hs_analytics_first_touch_converting_campaign`:STRING,`hs_analytics_last_touch_converting_campaign`:STRING,`hs_date_entered_customer`:STRING,`hs_date_entered_opportunity`:STRING,`hs_date_exited_opportunity`:STRING,`hs_last_open_task_date`:STRING,`hs_pinned_engagement_id`:STRING,`hs_time_in_customer`:STRING,`hs_time_in_opportunity`:STRING,`hs_updated_by_user_id`:STRING,`lifecyclestage`:STRING,`num_associated_deals`:STRING,`recent_deal_amount`:STRING,`recent_deal_close_date`:STRING,`services_offered`:STRING,`total_revenue`:STRING,`current_vendor_new`:STRING,`founded_year`:STRING,`address2`:STRING,`hs_num_child_companies`:STRING,`current_software`:STRING,`hs_last_sales_activity_type`:STRING,`hs_parent_company_id`:STRING,`hs_pipeline`:STRING,`hs_lead_status`:STRING,`hs_merged_object_ids`:STRING,`trade_show`:STRING,`client_or_churned`:STRING,`must_haves`:STRING,`enterprise_opportunity`:STRING,`total_money_raised`:STRING,`email`:STRING,`hs_additional_domains`:STRING,`hs_created_by_user_id`:STRING,`inactive`:STRING,`dockwa_url`:STRING,`municipality`:STRING,`first_contact_createdate_timestamp_earliest_value_78b50eea`:STRING,`first_conversion_date_timestamp_earliest_value_61f58f2c`:STRING,`first_conversion_event_name_timestamp_earliest_value_68ddae0a`:STRING,`recent_conversion_date_timestamp_latest_value_72856da1`:STRING,`recent_conversion_event_name_timestamp_latest_value_66c820bf`:STRING,`cross_sell_deal_owner`:STRING,`cross_sell_opportunity`:STRING,`type`:STRING,`hs_is_target_account`:STRING,`qualified`:STRING,`hs_date_entered_lead`:STRING,`hs_time_in_lead`:STRING,`about_us`:STRING,`associated_company`:STRING,`mobile_phone_number`:STRING,`snag_a_slip_url`:STRING,`hs_avatar_filemanager_key`:STRING,`hs_date_exited_lead`:STRING,`marina_type`:STRING,`hs_date_entered_subscriber`:STRING,`hs_time_in_subscriber`:STRING,`hs_date_exited_subscriber`: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_companies/2023-02-09/1675956420'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_companies`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_companies"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}
©2019 SpareFoot Data Platform