Schema Info

Schema Name: sfdl_dev_drivethru.hubspot_molo_deals
  • created: 2022-11-30 12:59:12
  • disabled: False
  • format: raw
  • id: 2173
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_dev_drivethru",
    "table": "hubspot_molo_deals"
}
  • type: drivethrujson
Schema Versions: 4
    • created: 2023-02-09 09:27:35
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`days_to_close`:STRING,`deal_value`:STRING,`dealname`:STRING,`dealstage`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_company`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_1_company`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_data_2_company`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_closed_amount`:STRING,`hs_closed_amount_in_home_currency`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_closed`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`current_vendor_new`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_date_entered_23229964`:STRING,`hs_date_entered_23229965`:STRING,`hs_date_entered_23229966`:STRING,`hs_date_entered_23229967`:STRING,`hs_date_entered_23229968`:STRING,`hs_date_entered_closedwon`:STRING,`hs_date_exited_23229964`:STRING,`hs_date_exited_23229965`:STRING,`hs_date_exited_23229966`:STRING,`hs_date_exited_23229967`:STRING,`hs_date_exited_23229968`:STRING,`hs_time_in_23229964`:STRING,`hs_time_in_23229965`:STRING,`hs_time_in_23229966`:STRING,`hs_time_in_23229967`:STRING,`hs_time_in_23229968`:STRING,`hs_time_in_closedwon`:STRING,`hs_analytics_latest_source_contact`:STRING,`hs_analytics_latest_source_data_1_contact`:STRING,`hs_analytics_latest_source_data_2_contact`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`head_to_head_competitor`:STRING,`hs_forecast_amount`:STRING,`hs_projected_amount`:STRING,`hs_projected_amount_in_home_currency`:STRING,`hs_sales_email_last_replied`:STRING,`likelihood`:STRING,`next_step`:STRING,`next_step_date`:STRING,`source`:STRING,`vendor_lost_to`:STRING,`engagements_last_meeting_booked`:STRING,`forecast_category`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_latest_meeting_activity`:STRING,`needs_quickbooks_desktop_integration`:STRING,`hs_pinned_engagement_id`:STRING,`micro`:STRING,`deal_currency_code`:STRING,`hs_created_by_user_id`:STRING,`hs_date_entered_contractsent`:STRING,`hs_date_entered_decisionmakerboughtin`:STRING,`hs_date_entered_presentationscheduled`:STRING,`hs_date_entered_qualifiedtobuy`:STRING,`hs_date_exited_decisionmakerboughtin`:STRING,`hs_date_exited_presentationscheduled`:STRING,`hs_date_exited_qualifiedtobuy`:STRING,`hs_merged_object_ids`:STRING,`hs_predicted_amount`:STRING,`hs_predicted_amount_in_home_currency`:STRING,`hs_time_in_contractsent`:STRING,`hs_time_in_decisionmakerboughtin`:STRING,`hs_time_in_presentationscheduled`:STRING,`hs_time_in_qualifiedtobuy`:STRING,`hs_date_exited_contractsent`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`must_have_feature_explanation`:STRING,`must_have_features`:STRING,`accounting_integration_desired`:STRING,`additional_notes_or_comments`:STRING,`address`:STRING,`annual_or_monthly`:STRING,`current_accounting_software`:STRING,`deal_value__usd_`:STRING,`enterprise__3__locations_`:STRING,`modules`:STRING,`municipality__city__or_county_owned_property_`:STRING,`of_resources`:STRING,`of_slips`:STRING,`perform_date`:STRING,`point_of_contact`:STRING,`title__role___responsibilities`:STRING,`website`:STRING,`hs_num_associated_deal_splits`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`hs_exchange_rate`: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_deals/2023-02-09/1675956416'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_deals/2023-02-09/1675956416
    • id: 4692829
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "additional_notes_or_comments": "mike operations\nlindsay office admin\nstephen consultant also helping with secure internet etc\nqb and google drive\n3mm in revenue, up from 300k two years ago\nlikes how we organize the workflow\n15% (maybe 50? but don't think so) then the rest at launch\ndry= 28 acres, 320 this year) + 45 slips + service=7 speciality techs, 15 employees at the marina\ninsurance is notes, QB, don't check, contract is blanket\ninventory is eyeballing\ncalendar is huge\nall around great fit\nemployees enter time in QBs\nwill be relaying for QBO integration/setup\nlindsey been there 2 months, Mike 4 months\n\n",
        "address": "137 Endeavor Ave, Hubbards, Halifax, B0J 1T0 \n",
        "amount": "18039.9",
        "amount_in_home_currency": "18039.9",
        "annual_or_monthly": "Annual",
        "caller_owner": "60367669",
        "closed_lost_reason": "Deal Cleanup",
        "closed_lost_reason12": "Cleanup",
        "closed_won_reason": "Oasis / Snag a Slip Marina",
        "closed_won_reason1": "Online Booking",
        "closedate": "2021-05-13T01:14:35.164Z",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Nautical Solutions",
        "days_to_close": "1415",
        "deal_currency_code": "",
        "deal_status": "Performed - DM",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_all_accessible_team_ids": "",
        "hs_all_owner_ids": "",
        "hs_all_team_ids": "",
        "hs_analytics_latest_source": "OFFLINE",
        "hs_analytics_latest_source_company": "OFFLINE",
        "hs_analytics_latest_source_contact": "OFFLINE",
        "hs_analytics_latest_source_data_1": "INTEGRATION",
        "hs_analytics_latest_source_data_1_company": "INTEGRATION",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "206398",
        "hs_analytics_latest_source_data_2_company": "206398",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2017-06-26T15:33:09.759Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.640Z",
        "hs_date_entered_23229963": "2022-05-25T19:36:40.145Z",
        "hs_date_entered_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_closedlost": "2021-05-13T01:17:24.952Z",
        "hs_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_contractsent": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_qualifiedtobuy": "2019-09-13T14:37:45.058Z",
        "hs_date_exited_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_contractsent": "2020-05-19T13:29:28.120Z",
        "hs_date_exited_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_qualifiedtobuy": "2019-09-13T14:37:49.672Z",
        "hs_deal_stage_probability": "0",
        "hs_deal_stage_probability_shadow": "0",
        "hs_exchange_rate": "",
        "hs_forecast_amount": "0.00",
        "hs_forecast_probability": "0.0",
        "hs_is_closed": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_lastmodifieddate": "2022-08-22T14:03:46.881Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059209",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_time_in_23229963": "22448988400",
        "hs_time_in_23229964": "0",
        "hs_time_in_23229965": "0",
        "hs_time_in_23229966": "0",
        "hs_time_in_23229967": "0",
        "hs_time_in_23229968": "0",
        "hs_time_in_closedlost": "55087740370",
        "hs_time_in_closedwon": "56390839009",
        "hs_time_in_contractsent": "21511277483",
        "hs_time_in_decisionmakerboughtin": "0",
        "hs_time_in_presentationscheduled": "0",
        "hs_time_in_qualifiedtobuy": "4614",
        "hs_updated_by_user_id": "3695245",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "likelihood": "25%",
        "micro": "true",
        "modules": "Service;Slips/Rack Reservations",
        "municipality__city__or_county_owned_property_": "false",
        "must_have_feature_explanation": "N/A",
        "must_have_features": "None",
        "needs_quickbooks_desktop_integration": "Needed to Close Deal",
        "next_step": "send email to Don",
        "next_step_date": "2021-08-27",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-05-14T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_resources": "0",
        "of_slips": "375",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "second_deal_owner": "148939047",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "source": "Inbound",
        "state_region": "MA",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "website": "https://www.eastrivershipyard.ca/"
    },
    "updatedAt": "2022-05-11T17:35:09.745Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "associations.calls.paging.next.after": "string",
    "associations.calls.paging.next.link": "string",
    "associations.calls.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.companies.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.contacts.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.additional_notes_or_comments": "string",
    "properties.address": "string",
    "properties.amount": "string",
    "properties.amount_in_home_currency": "string",
    "properties.annual_or_monthly": "string",
    "properties.caller_owner": "string",
    "properties.closed_lost_reason": "string",
    "properties.closed_lost_reason12": "string",
    "properties.closed_won_reason": "string",
    "properties.closed_won_reason1": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.createdate": "string",
    "properties.current_accounting_software": "string",
    "properties.current_vendor": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.deal_currency_code": "string",
    "properties.deal_status": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.description": "string",
    "properties.discount_offered": "string",
    "properties.discount_reception_perception": "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__3__locations_": "string",
    "properties.feet_of_linear_dockage": "string",
    "properties.forecast_category": "string",
    "properties.head_to_head_competitor": "string",
    "properties.hs_acv": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_collaborator_owner_ids": "string",
    "properties.hs_all_deal_split_owner_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_company": "string",
    "properties.hs_analytics_latest_source_contact": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_1_company": "string",
    "properties.hs_analytics_latest_source_data_1_contact": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_data_2_company": "string",
    "properties.hs_analytics_latest_source_data_2_contact": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_latest_source_timestamp_company": "string",
    "properties.hs_analytics_latest_source_timestamp_contact": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_arr": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_23229963": "string",
    "properties.hs_date_entered_23229964": "string",
    "properties.hs_date_entered_23229965": "string",
    "properties.hs_date_entered_23229966": "string",
    "properties.hs_date_entered_23229967": "string",
    "properties.hs_date_entered_23229968": "string",
    "properties.hs_date_entered_appointmentscheduled": "string",
    "properties.hs_date_entered_closedlost": "string",
    "properties.hs_date_entered_closedwon": "string",
    "properties.hs_date_entered_contractsent": "string",
    "properties.hs_date_entered_decisionmakerboughtin": "string",
    "properties.hs_date_entered_presentationscheduled": "string",
    "properties.hs_date_entered_qualifiedtobuy": "string",
    "properties.hs_date_exited_23229963": "string",
    "properties.hs_date_exited_23229964": "string",
    "properties.hs_date_exited_23229965": "string",
    "properties.hs_date_exited_23229966": "string",
    "properties.hs_date_exited_23229967": "string",
    "properties.hs_date_exited_23229968": "string",
    "properties.hs_date_exited_appointmentscheduled": "string",
    "properties.hs_date_exited_closedlost": "string",
    "properties.hs_date_exited_closedwon": "string",
    "properties.hs_date_exited_contractsent": "string",
    "properties.hs_date_exited_decisionmakerboughtin": "string",
    "properties.hs_date_exited_presentationscheduled": "string",
    "properties.hs_date_exited_qualifiedtobuy": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_stage_probability": "string",
    "properties.hs_deal_stage_probability_shadow": "string",
    "properties.hs_exchange_rate": "string",
    "properties.hs_forecast_amount": "string",
    "properties.hs_forecast_probability": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_likelihood_to_close": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency_enabled": "string",
    "properties.hs_manual_forecast_category": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_mrr": "string",
    "properties.hs_next_step": "string",
    "properties.hs_num_associated_active_deal_registrations": "string",
    "properties.hs_num_associated_deal_registrations": "string",
    "properties.hs_num_associated_deal_splits": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_predicted_amount": "string",
    "properties.hs_predicted_amount_in_home_currency": "string",
    "properties.hs_priority": "string",
    "properties.hs_projected_amount": "string",
    "properties.hs_projected_amount_in_home_currency": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_tcv": "string",
    "properties.hs_time_in_23229963": "string",
    "properties.hs_time_in_23229964": "string",
    "properties.hs_time_in_23229965": "string",
    "properties.hs_time_in_23229966": "string",
    "properties.hs_time_in_23229967": "string",
    "properties.hs_time_in_23229968": "string",
    "properties.hs_time_in_appointmentscheduled": "string",
    "properties.hs_time_in_closedlost": "string",
    "properties.hs_time_in_closedwon": "string",
    "properties.hs_time_in_contractsent": "string",
    "properties.hs_time_in_decisionmakerboughtin": "string",
    "properties.hs_time_in_presentationscheduled": "string",
    "properties.hs_time_in_qualifiedtobuy": "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.likelihood": "string",
    "properties.micro": "string",
    "properties.modules": "string",
    "properties.municipality__city__or_county_owned_property_": "string",
    "properties.must_have_feature_explanation": "string",
    "properties.must_have_features": "string",
    "properties.needs_quickbooks_desktop_integration": "string",
    "properties.next_step": "string",
    "properties.next_step_date": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips": "string",
    "properties.of_resources": "string",
    "properties.of_slips": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.second_deal_owner": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.website": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2173
    • schema_scan_id: 6108976
    • updated: 2023-02-09 09:27:46
    • created: 2023-02-08 11:03:10
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`days_to_close`:STRING,`deal_value`:STRING,`dealname`:STRING,`dealstage`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_company`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_1_company`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_data_2_company`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_closed_amount`:STRING,`hs_closed_amount_in_home_currency`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_closed`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`current_vendor_new`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_date_entered_23229964`:STRING,`hs_date_entered_23229965`:STRING,`hs_date_entered_23229966`:STRING,`hs_date_entered_23229967`:STRING,`hs_date_entered_23229968`:STRING,`hs_date_entered_closedwon`:STRING,`hs_date_exited_23229964`:STRING,`hs_date_exited_23229965`:STRING,`hs_date_exited_23229966`:STRING,`hs_date_exited_23229967`:STRING,`hs_date_exited_23229968`:STRING,`hs_time_in_23229964`:STRING,`hs_time_in_23229965`:STRING,`hs_time_in_23229966`:STRING,`hs_time_in_23229967`:STRING,`hs_time_in_23229968`:STRING,`hs_time_in_closedwon`:STRING,`hs_analytics_latest_source_contact`:STRING,`hs_analytics_latest_source_data_1_contact`:STRING,`hs_analytics_latest_source_data_2_contact`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`head_to_head_competitor`:STRING,`hs_forecast_amount`:STRING,`hs_projected_amount`:STRING,`hs_projected_amount_in_home_currency`:STRING,`hs_sales_email_last_replied`:STRING,`likelihood`:STRING,`next_step`:STRING,`next_step_date`:STRING,`source`:STRING,`vendor_lost_to`:STRING,`engagements_last_meeting_booked`:STRING,`forecast_category`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_latest_meeting_activity`:STRING,`needs_quickbooks_desktop_integration`:STRING,`hs_pinned_engagement_id`:STRING,`micro`:STRING,`deal_currency_code`:STRING,`hs_created_by_user_id`:STRING,`hs_date_entered_contractsent`:STRING,`hs_date_entered_decisionmakerboughtin`:STRING,`hs_date_entered_presentationscheduled`:STRING,`hs_date_entered_qualifiedtobuy`:STRING,`hs_date_exited_decisionmakerboughtin`:STRING,`hs_date_exited_presentationscheduled`:STRING,`hs_date_exited_qualifiedtobuy`:STRING,`hs_merged_object_ids`:STRING,`hs_predicted_amount`:STRING,`hs_predicted_amount_in_home_currency`:STRING,`hs_time_in_contractsent`:STRING,`hs_time_in_decisionmakerboughtin`:STRING,`hs_time_in_presentationscheduled`:STRING,`hs_time_in_qualifiedtobuy`:STRING,`hs_date_exited_contractsent`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`must_have_feature_explanation`:STRING,`must_have_features`:STRING,`accounting_integration_desired`:STRING,`additional_notes_or_comments`:STRING,`address`:STRING,`annual_or_monthly`:STRING,`current_accounting_software`:STRING,`deal_value__usd_`:STRING,`enterprise__3__locations_`:STRING,`modules`:STRING,`municipality__city__or_county_owned_property_`:STRING,`of_resources`:STRING,`of_slips`:STRING,`perform_date`:STRING,`point_of_contact`:STRING,`title__role___responsibilities`:STRING,`website`:STRING,`hs_num_associated_deal_splits`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`hs_exchange_rate`: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_deals/2023-02-08/1675875492'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_deals/2023-02-08/1675875492
    • id: 4692807
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "additional_notes_or_comments": "mike operations\nlindsay office admin\nstephen consultant also helping with secure internet etc\nqb and google drive\n3mm in revenue, up from 300k two years ago\nlikes how we organize the workflow\n15% (maybe 50? but don't think so) then the rest at launch\ndry= 28 acres, 320 this year) + 45 slips + service=7 speciality techs, 15 employees at the marina\ninsurance is notes, QB, don't check, contract is blanket\ninventory is eyeballing\ncalendar is huge\nall around great fit\nemployees enter time in QBs\nwill be relaying for QBO integration/setup\nlindsey been there 2 months, Mike 4 months\n\n",
        "address": "137 Endeavor Ave, Hubbards, Halifax, B0J 1T0 \n",
        "amount": "18039.9",
        "amount_in_home_currency": "18039.9",
        "annual_or_monthly": "Annual",
        "caller_owner": "60367669",
        "closed_lost_reason": "Deal Cleanup",
        "closed_lost_reason12": "Cleanup",
        "closed_won_reason": "Oasis / Snag a Slip Marina",
        "closed_won_reason1": "Online Booking",
        "closedate": "2021-05-13T01:14:35.164Z",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Nautical Solutions",
        "days_to_close": "1415",
        "deal_currency_code": "",
        "deal_status": "Performed - DM",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_all_accessible_team_ids": "",
        "hs_all_owner_ids": "",
        "hs_all_team_ids": "",
        "hs_analytics_latest_source": "OFFLINE",
        "hs_analytics_latest_source_company": "OFFLINE",
        "hs_analytics_latest_source_contact": "OFFLINE",
        "hs_analytics_latest_source_data_1": "INTEGRATION",
        "hs_analytics_latest_source_data_1_company": "INTEGRATION",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "206398",
        "hs_analytics_latest_source_data_2_company": "206398",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2017-06-26T15:33:09.759Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.640Z",
        "hs_date_entered_23229963": "2022-05-25T19:36:40.145Z",
        "hs_date_entered_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_closedlost": "2021-05-13T01:17:24.952Z",
        "hs_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_contractsent": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_qualifiedtobuy": "2019-09-13T14:37:45.058Z",
        "hs_date_exited_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_contractsent": "2020-05-19T13:29:28.120Z",
        "hs_date_exited_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_qualifiedtobuy": "2019-09-13T14:37:49.672Z",
        "hs_deal_stage_probability": "0",
        "hs_deal_stage_probability_shadow": "0",
        "hs_exchange_rate": "",
        "hs_forecast_amount": "0.00",
        "hs_forecast_probability": "0.0",
        "hs_is_closed": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_lastmodifieddate": "2022-08-22T14:03:46.881Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059209",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_time_in_23229963": "22367963838",
        "hs_time_in_23229964": "0",
        "hs_time_in_23229965": "0",
        "hs_time_in_23229966": "0",
        "hs_time_in_23229967": "0",
        "hs_time_in_23229968": "0",
        "hs_time_in_closedlost": "55006715899",
        "hs_time_in_closedwon": "56309814550",
        "hs_time_in_contractsent": "21511277483",
        "hs_time_in_decisionmakerboughtin": "0",
        "hs_time_in_presentationscheduled": "0",
        "hs_time_in_qualifiedtobuy": "4614",
        "hs_updated_by_user_id": "3695245",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "likelihood": "25%",
        "micro": "true",
        "modules": "Service;Slips/Rack Reservations",
        "municipality__city__or_county_owned_property_": "false",
        "must_have_feature_explanation": "N/A",
        "must_have_features": "None",
        "needs_quickbooks_desktop_integration": "Needed to Close Deal",
        "next_step": "send email to Don",
        "next_step_date": "2021-08-27",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-05-14T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_resources": "0",
        "of_slips": "375",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "second_deal_owner": "148939047",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "source": "Inbound",
        "state_region": "MA",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "website": "https://www.eastrivershipyard.ca/"
    },
    "updatedAt": "2022-05-11T17:35:09.745Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "associations.calls.paging.next.after": "string",
    "associations.calls.paging.next.link": "string",
    "associations.calls.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.companies.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.contacts.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.additional_notes_or_comments": "string",
    "properties.address": "string",
    "properties.amount": "string",
    "properties.amount_in_home_currency": "string",
    "properties.annual_or_monthly": "string",
    "properties.caller_owner": "string",
    "properties.closed_lost_reason": "string",
    "properties.closed_lost_reason12": "string",
    "properties.closed_won_reason": "string",
    "properties.closed_won_reason1": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.createdate": "string",
    "properties.current_accounting_software": "string",
    "properties.current_vendor": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.deal_currency_code": "string",
    "properties.deal_status": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.description": "string",
    "properties.discount_offered": "string",
    "properties.discount_reception_perception": "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__3__locations_": "string",
    "properties.feet_of_linear_dockage": "string",
    "properties.forecast_category": "string",
    "properties.head_to_head_competitor": "string",
    "properties.hs_acv": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_collaborator_owner_ids": "string",
    "properties.hs_all_deal_split_owner_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_company": "string",
    "properties.hs_analytics_latest_source_contact": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_1_company": "string",
    "properties.hs_analytics_latest_source_data_1_contact": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_data_2_company": "string",
    "properties.hs_analytics_latest_source_data_2_contact": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_latest_source_timestamp_company": "string",
    "properties.hs_analytics_latest_source_timestamp_contact": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_arr": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_23229963": "string",
    "properties.hs_date_entered_23229964": "string",
    "properties.hs_date_entered_23229965": "string",
    "properties.hs_date_entered_23229966": "string",
    "properties.hs_date_entered_23229967": "string",
    "properties.hs_date_entered_23229968": "string",
    "properties.hs_date_entered_appointmentscheduled": "string",
    "properties.hs_date_entered_closedlost": "string",
    "properties.hs_date_entered_closedwon": "string",
    "properties.hs_date_entered_contractsent": "string",
    "properties.hs_date_entered_decisionmakerboughtin": "string",
    "properties.hs_date_entered_presentationscheduled": "string",
    "properties.hs_date_entered_qualifiedtobuy": "string",
    "properties.hs_date_exited_23229963": "string",
    "properties.hs_date_exited_23229964": "string",
    "properties.hs_date_exited_23229965": "string",
    "properties.hs_date_exited_23229966": "string",
    "properties.hs_date_exited_23229967": "string",
    "properties.hs_date_exited_23229968": "string",
    "properties.hs_date_exited_appointmentscheduled": "string",
    "properties.hs_date_exited_closedlost": "string",
    "properties.hs_date_exited_closedwon": "string",
    "properties.hs_date_exited_contractsent": "string",
    "properties.hs_date_exited_decisionmakerboughtin": "string",
    "properties.hs_date_exited_presentationscheduled": "string",
    "properties.hs_date_exited_qualifiedtobuy": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_stage_probability": "string",
    "properties.hs_deal_stage_probability_shadow": "string",
    "properties.hs_exchange_rate": "string",
    "properties.hs_forecast_amount": "string",
    "properties.hs_forecast_probability": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_likelihood_to_close": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency_enabled": "string",
    "properties.hs_manual_forecast_category": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_mrr": "string",
    "properties.hs_next_step": "string",
    "properties.hs_num_associated_active_deal_registrations": "string",
    "properties.hs_num_associated_deal_registrations": "string",
    "properties.hs_num_associated_deal_splits": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_predicted_amount": "string",
    "properties.hs_predicted_amount_in_home_currency": "string",
    "properties.hs_priority": "string",
    "properties.hs_projected_amount": "string",
    "properties.hs_projected_amount_in_home_currency": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_tcv": "string",
    "properties.hs_time_in_23229963": "string",
    "properties.hs_time_in_23229964": "string",
    "properties.hs_time_in_23229965": "string",
    "properties.hs_time_in_23229966": "string",
    "properties.hs_time_in_23229967": "string",
    "properties.hs_time_in_23229968": "string",
    "properties.hs_time_in_appointmentscheduled": "string",
    "properties.hs_time_in_closedlost": "string",
    "properties.hs_time_in_closedwon": "string",
    "properties.hs_time_in_contractsent": "string",
    "properties.hs_time_in_decisionmakerboughtin": "string",
    "properties.hs_time_in_presentationscheduled": "string",
    "properties.hs_time_in_qualifiedtobuy": "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.likelihood": "string",
    "properties.micro": "string",
    "properties.modules": "string",
    "properties.municipality__city__or_county_owned_property_": "string",
    "properties.must_have_feature_explanation": "string",
    "properties.must_have_features": "string",
    "properties.needs_quickbooks_desktop_integration": "string",
    "properties.next_step": "string",
    "properties.next_step_date": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips": "string",
    "properties.of_resources": "string",
    "properties.of_slips": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.second_deal_owner": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.website": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2173
    • schema_scan_id: 6106947
    • updated: 2023-02-08 11:03:22
    • created: 2023-02-07 19:00:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`days_to_close`:STRING,`deal_value`:STRING,`dealname`:STRING,`dealstage`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_company`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_1_company`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_data_2_company`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_closed_amount`:STRING,`hs_closed_amount_in_home_currency`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_closed`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`current_vendor_new`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_date_entered_23229964`:STRING,`hs_date_entered_23229965`:STRING,`hs_date_entered_23229966`:STRING,`hs_date_entered_23229967`:STRING,`hs_date_entered_23229968`:STRING,`hs_date_entered_closedwon`:STRING,`hs_date_exited_23229964`:STRING,`hs_date_exited_23229965`:STRING,`hs_date_exited_23229966`:STRING,`hs_date_exited_23229967`:STRING,`hs_date_exited_23229968`:STRING,`hs_time_in_23229964`:STRING,`hs_time_in_23229965`:STRING,`hs_time_in_23229966`:STRING,`hs_time_in_23229967`:STRING,`hs_time_in_23229968`:STRING,`hs_time_in_closedwon`:STRING,`hs_analytics_latest_source_contact`:STRING,`hs_analytics_latest_source_data_1_contact`:STRING,`hs_analytics_latest_source_data_2_contact`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`head_to_head_competitor`:STRING,`hs_forecast_amount`:STRING,`hs_projected_amount`:STRING,`hs_projected_amount_in_home_currency`:STRING,`hs_sales_email_last_replied`:STRING,`likelihood`:STRING,`next_step`:STRING,`next_step_date`:STRING,`source`:STRING,`vendor_lost_to`:STRING,`engagements_last_meeting_booked`:STRING,`forecast_category`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_latest_meeting_activity`:STRING,`needs_quickbooks_desktop_integration`:STRING,`hs_pinned_engagement_id`:STRING,`micro`:STRING,`deal_currency_code`:STRING,`hs_created_by_user_id`:STRING,`hs_date_entered_contractsent`:STRING,`hs_date_entered_decisionmakerboughtin`:STRING,`hs_date_entered_presentationscheduled`:STRING,`hs_date_entered_qualifiedtobuy`:STRING,`hs_date_exited_decisionmakerboughtin`:STRING,`hs_date_exited_presentationscheduled`:STRING,`hs_date_exited_qualifiedtobuy`:STRING,`hs_merged_object_ids`:STRING,`hs_predicted_amount`:STRING,`hs_predicted_amount_in_home_currency`:STRING,`hs_time_in_contractsent`:STRING,`hs_time_in_decisionmakerboughtin`:STRING,`hs_time_in_presentationscheduled`:STRING,`hs_time_in_qualifiedtobuy`:STRING,`hs_date_exited_contractsent`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`must_have_feature_explanation`:STRING,`must_have_features`:STRING,`accounting_integration_desired`:STRING,`additional_notes_or_comments`:STRING,`address`:STRING,`annual_or_monthly`:STRING,`current_accounting_software`:STRING,`deal_value__usd_`:STRING,`enterprise__3__locations_`:STRING,`modules`:STRING,`municipality__city__or_county_owned_property_`:STRING,`of_resources`:STRING,`of_slips`:STRING,`perform_date`:STRING,`point_of_contact`:STRING,`title__role___responsibilities`:STRING,`website`:STRING,`hs_num_associated_deal_splits`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`hs_exchange_rate`:STRING>,`createdAt`STRING,`updatedAt`STRING,`archived`STRING,`associations`struct<`companies`:struct<`results`:array>>,`calls`:struct<`results`:array>,`paging`:struct<`next`:struct<`after`:STRING,`link`:STRING>>>,`contacts`:struct<`results`:array>>>\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_deals/2023-02-07/1675817996'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_deals/2023-02-07/1675817996
    • id: 4692782
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "associations": {
        "calls": {
            "paging": {
                "next": {
                    "after": "MC0yMDUtMTA5ODE3NTY2MDA%3D",
                    "link": "https://api.hubapi.com/crm/v3/objects/0-3/1380531728/associations/0-48?portalId=2753955&after=MC0yMDUtMTA5ODE3NTY2MDA%3D"
                }
            },
            "results": [
                {
                    "id": "12855641859",
                    "type": "deal_to_call"
                }
            ]
        },
        "companies": {
            "results": [
                {
                    "id": "482403473",
                    "type": "deal_to_company_unlabeled"
                }
            ]
        },
        "contacts": {
            "results": [
                {
                    "id": "532906",
                    "type": "deal_to_contact"
                }
            ]
        }
    },
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "additional_notes_or_comments": "mike operations\nlindsay office admin\nstephen consultant also helping with secure internet etc\nqb and google drive\n3mm in revenue, up from 300k two years ago\nlikes how we organize the workflow\n15% (maybe 50? but don't think so) then the rest at launch\ndry= 28 acres, 320 this year) + 45 slips + service=7 speciality techs, 15 employees at the marina\ninsurance is notes, QB, don't check, contract is blanket\ninventory is eyeballing\ncalendar is huge\nall around great fit\nemployees enter time in QBs\nwill be relaying for QBO integration/setup\nlindsey been there 2 months, Mike 4 months\n\n",
        "address": "137 Endeavor Ave, Hubbards, Halifax, B0J 1T0 \n",
        "amount": "18039.9",
        "amount_in_home_currency": "18039.9",
        "annual_or_monthly": "Annual",
        "caller_owner": "60367669",
        "closed_lost_reason": "Deal Cleanup",
        "closed_lost_reason12": "Cleanup",
        "closed_won_reason": "Oasis / Snag a Slip Marina",
        "closed_won_reason1": "Online Booking",
        "closedate": "2021-05-13T01:14:35.164Z",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Nautical Solutions",
        "days_to_close": "1415",
        "deal_currency_code": "",
        "deal_status": "Performed - DM",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_all_accessible_team_ids": "",
        "hs_all_owner_ids": "",
        "hs_all_team_ids": "",
        "hs_analytics_latest_source": "OFFLINE",
        "hs_analytics_latest_source_company": "OFFLINE",
        "hs_analytics_latest_source_contact": "OFFLINE",
        "hs_analytics_latest_source_data_1": "INTEGRATION",
        "hs_analytics_latest_source_data_1_company": "INTEGRATION",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "206398",
        "hs_analytics_latest_source_data_2_company": "206398",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2017-06-26T15:33:09.759Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.640Z",
        "hs_date_entered_23229963": "2022-05-25T19:36:40.145Z",
        "hs_date_entered_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_closedlost": "2021-05-13T01:17:24.952Z",
        "hs_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_contractsent": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_qualifiedtobuy": "2019-09-13T14:37:45.058Z",
        "hs_date_exited_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_contractsent": "2020-05-19T13:29:28.120Z",
        "hs_date_exited_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_qualifiedtobuy": "2019-09-13T14:37:49.672Z",
        "hs_deal_stage_probability": "0",
        "hs_deal_stage_probability_shadow": "0",
        "hs_exchange_rate": "",
        "hs_forecast_amount": "0.00",
        "hs_forecast_probability": "0.0",
        "hs_is_closed": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_lastmodifieddate": "2022-08-22T14:03:46.881Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059209",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_time_in_23229963": "22310589989",
        "hs_time_in_23229964": "0",
        "hs_time_in_23229965": "0",
        "hs_time_in_23229966": "0",
        "hs_time_in_23229967": "0",
        "hs_time_in_23229968": "0",
        "hs_time_in_closedlost": "54949341651",
        "hs_time_in_closedwon": "56252440295",
        "hs_time_in_contractsent": "21511277483",
        "hs_time_in_decisionmakerboughtin": "0",
        "hs_time_in_presentationscheduled": "0",
        "hs_time_in_qualifiedtobuy": "4614",
        "hs_updated_by_user_id": "3695245",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "likelihood": "25%",
        "micro": "true",
        "modules": "Service;Slips/Rack Reservations",
        "municipality__city__or_county_owned_property_": "false",
        "must_have_feature_explanation": "N/A",
        "must_have_features": "None",
        "needs_quickbooks_desktop_integration": "Needed to Close Deal",
        "next_step": "send email to Don",
        "next_step_date": "2021-08-27",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-05-14T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_resources": "0",
        "of_slips": "375",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "second_deal_owner": "148939047",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "source": "Inbound",
        "state_region": "MA",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "website": "https://www.eastrivershipyard.ca/"
    },
    "updatedAt": "2022-05-11T17:35:09.745Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "associations.calls.paging.next.after": "string",
    "associations.calls.paging.next.link": "string",
    "associations.calls.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.companies.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.contacts.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.additional_notes_or_comments": "string",
    "properties.address": "string",
    "properties.amount": "string",
    "properties.amount_in_home_currency": "string",
    "properties.annual_or_monthly": "string",
    "properties.caller_owner": "string",
    "properties.closed_lost_reason": "string",
    "properties.closed_lost_reason12": "string",
    "properties.closed_won_reason": "string",
    "properties.closed_won_reason1": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.createdate": "string",
    "properties.current_accounting_software": "string",
    "properties.current_vendor": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.deal_currency_code": "string",
    "properties.deal_status": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.description": "string",
    "properties.discount_offered": "string",
    "properties.discount_reception_perception": "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__3__locations_": "string",
    "properties.feet_of_linear_dockage": "string",
    "properties.forecast_category": "string",
    "properties.head_to_head_competitor": "string",
    "properties.hs_acv": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_collaborator_owner_ids": "string",
    "properties.hs_all_deal_split_owner_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_company": "string",
    "properties.hs_analytics_latest_source_contact": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_1_company": "string",
    "properties.hs_analytics_latest_source_data_1_contact": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_data_2_company": "string",
    "properties.hs_analytics_latest_source_data_2_contact": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_latest_source_timestamp_company": "string",
    "properties.hs_analytics_latest_source_timestamp_contact": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_arr": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_23229963": "string",
    "properties.hs_date_entered_23229964": "string",
    "properties.hs_date_entered_23229965": "string",
    "properties.hs_date_entered_23229966": "string",
    "properties.hs_date_entered_23229967": "string",
    "properties.hs_date_entered_23229968": "string",
    "properties.hs_date_entered_appointmentscheduled": "string",
    "properties.hs_date_entered_closedlost": "string",
    "properties.hs_date_entered_closedwon": "string",
    "properties.hs_date_entered_contractsent": "string",
    "properties.hs_date_entered_decisionmakerboughtin": "string",
    "properties.hs_date_entered_presentationscheduled": "string",
    "properties.hs_date_entered_qualifiedtobuy": "string",
    "properties.hs_date_exited_23229963": "string",
    "properties.hs_date_exited_23229964": "string",
    "properties.hs_date_exited_23229965": "string",
    "properties.hs_date_exited_23229966": "string",
    "properties.hs_date_exited_23229967": "string",
    "properties.hs_date_exited_23229968": "string",
    "properties.hs_date_exited_appointmentscheduled": "string",
    "properties.hs_date_exited_closedlost": "string",
    "properties.hs_date_exited_closedwon": "string",
    "properties.hs_date_exited_contractsent": "string",
    "properties.hs_date_exited_decisionmakerboughtin": "string",
    "properties.hs_date_exited_presentationscheduled": "string",
    "properties.hs_date_exited_qualifiedtobuy": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_stage_probability": "string",
    "properties.hs_deal_stage_probability_shadow": "string",
    "properties.hs_exchange_rate": "string",
    "properties.hs_forecast_amount": "string",
    "properties.hs_forecast_probability": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_likelihood_to_close": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency_enabled": "string",
    "properties.hs_manual_forecast_category": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_mrr": "string",
    "properties.hs_next_step": "string",
    "properties.hs_num_associated_active_deal_registrations": "string",
    "properties.hs_num_associated_deal_registrations": "string",
    "properties.hs_num_associated_deal_splits": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_predicted_amount": "string",
    "properties.hs_predicted_amount_in_home_currency": "string",
    "properties.hs_priority": "string",
    "properties.hs_projected_amount": "string",
    "properties.hs_projected_amount_in_home_currency": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_tcv": "string",
    "properties.hs_time_in_23229963": "string",
    "properties.hs_time_in_23229964": "string",
    "properties.hs_time_in_23229965": "string",
    "properties.hs_time_in_23229966": "string",
    "properties.hs_time_in_23229967": "string",
    "properties.hs_time_in_23229968": "string",
    "properties.hs_time_in_appointmentscheduled": "string",
    "properties.hs_time_in_closedlost": "string",
    "properties.hs_time_in_closedwon": "string",
    "properties.hs_time_in_contractsent": "string",
    "properties.hs_time_in_decisionmakerboughtin": "string",
    "properties.hs_time_in_presentationscheduled": "string",
    "properties.hs_time_in_qualifiedtobuy": "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.likelihood": "string",
    "properties.micro": "string",
    "properties.modules": "string",
    "properties.municipality__city__or_county_owned_property_": "string",
    "properties.must_have_feature_explanation": "string",
    "properties.must_have_features": "string",
    "properties.needs_quickbooks_desktop_integration": "string",
    "properties.next_step": "string",
    "properties.next_step_date": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips": "string",
    "properties.of_resources": "string",
    "properties.of_slips": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.second_deal_owner": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.website": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2173
    • schema_scan_id: 6106667
    • updated: 2023-02-07 19:00:39
    • created: 2023-02-07 18:42:04
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_drivethru.hubspot_molo_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`days_to_close`:STRING,`deal_value`:STRING,`dealname`:STRING,`dealstage`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_company`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_1_company`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_data_2_company`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_closed_amount`:STRING,`hs_closed_amount_in_home_currency`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_closed`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`current_vendor_new`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_date_entered_23229964`:STRING,`hs_date_entered_23229965`:STRING,`hs_date_entered_23229966`:STRING,`hs_date_entered_23229967`:STRING,`hs_date_entered_23229968`:STRING,`hs_date_entered_closedwon`:STRING,`hs_date_exited_23229964`:STRING,`hs_date_exited_23229965`:STRING,`hs_date_exited_23229966`:STRING,`hs_date_exited_23229967`:STRING,`hs_date_exited_23229968`:STRING,`hs_time_in_23229964`:STRING,`hs_time_in_23229965`:STRING,`hs_time_in_23229966`:STRING,`hs_time_in_23229967`:STRING,`hs_time_in_23229968`:STRING,`hs_time_in_closedwon`:STRING,`hs_analytics_latest_source_contact`:STRING,`hs_analytics_latest_source_data_1_contact`:STRING,`hs_analytics_latest_source_data_2_contact`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`head_to_head_competitor`:STRING,`hs_forecast_amount`:STRING,`hs_projected_amount`:STRING,`hs_projected_amount_in_home_currency`:STRING,`hs_sales_email_last_replied`:STRING,`likelihood`:STRING,`next_step`:STRING,`next_step_date`:STRING,`source`:STRING,`vendor_lost_to`:STRING,`engagements_last_meeting_booked`:STRING,`forecast_category`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_latest_meeting_activity`:STRING,`needs_quickbooks_desktop_integration`:STRING,`hs_pinned_engagement_id`:STRING,`micro`:STRING,`deal_currency_code`:STRING,`hs_created_by_user_id`:STRING,`hs_date_entered_contractsent`:STRING,`hs_date_entered_decisionmakerboughtin`:STRING,`hs_date_entered_presentationscheduled`:STRING,`hs_date_entered_qualifiedtobuy`:STRING,`hs_date_exited_decisionmakerboughtin`:STRING,`hs_date_exited_presentationscheduled`:STRING,`hs_date_exited_qualifiedtobuy`:STRING,`hs_merged_object_ids`:STRING,`hs_predicted_amount`:STRING,`hs_predicted_amount_in_home_currency`:STRING,`hs_time_in_contractsent`:STRING,`hs_time_in_decisionmakerboughtin`:STRING,`hs_time_in_presentationscheduled`:STRING,`hs_time_in_qualifiedtobuy`:STRING,`hs_date_exited_contractsent`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`must_have_feature_explanation`:STRING,`must_have_features`:STRING,`accounting_integration_desired`:STRING,`additional_notes_or_comments`:STRING,`address`:STRING,`annual_or_monthly`:STRING,`current_accounting_software`:STRING,`deal_value__usd_`:STRING,`enterprise__3__locations_`:STRING,`modules`:STRING,`municipality__city__or_county_owned_property_`:STRING,`of_resources`:STRING,`of_slips`:STRING,`perform_date`:STRING,`point_of_contact`:STRING,`title__role___responsibilities`:STRING,`website`:STRING,`hs_num_associated_deal_splits`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`hs_exchange_rate`: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_deals/2023-02-07/1675816895'\n",
    "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-dev/raw/hubspot_molo_deals/2023-02-07/1675816895
    • id: 4692781
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "additional_notes_or_comments": "mike operations\nlindsay office admin\nstephen consultant also helping with secure internet etc\nqb and google drive\n3mm in revenue, up from 300k two years ago\nlikes how we organize the workflow\n15% (maybe 50? but don't think so) then the rest at launch\ndry= 28 acres, 320 this year) + 45 slips + service=7 speciality techs, 15 employees at the marina\ninsurance is notes, QB, don't check, contract is blanket\ninventory is eyeballing\ncalendar is huge\nall around great fit\nemployees enter time in QBs\nwill be relaying for QBO integration/setup\nlindsey been there 2 months, Mike 4 months\n\n",
        "address": "137 Endeavor Ave, Hubbards, Halifax, B0J 1T0 \n",
        "amount": "18039.9",
        "amount_in_home_currency": "18039.9",
        "annual_or_monthly": "Annual",
        "caller_owner": "60367669",
        "closed_lost_reason": "Deal Cleanup",
        "closed_lost_reason12": "Cleanup",
        "closed_won_reason": "Oasis / Snag a Slip Marina",
        "closed_won_reason1": "Online Booking",
        "closedate": "2021-05-13T01:14:35.164Z",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Nautical Solutions",
        "days_to_close": "1415",
        "deal_currency_code": "",
        "deal_status": "Performed - DM",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_all_accessible_team_ids": "",
        "hs_all_owner_ids": "",
        "hs_all_team_ids": "",
        "hs_analytics_latest_source": "OFFLINE",
        "hs_analytics_latest_source_company": "OFFLINE",
        "hs_analytics_latest_source_contact": "OFFLINE",
        "hs_analytics_latest_source_data_1": "INTEGRATION",
        "hs_analytics_latest_source_data_1_company": "INTEGRATION",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "206398",
        "hs_analytics_latest_source_data_2_company": "206398",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2017-06-26T15:33:09.759Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "ORGANIC_SEARCH",
        "hs_analytics_source_data_1": "Unknown keywords (SSL)",
        "hs_analytics_source_data_2": "GOOGLE",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.640Z",
        "hs_date_entered_23229963": "2022-05-25T19:36:40.145Z",
        "hs_date_entered_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_closedlost": "2021-05-13T01:17:24.952Z",
        "hs_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_date_entered_contractsent": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_entered_qualifiedtobuy": "2019-09-13T14:37:45.058Z",
        "hs_date_exited_23229964": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229965": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229966": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229967": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_23229968": "2021-04-27T23:19:06.302Z",
        "hs_date_exited_contractsent": "2020-05-19T13:29:28.120Z",
        "hs_date_exited_decisionmakerboughtin": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_presentationscheduled": "2019-09-13T14:37:49.672Z",
        "hs_date_exited_qualifiedtobuy": "2019-09-13T14:37:49.672Z",
        "hs_deal_stage_probability": "0",
        "hs_deal_stage_probability_shadow": "0",
        "hs_exchange_rate": "",
        "hs_forecast_amount": "0.00",
        "hs_forecast_probability": "0.0",
        "hs_is_closed": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_lastmodifieddate": "2022-08-22T14:03:46.881Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059209",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_time_in_23229963": "22309489420",
        "hs_time_in_23229964": "0",
        "hs_time_in_23229965": "0",
        "hs_time_in_23229966": "0",
        "hs_time_in_23229967": "0",
        "hs_time_in_23229968": "0",
        "hs_time_in_closedlost": "54948241999",
        "hs_time_in_closedwon": "56251340654",
        "hs_time_in_contractsent": "21511277483",
        "hs_time_in_decisionmakerboughtin": "0",
        "hs_time_in_presentationscheduled": "0",
        "hs_time_in_qualifiedtobuy": "4614",
        "hs_updated_by_user_id": "3695245",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "likelihood": "25%",
        "micro": "true",
        "modules": "Service;Slips/Rack Reservations",
        "municipality__city__or_county_owned_property_": "false",
        "must_have_feature_explanation": "N/A",
        "must_have_features": "None",
        "needs_quickbooks_desktop_integration": "Needed to Close Deal",
        "next_step": "send email to Don",
        "next_step_date": "2021-08-27",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-05-14T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_resources": "0",
        "of_slips": "375",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "second_deal_owner": "148939047",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "source": "Inbound",
        "state_region": "MA",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "website": "https://www.eastrivershipyard.ca/"
    },
    "updatedAt": "2022-05-11T17:35:09.745Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.additional_notes_or_comments": "string",
    "properties.address": "string",
    "properties.amount": "string",
    "properties.amount_in_home_currency": "string",
    "properties.annual_or_monthly": "string",
    "properties.caller_owner": "string",
    "properties.closed_lost_reason": "string",
    "properties.closed_lost_reason12": "string",
    "properties.closed_won_reason": "string",
    "properties.closed_won_reason1": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.createdate": "string",
    "properties.current_accounting_software": "string",
    "properties.current_vendor": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.deal_currency_code": "string",
    "properties.deal_status": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.description": "string",
    "properties.discount_offered": "string",
    "properties.discount_reception_perception": "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__3__locations_": "string",
    "properties.feet_of_linear_dockage": "string",
    "properties.forecast_category": "string",
    "properties.head_to_head_competitor": "string",
    "properties.hs_acv": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_collaborator_owner_ids": "string",
    "properties.hs_all_deal_split_owner_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_company": "string",
    "properties.hs_analytics_latest_source_contact": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_1_company": "string",
    "properties.hs_analytics_latest_source_data_1_contact": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_data_2_company": "string",
    "properties.hs_analytics_latest_source_data_2_contact": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_latest_source_timestamp_company": "string",
    "properties.hs_analytics_latest_source_timestamp_contact": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_arr": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_23229963": "string",
    "properties.hs_date_entered_23229964": "string",
    "properties.hs_date_entered_23229965": "string",
    "properties.hs_date_entered_23229966": "string",
    "properties.hs_date_entered_23229967": "string",
    "properties.hs_date_entered_23229968": "string",
    "properties.hs_date_entered_appointmentscheduled": "string",
    "properties.hs_date_entered_closedlost": "string",
    "properties.hs_date_entered_closedwon": "string",
    "properties.hs_date_entered_contractsent": "string",
    "properties.hs_date_entered_decisionmakerboughtin": "string",
    "properties.hs_date_entered_presentationscheduled": "string",
    "properties.hs_date_entered_qualifiedtobuy": "string",
    "properties.hs_date_exited_23229963": "string",
    "properties.hs_date_exited_23229964": "string",
    "properties.hs_date_exited_23229965": "string",
    "properties.hs_date_exited_23229966": "string",
    "properties.hs_date_exited_23229967": "string",
    "properties.hs_date_exited_23229968": "string",
    "properties.hs_date_exited_appointmentscheduled": "string",
    "properties.hs_date_exited_closedlost": "string",
    "properties.hs_date_exited_closedwon": "string",
    "properties.hs_date_exited_contractsent": "string",
    "properties.hs_date_exited_decisionmakerboughtin": "string",
    "properties.hs_date_exited_presentationscheduled": "string",
    "properties.hs_date_exited_qualifiedtobuy": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_stage_probability": "string",
    "properties.hs_deal_stage_probability_shadow": "string",
    "properties.hs_exchange_rate": "string",
    "properties.hs_forecast_amount": "string",
    "properties.hs_forecast_probability": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_likelihood_to_close": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency_enabled": "string",
    "properties.hs_manual_forecast_category": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_mrr": "string",
    "properties.hs_next_step": "string",
    "properties.hs_num_associated_active_deal_registrations": "string",
    "properties.hs_num_associated_deal_registrations": "string",
    "properties.hs_num_associated_deal_splits": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_predicted_amount": "string",
    "properties.hs_predicted_amount_in_home_currency": "string",
    "properties.hs_priority": "string",
    "properties.hs_projected_amount": "string",
    "properties.hs_projected_amount_in_home_currency": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_tcv": "string",
    "properties.hs_time_in_23229963": "string",
    "properties.hs_time_in_23229964": "string",
    "properties.hs_time_in_23229965": "string",
    "properties.hs_time_in_23229966": "string",
    "properties.hs_time_in_23229967": "string",
    "properties.hs_time_in_23229968": "string",
    "properties.hs_time_in_appointmentscheduled": "string",
    "properties.hs_time_in_closedlost": "string",
    "properties.hs_time_in_closedwon": "string",
    "properties.hs_time_in_contractsent": "string",
    "properties.hs_time_in_decisionmakerboughtin": "string",
    "properties.hs_time_in_presentationscheduled": "string",
    "properties.hs_time_in_qualifiedtobuy": "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.likelihood": "string",
    "properties.micro": "string",
    "properties.modules": "string",
    "properties.municipality__city__or_county_owned_property_": "string",
    "properties.must_have_feature_explanation": "string",
    "properties.must_have_features": "string",
    "properties.needs_quickbooks_desktop_integration": "string",
    "properties.next_step": "string",
    "properties.next_step_date": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips": "string",
    "properties.of_resources": "string",
    "properties.of_slips": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.second_deal_owner": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.website": "string",
    "updatedAt": "string"
}
    • schema_name_id: 2173
    • schema_scan_id: 6106666
    • updated: 2023-02-07 18:42:15
Schema Scans: 4
Last at 2023-02-09 09:27:25
    • duration: 0:00:21.734243
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6108976
    • 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_deals/2023-02-09/1675956416",
        "key": "raw/hubspot_molo_deals/2023-02-09/1675956416/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 16856278816903148179,
        "service_name": "drive-thru",
        "span_id": 1027920274120801870,
        "trace_id": 15443431308365852984
    }
}
    • running: False
    • schema_name_id: 2173
    • start_time: 2023-02-09 09:27:25
    • success: True
    • trace_id: 15443431308365852984
    • duration: 0:00:21.966506
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6106947
    • 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_deals/2023-02-08/1675875492",
        "key": "raw/hubspot_molo_deals/2023-02-08/1675875492/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 6564218410405753320,
        "service_name": "drive-thru",
        "span_id": 223797687374806526,
        "trace_id": 14856972171415819095
    }
}
    • running: False
    • schema_name_id: 2173
    • start_time: 2023-02-08 11:03:00
    • success: True
    • trace_id: 14856972171415819095
    • duration: 0:00:23.194414
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6106667
    • 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_deals/2023-02-07/1675817996",
        "key": "raw/hubspot_molo_deals/2023-02-07/1675817996/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8378661818330290287,
        "service_name": "drive-thru",
        "span_id": 9924548619979499930,
        "trace_id": 9401349219865430533
    }
}
    • running: False
    • schema_name_id: 2173
    • start_time: 2023-02-07 19:00:16
    • success: True
    • trace_id: 9401349219865430533
    • duration: 0:00:21.870682
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6106666
    • 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_deals/2023-02-07/1675816895",
        "key": "raw/hubspot_molo_deals/2023-02-07/1675816895/data.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 13092490780666084106,
        "service_name": "drive-thru",
        "span_id": 17442082834190058970,
        "trace_id": 16237078440736704497
    }
}
    • running: False
    • schema_name_id: 2173
    • start_time: 2023-02-07 18:41:53
    • success: True
    • trace_id: 16237078440736704497
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "associations.calls.paging.next.after": "string",
    "associations.calls.paging.next.link": "string",
    "associations.calls.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.companies.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "associations.contacts.results": [
        {
            "id": "string",
            "type": "string"
        }
    ],
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.additional_notes_or_comments": "string",
    "properties.address": "string",
    "properties.amount": "string",
    "properties.amount_in_home_currency": "string",
    "properties.annual_or_monthly": "string",
    "properties.caller_owner": "string",
    "properties.closed_lost_reason": "string",
    "properties.closed_lost_reason12": "string",
    "properties.closed_won_reason": "string",
    "properties.closed_won_reason1": "string",
    "properties.closedate": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.createdate": "string",
    "properties.current_accounting_software": "string",
    "properties.current_vendor": "string",
    "properties.current_vendor_new": "string",
    "properties.days_to_close": "string",
    "properties.deal_currency_code": "string",
    "properties.deal_status": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.description": "string",
    "properties.discount_offered": "string",
    "properties.discount_reception_perception": "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__3__locations_": "string",
    "properties.feet_of_linear_dockage": "string",
    "properties.forecast_category": "string",
    "properties.head_to_head_competitor": "string",
    "properties.hs_acv": "string",
    "properties.hs_all_accessible_team_ids": "string",
    "properties.hs_all_assigned_business_unit_ids": "string",
    "properties.hs_all_collaborator_owner_ids": "string",
    "properties.hs_all_deal_split_owner_ids": "string",
    "properties.hs_all_owner_ids": "string",
    "properties.hs_all_team_ids": "string",
    "properties.hs_analytics_latest_source": "string",
    "properties.hs_analytics_latest_source_company": "string",
    "properties.hs_analytics_latest_source_contact": "string",
    "properties.hs_analytics_latest_source_data_1": "string",
    "properties.hs_analytics_latest_source_data_1_company": "string",
    "properties.hs_analytics_latest_source_data_1_contact": "string",
    "properties.hs_analytics_latest_source_data_2": "string",
    "properties.hs_analytics_latest_source_data_2_company": "string",
    "properties.hs_analytics_latest_source_data_2_contact": "string",
    "properties.hs_analytics_latest_source_timestamp": "string",
    "properties.hs_analytics_latest_source_timestamp_company": "string",
    "properties.hs_analytics_latest_source_timestamp_contact": "string",
    "properties.hs_analytics_source": "string",
    "properties.hs_analytics_source_data_1": "string",
    "properties.hs_analytics_source_data_2": "string",
    "properties.hs_arr": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_23229963": "string",
    "properties.hs_date_entered_23229964": "string",
    "properties.hs_date_entered_23229965": "string",
    "properties.hs_date_entered_23229966": "string",
    "properties.hs_date_entered_23229967": "string",
    "properties.hs_date_entered_23229968": "string",
    "properties.hs_date_entered_appointmentscheduled": "string",
    "properties.hs_date_entered_closedlost": "string",
    "properties.hs_date_entered_closedwon": "string",
    "properties.hs_date_entered_contractsent": "string",
    "properties.hs_date_entered_decisionmakerboughtin": "string",
    "properties.hs_date_entered_presentationscheduled": "string",
    "properties.hs_date_entered_qualifiedtobuy": "string",
    "properties.hs_date_exited_23229963": "string",
    "properties.hs_date_exited_23229964": "string",
    "properties.hs_date_exited_23229965": "string",
    "properties.hs_date_exited_23229966": "string",
    "properties.hs_date_exited_23229967": "string",
    "properties.hs_date_exited_23229968": "string",
    "properties.hs_date_exited_appointmentscheduled": "string",
    "properties.hs_date_exited_closedlost": "string",
    "properties.hs_date_exited_closedwon": "string",
    "properties.hs_date_exited_contractsent": "string",
    "properties.hs_date_exited_decisionmakerboughtin": "string",
    "properties.hs_date_exited_presentationscheduled": "string",
    "properties.hs_date_exited_qualifiedtobuy": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_stage_probability": "string",
    "properties.hs_deal_stage_probability_shadow": "string",
    "properties.hs_exchange_rate": "string",
    "properties.hs_forecast_amount": "string",
    "properties.hs_forecast_probability": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_lastmodifieddate": "string",
    "properties.hs_latest_meeting_activity": "string",
    "properties.hs_likelihood_to_close": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage": "string",
    "properties.hs_line_item_global_term_hs_discount_percentage_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_period_enabled": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date": "string",
    "properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency": "string",
    "properties.hs_line_item_global_term_recurringbillingfrequency_enabled": "string",
    "properties.hs_manual_forecast_category": "string",
    "properties.hs_merged_object_ids": "string",
    "properties.hs_mrr": "string",
    "properties.hs_next_step": "string",
    "properties.hs_num_associated_active_deal_registrations": "string",
    "properties.hs_num_associated_deal_registrations": "string",
    "properties.hs_num_associated_deal_splits": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_pinned_engagement_id": "string",
    "properties.hs_predicted_amount": "string",
    "properties.hs_predicted_amount_in_home_currency": "string",
    "properties.hs_priority": "string",
    "properties.hs_projected_amount": "string",
    "properties.hs_projected_amount_in_home_currency": "string",
    "properties.hs_read_only": "string",
    "properties.hs_sales_email_last_replied": "string",
    "properties.hs_tcv": "string",
    "properties.hs_time_in_23229963": "string",
    "properties.hs_time_in_23229964": "string",
    "properties.hs_time_in_23229965": "string",
    "properties.hs_time_in_23229966": "string",
    "properties.hs_time_in_23229967": "string",
    "properties.hs_time_in_23229968": "string",
    "properties.hs_time_in_appointmentscheduled": "string",
    "properties.hs_time_in_closedlost": "string",
    "properties.hs_time_in_closedwon": "string",
    "properties.hs_time_in_contractsent": "string",
    "properties.hs_time_in_decisionmakerboughtin": "string",
    "properties.hs_time_in_presentationscheduled": "string",
    "properties.hs_time_in_qualifiedtobuy": "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.likelihood": "string",
    "properties.micro": "string",
    "properties.modules": "string",
    "properties.municipality__city__or_county_owned_property_": "string",
    "properties.must_have_feature_explanation": "string",
    "properties.must_have_features": "string",
    "properties.needs_quickbooks_desktop_integration": "string",
    "properties.next_step": "string",
    "properties.next_step_date": "string",
    "properties.notes_last_contacted": "string",
    "properties.notes_last_updated": "string",
    "properties.notes_next_activity_date": "string",
    "properties.num_associated_contacts": "string",
    "properties.num_contacted_notes": "string",
    "properties.num_notes": "string",
    "properties.number_of_slips": "string",
    "properties.of_resources": "string",
    "properties.of_slips": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.second_deal_owner": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.website": "string",
    "updatedAt": "string"
}
  • created: 2023-02-09 09:27:35
  • 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_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`days_to_close`:STRING,`deal_value`:STRING,`dealname`:STRING,`dealstage`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_company`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_1_company`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_data_2_company`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_closed_amount`:STRING,`hs_closed_amount_in_home_currency`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_closed`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`current_vendor_new`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_date_entered_23229964`:STRING,`hs_date_entered_23229965`:STRING,`hs_date_entered_23229966`:STRING,`hs_date_entered_23229967`:STRING,`hs_date_entered_23229968`:STRING,`hs_date_entered_closedwon`:STRING,`hs_date_exited_23229964`:STRING,`hs_date_exited_23229965`:STRING,`hs_date_exited_23229966`:STRING,`hs_date_exited_23229967`:STRING,`hs_date_exited_23229968`:STRING,`hs_time_in_23229964`:STRING,`hs_time_in_23229965`:STRING,`hs_time_in_23229966`:STRING,`hs_time_in_23229967`:STRING,`hs_time_in_23229968`:STRING,`hs_time_in_closedwon`:STRING,`hs_analytics_latest_source_contact`:STRING,`hs_analytics_latest_source_data_1_contact`:STRING,`hs_analytics_latest_source_data_2_contact`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`head_to_head_competitor`:STRING,`hs_forecast_amount`:STRING,`hs_projected_amount`:STRING,`hs_projected_amount_in_home_currency`:STRING,`hs_sales_email_last_replied`:STRING,`likelihood`:STRING,`next_step`:STRING,`next_step_date`:STRING,`source`:STRING,`vendor_lost_to`:STRING,`engagements_last_meeting_booked`:STRING,`forecast_category`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_latest_meeting_activity`:STRING,`needs_quickbooks_desktop_integration`:STRING,`hs_pinned_engagement_id`:STRING,`micro`:STRING,`deal_currency_code`:STRING,`hs_created_by_user_id`:STRING,`hs_date_entered_contractsent`:STRING,`hs_date_entered_decisionmakerboughtin`:STRING,`hs_date_entered_presentationscheduled`:STRING,`hs_date_entered_qualifiedtobuy`:STRING,`hs_date_exited_decisionmakerboughtin`:STRING,`hs_date_exited_presentationscheduled`:STRING,`hs_date_exited_qualifiedtobuy`:STRING,`hs_merged_object_ids`:STRING,`hs_predicted_amount`:STRING,`hs_predicted_amount_in_home_currency`:STRING,`hs_time_in_contractsent`:STRING,`hs_time_in_decisionmakerboughtin`:STRING,`hs_time_in_presentationscheduled`:STRING,`hs_time_in_qualifiedtobuy`:STRING,`hs_date_exited_contractsent`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`must_have_feature_explanation`:STRING,`must_have_features`:STRING,`accounting_integration_desired`:STRING,`additional_notes_or_comments`:STRING,`address`:STRING,`annual_or_monthly`:STRING,`current_accounting_software`:STRING,`deal_value__usd_`:STRING,`enterprise__3__locations_`:STRING,`modules`:STRING,`municipality__city__or_county_owned_property_`:STRING,`of_resources`:STRING,`of_slips`:STRING,`perform_date`:STRING,`point_of_contact`:STRING,`title__role___responsibilities`:STRING,`website`:STRING,`hs_num_associated_deal_splits`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`hs_exchange_rate`: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_deals/2023-02-09/1675956416'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_deals`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_deals"
}
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:12",
        "disabled": false,
        "format": "raw",
        "id": 2173,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_drivethru",
            "table": "hubspot_molo_deals"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "associations.calls.paging.next.after": "string",
            "associations.calls.paging.next.link": "string",
            "associations.calls.results": [
                {
                    "id": "string",
                    "type": "string"
                }
            ],
            "associations.companies.results": [
                {
                    "id": "string",
                    "type": "string"
                }
            ],
            "associations.contacts.results": [
                {
                    "id": "string",
                    "type": "string"
                }
            ],
            "createdAt": "string",
            "id": "string",
            "properties.accounting_integration_desired": "string",
            "properties.additional_notes_or_comments": "string",
            "properties.address": "string",
            "properties.amount": "string",
            "properties.amount_in_home_currency": "string",
            "properties.annual_or_monthly": "string",
            "properties.caller_owner": "string",
            "properties.closed_lost_reason": "string",
            "properties.closed_lost_reason12": "string",
            "properties.closed_won_reason": "string",
            "properties.closed_won_reason1": "string",
            "properties.closedate": "string",
            "properties.company": "string",
            "properties.contact": "string",
            "properties.createdate": "string",
            "properties.current_accounting_software": "string",
            "properties.current_vendor": "string",
            "properties.current_vendor_new": "string",
            "properties.days_to_close": "string",
            "properties.deal_currency_code": "string",
            "properties.deal_status": "string",
            "properties.deal_temperature": "string",
            "properties.deal_value": "string",
            "properties.deal_value__usd_": "string",
            "properties.dealname": "string",
            "properties.dealstage": "string",
            "properties.dealtype": "string",
            "properties.description": "string",
            "properties.discount_offered": "string",
            "properties.discount_reception_perception": "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__3__locations_": "string",
            "properties.feet_of_linear_dockage": "string",
            "properties.forecast_category": "string",
            "properties.head_to_head_competitor": "string",
            "properties.hs_acv": "string",
            "properties.hs_all_accessible_team_ids": "string",
            "properties.hs_all_assigned_business_unit_ids": "string",
            "properties.hs_all_collaborator_owner_ids": "string",
            "properties.hs_all_deal_split_owner_ids": "string",
            "properties.hs_all_owner_ids": "string",
            "properties.hs_all_team_ids": "string",
            "properties.hs_analytics_latest_source": "string",
            "properties.hs_analytics_latest_source_company": "string",
            "properties.hs_analytics_latest_source_contact": "string",
            "properties.hs_analytics_latest_source_data_1": "string",
            "properties.hs_analytics_latest_source_data_1_company": "string",
            "properties.hs_analytics_latest_source_data_1_contact": "string",
            "properties.hs_analytics_latest_source_data_2": "string",
            "properties.hs_analytics_latest_source_data_2_company": "string",
            "properties.hs_analytics_latest_source_data_2_contact": "string",
            "properties.hs_analytics_latest_source_timestamp": "string",
            "properties.hs_analytics_latest_source_timestamp_company": "string",
            "properties.hs_analytics_latest_source_timestamp_contact": "string",
            "properties.hs_analytics_source": "string",
            "properties.hs_analytics_source_data_1": "string",
            "properties.hs_analytics_source_data_2": "string",
            "properties.hs_arr": "string",
            "properties.hs_campaign": "string",
            "properties.hs_closed_amount": "string",
            "properties.hs_closed_amount_in_home_currency": "string",
            "properties.hs_created_by_user_id": "string",
            "properties.hs_createdate": "string",
            "properties.hs_date_entered_23229963": "string",
            "properties.hs_date_entered_23229964": "string",
            "properties.hs_date_entered_23229965": "string",
            "properties.hs_date_entered_23229966": "string",
            "properties.hs_date_entered_23229967": "string",
            "properties.hs_date_entered_23229968": "string",
            "properties.hs_date_entered_appointmentscheduled": "string",
            "properties.hs_date_entered_closedlost": "string",
            "properties.hs_date_entered_closedwon": "string",
            "properties.hs_date_entered_contractsent": "string",
            "properties.hs_date_entered_decisionmakerboughtin": "string",
            "properties.hs_date_entered_presentationscheduled": "string",
            "properties.hs_date_entered_qualifiedtobuy": "string",
            "properties.hs_date_exited_23229963": "string",
            "properties.hs_date_exited_23229964": "string",
            "properties.hs_date_exited_23229965": "string",
            "properties.hs_date_exited_23229966": "string",
            "properties.hs_date_exited_23229967": "string",
            "properties.hs_date_exited_23229968": "string",
            "properties.hs_date_exited_appointmentscheduled": "string",
            "properties.hs_date_exited_closedlost": "string",
            "properties.hs_date_exited_closedwon": "string",
            "properties.hs_date_exited_contractsent": "string",
            "properties.hs_date_exited_decisionmakerboughtin": "string",
            "properties.hs_date_exited_presentationscheduled": "string",
            "properties.hs_date_exited_qualifiedtobuy": "string",
            "properties.hs_deal_amount_calculation_preference": "string",
            "properties.hs_deal_stage_probability": "string",
            "properties.hs_deal_stage_probability_shadow": "string",
            "properties.hs_exchange_rate": "string",
            "properties.hs_forecast_amount": "string",
            "properties.hs_forecast_probability": "string",
            "properties.hs_is_closed": "string",
            "properties.hs_is_closed_won": "string",
            "properties.hs_is_deal_split": "string",
            "properties.hs_lastmodifieddate": "string",
            "properties.hs_latest_meeting_activity": "string",
            "properties.hs_likelihood_to_close": "string",
            "properties.hs_line_item_global_term_hs_discount_percentage": "string",
            "properties.hs_line_item_global_term_hs_discount_percentage_enabled": "string",
            "properties.hs_line_item_global_term_hs_recurring_billing_period": "string",
            "properties.hs_line_item_global_term_hs_recurring_billing_period_enabled": "string",
            "properties.hs_line_item_global_term_hs_recurring_billing_start_date": "string",
            "properties.hs_line_item_global_term_hs_recurring_billing_start_date_enabled": "string",
            "properties.hs_line_item_global_term_recurringbillingfrequency": "string",
            "properties.hs_line_item_global_term_recurringbillingfrequency_enabled": "string",
            "properties.hs_manual_forecast_category": "string",
            "properties.hs_merged_object_ids": "string",
            "properties.hs_mrr": "string",
            "properties.hs_next_step": "string",
            "properties.hs_num_associated_active_deal_registrations": "string",
            "properties.hs_num_associated_deal_registrations": "string",
            "properties.hs_num_associated_deal_splits": "string",
            "properties.hs_num_target_accounts": "string",
            "properties.hs_object_id": "string",
            "properties.hs_pinned_engagement_id": "string",
            "properties.hs_predicted_amount": "string",
            "properties.hs_predicted_amount_in_home_currency": "string",
            "properties.hs_priority": "string",
            "properties.hs_projected_amount": "string",
            "properties.hs_projected_amount_in_home_currency": "string",
            "properties.hs_read_only": "string",
            "properties.hs_sales_email_last_replied": "string",
            "properties.hs_tcv": "string",
            "properties.hs_time_in_23229963": "string",
            "properties.hs_time_in_23229964": "string",
            "properties.hs_time_in_23229965": "string",
            "properties.hs_time_in_23229966": "string",
            "properties.hs_time_in_23229967": "string",
            "properties.hs_time_in_23229968": "string",
            "properties.hs_time_in_appointmentscheduled": "string",
            "properties.hs_time_in_closedlost": "string",
            "properties.hs_time_in_closedwon": "string",
            "properties.hs_time_in_contractsent": "string",
            "properties.hs_time_in_decisionmakerboughtin": "string",
            "properties.hs_time_in_presentationscheduled": "string",
            "properties.hs_time_in_qualifiedtobuy": "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.likelihood": "string",
            "properties.micro": "string",
            "properties.modules": "string",
            "properties.municipality__city__or_county_owned_property_": "string",
            "properties.must_have_feature_explanation": "string",
            "properties.must_have_features": "string",
            "properties.needs_quickbooks_desktop_integration": "string",
            "properties.next_step": "string",
            "properties.next_step_date": "string",
            "properties.notes_last_contacted": "string",
            "properties.notes_last_updated": "string",
            "properties.notes_next_activity_date": "string",
            "properties.num_associated_contacts": "string",
            "properties.num_contacted_notes": "string",
            "properties.num_notes": "string",
            "properties.number_of_slips": "string",
            "properties.of_resources": "string",
            "properties.of_slips": "string",
            "properties.other_vendor_lost_to": "string",
            "properties.panda_url": "string",
            "properties.perform_date": "string",
            "properties.pipeline": "string",
            "properties.point_of_contact": "string",
            "properties.point_of_contact_email": "string",
            "properties.second_deal_owner": "string",
            "properties.services_offered": "string",
            "properties.size": "string",
            "properties.source": "string",
            "properties.state": "string",
            "properties.state_region": "string",
            "properties.tags": "string",
            "properties.temperature": "string",
            "properties.title__role___responsibilities": "string",
            "properties.vendor_lost_to": "string",
            "properties.website": "string",
            "updatedAt": "string"
        },
        "created": "2023-02-09 09:27:35",
        "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_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`days_to_close`:STRING,`deal_value`:STRING,`dealname`:STRING,`dealstage`:STRING,`hs_analytics_latest_source`:STRING,`hs_analytics_latest_source_company`:STRING,`hs_analytics_latest_source_data_1`:STRING,`hs_analytics_latest_source_data_1_company`:STRING,`hs_analytics_latest_source_data_2`:STRING,`hs_analytics_latest_source_data_2_company`:STRING,`hs_analytics_source`:STRING,`hs_analytics_source_data_1`:STRING,`hs_analytics_source_data_2`:STRING,`hs_closed_amount`:STRING,`hs_closed_amount_in_home_currency`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_closed`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`current_vendor_new`:STRING,`number_of_slips`:STRING,`services_offered`:STRING,`hs_all_accessible_team_ids`:STRING,`hs_all_owner_ids`:STRING,`hs_all_team_ids`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_date_entered_23229964`:STRING,`hs_date_entered_23229965`:STRING,`hs_date_entered_23229966`:STRING,`hs_date_entered_23229967`:STRING,`hs_date_entered_23229968`:STRING,`hs_date_entered_closedwon`:STRING,`hs_date_exited_23229964`:STRING,`hs_date_exited_23229965`:STRING,`hs_date_exited_23229966`:STRING,`hs_date_exited_23229967`:STRING,`hs_date_exited_23229968`:STRING,`hs_time_in_23229964`:STRING,`hs_time_in_23229965`:STRING,`hs_time_in_23229966`:STRING,`hs_time_in_23229967`:STRING,`hs_time_in_23229968`:STRING,`hs_time_in_closedwon`:STRING,`hs_analytics_latest_source_contact`:STRING,`hs_analytics_latest_source_data_1_contact`:STRING,`hs_analytics_latest_source_data_2_contact`:STRING,`hs_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`head_to_head_competitor`:STRING,`hs_forecast_amount`:STRING,`hs_projected_amount`:STRING,`hs_projected_amount_in_home_currency`:STRING,`hs_sales_email_last_replied`:STRING,`likelihood`:STRING,`next_step`:STRING,`next_step_date`:STRING,`source`:STRING,`vendor_lost_to`:STRING,`engagements_last_meeting_booked`:STRING,`forecast_category`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_user_ids_of_all_notification_unfollowers`:STRING,`hs_latest_meeting_activity`:STRING,`needs_quickbooks_desktop_integration`:STRING,`hs_pinned_engagement_id`:STRING,`micro`:STRING,`deal_currency_code`:STRING,`hs_created_by_user_id`:STRING,`hs_date_entered_contractsent`:STRING,`hs_date_entered_decisionmakerboughtin`:STRING,`hs_date_entered_presentationscheduled`:STRING,`hs_date_entered_qualifiedtobuy`:STRING,`hs_date_exited_decisionmakerboughtin`:STRING,`hs_date_exited_presentationscheduled`:STRING,`hs_date_exited_qualifiedtobuy`:STRING,`hs_merged_object_ids`:STRING,`hs_predicted_amount`:STRING,`hs_predicted_amount_in_home_currency`:STRING,`hs_time_in_contractsent`:STRING,`hs_time_in_decisionmakerboughtin`:STRING,`hs_time_in_presentationscheduled`:STRING,`hs_time_in_qualifiedtobuy`:STRING,`hs_date_exited_contractsent`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`must_have_feature_explanation`:STRING,`must_have_features`:STRING,`accounting_integration_desired`:STRING,`additional_notes_or_comments`:STRING,`address`:STRING,`annual_or_monthly`:STRING,`current_accounting_software`:STRING,`deal_value__usd_`:STRING,`enterprise__3__locations_`:STRING,`modules`:STRING,`municipality__city__or_county_owned_property_`:STRING,`of_resources`:STRING,`of_slips`:STRING,`perform_date`:STRING,`point_of_contact`:STRING,`title__role___responsibilities`:STRING,`website`:STRING,`hs_num_associated_deal_splits`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`hs_exchange_rate`: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_deals/2023-02-09/1675956416'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_drivethru.hubspot_molo_deals`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_drivethru.hubspot_molo_deals"
        }
    },
    "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