Schema Info

Schema Name: sfdl_stage_drivethru.hubspot_molo_deals
  • created: 2022-11-30 13:39:25
  • disabled: False
  • format: raw
  • id: 1506
  • is_partitioned: False
  • is_schema_datatyped: False
  • name: 
    {
    "database": "sfdl_stage_drivethru",
    "table": "hubspot_molo_deals"
}
  • type: drivethrujson
Schema Versions: 3
    • created: 2024-12-09 07:19:59
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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,`current_vendor_new`: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_closed_deal_close_date`:STRING,`hs_closed_deal_create_date`:STRING,`hs_closed_won_count`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_days_to_close_raw`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_active_shared_deal`:STRING,`hs_is_closed`:STRING,`hs_is_closed_count`:STRING,`hs_is_closed_lost`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_is_open_count`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_of_associated_line_items`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_open_deal_create_date`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`hs_v2_date_entered_closedlost`:STRING,`hs_was_imported`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`hs_notes_last_activity`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`hs_v2_cumulative_time_in_closedlost`:STRING,`hs_v2_date_exited_closedlost`:STRING,`hs_v2_latest_time_in_closedlost`: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_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_company`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`hs_attributed_team_ids`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_closed_won_date`: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_v2_date_entered_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_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`deal_currency_code`: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,`hs_deal_score`:STRING,`hs_v2_date_entered_23229967`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_v2_cumulative_time_in_closedwon`:STRING,`hs_v2_date_exited_closedwon`:STRING,`hs_v2_latest_time_in_closedwon`: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,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_created_by_user_id`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_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,`hs_v2_date_entered_23229964`:STRING,`hs_v2_cumulative_time_in_23229967`:STRING,`hs_v2_date_exited_23229967`:STRING,`hs_v2_latest_time_in_23229967`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`hs_v2_cumulative_time_in_23229968`:STRING,`hs_v2_date_entered_23229968`:STRING,`hs_v2_date_exited_23229968`:STRING,`hs_v2_latest_time_in_23229968`: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,`hs_v2_cumulative_time_in_23229965`:STRING,`hs_v2_date_entered_23229965`:STRING,`hs_v2_date_exited_23229965`:STRING,`hs_v2_latest_time_in_23229965`: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,`assets`:STRING,`hs_num_associated_deal_splits`:STRING,`hs_v2_date_entered_23229966`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`hs_v2_cumulative_time_in_23229966`:STRING,`hs_v2_date_exited_23229966`:STRING,`hs_v2_latest_time_in_23229966`:STRING,`hs_v2_cumulative_time_in_23229964`:STRING,`hs_v2_date_exited_23229964`:STRING,`hs_v2_latest_time_in_23229964`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_v2_cumulative_time_in_23229963`:STRING,`hs_v2_date_entered_23229963`:STRING,`hs_v2_date_exited_23229963`:STRING,`hs_v2_latest_time_in_23229963`:STRING,`demo_performed`:STRING,`demo_scheduled`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`stellar_bundle_`:STRING,`stellar_rep`:STRING,`city`:STRING,`of_boats`:STRING,`of_service_techs`:STRING,`rental_locations`:STRING,`street_address`:STRING,`accounting_method`:STRING,`hs_date_entered_142982663`:STRING,`hs_date_entered_142982665`:STRING,`hs_date_entered_142982666`:STRING,`hs_date_entered_142982669`:STRING,`hs_date_entered_142982670`:STRING,`hs_date_entered_177683085`:STRING,`hs_date_exited_142982663`:STRING,`hs_date_exited_142982665`:STRING,`hs_date_exited_142982669`:STRING,`hs_date_exited_142982670`:STRING,`hs_date_exited_177683085`:STRING,`hs_is_in_first_deal_stage`:STRING,`hs_time_in_142982663`:STRING,`hs_time_in_142982665`:STRING,`hs_time_in_142982666`:STRING,`hs_time_in_142982669`:STRING,`hs_time_in_142982670`:STRING,`hs_time_in_177683085`:STRING,`hs_v2_date_entered_142982666`:STRING,`non_powered_units`:STRING,`service_locations`:STRING,`slip_locations`:STRING,`billing_support_validated`:STRING,`club_locations`:STRING,`contract__file_`:STRING,`deal_notes___contract_modifications_and_non_standard_billing_summary`:STRING,`deal_value_total___1st_year__arr_and_implementation_fee_`:STRING,`estimated_price_per_slip`:STRING,`ims_license_revenue__`:STRING,`mms_commission__molo_slips_`:STRING,`mms_commission_rep_1`:STRING,`molo_implementation_fees__`:STRING,`operators_last_year_rentals_revenue__stellar_`:STRING,`rentals_license_revenue__rentals___ims_`:STRING,`revenue_type__license__convenience__annual_or_monthly_`:STRING,`service_license_revenue__molo___sms_`:STRING,`slips_license_revenue__molo_`:STRING,`stellar_implementation_fees__`:STRING,`hs_exchange_rate`:STRING,`of_campgrounds`:STRING,`hs_date_entered_142982667`:STRING,`hs_time_in_142982667`:STRING,`hs_v2_cumulative_time_in_142982663`:STRING,`hs_v2_date_entered_142982663`:STRING,`hs_v2_date_entered_142982667`:STRING,`hs_v2_date_exited_142982663`:STRING,`hs_v2_latest_time_in_142982663`:STRING,`active_rollout`:STRING,`integration_fees__erp__fees_arr`:STRING,`ims_commission_sales_rep_1`:STRING,`ims_sales_rep_1__stellar_rentals_`:STRING,`of_club_boats`:STRING,`zoho_id__zoho_crm_`:STRING,`hs_date_entered_177683084`:STRING,`hs_time_in_177683084`:STRING,`hs_v2_date_entered_177683084`:STRING,`hs_v2_cumulative_time_in_142982670`:STRING,`hs_v2_date_entered_142982670`:STRING,`hs_v2_date_exited_142982670`:STRING,`hs_v2_latest_time_in_142982670`:STRING,`mms_commission_rep_2`:STRING,`hs_v2_date_entered_142982669`:STRING,`hs_priority`:STRING,`of_rv_sites`:STRING,`hs_acv`:STRING,`hs_arr`:STRING,`hs_mrr`:STRING,`hs_tcv`:STRING,`hs_v2_cumulative_time_in_142982665`:STRING,`hs_v2_date_entered_142982665`:STRING,`hs_v2_date_exited_142982665`:STRING,`hs_v2_latest_time_in_142982665`:STRING,`of_atvs`:STRING,`ims_sales_rep_2__stellar_rentals___cloned_`:STRING,`of_snowmobiles`:STRING,`integration_complete_`:STRING,`referral_type`:STRING,`contract_signed_date`:STRING,`description`:STRING,`assets__cloned_`:STRING,`powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units`:STRING,`rv___campsites`:STRING,`sms_commission_rep_1`:STRING,`sms_commission_rep_2`:STRING,`hs_v2_cumulative_time_in_142982669`:STRING,`hs_v2_date_exited_142982669`:STRING,`hs_v2_latest_time_in_142982669`:STRING,`sms_commission__service___molo_`:STRING,`hs_v2_cumulative_time_in_142982667`:STRING,`hs_v2_date_exited_142982667`:STRING,`hs_v2_latest_time_in_142982667`:STRING,`buoy_rep__partner_`:STRING,`hs_date_entered_142982492`:STRING,`hs_date_entered_142997278`:STRING,`hs_date_exited_142997278`:STRING,`hs_time_in_142982492`:STRING,`hs_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_136764464`:STRING,`hs_v2_date_entered_136764464`:STRING,`hs_v2_date_entered_142982492`:STRING,`hs_v2_date_exited_136764464`:STRING,`hs_v2_latest_time_in_136764464`:STRING,`partner_referral`:STRING,`partner_rep`:STRING,`hs_date_entered_136764464`:STRING,`hs_date_entered_136764466`:STRING,`hs_date_entered_136764468`:STRING,`hs_date_entered_136764469`:STRING,`hs_date_exited_136764464`:STRING,`hs_date_exited_136764466`:STRING,`hs_date_exited_136764468`:STRING,`hs_date_exited_142982492`:STRING,`hs_time_in_136764464`:STRING,`hs_time_in_136764466`:STRING,`hs_time_in_136764468`:STRING,`hs_time_in_136764469`:STRING,`hs_v2_cumulative_time_in_142982492`:STRING,`hs_v2_date_entered_136764469`:STRING,`hs_v2_date_exited_142982492`:STRING,`hs_v2_latest_time_in_142982492`:STRING,`vquip_rep__partner_`:STRING,`hs_v2_date_entered_136764468`:STRING,`hs_v2_cumulative_time_in_136764469`:STRING,`hs_v2_date_entered_136764466`:STRING,`hs_v2_date_exited_136764469`:STRING,`hs_v2_latest_time_in_136764469`:STRING,`hs_date_entered_147509879`:STRING,`hs_date_exited_147509879`:STRING,`hs_time_in_147509879`:STRING,`hs_v2_cumulative_time_in_147509879`:STRING,`hs_v2_date_entered_147509879`:STRING,`hs_v2_date_exited_147509879`:STRING,`hs_v2_latest_time_in_147509879`:STRING,`hs_date_entered_136764470`:STRING,`hs_time_in_136764470`:STRING,`hs_v2_cumulative_time_in_136764468`:STRING,`hs_v2_date_entered_136764470`:STRING,`hs_v2_date_exited_136764468`:STRING,`hs_v2_latest_time_in_136764468`:STRING,`hs_v2_cumulative_time_in_136764466`:STRING,`hs_v2_cumulative_time_in_142997278`:STRING,`hs_v2_date_entered_142997278`:STRING,`hs_v2_date_exited_136764466`:STRING,`hs_v2_date_exited_142997278`:STRING,`hs_v2_latest_time_in_136764466`:STRING,`hs_v2_latest_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_142982666`:STRING,`hs_v2_date_exited_142982666`:STRING,`hs_v2_latest_time_in_142982666`:STRING,`hs_object_source_detail_1`:STRING,`deal_status_timestamp`:STRING,`license_billing_type`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`hs_next_step`:STRING,`postal_code`:STRING,`state`:STRING,`boatfix_rep__partner_`:STRING,`noreaster_rep__partner_`:STRING,`hs_v2_cumulative_time_in_177683084`:STRING,`hs_v2_date_exited_177683084`:STRING,`hs_v2_latest_time_in_177683084`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`snag_a_slip__partner_`: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-stage/raw/hubspot_molo_deals/2024-12-09/1733750355'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals/2024-12-09/1733750355
    • id: 784039
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "accounting_method": "Accrual",
        "active_rollout": "Yes",
        "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",
        "assets": "MMS",
        "assets__cloned_": "MMS",
        "billing_support_validated": "Validated",
        "boatfix_rep__partner_": "Alastair Crawford",
        "buoy_rep__partner_": "Peter Stalin",
        "caller_owner": "42545200",
        "city": "Bridgton",
        "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",
        "club_locations": "0",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "contract__file_": "https://app.pandadoc.com/a/#/documents/bRp34JwGLrznhorzLy65Gc",
        "contract_signed_date": "2023-11-07",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Marina Go",
        "days_to_close": "1415",
        "deal_currency_code": "USD",
        "deal_notes___contract_modifications_and_non_standard_billing_summary": "240 slips",
        "deal_status": "Performed - DM",
        "deal_status_timestamp": "2024-02-24",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "deal_value_total___1st_year__arr_and_implementation_fee_": "6218.2",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "demo_performed": "2024-04-11",
        "demo_scheduled": "2023-11-17",
        "description": "Club for 3 boats",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "estimated_price_per_slip": "25.909167",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_acv": "5988.00",
        "hs_all_accessible_team_ids": "",
        "hs_all_assigned_business_unit_ids": "0",
        "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": "IMPORT",
        "hs_analytics_latest_source_data_1_company": "IMPORT",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "2224c148-899f-4ed7-b594-fd7b7f50ac2f",
        "hs_analytics_latest_source_data_2_company": "2224c148-899f-4ed7-b594-fd7b7f50ac2f",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2022-08-03T14:01:42.895Z",
        "hs_analytics_latest_source_timestamp_company": "2022-08-03T14:01:42.895Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "OFFLINE",
        "hs_analytics_source_data_1": "IMPORT",
        "hs_analytics_source_data_2": "f76d9deb-c0fc-46e9-8991-64f6899d8284",
        "hs_arr": "5988.00",
        "hs_attributed_team_ids": "242125",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_closed_deal_close_date": "1620869033410",
        "hs_closed_deal_create_date": "1498586908556",
        "hs_closed_won_count": "0",
        "hs_closed_won_date": "2018-06-25T23:19:04.353Z",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.556Z",
        "hs_date_entered_136764464": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764466": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764468": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764469": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764470": "2024-03-28T15:09:50.642Z",
        "hs_date_entered_142982492": "2024-01-05T16:38:26.230Z",
        "hs_date_entered_142982663": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982665": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982666": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982667": "2024-04-22T20:59:06.003Z",
        "hs_date_entered_142982669": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982670": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142997278": "2024-01-05T16:38:26.230Z",
        "hs_date_entered_147509879": "2024-01-29T22:03:09.371Z",
        "hs_date_entered_177683084": "2024-07-01T15:45:42.879Z",
        "hs_date_entered_177683085": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_23229963": "2022-05-31T19:28:02.571Z",
        "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": "2022-06-01T12:36:07.116Z",
        "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_136764464": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_136764466": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_136764468": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_142982492": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_142982663": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982665": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982669": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982670": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142997278": "2024-01-05T16:38:26.230Z",
        "hs_date_exited_147509879": "2024-02-08T16:06:32.350Z",
        "hs_date_exited_177683085": "2024-08-12T21:06:44.043Z",
        "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_days_to_close_raw": "1415.302371",
        "hs_deal_score": "12.0",
        "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_active_shared_deal": "false",
        "hs_is_closed": "true",
        "hs_is_closed_count": "1",
        "hs_is_closed_lost": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_is_in_first_deal_stage": "false",
        "hs_is_open_count": "0",
        "hs_lastmodifieddate": "2022-11-14T20:31:14.119Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_mrr": "499.00",
        "hs_next_step": "Welcome Call",
        "hs_notes_last_activity": "0-27-13252580924",
        "hs_notes_next_activity": "",
        "hs_notes_next_activity_type": "",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_of_associated_line_items": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059206",
        "hs_object_source": "API",
        "hs_object_source_detail_1": "Buoy Insurance Interest Work Flow",
        "hs_object_source_detail_2": "",
        "hs_object_source_detail_3": "",
        "hs_object_source_id": "userId:9386903",
        "hs_object_source_label": "INTERNAL_PROCESSING",
        "hs_object_source_user_id": "9386903",
        "hs_open_deal_create_date": "0",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_priority": "high",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_tcv": "5988.00",
        "hs_time_in_136764464": "0",
        "hs_time_in_136764466": "0",
        "hs_time_in_136764468": "0",
        "hs_time_in_136764469": "21505735693",
        "hs_time_in_136764470": "22110722838",
        "hs_time_in_142982492": "29276605765",
        "hs_time_in_142982663": "0",
        "hs_time_in_142982665": "0",
        "hs_time_in_142982666": "10252495184",
        "hs_time_in_142982667": "19929755281",
        "hs_time_in_142982669": "0",
        "hs_time_in_142982670": "0",
        "hs_time_in_142997278": "0",
        "hs_time_in_147509879": "842602979",
        "hs_time_in_177683084": "13900559278",
        "hs_time_in_177683085": "0",
        "hs_time_in_23229963": "79724014754",
        "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": "79662325163",
        "hs_time_in_closedwon": "114183745982",
        "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": "44200137",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hs_v2_cumulative_time_in_136764464": "261942509",
        "hs_v2_cumulative_time_in_136764466": "2415390737",
        "hs_v2_cumulative_time_in_136764468": "4216174337",
        "hs_v2_cumulative_time_in_136764469": "10883305580",
        "hs_v2_cumulative_time_in_142982492": "7509083516",
        "hs_v2_cumulative_time_in_142982663": "9082870327",
        "hs_v2_cumulative_time_in_142982665": "114641",
        "hs_v2_cumulative_time_in_142982666": "11248324",
        "hs_v2_cumulative_time_in_142982667": "5958135602",
        "hs_v2_cumulative_time_in_142982669": "8444216071",
        "hs_v2_cumulative_time_in_142982670": "97016268",
        "hs_v2_cumulative_time_in_142997278": "2553163",
        "hs_v2_cumulative_time_in_147509879": "842602979",
        "hs_v2_cumulative_time_in_177683084": "57580",
        "hs_v2_cumulative_time_in_23229963": "79722",
        "hs_v2_cumulative_time_in_23229964": "6499144690",
        "hs_v2_cumulative_time_in_23229965": "3561159083",
        "hs_v2_cumulative_time_in_23229966": "604058719",
        "hs_v2_cumulative_time_in_23229967": "543967348",
        "hs_v2_cumulative_time_in_23229968": "5790905137",
        "hs_v2_cumulative_time_in_closedlost": "607040669",
        "hs_v2_cumulative_time_in_closedwon": "8572119445",
        "hs_v2_date_entered_136764464": "2024-01-05T16:38:26.230Z",
        "hs_v2_date_entered_136764466": "2024-05-30T15:08:33.483Z",
        "hs_v2_date_entered_136764468": "2024-01-25T16:17:15.272Z",
        "hs_v2_date_entered_136764469": "2024-04-04T15:12:56.289Z",
        "hs_v2_date_entered_136764470": "2024-03-28T15:09:50.642Z",
        "hs_v2_date_entered_142982492": "2024-01-08T17:24:08.739Z",
        "hs_v2_date_entered_142982663": "2024-01-08T17:57:55.676Z",
        "hs_v2_date_entered_142982665": "2024-02-02T22:01:20.398Z",
        "hs_v2_date_entered_142982666": "2024-08-12T21:06:44.043Z",
        "hs_v2_date_entered_142982667": "2024-04-22T20:59:06.003Z",
        "hs_v2_date_entered_142982669": "2024-04-24T19:26:15.731Z",
        "hs_v2_date_entered_142982670": "2024-01-08T17:54:32.356Z",
        "hs_v2_date_entered_142997278": "2024-02-06T15:46:52.701Z",
        "hs_v2_date_entered_147509879": "2024-01-29T22:03:09.371Z",
        "hs_v2_date_entered_177683084": "2024-07-01T15:45:42.879Z",
        "hs_v2_date_entered_23229963": "2022-05-26T13:34:05.022Z",
        "hs_v2_date_entered_23229964": "2023-07-18T19:48:02.948Z",
        "hs_v2_date_entered_23229965": "2022-07-06T14:44:20.517Z",
        "hs_v2_date_entered_23229966": "2022-06-07T19:42:22.158Z",
        "hs_v2_date_entered_23229967": "2022-06-01T12:36:06.470Z",
        "hs_v2_date_entered_23229968": "2022-06-02T19:50:46.247Z",
        "hs_v2_date_entered_closedlost": "2022-06-01T12:36:07.116Z",
        "hs_v2_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_v2_date_exited_136764464": "2024-01-08T17:24:08.739Z",
        "hs_v2_date_exited_136764466": "2024-03-21T15:05:55.961Z",
        "hs_v2_date_exited_136764468": "2024-03-28T15:09:50.642Z",
        "hs_v2_date_exited_136764469": "2024-05-30T15:08:33.483Z",
        "hs_v2_date_exited_142982492": "2024-04-04T15:12:56.289Z",
        "hs_v2_date_exited_142982663": "2024-04-22T20:59:06.003Z",
        "hs_v2_date_exited_142982665": "2024-02-02T22:03:15.039Z",
        "hs_v2_date_exited_142982666": "2024-02-09T20:19:48.127Z",
        "hs_v2_date_exited_142982667": "2024-07-01T15:42:38.041Z",
        "hs_v2_date_exited_142982669": "2024-04-24T14:49:07.367Z",
        "hs_v2_date_exited_142982670": "2024-01-09T20:51:28.624Z",
        "hs_v2_date_exited_142997278": "2024-02-06T16:29:25.864Z",
        "hs_v2_date_exited_147509879": "2024-02-08T16:06:32.350Z",
        "hs_v2_date_exited_177683084": "2024-04-30T19:22:27.460Z",
        "hs_v2_date_exited_23229963": "2022-05-26T13:35:24.744Z",
        "hs_v2_date_exited_23229964": "2022-08-09T18:52:37.936Z",
        "hs_v2_date_exited_23229965": "2022-08-16T19:56:59.600Z",
        "hs_v2_date_exited_23229966": "2022-07-27T20:06:00.183Z",
        "hs_v2_date_exited_23229967": "2022-06-07T19:42:13.818Z",
        "hs_v2_date_exited_23229968": "2022-08-08T20:25:51.384Z",
        "hs_v2_date_exited_closedlost": "2021-05-20T02:01:15.466Z",
        "hs_v2_date_exited_closedwon": "2018-02-09T21:08:32.994Z",
        "hs_v2_latest_time_in_136764464": "261942509",
        "hs_v2_latest_time_in_136764466": "2415390737",
        "hs_v2_latest_time_in_136764468": "4216174337",
        "hs_v2_latest_time_in_136764469": "10883305580",
        "hs_v2_latest_time_in_142982492": "7509083516",
        "hs_v2_latest_time_in_142982663": "9082870327",
        "hs_v2_latest_time_in_142982665": "114641",
        "hs_v2_latest_time_in_142982666": "192939",
        "hs_v2_latest_time_in_142982667": "5958135602",
        "hs_v2_latest_time_in_142982669": "8444216071",
        "hs_v2_latest_time_in_142982670": "97016268",
        "hs_v2_latest_time_in_142997278": "2553163",
        "hs_v2_latest_time_in_147509879": "842602979",
        "hs_v2_latest_time_in_177683084": "57580",
        "hs_v2_latest_time_in_23229963": "79722",
        "hs_v2_latest_time_in_23229964": "6499144690",
        "hs_v2_latest_time_in_23229965": "3561159083",
        "hs_v2_latest_time_in_23229966": "604058719",
        "hs_v2_latest_time_in_23229967": "543967348",
        "hs_v2_latest_time_in_23229968": "5790905137",
        "hs_v2_latest_time_in_closedlost": "607040669",
        "hs_v2_latest_time_in_closedwon": "8572119445",
        "hs_was_imported": "true",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "ims_commission_sales_rep_1": "Stellar Lead (Company Provided Lead)",
        "ims_license_revenue__": "0",
        "ims_sales_rep_1__stellar_rentals_": "42545200",
        "ims_sales_rep_2__stellar_rentals___cloned_": "378624070",
        "integration_complete_": "No",
        "integration_fees__erp__fees_arr": "0",
        "license_billing_type": "Monthly Stellar License Fee",
        "likelihood": "25%",
        "micro": "true",
        "mms_commission__molo_slips_": "Molo (20%)",
        "mms_commission_rep_1": "42545200",
        "mms_commission_rep_2": "378624067",
        "modules": "Service;Slips/Rack Reservations",
        "molo_implementation_fees__": "0",
        "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",
        "non_powered_units": "0",
        "noreaster_rep__partner_": "Adrian Mott",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-06-04T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_atvs": "6",
        "of_boats": "13",
        "of_campgrounds": "90",
        "of_club_boats": "0",
        "of_resources": "0",
        "of_rv_sites": "50",
        "of_service_techs": "3",
        "of_slips": "375",
        "of_snowmobiles": "0",
        "operators_last_year_rentals_revenue__stellar_": "0",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "partner_referral": "Buoy",
        "partner_rep": "Javier Ortiz",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "postal_code": "25304",
        "powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "0",
        "referral_type": "Neither",
        "rental_locations": "0",
        "rentals_license_revenue__rentals___ims_": "0",
        "revenue_type__license__convenience__annual_or_monthly_": "Slips License Annual",
        "rv___campsites": "0",
        "second_deal_owner": "148939047",
        "service_license_revenue__molo___sms_": "0",
        "service_locations": "1",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "slip_locations": "1",
        "slips_license_revenue__molo_": "6218.2",
        "sms_commission__service___molo_": "",
        "sms_commission_rep_1": "36256868",
        "sms_commission_rep_2": "378624070",
        "snag_a_slip__partner_": "Lisa Colangelo",
        "source": "Inbound",
        "state": "WV",
        "state_region": "MA",
        "stellar_bundle_": "false",
        "stellar_implementation_fees__": "0",
        "stellar_rep": "None",
        "street_address": "779 Harrison RoadBridgton, Maine 04009",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "vquip_rep__partner_": "Devin Pike",
        "website": "https://www.eastrivershipyard.ca/",
        "zoho_id__zoho_crm_": "19990"
    },
    "updatedAt": "2024-06-28T17:58:00.063Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.accounting_method": "string",
    "properties.active_rollout": "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.assets": "string",
    "properties.assets__cloned_": "string",
    "properties.billing_support_validated": "string",
    "properties.boatfix_rep__partner_": "string",
    "properties.buoy_rep__partner_": "string",
    "properties.caller_owner": "string",
    "properties.city": "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.club_locations": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.contract__file_": "string",
    "properties.contract_signed_date": "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_notes___contract_modifications_and_non_standard_billing_summary": "string",
    "properties.deal_status": "string",
    "properties.deal_status_timestamp": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.deal_value_total___1st_year__arr_and_implementation_fee_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.demo_performed": "string",
    "properties.demo_scheduled": "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.estimated_price_per_slip": "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_attributed_team_ids": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_closed_deal_close_date": "string",
    "properties.hs_closed_deal_create_date": "string",
    "properties.hs_closed_won_count": "string",
    "properties.hs_closed_won_date": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_136764464": "string",
    "properties.hs_date_entered_136764466": "string",
    "properties.hs_date_entered_136764468": "string",
    "properties.hs_date_entered_136764469": "string",
    "properties.hs_date_entered_136764470": "string",
    "properties.hs_date_entered_142982492": "string",
    "properties.hs_date_entered_142982663": "string",
    "properties.hs_date_entered_142982665": "string",
    "properties.hs_date_entered_142982666": "string",
    "properties.hs_date_entered_142982667": "string",
    "properties.hs_date_entered_142982669": "string",
    "properties.hs_date_entered_142982670": "string",
    "properties.hs_date_entered_142997278": "string",
    "properties.hs_date_entered_147509879": "string",
    "properties.hs_date_entered_177683084": "string",
    "properties.hs_date_entered_177683085": "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_136764464": "string",
    "properties.hs_date_exited_136764466": "string",
    "properties.hs_date_exited_136764468": "string",
    "properties.hs_date_exited_142982492": "string",
    "properties.hs_date_exited_142982663": "string",
    "properties.hs_date_exited_142982665": "string",
    "properties.hs_date_exited_142982669": "string",
    "properties.hs_date_exited_142982670": "string",
    "properties.hs_date_exited_142997278": "string",
    "properties.hs_date_exited_147509879": "string",
    "properties.hs_date_exited_177683085": "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_days_to_close_raw": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_score": "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_active_shared_deal": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_count": "string",
    "properties.hs_is_closed_lost": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_is_in_first_deal_stage": "string",
    "properties.hs_is_open_count": "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_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "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_of_associated_line_items": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_open_deal_create_date": "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_136764464": "string",
    "properties.hs_time_in_136764466": "string",
    "properties.hs_time_in_136764468": "string",
    "properties.hs_time_in_136764469": "string",
    "properties.hs_time_in_136764470": "string",
    "properties.hs_time_in_142982492": "string",
    "properties.hs_time_in_142982663": "string",
    "properties.hs_time_in_142982665": "string",
    "properties.hs_time_in_142982666": "string",
    "properties.hs_time_in_142982667": "string",
    "properties.hs_time_in_142982669": "string",
    "properties.hs_time_in_142982670": "string",
    "properties.hs_time_in_142997278": "string",
    "properties.hs_time_in_147509879": "string",
    "properties.hs_time_in_177683084": "string",
    "properties.hs_time_in_177683085": "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.hs_v2_cumulative_time_in_136764464": "string",
    "properties.hs_v2_cumulative_time_in_136764466": "string",
    "properties.hs_v2_cumulative_time_in_136764468": "string",
    "properties.hs_v2_cumulative_time_in_136764469": "string",
    "properties.hs_v2_cumulative_time_in_142982492": "string",
    "properties.hs_v2_cumulative_time_in_142982663": "string",
    "properties.hs_v2_cumulative_time_in_142982665": "string",
    "properties.hs_v2_cumulative_time_in_142982666": "string",
    "properties.hs_v2_cumulative_time_in_142982667": "string",
    "properties.hs_v2_cumulative_time_in_142982669": "string",
    "properties.hs_v2_cumulative_time_in_142982670": "string",
    "properties.hs_v2_cumulative_time_in_142997278": "string",
    "properties.hs_v2_cumulative_time_in_147509879": "string",
    "properties.hs_v2_cumulative_time_in_177683084": "string",
    "properties.hs_v2_cumulative_time_in_23229963": "string",
    "properties.hs_v2_cumulative_time_in_23229964": "string",
    "properties.hs_v2_cumulative_time_in_23229965": "string",
    "properties.hs_v2_cumulative_time_in_23229966": "string",
    "properties.hs_v2_cumulative_time_in_23229967": "string",
    "properties.hs_v2_cumulative_time_in_23229968": "string",
    "properties.hs_v2_cumulative_time_in_closedlost": "string",
    "properties.hs_v2_cumulative_time_in_closedwon": "string",
    "properties.hs_v2_date_entered_136764464": "string",
    "properties.hs_v2_date_entered_136764466": "string",
    "properties.hs_v2_date_entered_136764468": "string",
    "properties.hs_v2_date_entered_136764469": "string",
    "properties.hs_v2_date_entered_136764470": "string",
    "properties.hs_v2_date_entered_142982492": "string",
    "properties.hs_v2_date_entered_142982663": "string",
    "properties.hs_v2_date_entered_142982665": "string",
    "properties.hs_v2_date_entered_142982666": "string",
    "properties.hs_v2_date_entered_142982667": "string",
    "properties.hs_v2_date_entered_142982669": "string",
    "properties.hs_v2_date_entered_142982670": "string",
    "properties.hs_v2_date_entered_142997278": "string",
    "properties.hs_v2_date_entered_147509879": "string",
    "properties.hs_v2_date_entered_177683084": "string",
    "properties.hs_v2_date_entered_177683085": "string",
    "properties.hs_v2_date_entered_23229963": "string",
    "properties.hs_v2_date_entered_23229964": "string",
    "properties.hs_v2_date_entered_23229965": "string",
    "properties.hs_v2_date_entered_23229966": "string",
    "properties.hs_v2_date_entered_23229967": "string",
    "properties.hs_v2_date_entered_23229968": "string",
    "properties.hs_v2_date_entered_closedlost": "string",
    "properties.hs_v2_date_entered_closedwon": "string",
    "properties.hs_v2_date_exited_136764464": "string",
    "properties.hs_v2_date_exited_136764466": "string",
    "properties.hs_v2_date_exited_136764468": "string",
    "properties.hs_v2_date_exited_136764469": "string",
    "properties.hs_v2_date_exited_142982492": "string",
    "properties.hs_v2_date_exited_142982663": "string",
    "properties.hs_v2_date_exited_142982665": "string",
    "properties.hs_v2_date_exited_142982666": "string",
    "properties.hs_v2_date_exited_142982667": "string",
    "properties.hs_v2_date_exited_142982669": "string",
    "properties.hs_v2_date_exited_142982670": "string",
    "properties.hs_v2_date_exited_142997278": "string",
    "properties.hs_v2_date_exited_147509879": "string",
    "properties.hs_v2_date_exited_177683084": "string",
    "properties.hs_v2_date_exited_23229963": "string",
    "properties.hs_v2_date_exited_23229964": "string",
    "properties.hs_v2_date_exited_23229965": "string",
    "properties.hs_v2_date_exited_23229966": "string",
    "properties.hs_v2_date_exited_23229967": "string",
    "properties.hs_v2_date_exited_23229968": "string",
    "properties.hs_v2_date_exited_closedlost": "string",
    "properties.hs_v2_date_exited_closedwon": "string",
    "properties.hs_v2_latest_time_in_136764464": "string",
    "properties.hs_v2_latest_time_in_136764466": "string",
    "properties.hs_v2_latest_time_in_136764468": "string",
    "properties.hs_v2_latest_time_in_136764469": "string",
    "properties.hs_v2_latest_time_in_142982492": "string",
    "properties.hs_v2_latest_time_in_142982663": "string",
    "properties.hs_v2_latest_time_in_142982665": "string",
    "properties.hs_v2_latest_time_in_142982666": "string",
    "properties.hs_v2_latest_time_in_142982667": "string",
    "properties.hs_v2_latest_time_in_142982669": "string",
    "properties.hs_v2_latest_time_in_142982670": "string",
    "properties.hs_v2_latest_time_in_142997278": "string",
    "properties.hs_v2_latest_time_in_147509879": "string",
    "properties.hs_v2_latest_time_in_177683084": "string",
    "properties.hs_v2_latest_time_in_23229963": "string",
    "properties.hs_v2_latest_time_in_23229964": "string",
    "properties.hs_v2_latest_time_in_23229965": "string",
    "properties.hs_v2_latest_time_in_23229966": "string",
    "properties.hs_v2_latest_time_in_23229967": "string",
    "properties.hs_v2_latest_time_in_23229968": "string",
    "properties.hs_v2_latest_time_in_closedlost": "string",
    "properties.hs_v2_latest_time_in_closedwon": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.ims_commission_sales_rep_1": "string",
    "properties.ims_license_revenue__": "string",
    "properties.ims_sales_rep_1__stellar_rentals_": "string",
    "properties.ims_sales_rep_2__stellar_rentals___cloned_": "string",
    "properties.integration_complete_": "string",
    "properties.integration_fees__erp__fees_arr": "string",
    "properties.license_billing_type": "string",
    "properties.likelihood": "string",
    "properties.micro": "string",
    "properties.mms_commission__molo_slips_": "string",
    "properties.mms_commission_rep_1": "string",
    "properties.mms_commission_rep_2": "string",
    "properties.modules": "string",
    "properties.molo_implementation_fees__": "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.non_powered_units": "string",
    "properties.noreaster_rep__partner_": "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_atvs": "string",
    "properties.of_boats": "string",
    "properties.of_campgrounds": "string",
    "properties.of_club_boats": "string",
    "properties.of_resources": "string",
    "properties.of_rv_sites": "string",
    "properties.of_service_techs": "string",
    "properties.of_slips": "string",
    "properties.of_snowmobiles": "string",
    "properties.operators_last_year_rentals_revenue__stellar_": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.partner_referral": "string",
    "properties.partner_rep": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.postal_code": "string",
    "properties.powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "string",
    "properties.referral_type": "string",
    "properties.rental_locations": "string",
    "properties.rentals_license_revenue__rentals___ims_": "string",
    "properties.revenue_type__license__convenience__annual_or_monthly_": "string",
    "properties.rv___campsites": "string",
    "properties.second_deal_owner": "string",
    "properties.service_license_revenue__molo___sms_": "string",
    "properties.service_locations": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slip_locations": "string",
    "properties.slips_license_revenue__molo_": "string",
    "properties.sms_commission__service___molo_": "string",
    "properties.sms_commission_rep_1": "string",
    "properties.sms_commission_rep_2": "string",
    "properties.snag_a_slip__partner_": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.stellar_bundle_": "string",
    "properties.stellar_implementation_fees__": "string",
    "properties.stellar_rep": "string",
    "properties.street_address": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.vquip_rep__partner_": "string",
    "properties.website": "string",
    "properties.zoho_id__zoho_crm_": "string",
    "updatedAt": "string"
}
    • schema_name_id: 1506
    • schema_scan_id: 6151012
    • updated: 2024-12-09 07:20:13
    • created: 2024-12-08 07:16:17
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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,`current_vendor_new`: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_closed_deal_close_date`:STRING,`hs_closed_deal_create_date`:STRING,`hs_closed_won_count`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_days_to_close_raw`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_active_shared_deal`:STRING,`hs_is_closed`:STRING,`hs_is_closed_count`:STRING,`hs_is_closed_lost`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_is_open_count`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_of_associated_line_items`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_open_deal_create_date`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`hs_v2_date_entered_closedlost`:STRING,`hs_was_imported`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`hs_notes_last_activity`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`hs_v2_cumulative_time_in_closedlost`:STRING,`hs_v2_date_exited_closedlost`:STRING,`hs_v2_latest_time_in_closedlost`: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_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_company`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`hs_attributed_team_ids`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_closed_won_date`: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_v2_date_entered_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_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`deal_currency_code`: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,`hs_deal_score`:STRING,`hs_v2_date_entered_23229967`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_v2_cumulative_time_in_closedwon`:STRING,`hs_v2_date_exited_closedwon`:STRING,`hs_v2_latest_time_in_closedwon`: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,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_created_by_user_id`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_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,`hs_v2_date_entered_23229964`:STRING,`hs_v2_cumulative_time_in_23229967`:STRING,`hs_v2_date_exited_23229967`:STRING,`hs_v2_latest_time_in_23229967`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`hs_v2_cumulative_time_in_23229968`:STRING,`hs_v2_date_entered_23229968`:STRING,`hs_v2_date_exited_23229968`:STRING,`hs_v2_latest_time_in_23229968`: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,`hs_v2_cumulative_time_in_23229965`:STRING,`hs_v2_date_entered_23229965`:STRING,`hs_v2_date_exited_23229965`:STRING,`hs_v2_latest_time_in_23229965`: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,`assets`:STRING,`hs_num_associated_deal_splits`:STRING,`hs_v2_date_entered_23229966`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`hs_v2_cumulative_time_in_23229966`:STRING,`hs_v2_date_exited_23229966`:STRING,`hs_v2_latest_time_in_23229966`:STRING,`hs_v2_cumulative_time_in_23229964`:STRING,`hs_v2_date_exited_23229964`:STRING,`hs_v2_latest_time_in_23229964`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_v2_cumulative_time_in_23229963`:STRING,`hs_v2_date_entered_23229963`:STRING,`hs_v2_date_exited_23229963`:STRING,`hs_v2_latest_time_in_23229963`:STRING,`demo_performed`:STRING,`demo_scheduled`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`stellar_bundle_`:STRING,`stellar_rep`:STRING,`city`:STRING,`of_boats`:STRING,`of_service_techs`:STRING,`rental_locations`:STRING,`street_address`:STRING,`accounting_method`:STRING,`hs_date_entered_142982663`:STRING,`hs_date_entered_142982665`:STRING,`hs_date_entered_142982666`:STRING,`hs_date_entered_142982669`:STRING,`hs_date_entered_142982670`:STRING,`hs_date_entered_177683085`:STRING,`hs_date_exited_142982663`:STRING,`hs_date_exited_142982665`:STRING,`hs_date_exited_142982669`:STRING,`hs_date_exited_142982670`:STRING,`hs_date_exited_177683085`:STRING,`hs_is_in_first_deal_stage`:STRING,`hs_time_in_142982663`:STRING,`hs_time_in_142982665`:STRING,`hs_time_in_142982666`:STRING,`hs_time_in_142982669`:STRING,`hs_time_in_142982670`:STRING,`hs_time_in_177683085`:STRING,`hs_v2_date_entered_142982666`:STRING,`non_powered_units`:STRING,`service_locations`:STRING,`slip_locations`:STRING,`billing_support_validated`:STRING,`club_locations`:STRING,`contract__file_`:STRING,`deal_notes___contract_modifications_and_non_standard_billing_summary`:STRING,`deal_value_total___1st_year__arr_and_implementation_fee_`:STRING,`estimated_price_per_slip`:STRING,`ims_license_revenue__`:STRING,`mms_commission__molo_slips_`:STRING,`mms_commission_rep_1`:STRING,`molo_implementation_fees__`:STRING,`operators_last_year_rentals_revenue__stellar_`:STRING,`rentals_license_revenue__rentals___ims_`:STRING,`revenue_type__license__convenience__annual_or_monthly_`:STRING,`service_license_revenue__molo___sms_`:STRING,`slips_license_revenue__molo_`:STRING,`stellar_implementation_fees__`:STRING,`hs_exchange_rate`:STRING,`of_campgrounds`:STRING,`hs_date_entered_142982667`:STRING,`hs_time_in_142982667`:STRING,`hs_v2_cumulative_time_in_142982663`:STRING,`hs_v2_date_entered_142982663`:STRING,`hs_v2_date_entered_142982667`:STRING,`hs_v2_date_exited_142982663`:STRING,`hs_v2_latest_time_in_142982663`:STRING,`active_rollout`:STRING,`integration_fees__erp__fees_arr`:STRING,`ims_commission_sales_rep_1`:STRING,`ims_sales_rep_1__stellar_rentals_`:STRING,`of_club_boats`:STRING,`zoho_id__zoho_crm_`:STRING,`hs_date_entered_177683084`:STRING,`hs_time_in_177683084`:STRING,`hs_v2_date_entered_177683084`:STRING,`hs_v2_cumulative_time_in_142982670`:STRING,`hs_v2_date_entered_142982670`:STRING,`hs_v2_date_exited_142982670`:STRING,`hs_v2_latest_time_in_142982670`:STRING,`mms_commission_rep_2`:STRING,`hs_v2_date_entered_142982669`:STRING,`hs_priority`:STRING,`of_rv_sites`:STRING,`hs_acv`:STRING,`hs_arr`:STRING,`hs_mrr`:STRING,`hs_tcv`:STRING,`hs_v2_cumulative_time_in_142982665`:STRING,`hs_v2_date_entered_142982665`:STRING,`hs_v2_date_exited_142982665`:STRING,`hs_v2_latest_time_in_142982665`:STRING,`of_atvs`:STRING,`ims_sales_rep_2__stellar_rentals___cloned_`:STRING,`of_snowmobiles`:STRING,`integration_complete_`:STRING,`referral_type`:STRING,`contract_signed_date`:STRING,`description`:STRING,`assets__cloned_`:STRING,`powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units`:STRING,`rv___campsites`:STRING,`sms_commission_rep_1`:STRING,`sms_commission_rep_2`:STRING,`hs_v2_cumulative_time_in_142982669`:STRING,`hs_v2_date_exited_142982669`:STRING,`hs_v2_latest_time_in_142982669`:STRING,`sms_commission__service___molo_`:STRING,`hs_v2_cumulative_time_in_142982667`:STRING,`hs_v2_date_exited_142982667`:STRING,`hs_v2_latest_time_in_142982667`:STRING,`buoy_rep__partner_`:STRING,`hs_date_entered_142982492`:STRING,`hs_date_entered_142997278`:STRING,`hs_date_exited_142997278`:STRING,`hs_time_in_142982492`:STRING,`hs_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_136764464`:STRING,`hs_v2_date_entered_136764464`:STRING,`hs_v2_date_entered_142982492`:STRING,`hs_v2_date_exited_136764464`:STRING,`hs_v2_latest_time_in_136764464`:STRING,`partner_referral`:STRING,`partner_rep`:STRING,`hs_date_entered_136764464`:STRING,`hs_date_entered_136764466`:STRING,`hs_date_entered_136764468`:STRING,`hs_date_entered_136764469`:STRING,`hs_date_exited_136764464`:STRING,`hs_date_exited_136764466`:STRING,`hs_date_exited_136764468`:STRING,`hs_date_exited_142982492`:STRING,`hs_time_in_136764464`:STRING,`hs_time_in_136764466`:STRING,`hs_time_in_136764468`:STRING,`hs_time_in_136764469`:STRING,`hs_v2_cumulative_time_in_142982492`:STRING,`hs_v2_date_entered_136764469`:STRING,`hs_v2_date_exited_142982492`:STRING,`hs_v2_latest_time_in_142982492`:STRING,`vquip_rep__partner_`:STRING,`hs_v2_date_entered_136764468`:STRING,`hs_v2_cumulative_time_in_136764469`:STRING,`hs_v2_date_entered_136764466`:STRING,`hs_v2_date_exited_136764469`:STRING,`hs_v2_latest_time_in_136764469`:STRING,`hs_date_entered_147509879`:STRING,`hs_date_exited_147509879`:STRING,`hs_time_in_147509879`:STRING,`hs_v2_cumulative_time_in_147509879`:STRING,`hs_v2_date_entered_147509879`:STRING,`hs_v2_date_exited_147509879`:STRING,`hs_v2_latest_time_in_147509879`:STRING,`hs_date_entered_136764470`:STRING,`hs_time_in_136764470`:STRING,`hs_v2_cumulative_time_in_136764468`:STRING,`hs_v2_date_entered_136764470`:STRING,`hs_v2_date_exited_136764468`:STRING,`hs_v2_latest_time_in_136764468`:STRING,`hs_v2_cumulative_time_in_136764466`:STRING,`hs_v2_cumulative_time_in_142997278`:STRING,`hs_v2_date_entered_142997278`:STRING,`hs_v2_date_exited_136764466`:STRING,`hs_v2_date_exited_142997278`:STRING,`hs_v2_latest_time_in_136764466`:STRING,`hs_v2_latest_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_142982666`:STRING,`hs_v2_date_exited_142982666`:STRING,`hs_v2_latest_time_in_142982666`:STRING,`hs_object_source_detail_1`:STRING,`deal_status_timestamp`:STRING,`license_billing_type`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`hs_next_step`:STRING,`postal_code`:STRING,`state`:STRING,`boatfix_rep__partner_`:STRING,`noreaster_rep__partner_`:STRING,`hs_v2_cumulative_time_in_177683084`:STRING,`hs_v2_date_exited_177683084`:STRING,`hs_v2_latest_time_in_177683084`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`snag_a_slip__partner_`: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-stage/raw/hubspot_molo_deals/2024-12-08/1733663746'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals/2024-12-08/1733663746
    • id: 783599
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "accounting_method": "Accrual",
        "active_rollout": "Yes",
        "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",
        "assets": "MMS",
        "assets__cloned_": "MMS",
        "billing_support_validated": "Validated",
        "boatfix_rep__partner_": "Alastair Crawford",
        "buoy_rep__partner_": "Peter Stalin",
        "caller_owner": "42545200",
        "city": "Bridgton",
        "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",
        "club_locations": "0",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "contract__file_": "https://app.pandadoc.com/a/#/documents/bRp34JwGLrznhorzLy65Gc",
        "contract_signed_date": "2023-11-07",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Marina Go",
        "days_to_close": "1415",
        "deal_currency_code": "USD",
        "deal_notes___contract_modifications_and_non_standard_billing_summary": "240 slips",
        "deal_status": "Performed - DM",
        "deal_status_timestamp": "2024-02-24",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "deal_value_total___1st_year__arr_and_implementation_fee_": "6218.2",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "demo_performed": "2024-04-11",
        "demo_scheduled": "2023-11-17",
        "description": "Club for 3 boats",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "estimated_price_per_slip": "25.909167",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_acv": "5988.00",
        "hs_all_accessible_team_ids": "",
        "hs_all_assigned_business_unit_ids": "0",
        "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": "IMPORT",
        "hs_analytics_latest_source_data_1_company": "IMPORT",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "2224c148-899f-4ed7-b594-fd7b7f50ac2f",
        "hs_analytics_latest_source_data_2_company": "2224c148-899f-4ed7-b594-fd7b7f50ac2f",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2022-08-03T14:01:42.895Z",
        "hs_analytics_latest_source_timestamp_company": "2022-08-03T14:01:42.895Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "OFFLINE",
        "hs_analytics_source_data_1": "IMPORT",
        "hs_analytics_source_data_2": "f76d9deb-c0fc-46e9-8991-64f6899d8284",
        "hs_arr": "5988.00",
        "hs_attributed_team_ids": "242125",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_closed_deal_close_date": "1620869033410",
        "hs_closed_deal_create_date": "1498586908556",
        "hs_closed_won_count": "0",
        "hs_closed_won_date": "2018-06-25T23:19:04.353Z",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.556Z",
        "hs_date_entered_136764464": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764466": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764468": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764469": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764470": "2024-03-28T15:09:50.642Z",
        "hs_date_entered_142982492": "2024-01-05T16:38:26.230Z",
        "hs_date_entered_142982663": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982665": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982666": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982667": "2024-04-22T20:59:06.003Z",
        "hs_date_entered_142982669": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982670": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142997278": "2024-01-05T16:38:26.230Z",
        "hs_date_entered_147509879": "2024-01-29T22:03:09.371Z",
        "hs_date_entered_177683084": "2024-07-01T15:45:42.879Z",
        "hs_date_entered_177683085": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_23229963": "2022-05-31T19:28:02.571Z",
        "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": "2022-06-01T12:36:07.116Z",
        "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_136764464": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_136764466": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_136764468": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_142982492": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_142982663": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982665": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982669": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982670": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142997278": "2024-01-05T16:38:26.230Z",
        "hs_date_exited_147509879": "2024-02-08T16:06:32.350Z",
        "hs_date_exited_177683085": "2024-08-12T21:06:44.043Z",
        "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_days_to_close_raw": "1415.302371",
        "hs_deal_score": "12.0",
        "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_active_shared_deal": "false",
        "hs_is_closed": "true",
        "hs_is_closed_count": "1",
        "hs_is_closed_lost": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_is_in_first_deal_stage": "false",
        "hs_is_open_count": "0",
        "hs_lastmodifieddate": "2022-11-14T20:31:14.119Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_mrr": "499.00",
        "hs_next_step": "Welcome Call",
        "hs_notes_last_activity": "0-27-13252580924",
        "hs_notes_next_activity": "",
        "hs_notes_next_activity_type": "",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_of_associated_line_items": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059206",
        "hs_object_source": "API",
        "hs_object_source_detail_1": "Buoy Insurance Interest Work Flow",
        "hs_object_source_detail_2": "",
        "hs_object_source_detail_3": "",
        "hs_object_source_id": "userId:9386903",
        "hs_object_source_label": "INTERNAL_PROCESSING",
        "hs_object_source_user_id": "9386903",
        "hs_open_deal_create_date": "0",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_priority": "high",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_tcv": "5988.00",
        "hs_time_in_136764464": "0",
        "hs_time_in_136764466": "0",
        "hs_time_in_136764468": "0",
        "hs_time_in_136764469": "21419260841",
        "hs_time_in_136764470": "22024248951",
        "hs_time_in_142982492": "29190130908",
        "hs_time_in_142982663": "0",
        "hs_time_in_142982665": "0",
        "hs_time_in_142982666": "10166021952",
        "hs_time_in_142982667": "19843282037",
        "hs_time_in_142982669": "0",
        "hs_time_in_142982670": "0",
        "hs_time_in_142997278": "0",
        "hs_time_in_147509879": "842602979",
        "hs_time_in_177683084": "13814085843",
        "hs_time_in_177683085": "0",
        "hs_time_in_23229963": "79637541353",
        "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": "79575852401",
        "hs_time_in_closedwon": "114097273224",
        "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": "44200137",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hs_v2_cumulative_time_in_136764464": "261942509",
        "hs_v2_cumulative_time_in_136764466": "2415390737",
        "hs_v2_cumulative_time_in_136764468": "4216174337",
        "hs_v2_cumulative_time_in_136764469": "10883305580",
        "hs_v2_cumulative_time_in_142982492": "7509083516",
        "hs_v2_cumulative_time_in_142982663": "9082870327",
        "hs_v2_cumulative_time_in_142982665": "114641",
        "hs_v2_cumulative_time_in_142982666": "11248324",
        "hs_v2_cumulative_time_in_142982667": "5958135602",
        "hs_v2_cumulative_time_in_142982669": "8444216071",
        "hs_v2_cumulative_time_in_142982670": "97016268",
        "hs_v2_cumulative_time_in_142997278": "2553163",
        "hs_v2_cumulative_time_in_147509879": "842602979",
        "hs_v2_cumulative_time_in_177683084": "57580",
        "hs_v2_cumulative_time_in_23229963": "79722",
        "hs_v2_cumulative_time_in_23229964": "6499144690",
        "hs_v2_cumulative_time_in_23229965": "3561159083",
        "hs_v2_cumulative_time_in_23229966": "604058719",
        "hs_v2_cumulative_time_in_23229967": "543967348",
        "hs_v2_cumulative_time_in_23229968": "5790905137",
        "hs_v2_cumulative_time_in_closedlost": "607040669",
        "hs_v2_cumulative_time_in_closedwon": "8572119445",
        "hs_v2_date_entered_136764464": "2024-01-05T16:38:26.230Z",
        "hs_v2_date_entered_136764466": "2024-05-30T15:08:33.483Z",
        "hs_v2_date_entered_136764468": "2024-01-25T16:17:15.272Z",
        "hs_v2_date_entered_136764469": "2024-04-04T15:12:56.289Z",
        "hs_v2_date_entered_136764470": "2024-03-28T15:09:50.642Z",
        "hs_v2_date_entered_142982492": "2024-01-08T17:24:08.739Z",
        "hs_v2_date_entered_142982663": "2024-01-08T17:57:55.676Z",
        "hs_v2_date_entered_142982665": "2024-02-02T22:01:20.398Z",
        "hs_v2_date_entered_142982666": "2024-08-12T21:06:44.043Z",
        "hs_v2_date_entered_142982667": "2024-04-22T20:59:06.003Z",
        "hs_v2_date_entered_142982669": "2024-04-24T19:26:15.731Z",
        "hs_v2_date_entered_142982670": "2024-01-08T17:54:32.356Z",
        "hs_v2_date_entered_142997278": "2024-02-06T15:46:52.701Z",
        "hs_v2_date_entered_147509879": "2024-01-29T22:03:09.371Z",
        "hs_v2_date_entered_177683084": "2024-07-01T15:45:42.879Z",
        "hs_v2_date_entered_23229963": "2022-05-26T13:34:05.022Z",
        "hs_v2_date_entered_23229964": "2023-07-18T19:48:02.948Z",
        "hs_v2_date_entered_23229965": "2022-07-06T14:44:20.517Z",
        "hs_v2_date_entered_23229966": "2022-06-07T19:42:22.158Z",
        "hs_v2_date_entered_23229967": "2022-06-01T12:36:06.470Z",
        "hs_v2_date_entered_23229968": "2022-06-02T19:50:46.247Z",
        "hs_v2_date_entered_closedlost": "2022-06-01T12:36:07.116Z",
        "hs_v2_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_v2_date_exited_136764464": "2024-01-08T17:24:08.739Z",
        "hs_v2_date_exited_136764466": "2024-03-21T15:05:55.961Z",
        "hs_v2_date_exited_136764468": "2024-03-28T15:09:50.642Z",
        "hs_v2_date_exited_136764469": "2024-05-30T15:08:33.483Z",
        "hs_v2_date_exited_142982492": "2024-04-04T15:12:56.289Z",
        "hs_v2_date_exited_142982663": "2024-04-22T20:59:06.003Z",
        "hs_v2_date_exited_142982665": "2024-02-02T22:03:15.039Z",
        "hs_v2_date_exited_142982666": "2024-02-09T20:19:48.127Z",
        "hs_v2_date_exited_142982667": "2024-07-01T15:42:38.041Z",
        "hs_v2_date_exited_142982669": "2024-04-24T14:49:07.367Z",
        "hs_v2_date_exited_142982670": "2024-01-09T20:51:28.624Z",
        "hs_v2_date_exited_142997278": "2024-02-06T16:29:25.864Z",
        "hs_v2_date_exited_147509879": "2024-02-08T16:06:32.350Z",
        "hs_v2_date_exited_177683084": "2024-04-30T19:22:27.460Z",
        "hs_v2_date_exited_23229963": "2022-05-26T13:35:24.744Z",
        "hs_v2_date_exited_23229964": "2022-08-09T18:52:37.936Z",
        "hs_v2_date_exited_23229965": "2022-08-16T19:56:59.600Z",
        "hs_v2_date_exited_23229966": "2022-07-27T20:06:00.183Z",
        "hs_v2_date_exited_23229967": "2022-06-07T19:42:13.818Z",
        "hs_v2_date_exited_23229968": "2022-08-08T20:25:51.384Z",
        "hs_v2_date_exited_closedlost": "2021-05-20T02:01:15.466Z",
        "hs_v2_date_exited_closedwon": "2018-02-09T21:08:32.994Z",
        "hs_v2_latest_time_in_136764464": "261942509",
        "hs_v2_latest_time_in_136764466": "2415390737",
        "hs_v2_latest_time_in_136764468": "4216174337",
        "hs_v2_latest_time_in_136764469": "10883305580",
        "hs_v2_latest_time_in_142982492": "7509083516",
        "hs_v2_latest_time_in_142982663": "9082870327",
        "hs_v2_latest_time_in_142982665": "114641",
        "hs_v2_latest_time_in_142982666": "192939",
        "hs_v2_latest_time_in_142982667": "5958135602",
        "hs_v2_latest_time_in_142982669": "8444216071",
        "hs_v2_latest_time_in_142982670": "97016268",
        "hs_v2_latest_time_in_142997278": "2553163",
        "hs_v2_latest_time_in_147509879": "842602979",
        "hs_v2_latest_time_in_177683084": "57580",
        "hs_v2_latest_time_in_23229963": "79722",
        "hs_v2_latest_time_in_23229964": "6499144690",
        "hs_v2_latest_time_in_23229965": "3561159083",
        "hs_v2_latest_time_in_23229966": "604058719",
        "hs_v2_latest_time_in_23229967": "543967348",
        "hs_v2_latest_time_in_23229968": "5790905137",
        "hs_v2_latest_time_in_closedlost": "607040669",
        "hs_v2_latest_time_in_closedwon": "8572119445",
        "hs_was_imported": "true",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "ims_commission_sales_rep_1": "Stellar Lead (Company Provided Lead)",
        "ims_license_revenue__": "0",
        "ims_sales_rep_1__stellar_rentals_": "42545200",
        "ims_sales_rep_2__stellar_rentals___cloned_": "378624070",
        "integration_complete_": "No",
        "integration_fees__erp__fees_arr": "0",
        "license_billing_type": "Monthly Stellar License Fee",
        "likelihood": "25%",
        "micro": "true",
        "mms_commission__molo_slips_": "Molo (20%)",
        "mms_commission_rep_1": "42545200",
        "mms_commission_rep_2": "378624067",
        "modules": "Service;Slips/Rack Reservations",
        "molo_implementation_fees__": "0",
        "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",
        "non_powered_units": "0",
        "noreaster_rep__partner_": "Adrian Mott",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-06-04T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_atvs": "6",
        "of_boats": "13",
        "of_campgrounds": "90",
        "of_club_boats": "0",
        "of_resources": "0",
        "of_rv_sites": "50",
        "of_service_techs": "3",
        "of_slips": "375",
        "of_snowmobiles": "0",
        "operators_last_year_rentals_revenue__stellar_": "0",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "partner_referral": "Buoy",
        "partner_rep": "Javier Ortiz",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "postal_code": "25304",
        "powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "0",
        "referral_type": "Neither",
        "rental_locations": "0",
        "rentals_license_revenue__rentals___ims_": "0",
        "revenue_type__license__convenience__annual_or_monthly_": "Slips License Annual",
        "rv___campsites": "0",
        "second_deal_owner": "148939047",
        "service_license_revenue__molo___sms_": "0",
        "service_locations": "1",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "slip_locations": "1",
        "slips_license_revenue__molo_": "6218.2",
        "sms_commission__service___molo_": "",
        "sms_commission_rep_1": "36256868",
        "sms_commission_rep_2": "378624070",
        "snag_a_slip__partner_": "Lisa Colangelo",
        "source": "Inbound",
        "state": "WV",
        "state_region": "MA",
        "stellar_bundle_": "false",
        "stellar_implementation_fees__": "0",
        "stellar_rep": "None",
        "street_address": "779 Harrison RoadBridgton, Maine 04009",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "vquip_rep__partner_": "Devin Pike",
        "website": "https://www.eastrivershipyard.ca/",
        "zoho_id__zoho_crm_": "19990"
    },
    "updatedAt": "2024-06-28T17:58:00.063Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.accounting_method": "string",
    "properties.active_rollout": "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.assets": "string",
    "properties.assets__cloned_": "string",
    "properties.billing_support_validated": "string",
    "properties.boatfix_rep__partner_": "string",
    "properties.buoy_rep__partner_": "string",
    "properties.caller_owner": "string",
    "properties.city": "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.club_locations": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.contract__file_": "string",
    "properties.contract_signed_date": "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_notes___contract_modifications_and_non_standard_billing_summary": "string",
    "properties.deal_status": "string",
    "properties.deal_status_timestamp": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.deal_value_total___1st_year__arr_and_implementation_fee_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.demo_performed": "string",
    "properties.demo_scheduled": "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.estimated_price_per_slip": "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_attributed_team_ids": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_closed_deal_close_date": "string",
    "properties.hs_closed_deal_create_date": "string",
    "properties.hs_closed_won_count": "string",
    "properties.hs_closed_won_date": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_136764464": "string",
    "properties.hs_date_entered_136764466": "string",
    "properties.hs_date_entered_136764468": "string",
    "properties.hs_date_entered_136764469": "string",
    "properties.hs_date_entered_136764470": "string",
    "properties.hs_date_entered_142982492": "string",
    "properties.hs_date_entered_142982663": "string",
    "properties.hs_date_entered_142982665": "string",
    "properties.hs_date_entered_142982666": "string",
    "properties.hs_date_entered_142982667": "string",
    "properties.hs_date_entered_142982669": "string",
    "properties.hs_date_entered_142982670": "string",
    "properties.hs_date_entered_142997278": "string",
    "properties.hs_date_entered_147509879": "string",
    "properties.hs_date_entered_177683084": "string",
    "properties.hs_date_entered_177683085": "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_136764464": "string",
    "properties.hs_date_exited_136764466": "string",
    "properties.hs_date_exited_136764468": "string",
    "properties.hs_date_exited_142982492": "string",
    "properties.hs_date_exited_142982663": "string",
    "properties.hs_date_exited_142982665": "string",
    "properties.hs_date_exited_142982669": "string",
    "properties.hs_date_exited_142982670": "string",
    "properties.hs_date_exited_142997278": "string",
    "properties.hs_date_exited_147509879": "string",
    "properties.hs_date_exited_177683085": "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_days_to_close_raw": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_score": "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_active_shared_deal": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_count": "string",
    "properties.hs_is_closed_lost": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_is_in_first_deal_stage": "string",
    "properties.hs_is_open_count": "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_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "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_of_associated_line_items": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_open_deal_create_date": "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_136764464": "string",
    "properties.hs_time_in_136764466": "string",
    "properties.hs_time_in_136764468": "string",
    "properties.hs_time_in_136764469": "string",
    "properties.hs_time_in_136764470": "string",
    "properties.hs_time_in_142982492": "string",
    "properties.hs_time_in_142982663": "string",
    "properties.hs_time_in_142982665": "string",
    "properties.hs_time_in_142982666": "string",
    "properties.hs_time_in_142982667": "string",
    "properties.hs_time_in_142982669": "string",
    "properties.hs_time_in_142982670": "string",
    "properties.hs_time_in_142997278": "string",
    "properties.hs_time_in_147509879": "string",
    "properties.hs_time_in_177683084": "string",
    "properties.hs_time_in_177683085": "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.hs_v2_cumulative_time_in_136764464": "string",
    "properties.hs_v2_cumulative_time_in_136764466": "string",
    "properties.hs_v2_cumulative_time_in_136764468": "string",
    "properties.hs_v2_cumulative_time_in_136764469": "string",
    "properties.hs_v2_cumulative_time_in_142982492": "string",
    "properties.hs_v2_cumulative_time_in_142982663": "string",
    "properties.hs_v2_cumulative_time_in_142982665": "string",
    "properties.hs_v2_cumulative_time_in_142982666": "string",
    "properties.hs_v2_cumulative_time_in_142982667": "string",
    "properties.hs_v2_cumulative_time_in_142982669": "string",
    "properties.hs_v2_cumulative_time_in_142982670": "string",
    "properties.hs_v2_cumulative_time_in_142997278": "string",
    "properties.hs_v2_cumulative_time_in_147509879": "string",
    "properties.hs_v2_cumulative_time_in_177683084": "string",
    "properties.hs_v2_cumulative_time_in_23229963": "string",
    "properties.hs_v2_cumulative_time_in_23229964": "string",
    "properties.hs_v2_cumulative_time_in_23229965": "string",
    "properties.hs_v2_cumulative_time_in_23229966": "string",
    "properties.hs_v2_cumulative_time_in_23229967": "string",
    "properties.hs_v2_cumulative_time_in_23229968": "string",
    "properties.hs_v2_cumulative_time_in_closedlost": "string",
    "properties.hs_v2_cumulative_time_in_closedwon": "string",
    "properties.hs_v2_date_entered_136764464": "string",
    "properties.hs_v2_date_entered_136764466": "string",
    "properties.hs_v2_date_entered_136764468": "string",
    "properties.hs_v2_date_entered_136764469": "string",
    "properties.hs_v2_date_entered_136764470": "string",
    "properties.hs_v2_date_entered_142982492": "string",
    "properties.hs_v2_date_entered_142982663": "string",
    "properties.hs_v2_date_entered_142982665": "string",
    "properties.hs_v2_date_entered_142982666": "string",
    "properties.hs_v2_date_entered_142982667": "string",
    "properties.hs_v2_date_entered_142982669": "string",
    "properties.hs_v2_date_entered_142982670": "string",
    "properties.hs_v2_date_entered_142997278": "string",
    "properties.hs_v2_date_entered_147509879": "string",
    "properties.hs_v2_date_entered_177683084": "string",
    "properties.hs_v2_date_entered_177683085": "string",
    "properties.hs_v2_date_entered_23229963": "string",
    "properties.hs_v2_date_entered_23229964": "string",
    "properties.hs_v2_date_entered_23229965": "string",
    "properties.hs_v2_date_entered_23229966": "string",
    "properties.hs_v2_date_entered_23229967": "string",
    "properties.hs_v2_date_entered_23229968": "string",
    "properties.hs_v2_date_entered_closedlost": "string",
    "properties.hs_v2_date_entered_closedwon": "string",
    "properties.hs_v2_date_exited_136764464": "string",
    "properties.hs_v2_date_exited_136764466": "string",
    "properties.hs_v2_date_exited_136764468": "string",
    "properties.hs_v2_date_exited_136764469": "string",
    "properties.hs_v2_date_exited_142982492": "string",
    "properties.hs_v2_date_exited_142982663": "string",
    "properties.hs_v2_date_exited_142982665": "string",
    "properties.hs_v2_date_exited_142982666": "string",
    "properties.hs_v2_date_exited_142982667": "string",
    "properties.hs_v2_date_exited_142982669": "string",
    "properties.hs_v2_date_exited_142982670": "string",
    "properties.hs_v2_date_exited_142997278": "string",
    "properties.hs_v2_date_exited_147509879": "string",
    "properties.hs_v2_date_exited_177683084": "string",
    "properties.hs_v2_date_exited_23229963": "string",
    "properties.hs_v2_date_exited_23229964": "string",
    "properties.hs_v2_date_exited_23229965": "string",
    "properties.hs_v2_date_exited_23229966": "string",
    "properties.hs_v2_date_exited_23229967": "string",
    "properties.hs_v2_date_exited_23229968": "string",
    "properties.hs_v2_date_exited_closedlost": "string",
    "properties.hs_v2_date_exited_closedwon": "string",
    "properties.hs_v2_latest_time_in_136764464": "string",
    "properties.hs_v2_latest_time_in_136764466": "string",
    "properties.hs_v2_latest_time_in_136764468": "string",
    "properties.hs_v2_latest_time_in_136764469": "string",
    "properties.hs_v2_latest_time_in_142982492": "string",
    "properties.hs_v2_latest_time_in_142982663": "string",
    "properties.hs_v2_latest_time_in_142982665": "string",
    "properties.hs_v2_latest_time_in_142982666": "string",
    "properties.hs_v2_latest_time_in_142982667": "string",
    "properties.hs_v2_latest_time_in_142982669": "string",
    "properties.hs_v2_latest_time_in_142982670": "string",
    "properties.hs_v2_latest_time_in_142997278": "string",
    "properties.hs_v2_latest_time_in_147509879": "string",
    "properties.hs_v2_latest_time_in_177683084": "string",
    "properties.hs_v2_latest_time_in_23229963": "string",
    "properties.hs_v2_latest_time_in_23229964": "string",
    "properties.hs_v2_latest_time_in_23229965": "string",
    "properties.hs_v2_latest_time_in_23229966": "string",
    "properties.hs_v2_latest_time_in_23229967": "string",
    "properties.hs_v2_latest_time_in_23229968": "string",
    "properties.hs_v2_latest_time_in_closedlost": "string",
    "properties.hs_v2_latest_time_in_closedwon": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.ims_commission_sales_rep_1": "string",
    "properties.ims_license_revenue__": "string",
    "properties.ims_sales_rep_1__stellar_rentals_": "string",
    "properties.ims_sales_rep_2__stellar_rentals___cloned_": "string",
    "properties.integration_complete_": "string",
    "properties.integration_fees__erp__fees_arr": "string",
    "properties.license_billing_type": "string",
    "properties.likelihood": "string",
    "properties.micro": "string",
    "properties.mms_commission__molo_slips_": "string",
    "properties.mms_commission_rep_1": "string",
    "properties.mms_commission_rep_2": "string",
    "properties.modules": "string",
    "properties.molo_implementation_fees__": "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.non_powered_units": "string",
    "properties.noreaster_rep__partner_": "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_atvs": "string",
    "properties.of_boats": "string",
    "properties.of_campgrounds": "string",
    "properties.of_club_boats": "string",
    "properties.of_resources": "string",
    "properties.of_rv_sites": "string",
    "properties.of_service_techs": "string",
    "properties.of_slips": "string",
    "properties.of_snowmobiles": "string",
    "properties.operators_last_year_rentals_revenue__stellar_": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.partner_referral": "string",
    "properties.partner_rep": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.postal_code": "string",
    "properties.powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "string",
    "properties.referral_type": "string",
    "properties.rental_locations": "string",
    "properties.rentals_license_revenue__rentals___ims_": "string",
    "properties.revenue_type__license__convenience__annual_or_monthly_": "string",
    "properties.rv___campsites": "string",
    "properties.second_deal_owner": "string",
    "properties.service_license_revenue__molo___sms_": "string",
    "properties.service_locations": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slip_locations": "string",
    "properties.slips_license_revenue__molo_": "string",
    "properties.sms_commission__service___molo_": "string",
    "properties.sms_commission_rep_1": "string",
    "properties.sms_commission_rep_2": "string",
    "properties.snag_a_slip__partner_": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.stellar_bundle_": "string",
    "properties.stellar_implementation_fees__": "string",
    "properties.stellar_rep": "string",
    "properties.street_address": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.vquip_rep__partner_": "string",
    "properties.website": "string",
    "properties.zoho_id__zoho_crm_": "string",
    "updatedAt": "string"
}
    • schema_name_id: 1506
    • schema_scan_id: 6149367
    • updated: 2024-12-08 07:16:28
    • created: 2024-12-07 07:20:58
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_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,`current_vendor_new`: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_closed_deal_close_date`:STRING,`hs_closed_deal_create_date`:STRING,`hs_closed_won_count`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_days_to_close_raw`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_active_shared_deal`:STRING,`hs_is_closed`:STRING,`hs_is_closed_count`:STRING,`hs_is_closed_lost`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_is_open_count`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_of_associated_line_items`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_open_deal_create_date`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`hs_v2_date_entered_closedlost`:STRING,`hs_was_imported`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`hs_notes_last_activity`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`hs_v2_cumulative_time_in_closedlost`:STRING,`hs_v2_date_exited_closedlost`:STRING,`hs_v2_latest_time_in_closedlost`: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_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_company`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`hs_attributed_team_ids`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_closed_won_date`: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_v2_date_entered_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_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`deal_currency_code`: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,`hs_deal_score`:STRING,`hs_v2_date_entered_23229967`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_v2_cumulative_time_in_closedwon`:STRING,`hs_v2_date_exited_closedwon`:STRING,`hs_v2_latest_time_in_closedwon`: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,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_created_by_user_id`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_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,`hs_v2_date_entered_23229964`:STRING,`hs_v2_cumulative_time_in_23229967`:STRING,`hs_v2_date_exited_23229967`:STRING,`hs_v2_latest_time_in_23229967`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`hs_v2_cumulative_time_in_23229968`:STRING,`hs_v2_date_entered_23229968`:STRING,`hs_v2_date_exited_23229968`:STRING,`hs_v2_latest_time_in_23229968`: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,`hs_v2_cumulative_time_in_23229965`:STRING,`hs_v2_date_entered_23229965`:STRING,`hs_v2_date_exited_23229965`:STRING,`hs_v2_latest_time_in_23229965`: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,`assets`:STRING,`hs_num_associated_deal_splits`:STRING,`hs_v2_date_entered_23229966`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`hs_v2_cumulative_time_in_23229966`:STRING,`hs_v2_date_exited_23229966`:STRING,`hs_v2_latest_time_in_23229966`:STRING,`hs_v2_cumulative_time_in_23229964`:STRING,`hs_v2_date_exited_23229964`:STRING,`hs_v2_latest_time_in_23229964`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_v2_cumulative_time_in_23229963`:STRING,`hs_v2_date_entered_23229963`:STRING,`hs_v2_date_exited_23229963`:STRING,`hs_v2_latest_time_in_23229963`:STRING,`demo_performed`:STRING,`demo_scheduled`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`stellar_bundle_`:STRING,`stellar_rep`:STRING,`city`:STRING,`of_boats`:STRING,`of_service_techs`:STRING,`rental_locations`:STRING,`street_address`:STRING,`accounting_method`:STRING,`hs_date_entered_142982663`:STRING,`hs_date_entered_142982665`:STRING,`hs_date_entered_142982666`:STRING,`hs_date_entered_142982669`:STRING,`hs_date_entered_142982670`:STRING,`hs_date_entered_177683085`:STRING,`hs_date_exited_142982663`:STRING,`hs_date_exited_142982665`:STRING,`hs_date_exited_142982669`:STRING,`hs_date_exited_142982670`:STRING,`hs_date_exited_177683085`:STRING,`hs_is_in_first_deal_stage`:STRING,`hs_time_in_142982663`:STRING,`hs_time_in_142982665`:STRING,`hs_time_in_142982666`:STRING,`hs_time_in_142982669`:STRING,`hs_time_in_142982670`:STRING,`hs_time_in_177683085`:STRING,`hs_v2_date_entered_142982666`:STRING,`non_powered_units`:STRING,`service_locations`:STRING,`slip_locations`:STRING,`billing_support_validated`:STRING,`club_locations`:STRING,`contract__file_`:STRING,`deal_notes___contract_modifications_and_non_standard_billing_summary`:STRING,`deal_value_total___1st_year__arr_and_implementation_fee_`:STRING,`estimated_price_per_slip`:STRING,`ims_license_revenue__`:STRING,`mms_commission__molo_slips_`:STRING,`mms_commission_rep_1`:STRING,`molo_implementation_fees__`:STRING,`operators_last_year_rentals_revenue__stellar_`:STRING,`rentals_license_revenue__rentals___ims_`:STRING,`revenue_type__license__convenience__annual_or_monthly_`:STRING,`service_license_revenue__molo___sms_`:STRING,`slips_license_revenue__molo_`:STRING,`stellar_implementation_fees__`:STRING,`hs_exchange_rate`:STRING,`of_campgrounds`:STRING,`hs_date_entered_142982667`:STRING,`hs_time_in_142982667`:STRING,`hs_v2_cumulative_time_in_142982663`:STRING,`hs_v2_date_entered_142982663`:STRING,`hs_v2_date_entered_142982667`:STRING,`hs_v2_date_exited_142982663`:STRING,`hs_v2_latest_time_in_142982663`:STRING,`active_rollout`:STRING,`integration_fees__erp__fees_arr`:STRING,`ims_commission_sales_rep_1`:STRING,`ims_sales_rep_1__stellar_rentals_`:STRING,`of_club_boats`:STRING,`zoho_id__zoho_crm_`:STRING,`hs_date_entered_177683084`:STRING,`hs_time_in_177683084`:STRING,`hs_v2_date_entered_177683084`:STRING,`hs_v2_cumulative_time_in_142982670`:STRING,`hs_v2_date_entered_142982670`:STRING,`hs_v2_date_exited_142982670`:STRING,`hs_v2_latest_time_in_142982670`:STRING,`mms_commission_rep_2`:STRING,`hs_v2_date_entered_142982669`:STRING,`hs_priority`:STRING,`of_rv_sites`:STRING,`hs_acv`:STRING,`hs_arr`:STRING,`hs_mrr`:STRING,`hs_tcv`:STRING,`hs_v2_cumulative_time_in_142982665`:STRING,`hs_v2_date_entered_142982665`:STRING,`hs_v2_date_exited_142982665`:STRING,`hs_v2_latest_time_in_142982665`:STRING,`of_atvs`:STRING,`ims_sales_rep_2__stellar_rentals___cloned_`:STRING,`of_snowmobiles`:STRING,`integration_complete_`:STRING,`referral_type`:STRING,`contract_signed_date`:STRING,`description`:STRING,`assets__cloned_`:STRING,`powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units`:STRING,`rv___campsites`:STRING,`sms_commission_rep_1`:STRING,`sms_commission_rep_2`:STRING,`hs_v2_cumulative_time_in_142982669`:STRING,`hs_v2_date_exited_142982669`:STRING,`hs_v2_latest_time_in_142982669`:STRING,`sms_commission__service___molo_`:STRING,`hs_v2_cumulative_time_in_142982667`:STRING,`hs_v2_date_exited_142982667`:STRING,`hs_v2_latest_time_in_142982667`:STRING,`buoy_rep__partner_`:STRING,`hs_date_entered_142982492`:STRING,`hs_date_entered_142997278`:STRING,`hs_date_exited_142997278`:STRING,`hs_time_in_142982492`:STRING,`hs_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_136764464`:STRING,`hs_v2_date_entered_136764464`:STRING,`hs_v2_date_entered_142982492`:STRING,`hs_v2_date_exited_136764464`:STRING,`hs_v2_latest_time_in_136764464`:STRING,`partner_referral`:STRING,`partner_rep`:STRING,`hs_date_entered_136764464`:STRING,`hs_date_entered_136764466`:STRING,`hs_date_entered_136764468`:STRING,`hs_date_entered_136764469`:STRING,`hs_date_exited_136764464`:STRING,`hs_date_exited_136764466`:STRING,`hs_date_exited_136764468`:STRING,`hs_date_exited_142982492`:STRING,`hs_time_in_136764464`:STRING,`hs_time_in_136764466`:STRING,`hs_time_in_136764468`:STRING,`hs_time_in_136764469`:STRING,`hs_v2_cumulative_time_in_142982492`:STRING,`hs_v2_date_entered_136764469`:STRING,`hs_v2_date_exited_142982492`:STRING,`hs_v2_latest_time_in_142982492`:STRING,`vquip_rep__partner_`:STRING,`hs_v2_date_entered_136764468`:STRING,`hs_v2_cumulative_time_in_136764469`:STRING,`hs_v2_date_entered_136764466`:STRING,`hs_v2_date_exited_136764469`:STRING,`hs_v2_latest_time_in_136764469`:STRING,`hs_date_entered_147509879`:STRING,`hs_date_exited_147509879`:STRING,`hs_time_in_147509879`:STRING,`hs_v2_cumulative_time_in_147509879`:STRING,`hs_v2_date_entered_147509879`:STRING,`hs_v2_date_exited_147509879`:STRING,`hs_v2_latest_time_in_147509879`:STRING,`hs_date_entered_136764470`:STRING,`hs_time_in_136764470`:STRING,`hs_v2_cumulative_time_in_136764468`:STRING,`hs_v2_date_entered_136764470`:STRING,`hs_v2_date_exited_136764468`:STRING,`hs_v2_latest_time_in_136764468`:STRING,`hs_v2_cumulative_time_in_136764466`:STRING,`hs_v2_cumulative_time_in_142997278`:STRING,`hs_v2_date_entered_142997278`:STRING,`hs_v2_date_exited_136764466`:STRING,`hs_v2_date_exited_142997278`:STRING,`hs_v2_latest_time_in_136764466`:STRING,`hs_v2_latest_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_142982666`:STRING,`hs_v2_date_exited_142982666`:STRING,`hs_v2_latest_time_in_142982666`:STRING,`hs_object_source_detail_1`:STRING,`deal_status_timestamp`:STRING,`license_billing_type`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`hs_next_step`:STRING,`postal_code`:STRING,`state`:STRING,`boatfix_rep__partner_`:STRING,`noreaster_rep__partner_`:STRING,`hs_v2_cumulative_time_in_177683084`:STRING,`hs_v2_date_exited_177683084`:STRING,`hs_v2_latest_time_in_177683084`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`snag_a_slip__partner_`: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-stage/raw/hubspot_molo_deals/2024-12-07/1733577600'\n",
    "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals"
]
    • hive_path: s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals/2024-12-07/1733577600
    • id: 783163
    • processed: 1
    • raw_data: 
      {
    "archived": false,
    "createdAt": "2017-06-27T18:08:28.383Z",
    "id": "160964128",
    "properties": {
        "accounting_integration_desired": "true",
        "accounting_method": "Accrual",
        "active_rollout": "Yes",
        "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",
        "assets": "MMS",
        "assets__cloned_": "MMS",
        "billing_support_validated": "Validated",
        "boatfix_rep__partner_": "Alastair Crawford",
        "buoy_rep__partner_": "Peter Stalin",
        "caller_owner": "42545200",
        "city": "Bridgton",
        "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",
        "club_locations": "0",
        "company": "Port Annapolis",
        "contact": "Mike Meer",
        "contract__file_": "https://app.pandadoc.com/a/#/documents/bRp34JwGLrznhorzLy65Gc",
        "contract_signed_date": "2023-11-07",
        "createdate": "2017-06-27T18:08:28.720Z",
        "current_accounting_software": "None",
        "current_vendor": "Quickbooks",
        "current_vendor_new": "Marina Go",
        "days_to_close": "1415",
        "deal_currency_code": "USD",
        "deal_notes___contract_modifications_and_non_standard_billing_summary": "240 slips",
        "deal_status": "Performed - DM",
        "deal_status_timestamp": "2024-02-24",
        "deal_value": "4902",
        "deal_value__usd_": "7000",
        "deal_value_total___1st_year__arr_and_implementation_fee_": "6218.2",
        "dealname": "Port Annapolis",
        "dealstage": "closedlost",
        "dealtype": "newbusiness",
        "demo_performed": "2024-04-11",
        "demo_scheduled": "2023-11-17",
        "description": "Club for 3 boats",
        "discount_offered": "None",
        "discount_reception_perception": "N/A",
        "engagements_last_meeting_booked": "",
        "enterprise__3__locations_": "false",
        "estimated_price_per_slip": "25.909167",
        "forecast_category": "Commit",
        "head_to_head_competitor": "Harbormaster;Other;Dockwa",
        "hs_acv": "5988.00",
        "hs_all_accessible_team_ids": "",
        "hs_all_assigned_business_unit_ids": "0",
        "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": "IMPORT",
        "hs_analytics_latest_source_data_1_company": "IMPORT",
        "hs_analytics_latest_source_data_1_contact": "IMPORT",
        "hs_analytics_latest_source_data_2": "2224c148-899f-4ed7-b594-fd7b7f50ac2f",
        "hs_analytics_latest_source_data_2_company": "2224c148-899f-4ed7-b594-fd7b7f50ac2f",
        "hs_analytics_latest_source_data_2_contact": "059e8757-1905-4fec-bbe9-779a934bc3ea",
        "hs_analytics_latest_source_timestamp": "2022-08-03T14:01:42.895Z",
        "hs_analytics_latest_source_timestamp_company": "2022-08-03T14:01:42.895Z",
        "hs_analytics_latest_source_timestamp_contact": "2017-06-26T15:33:09.759Z",
        "hs_analytics_source": "OFFLINE",
        "hs_analytics_source_data_1": "IMPORT",
        "hs_analytics_source_data_2": "f76d9deb-c0fc-46e9-8991-64f6899d8284",
        "hs_arr": "5988.00",
        "hs_attributed_team_ids": "242125",
        "hs_closed_amount": "0",
        "hs_closed_amount_in_home_currency": "0",
        "hs_closed_deal_close_date": "1620869033410",
        "hs_closed_deal_create_date": "1498586908556",
        "hs_closed_won_count": "0",
        "hs_closed_won_date": "2018-06-25T23:19:04.353Z",
        "hs_created_by_user_id": "3695245",
        "hs_createdate": "2017-06-27T18:08:28.556Z",
        "hs_date_entered_136764464": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764466": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764468": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764469": "2024-04-04T15:12:56.289Z",
        "hs_date_entered_136764470": "2024-03-28T15:09:50.642Z",
        "hs_date_entered_142982492": "2024-01-05T16:38:26.230Z",
        "hs_date_entered_142982663": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982665": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982666": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982667": "2024-04-22T20:59:06.003Z",
        "hs_date_entered_142982669": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142982670": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_142997278": "2024-01-05T16:38:26.230Z",
        "hs_date_entered_147509879": "2024-01-29T22:03:09.371Z",
        "hs_date_entered_177683084": "2024-07-01T15:45:42.879Z",
        "hs_date_entered_177683085": "2024-08-12T21:06:44.043Z",
        "hs_date_entered_23229963": "2022-05-31T19:28:02.571Z",
        "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": "2022-06-01T12:36:07.116Z",
        "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_136764464": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_136764466": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_136764468": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_142982492": "2024-04-04T15:12:56.289Z",
        "hs_date_exited_142982663": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982665": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982669": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142982670": "2024-08-12T21:06:44.043Z",
        "hs_date_exited_142997278": "2024-01-05T16:38:26.230Z",
        "hs_date_exited_147509879": "2024-02-08T16:06:32.350Z",
        "hs_date_exited_177683085": "2024-08-12T21:06:44.043Z",
        "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_days_to_close_raw": "1415.302371",
        "hs_deal_score": "12.0",
        "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_active_shared_deal": "false",
        "hs_is_closed": "true",
        "hs_is_closed_count": "1",
        "hs_is_closed_lost": "true",
        "hs_is_closed_won": "false",
        "hs_is_deal_split": "false",
        "hs_is_in_first_deal_stage": "false",
        "hs_is_open_count": "0",
        "hs_lastmodifieddate": "2022-11-14T20:31:14.119Z",
        "hs_latest_meeting_activity": "2019-06-25T21:00:00Z",
        "hs_manual_forecast_category": "OMIT",
        "hs_merged_object_ids": "1015307121;1015327421",
        "hs_mrr": "499.00",
        "hs_next_step": "Welcome Call",
        "hs_notes_last_activity": "0-27-13252580924",
        "hs_notes_next_activity": "",
        "hs_notes_next_activity_type": "",
        "hs_num_associated_active_deal_registrations": "0",
        "hs_num_associated_deal_registrations": "0",
        "hs_num_associated_deal_splits": "0",
        "hs_num_of_associated_line_items": "0",
        "hs_num_target_accounts": "0",
        "hs_object_id": "161059206",
        "hs_object_source": "API",
        "hs_object_source_detail_1": "Buoy Insurance Interest Work Flow",
        "hs_object_source_detail_2": "",
        "hs_object_source_detail_3": "",
        "hs_object_source_id": "userId:9386903",
        "hs_object_source_label": "INTERNAL_PROCESSING",
        "hs_object_source_user_id": "9386903",
        "hs_open_deal_create_date": "0",
        "hs_pinned_engagement_id": "822945693",
        "hs_predicted_amount": "",
        "hs_predicted_amount_in_home_currency": "",
        "hs_priority": "high",
        "hs_projected_amount": "0.0",
        "hs_projected_amount_in_home_currency": "0.0",
        "hs_sales_email_last_replied": "2022-03-15T15:49:41Z",
        "hs_tcv": "5988.00",
        "hs_time_in_136764464": "0",
        "hs_time_in_136764466": "0",
        "hs_time_in_136764468": "0",
        "hs_time_in_136764469": "21333809107",
        "hs_time_in_136764470": "21938796155",
        "hs_time_in_142982492": "29104679139",
        "hs_time_in_142982663": "0",
        "hs_time_in_142982665": "0",
        "hs_time_in_142982666": "10080569686",
        "hs_time_in_142982667": "19757829728",
        "hs_time_in_142982669": "0",
        "hs_time_in_142982670": "0",
        "hs_time_in_142997278": "0",
        "hs_time_in_147509879": "842602979",
        "hs_time_in_177683084": "13728633549",
        "hs_time_in_177683085": "0",
        "hs_time_in_23229963": "79552089132",
        "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": "79490400164",
        "hs_time_in_closedwon": "114011820964",
        "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": "44200137",
        "hs_user_ids_of_all_notification_unfollowers": "4428097",
        "hs_user_ids_of_all_owners": "",
        "hs_v2_cumulative_time_in_136764464": "261942509",
        "hs_v2_cumulative_time_in_136764466": "2415390737",
        "hs_v2_cumulative_time_in_136764468": "4216174337",
        "hs_v2_cumulative_time_in_136764469": "10883305580",
        "hs_v2_cumulative_time_in_142982492": "7509083516",
        "hs_v2_cumulative_time_in_142982663": "9082870327",
        "hs_v2_cumulative_time_in_142982665": "114641",
        "hs_v2_cumulative_time_in_142982666": "11248324",
        "hs_v2_cumulative_time_in_142982667": "5958135602",
        "hs_v2_cumulative_time_in_142982669": "8444216071",
        "hs_v2_cumulative_time_in_142982670": "97016268",
        "hs_v2_cumulative_time_in_142997278": "2553163",
        "hs_v2_cumulative_time_in_147509879": "842602979",
        "hs_v2_cumulative_time_in_177683084": "57580",
        "hs_v2_cumulative_time_in_23229963": "79722",
        "hs_v2_cumulative_time_in_23229964": "6499144690",
        "hs_v2_cumulative_time_in_23229965": "3561159083",
        "hs_v2_cumulative_time_in_23229966": "604058719",
        "hs_v2_cumulative_time_in_23229967": "543967348",
        "hs_v2_cumulative_time_in_23229968": "5790905137",
        "hs_v2_cumulative_time_in_closedlost": "607040669",
        "hs_v2_cumulative_time_in_closedwon": "8572119445",
        "hs_v2_date_entered_136764464": "2024-01-05T16:38:26.230Z",
        "hs_v2_date_entered_136764466": "2024-05-30T15:08:33.483Z",
        "hs_v2_date_entered_136764468": "2024-01-25T16:17:15.272Z",
        "hs_v2_date_entered_136764469": "2024-04-04T15:12:56.289Z",
        "hs_v2_date_entered_136764470": "2024-03-28T15:09:50.642Z",
        "hs_v2_date_entered_142982492": "2024-01-08T17:24:08.739Z",
        "hs_v2_date_entered_142982663": "2024-01-08T17:57:55.676Z",
        "hs_v2_date_entered_142982665": "2024-02-02T22:01:20.398Z",
        "hs_v2_date_entered_142982666": "2024-08-12T21:06:44.043Z",
        "hs_v2_date_entered_142982667": "2024-04-22T20:59:06.003Z",
        "hs_v2_date_entered_142982669": "2024-04-24T19:26:15.731Z",
        "hs_v2_date_entered_142982670": "2024-01-08T17:54:32.356Z",
        "hs_v2_date_entered_142997278": "2024-02-06T15:46:52.701Z",
        "hs_v2_date_entered_147509879": "2024-01-29T22:03:09.371Z",
        "hs_v2_date_entered_177683084": "2024-07-01T15:45:42.879Z",
        "hs_v2_date_entered_23229963": "2022-05-26T13:34:05.022Z",
        "hs_v2_date_entered_23229964": "2023-07-18T19:48:02.948Z",
        "hs_v2_date_entered_23229965": "2022-07-06T14:44:20.517Z",
        "hs_v2_date_entered_23229966": "2022-06-07T19:42:22.158Z",
        "hs_v2_date_entered_23229967": "2022-06-01T12:36:06.470Z",
        "hs_v2_date_entered_23229968": "2022-06-02T19:50:46.247Z",
        "hs_v2_date_entered_closedlost": "2022-06-01T12:36:07.116Z",
        "hs_v2_date_entered_closedwon": "2021-04-27T23:19:06.302Z",
        "hs_v2_date_exited_136764464": "2024-01-08T17:24:08.739Z",
        "hs_v2_date_exited_136764466": "2024-03-21T15:05:55.961Z",
        "hs_v2_date_exited_136764468": "2024-03-28T15:09:50.642Z",
        "hs_v2_date_exited_136764469": "2024-05-30T15:08:33.483Z",
        "hs_v2_date_exited_142982492": "2024-04-04T15:12:56.289Z",
        "hs_v2_date_exited_142982663": "2024-04-22T20:59:06.003Z",
        "hs_v2_date_exited_142982665": "2024-02-02T22:03:15.039Z",
        "hs_v2_date_exited_142982666": "2024-02-09T20:19:48.127Z",
        "hs_v2_date_exited_142982667": "2024-07-01T15:42:38.041Z",
        "hs_v2_date_exited_142982669": "2024-04-24T14:49:07.367Z",
        "hs_v2_date_exited_142982670": "2024-01-09T20:51:28.624Z",
        "hs_v2_date_exited_142997278": "2024-02-06T16:29:25.864Z",
        "hs_v2_date_exited_147509879": "2024-02-08T16:06:32.350Z",
        "hs_v2_date_exited_177683084": "2024-04-30T19:22:27.460Z",
        "hs_v2_date_exited_23229963": "2022-05-26T13:35:24.744Z",
        "hs_v2_date_exited_23229964": "2022-08-09T18:52:37.936Z",
        "hs_v2_date_exited_23229965": "2022-08-16T19:56:59.600Z",
        "hs_v2_date_exited_23229966": "2022-07-27T20:06:00.183Z",
        "hs_v2_date_exited_23229967": "2022-06-07T19:42:13.818Z",
        "hs_v2_date_exited_23229968": "2022-08-08T20:25:51.384Z",
        "hs_v2_date_exited_closedlost": "2021-05-20T02:01:15.466Z",
        "hs_v2_date_exited_closedwon": "2018-02-09T21:08:32.994Z",
        "hs_v2_latest_time_in_136764464": "261942509",
        "hs_v2_latest_time_in_136764466": "2415390737",
        "hs_v2_latest_time_in_136764468": "4216174337",
        "hs_v2_latest_time_in_136764469": "10883305580",
        "hs_v2_latest_time_in_142982492": "7509083516",
        "hs_v2_latest_time_in_142982663": "9082870327",
        "hs_v2_latest_time_in_142982665": "114641",
        "hs_v2_latest_time_in_142982666": "192939",
        "hs_v2_latest_time_in_142982667": "5958135602",
        "hs_v2_latest_time_in_142982669": "8444216071",
        "hs_v2_latest_time_in_142982670": "97016268",
        "hs_v2_latest_time_in_142997278": "2553163",
        "hs_v2_latest_time_in_147509879": "842602979",
        "hs_v2_latest_time_in_177683084": "57580",
        "hs_v2_latest_time_in_23229963": "79722",
        "hs_v2_latest_time_in_23229964": "6499144690",
        "hs_v2_latest_time_in_23229965": "3561159083",
        "hs_v2_latest_time_in_23229966": "604058719",
        "hs_v2_latest_time_in_23229967": "543967348",
        "hs_v2_latest_time_in_23229968": "5790905137",
        "hs_v2_latest_time_in_closedlost": "607040669",
        "hs_v2_latest_time_in_closedwon": "8572119445",
        "hs_was_imported": "true",
        "hubspot_owner_assigneddate": "",
        "hubspot_owner_id": "",
        "hubspot_team_id": "",
        "ims_commission_sales_rep_1": "Stellar Lead (Company Provided Lead)",
        "ims_license_revenue__": "0",
        "ims_sales_rep_1__stellar_rentals_": "42545200",
        "ims_sales_rep_2__stellar_rentals___cloned_": "378624070",
        "integration_complete_": "No",
        "integration_fees__erp__fees_arr": "0",
        "license_billing_type": "Monthly Stellar License Fee",
        "likelihood": "25%",
        "micro": "true",
        "mms_commission__molo_slips_": "Molo (20%)",
        "mms_commission_rep_1": "42545200",
        "mms_commission_rep_2": "378624067",
        "modules": "Service;Slips/Rack Reservations",
        "molo_implementation_fees__": "0",
        "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",
        "non_powered_units": "0",
        "noreaster_rep__partner_": "Adrian Mott",
        "notes_last_contacted": "2021-04-28T18:56:12.295Z",
        "notes_last_updated": "2021-06-04T12:00:00Z",
        "notes_next_activity_date": "",
        "num_associated_contacts": "0",
        "num_contacted_notes": "0",
        "num_notes": "1",
        "number_of_slips": "75",
        "of_atvs": "6",
        "of_boats": "13",
        "of_campgrounds": "90",
        "of_club_boats": "0",
        "of_resources": "0",
        "of_rv_sites": "50",
        "of_service_techs": "3",
        "of_slips": "375",
        "of_snowmobiles": "0",
        "operators_last_year_rentals_revenue__stellar_": "0",
        "other_vendor_lost_to": "Scribble ",
        "panda_url": "https://app.pandadoc.com/a/#/documents/TqZbSQgY6hf5ReZCScuePY",
        "partner_referral": "Buoy",
        "partner_rep": "Javier Ortiz",
        "perform_date": "2022-08-09",
        "pipeline": "default",
        "point_of_contact": "Lindsay and Mike",
        "point_of_contact_email": "[email protected]",
        "postal_code": "25304",
        "powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "0",
        "referral_type": "Neither",
        "rental_locations": "0",
        "rentals_license_revenue__rentals___ims_": "0",
        "revenue_type__license__convenience__annual_or_monthly_": "Slips License Annual",
        "rv___campsites": "0",
        "second_deal_owner": "148939047",
        "service_license_revenue__molo___sms_": "0",
        "service_locations": "1",
        "services_offered": "Slips;Dry Storage;Service",
        "size": "ENT",
        "slip_locations": "1",
        "slips_license_revenue__molo_": "6218.2",
        "sms_commission__service___molo_": "",
        "sms_commission_rep_1": "36256868",
        "sms_commission_rep_2": "378624070",
        "snag_a_slip__partner_": "Lisa Colangelo",
        "source": "Inbound",
        "state": "WV",
        "state_region": "MA",
        "stellar_bundle_": "false",
        "stellar_implementation_fees__": "0",
        "stellar_rep": "None",
        "street_address": "779 Harrison RoadBridgton, Maine 04009",
        "tags": "Cold Sales Trip",
        "temperature": "Hot",
        "title__role___responsibilities": "Office and Manager",
        "vendor_lost_to": "Dockwa",
        "vquip_rep__partner_": "Devin Pike",
        "website": "https://www.eastrivershipyard.ca/",
        "zoho_id__zoho_crm_": "19990"
    },
    "updatedAt": "2024-06-28T17:58:00.063Z"
}
    • schema_attributes: 
      {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.accounting_method": "string",
    "properties.active_rollout": "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.assets": "string",
    "properties.assets__cloned_": "string",
    "properties.billing_support_validated": "string",
    "properties.boatfix_rep__partner_": "string",
    "properties.buoy_rep__partner_": "string",
    "properties.caller_owner": "string",
    "properties.city": "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.club_locations": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.contract__file_": "string",
    "properties.contract_signed_date": "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_notes___contract_modifications_and_non_standard_billing_summary": "string",
    "properties.deal_status": "string",
    "properties.deal_status_timestamp": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.deal_value_total___1st_year__arr_and_implementation_fee_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.demo_performed": "string",
    "properties.demo_scheduled": "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.estimated_price_per_slip": "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_attributed_team_ids": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_closed_deal_close_date": "string",
    "properties.hs_closed_deal_create_date": "string",
    "properties.hs_closed_won_count": "string",
    "properties.hs_closed_won_date": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_136764464": "string",
    "properties.hs_date_entered_136764466": "string",
    "properties.hs_date_entered_136764468": "string",
    "properties.hs_date_entered_136764469": "string",
    "properties.hs_date_entered_136764470": "string",
    "properties.hs_date_entered_142982492": "string",
    "properties.hs_date_entered_142982663": "string",
    "properties.hs_date_entered_142982665": "string",
    "properties.hs_date_entered_142982666": "string",
    "properties.hs_date_entered_142982667": "string",
    "properties.hs_date_entered_142982669": "string",
    "properties.hs_date_entered_142982670": "string",
    "properties.hs_date_entered_142997278": "string",
    "properties.hs_date_entered_147509879": "string",
    "properties.hs_date_entered_177683084": "string",
    "properties.hs_date_entered_177683085": "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_136764464": "string",
    "properties.hs_date_exited_136764466": "string",
    "properties.hs_date_exited_136764468": "string",
    "properties.hs_date_exited_142982492": "string",
    "properties.hs_date_exited_142982663": "string",
    "properties.hs_date_exited_142982665": "string",
    "properties.hs_date_exited_142982669": "string",
    "properties.hs_date_exited_142982670": "string",
    "properties.hs_date_exited_142997278": "string",
    "properties.hs_date_exited_147509879": "string",
    "properties.hs_date_exited_177683085": "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_days_to_close_raw": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_score": "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_active_shared_deal": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_count": "string",
    "properties.hs_is_closed_lost": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_is_in_first_deal_stage": "string",
    "properties.hs_is_open_count": "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_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "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_of_associated_line_items": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_open_deal_create_date": "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_136764464": "string",
    "properties.hs_time_in_136764466": "string",
    "properties.hs_time_in_136764468": "string",
    "properties.hs_time_in_136764469": "string",
    "properties.hs_time_in_136764470": "string",
    "properties.hs_time_in_142982492": "string",
    "properties.hs_time_in_142982663": "string",
    "properties.hs_time_in_142982665": "string",
    "properties.hs_time_in_142982666": "string",
    "properties.hs_time_in_142982667": "string",
    "properties.hs_time_in_142982669": "string",
    "properties.hs_time_in_142982670": "string",
    "properties.hs_time_in_142997278": "string",
    "properties.hs_time_in_147509879": "string",
    "properties.hs_time_in_177683084": "string",
    "properties.hs_time_in_177683085": "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.hs_v2_cumulative_time_in_136764464": "string",
    "properties.hs_v2_cumulative_time_in_136764466": "string",
    "properties.hs_v2_cumulative_time_in_136764468": "string",
    "properties.hs_v2_cumulative_time_in_136764469": "string",
    "properties.hs_v2_cumulative_time_in_142982492": "string",
    "properties.hs_v2_cumulative_time_in_142982663": "string",
    "properties.hs_v2_cumulative_time_in_142982665": "string",
    "properties.hs_v2_cumulative_time_in_142982666": "string",
    "properties.hs_v2_cumulative_time_in_142982667": "string",
    "properties.hs_v2_cumulative_time_in_142982669": "string",
    "properties.hs_v2_cumulative_time_in_142982670": "string",
    "properties.hs_v2_cumulative_time_in_142997278": "string",
    "properties.hs_v2_cumulative_time_in_147509879": "string",
    "properties.hs_v2_cumulative_time_in_177683084": "string",
    "properties.hs_v2_cumulative_time_in_23229963": "string",
    "properties.hs_v2_cumulative_time_in_23229964": "string",
    "properties.hs_v2_cumulative_time_in_23229965": "string",
    "properties.hs_v2_cumulative_time_in_23229966": "string",
    "properties.hs_v2_cumulative_time_in_23229967": "string",
    "properties.hs_v2_cumulative_time_in_23229968": "string",
    "properties.hs_v2_cumulative_time_in_closedlost": "string",
    "properties.hs_v2_cumulative_time_in_closedwon": "string",
    "properties.hs_v2_date_entered_136764464": "string",
    "properties.hs_v2_date_entered_136764466": "string",
    "properties.hs_v2_date_entered_136764468": "string",
    "properties.hs_v2_date_entered_136764469": "string",
    "properties.hs_v2_date_entered_136764470": "string",
    "properties.hs_v2_date_entered_142982492": "string",
    "properties.hs_v2_date_entered_142982663": "string",
    "properties.hs_v2_date_entered_142982665": "string",
    "properties.hs_v2_date_entered_142982666": "string",
    "properties.hs_v2_date_entered_142982667": "string",
    "properties.hs_v2_date_entered_142982669": "string",
    "properties.hs_v2_date_entered_142982670": "string",
    "properties.hs_v2_date_entered_142997278": "string",
    "properties.hs_v2_date_entered_147509879": "string",
    "properties.hs_v2_date_entered_177683084": "string",
    "properties.hs_v2_date_entered_177683085": "string",
    "properties.hs_v2_date_entered_23229963": "string",
    "properties.hs_v2_date_entered_23229964": "string",
    "properties.hs_v2_date_entered_23229965": "string",
    "properties.hs_v2_date_entered_23229966": "string",
    "properties.hs_v2_date_entered_23229967": "string",
    "properties.hs_v2_date_entered_23229968": "string",
    "properties.hs_v2_date_entered_closedlost": "string",
    "properties.hs_v2_date_entered_closedwon": "string",
    "properties.hs_v2_date_exited_136764464": "string",
    "properties.hs_v2_date_exited_136764466": "string",
    "properties.hs_v2_date_exited_136764468": "string",
    "properties.hs_v2_date_exited_136764469": "string",
    "properties.hs_v2_date_exited_142982492": "string",
    "properties.hs_v2_date_exited_142982663": "string",
    "properties.hs_v2_date_exited_142982665": "string",
    "properties.hs_v2_date_exited_142982666": "string",
    "properties.hs_v2_date_exited_142982667": "string",
    "properties.hs_v2_date_exited_142982669": "string",
    "properties.hs_v2_date_exited_142982670": "string",
    "properties.hs_v2_date_exited_142997278": "string",
    "properties.hs_v2_date_exited_147509879": "string",
    "properties.hs_v2_date_exited_177683084": "string",
    "properties.hs_v2_date_exited_23229963": "string",
    "properties.hs_v2_date_exited_23229964": "string",
    "properties.hs_v2_date_exited_23229965": "string",
    "properties.hs_v2_date_exited_23229966": "string",
    "properties.hs_v2_date_exited_23229967": "string",
    "properties.hs_v2_date_exited_23229968": "string",
    "properties.hs_v2_date_exited_closedlost": "string",
    "properties.hs_v2_date_exited_closedwon": "string",
    "properties.hs_v2_latest_time_in_136764464": "string",
    "properties.hs_v2_latest_time_in_136764466": "string",
    "properties.hs_v2_latest_time_in_136764468": "string",
    "properties.hs_v2_latest_time_in_136764469": "string",
    "properties.hs_v2_latest_time_in_142982492": "string",
    "properties.hs_v2_latest_time_in_142982663": "string",
    "properties.hs_v2_latest_time_in_142982665": "string",
    "properties.hs_v2_latest_time_in_142982666": "string",
    "properties.hs_v2_latest_time_in_142982667": "string",
    "properties.hs_v2_latest_time_in_142982669": "string",
    "properties.hs_v2_latest_time_in_142982670": "string",
    "properties.hs_v2_latest_time_in_142997278": "string",
    "properties.hs_v2_latest_time_in_147509879": "string",
    "properties.hs_v2_latest_time_in_177683084": "string",
    "properties.hs_v2_latest_time_in_23229963": "string",
    "properties.hs_v2_latest_time_in_23229964": "string",
    "properties.hs_v2_latest_time_in_23229965": "string",
    "properties.hs_v2_latest_time_in_23229966": "string",
    "properties.hs_v2_latest_time_in_23229967": "string",
    "properties.hs_v2_latest_time_in_23229968": "string",
    "properties.hs_v2_latest_time_in_closedlost": "string",
    "properties.hs_v2_latest_time_in_closedwon": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.ims_commission_sales_rep_1": "string",
    "properties.ims_license_revenue__": "string",
    "properties.ims_sales_rep_1__stellar_rentals_": "string",
    "properties.ims_sales_rep_2__stellar_rentals___cloned_": "string",
    "properties.integration_complete_": "string",
    "properties.integration_fees__erp__fees_arr": "string",
    "properties.license_billing_type": "string",
    "properties.likelihood": "string",
    "properties.micro": "string",
    "properties.mms_commission__molo_slips_": "string",
    "properties.mms_commission_rep_1": "string",
    "properties.mms_commission_rep_2": "string",
    "properties.modules": "string",
    "properties.molo_implementation_fees__": "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.non_powered_units": "string",
    "properties.noreaster_rep__partner_": "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_atvs": "string",
    "properties.of_boats": "string",
    "properties.of_campgrounds": "string",
    "properties.of_club_boats": "string",
    "properties.of_resources": "string",
    "properties.of_rv_sites": "string",
    "properties.of_service_techs": "string",
    "properties.of_slips": "string",
    "properties.of_snowmobiles": "string",
    "properties.operators_last_year_rentals_revenue__stellar_": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.partner_referral": "string",
    "properties.partner_rep": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.postal_code": "string",
    "properties.powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "string",
    "properties.referral_type": "string",
    "properties.rental_locations": "string",
    "properties.rentals_license_revenue__rentals___ims_": "string",
    "properties.revenue_type__license__convenience__annual_or_monthly_": "string",
    "properties.rv___campsites": "string",
    "properties.second_deal_owner": "string",
    "properties.service_license_revenue__molo___sms_": "string",
    "properties.service_locations": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slip_locations": "string",
    "properties.slips_license_revenue__molo_": "string",
    "properties.sms_commission__service___molo_": "string",
    "properties.sms_commission_rep_1": "string",
    "properties.sms_commission_rep_2": "string",
    "properties.snag_a_slip__partner_": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.stellar_bundle_": "string",
    "properties.stellar_implementation_fees__": "string",
    "properties.stellar_rep": "string",
    "properties.street_address": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.vquip_rep__partner_": "string",
    "properties.website": "string",
    "properties.zoho_id__zoho_crm_": "string",
    "updatedAt": "string"
}
    • schema_name_id: 1506
    • schema_scan_id: 6147676
    • updated: 2024-12-07 07:21:09
Schema Scans: 3
Last at 2024-12-09 07:19:36
    • duration: 0:00:36.914827
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6151012
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals/2024-12-09/1733750355",
        "key": "raw/hubspot_molo_deals/2024-12-09/1733750355/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 11504317230799617421,
        "service_name": "drive-thru",
        "span_id": 13392724718282807570,
        "trace_id": 425189382613129354
    }
}
    • running: False
    • schema_name_id: 1506
    • start_time: 2024-12-09 07:19:36
    • success: True
    • trace_id: 425189382613129354
    • duration: 0:00:33.793444
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6149367
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals/2024-12-08/1733663746",
        "key": "raw/hubspot_molo_deals/2024-12-08/1733663746/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 8836692090153812090,
        "service_name": "drive-thru",
        "span_id": 6957678577396526861,
        "trace_id": 8215299805865321688
    }
}
    • running: False
    • schema_name_id: 1506
    • start_time: 2024-12-08 07:15:54
    • success: True
    • trace_id: 8215299805865321688
    • duration: 0:00:34.515698
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 6147676
    • payload: 
      {
    "datatype_dict": null,
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrujson-drivethru-stage",
        "hive_path": "s3://sfdl-drivethrujson-drivethru-stage/raw/hubspot_molo_deals/2024-12-07/1733577600",
        "key": "raw/hubspot_molo_deals/2024-12-07/1733577600/data.json.gz"
    },
    "schema": {
        "name": "sfdl_stage_drivethru.hubspot_molo_deals",
        "type": "drivethrujson"
    },
    "trace_context": {
        "parent_id": 9405959737546457956,
        "service_name": "drive-thru",
        "span_id": 15252200799607932888,
        "trace_id": 2884171262981737966
    }
}
    • running: False
    • schema_name_id: 1506
    • start_time: 2024-12-07 07:20:35
    • success: True
    • trace_id: 2884171262981737966
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "archived": "string",
    "createdAt": "string",
    "id": "string",
    "properties.accounting_integration_desired": "string",
    "properties.accounting_method": "string",
    "properties.active_rollout": "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.assets": "string",
    "properties.assets__cloned_": "string",
    "properties.billing_support_validated": "string",
    "properties.boatfix_rep__partner_": "string",
    "properties.buoy_rep__partner_": "string",
    "properties.caller_owner": "string",
    "properties.city": "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.club_locations": "string",
    "properties.company": "string",
    "properties.contact": "string",
    "properties.contract__file_": "string",
    "properties.contract_signed_date": "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_notes___contract_modifications_and_non_standard_billing_summary": "string",
    "properties.deal_status": "string",
    "properties.deal_status_timestamp": "string",
    "properties.deal_temperature": "string",
    "properties.deal_value": "string",
    "properties.deal_value__usd_": "string",
    "properties.deal_value_total___1st_year__arr_and_implementation_fee_": "string",
    "properties.dealname": "string",
    "properties.dealstage": "string",
    "properties.dealtype": "string",
    "properties.demo_performed": "string",
    "properties.demo_scheduled": "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.estimated_price_per_slip": "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_attributed_team_ids": "string",
    "properties.hs_campaign": "string",
    "properties.hs_closed_amount": "string",
    "properties.hs_closed_amount_in_home_currency": "string",
    "properties.hs_closed_deal_close_date": "string",
    "properties.hs_closed_deal_create_date": "string",
    "properties.hs_closed_won_count": "string",
    "properties.hs_closed_won_date": "string",
    "properties.hs_created_by_user_id": "string",
    "properties.hs_createdate": "string",
    "properties.hs_date_entered_136764464": "string",
    "properties.hs_date_entered_136764466": "string",
    "properties.hs_date_entered_136764468": "string",
    "properties.hs_date_entered_136764469": "string",
    "properties.hs_date_entered_136764470": "string",
    "properties.hs_date_entered_142982492": "string",
    "properties.hs_date_entered_142982663": "string",
    "properties.hs_date_entered_142982665": "string",
    "properties.hs_date_entered_142982666": "string",
    "properties.hs_date_entered_142982667": "string",
    "properties.hs_date_entered_142982669": "string",
    "properties.hs_date_entered_142982670": "string",
    "properties.hs_date_entered_142997278": "string",
    "properties.hs_date_entered_147509879": "string",
    "properties.hs_date_entered_177683084": "string",
    "properties.hs_date_entered_177683085": "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_136764464": "string",
    "properties.hs_date_exited_136764466": "string",
    "properties.hs_date_exited_136764468": "string",
    "properties.hs_date_exited_142982492": "string",
    "properties.hs_date_exited_142982663": "string",
    "properties.hs_date_exited_142982665": "string",
    "properties.hs_date_exited_142982669": "string",
    "properties.hs_date_exited_142982670": "string",
    "properties.hs_date_exited_142997278": "string",
    "properties.hs_date_exited_147509879": "string",
    "properties.hs_date_exited_177683085": "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_days_to_close_raw": "string",
    "properties.hs_deal_amount_calculation_preference": "string",
    "properties.hs_deal_score": "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_active_shared_deal": "string",
    "properties.hs_is_closed": "string",
    "properties.hs_is_closed_count": "string",
    "properties.hs_is_closed_lost": "string",
    "properties.hs_is_closed_won": "string",
    "properties.hs_is_deal_split": "string",
    "properties.hs_is_in_first_deal_stage": "string",
    "properties.hs_is_open_count": "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_notes_last_activity": "string",
    "properties.hs_notes_next_activity": "string",
    "properties.hs_notes_next_activity_type": "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_of_associated_line_items": "string",
    "properties.hs_num_target_accounts": "string",
    "properties.hs_object_id": "string",
    "properties.hs_object_source": "string",
    "properties.hs_object_source_detail_1": "string",
    "properties.hs_object_source_detail_2": "string",
    "properties.hs_object_source_detail_3": "string",
    "properties.hs_object_source_id": "string",
    "properties.hs_object_source_label": "string",
    "properties.hs_object_source_user_id": "string",
    "properties.hs_open_deal_create_date": "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_136764464": "string",
    "properties.hs_time_in_136764466": "string",
    "properties.hs_time_in_136764468": "string",
    "properties.hs_time_in_136764469": "string",
    "properties.hs_time_in_136764470": "string",
    "properties.hs_time_in_142982492": "string",
    "properties.hs_time_in_142982663": "string",
    "properties.hs_time_in_142982665": "string",
    "properties.hs_time_in_142982666": "string",
    "properties.hs_time_in_142982667": "string",
    "properties.hs_time_in_142982669": "string",
    "properties.hs_time_in_142982670": "string",
    "properties.hs_time_in_142997278": "string",
    "properties.hs_time_in_147509879": "string",
    "properties.hs_time_in_177683084": "string",
    "properties.hs_time_in_177683085": "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.hs_v2_cumulative_time_in_136764464": "string",
    "properties.hs_v2_cumulative_time_in_136764466": "string",
    "properties.hs_v2_cumulative_time_in_136764468": "string",
    "properties.hs_v2_cumulative_time_in_136764469": "string",
    "properties.hs_v2_cumulative_time_in_142982492": "string",
    "properties.hs_v2_cumulative_time_in_142982663": "string",
    "properties.hs_v2_cumulative_time_in_142982665": "string",
    "properties.hs_v2_cumulative_time_in_142982666": "string",
    "properties.hs_v2_cumulative_time_in_142982667": "string",
    "properties.hs_v2_cumulative_time_in_142982669": "string",
    "properties.hs_v2_cumulative_time_in_142982670": "string",
    "properties.hs_v2_cumulative_time_in_142997278": "string",
    "properties.hs_v2_cumulative_time_in_147509879": "string",
    "properties.hs_v2_cumulative_time_in_177683084": "string",
    "properties.hs_v2_cumulative_time_in_23229963": "string",
    "properties.hs_v2_cumulative_time_in_23229964": "string",
    "properties.hs_v2_cumulative_time_in_23229965": "string",
    "properties.hs_v2_cumulative_time_in_23229966": "string",
    "properties.hs_v2_cumulative_time_in_23229967": "string",
    "properties.hs_v2_cumulative_time_in_23229968": "string",
    "properties.hs_v2_cumulative_time_in_closedlost": "string",
    "properties.hs_v2_cumulative_time_in_closedwon": "string",
    "properties.hs_v2_date_entered_136764464": "string",
    "properties.hs_v2_date_entered_136764466": "string",
    "properties.hs_v2_date_entered_136764468": "string",
    "properties.hs_v2_date_entered_136764469": "string",
    "properties.hs_v2_date_entered_136764470": "string",
    "properties.hs_v2_date_entered_142982492": "string",
    "properties.hs_v2_date_entered_142982663": "string",
    "properties.hs_v2_date_entered_142982665": "string",
    "properties.hs_v2_date_entered_142982666": "string",
    "properties.hs_v2_date_entered_142982667": "string",
    "properties.hs_v2_date_entered_142982669": "string",
    "properties.hs_v2_date_entered_142982670": "string",
    "properties.hs_v2_date_entered_142997278": "string",
    "properties.hs_v2_date_entered_147509879": "string",
    "properties.hs_v2_date_entered_177683084": "string",
    "properties.hs_v2_date_entered_177683085": "string",
    "properties.hs_v2_date_entered_23229963": "string",
    "properties.hs_v2_date_entered_23229964": "string",
    "properties.hs_v2_date_entered_23229965": "string",
    "properties.hs_v2_date_entered_23229966": "string",
    "properties.hs_v2_date_entered_23229967": "string",
    "properties.hs_v2_date_entered_23229968": "string",
    "properties.hs_v2_date_entered_closedlost": "string",
    "properties.hs_v2_date_entered_closedwon": "string",
    "properties.hs_v2_date_exited_136764464": "string",
    "properties.hs_v2_date_exited_136764466": "string",
    "properties.hs_v2_date_exited_136764468": "string",
    "properties.hs_v2_date_exited_136764469": "string",
    "properties.hs_v2_date_exited_142982492": "string",
    "properties.hs_v2_date_exited_142982663": "string",
    "properties.hs_v2_date_exited_142982665": "string",
    "properties.hs_v2_date_exited_142982666": "string",
    "properties.hs_v2_date_exited_142982667": "string",
    "properties.hs_v2_date_exited_142982669": "string",
    "properties.hs_v2_date_exited_142982670": "string",
    "properties.hs_v2_date_exited_142997278": "string",
    "properties.hs_v2_date_exited_147509879": "string",
    "properties.hs_v2_date_exited_177683084": "string",
    "properties.hs_v2_date_exited_23229963": "string",
    "properties.hs_v2_date_exited_23229964": "string",
    "properties.hs_v2_date_exited_23229965": "string",
    "properties.hs_v2_date_exited_23229966": "string",
    "properties.hs_v2_date_exited_23229967": "string",
    "properties.hs_v2_date_exited_23229968": "string",
    "properties.hs_v2_date_exited_closedlost": "string",
    "properties.hs_v2_date_exited_closedwon": "string",
    "properties.hs_v2_latest_time_in_136764464": "string",
    "properties.hs_v2_latest_time_in_136764466": "string",
    "properties.hs_v2_latest_time_in_136764468": "string",
    "properties.hs_v2_latest_time_in_136764469": "string",
    "properties.hs_v2_latest_time_in_142982492": "string",
    "properties.hs_v2_latest_time_in_142982663": "string",
    "properties.hs_v2_latest_time_in_142982665": "string",
    "properties.hs_v2_latest_time_in_142982666": "string",
    "properties.hs_v2_latest_time_in_142982667": "string",
    "properties.hs_v2_latest_time_in_142982669": "string",
    "properties.hs_v2_latest_time_in_142982670": "string",
    "properties.hs_v2_latest_time_in_142997278": "string",
    "properties.hs_v2_latest_time_in_147509879": "string",
    "properties.hs_v2_latest_time_in_177683084": "string",
    "properties.hs_v2_latest_time_in_23229963": "string",
    "properties.hs_v2_latest_time_in_23229964": "string",
    "properties.hs_v2_latest_time_in_23229965": "string",
    "properties.hs_v2_latest_time_in_23229966": "string",
    "properties.hs_v2_latest_time_in_23229967": "string",
    "properties.hs_v2_latest_time_in_23229968": "string",
    "properties.hs_v2_latest_time_in_closedlost": "string",
    "properties.hs_v2_latest_time_in_closedwon": "string",
    "properties.hs_was_imported": "string",
    "properties.hubspot_owner_assigneddate": "string",
    "properties.hubspot_owner_id": "string",
    "properties.hubspot_team_id": "string",
    "properties.ims_commission_sales_rep_1": "string",
    "properties.ims_license_revenue__": "string",
    "properties.ims_sales_rep_1__stellar_rentals_": "string",
    "properties.ims_sales_rep_2__stellar_rentals___cloned_": "string",
    "properties.integration_complete_": "string",
    "properties.integration_fees__erp__fees_arr": "string",
    "properties.license_billing_type": "string",
    "properties.likelihood": "string",
    "properties.micro": "string",
    "properties.mms_commission__molo_slips_": "string",
    "properties.mms_commission_rep_1": "string",
    "properties.mms_commission_rep_2": "string",
    "properties.modules": "string",
    "properties.molo_implementation_fees__": "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.non_powered_units": "string",
    "properties.noreaster_rep__partner_": "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_atvs": "string",
    "properties.of_boats": "string",
    "properties.of_campgrounds": "string",
    "properties.of_club_boats": "string",
    "properties.of_resources": "string",
    "properties.of_rv_sites": "string",
    "properties.of_service_techs": "string",
    "properties.of_slips": "string",
    "properties.of_snowmobiles": "string",
    "properties.operators_last_year_rentals_revenue__stellar_": "string",
    "properties.other_vendor_lost_to": "string",
    "properties.panda_url": "string",
    "properties.partner_referral": "string",
    "properties.partner_rep": "string",
    "properties.perform_date": "string",
    "properties.pipeline": "string",
    "properties.point_of_contact": "string",
    "properties.point_of_contact_email": "string",
    "properties.postal_code": "string",
    "properties.powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "string",
    "properties.referral_type": "string",
    "properties.rental_locations": "string",
    "properties.rentals_license_revenue__rentals___ims_": "string",
    "properties.revenue_type__license__convenience__annual_or_monthly_": "string",
    "properties.rv___campsites": "string",
    "properties.second_deal_owner": "string",
    "properties.service_license_revenue__molo___sms_": "string",
    "properties.service_locations": "string",
    "properties.services_offered": "string",
    "properties.size": "string",
    "properties.slip_locations": "string",
    "properties.slips_license_revenue__molo_": "string",
    "properties.sms_commission__service___molo_": "string",
    "properties.sms_commission_rep_1": "string",
    "properties.sms_commission_rep_2": "string",
    "properties.snag_a_slip__partner_": "string",
    "properties.source": "string",
    "properties.state": "string",
    "properties.state_region": "string",
    "properties.stellar_bundle_": "string",
    "properties.stellar_implementation_fees__": "string",
    "properties.stellar_rep": "string",
    "properties.street_address": "string",
    "properties.tags": "string",
    "properties.temperature": "string",
    "properties.title__role___responsibilities": "string",
    "properties.vendor_lost_to": "string",
    "properties.vquip_rep__partner_": "string",
    "properties.website": "string",
    "properties.zoho_id__zoho_crm_": "string",
    "updatedAt": "string"
}
  • created: 2024-12-09 07:19:59
  • ddl: 
    {
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`current_vendor_new`: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_closed_deal_close_date`:STRING,`hs_closed_deal_create_date`:STRING,`hs_closed_won_count`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_days_to_close_raw`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_active_shared_deal`:STRING,`hs_is_closed`:STRING,`hs_is_closed_count`:STRING,`hs_is_closed_lost`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_is_open_count`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_of_associated_line_items`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_open_deal_create_date`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`hs_v2_date_entered_closedlost`:STRING,`hs_was_imported`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`hs_notes_last_activity`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`hs_v2_cumulative_time_in_closedlost`:STRING,`hs_v2_date_exited_closedlost`:STRING,`hs_v2_latest_time_in_closedlost`: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_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_company`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`hs_attributed_team_ids`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_closed_won_date`: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_v2_date_entered_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_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`deal_currency_code`: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,`hs_deal_score`:STRING,`hs_v2_date_entered_23229967`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_v2_cumulative_time_in_closedwon`:STRING,`hs_v2_date_exited_closedwon`:STRING,`hs_v2_latest_time_in_closedwon`: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,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_created_by_user_id`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_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,`hs_v2_date_entered_23229964`:STRING,`hs_v2_cumulative_time_in_23229967`:STRING,`hs_v2_date_exited_23229967`:STRING,`hs_v2_latest_time_in_23229967`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`hs_v2_cumulative_time_in_23229968`:STRING,`hs_v2_date_entered_23229968`:STRING,`hs_v2_date_exited_23229968`:STRING,`hs_v2_latest_time_in_23229968`: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,`hs_v2_cumulative_time_in_23229965`:STRING,`hs_v2_date_entered_23229965`:STRING,`hs_v2_date_exited_23229965`:STRING,`hs_v2_latest_time_in_23229965`: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,`assets`:STRING,`hs_num_associated_deal_splits`:STRING,`hs_v2_date_entered_23229966`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`hs_v2_cumulative_time_in_23229966`:STRING,`hs_v2_date_exited_23229966`:STRING,`hs_v2_latest_time_in_23229966`:STRING,`hs_v2_cumulative_time_in_23229964`:STRING,`hs_v2_date_exited_23229964`:STRING,`hs_v2_latest_time_in_23229964`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_v2_cumulative_time_in_23229963`:STRING,`hs_v2_date_entered_23229963`:STRING,`hs_v2_date_exited_23229963`:STRING,`hs_v2_latest_time_in_23229963`:STRING,`demo_performed`:STRING,`demo_scheduled`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`stellar_bundle_`:STRING,`stellar_rep`:STRING,`city`:STRING,`of_boats`:STRING,`of_service_techs`:STRING,`rental_locations`:STRING,`street_address`:STRING,`accounting_method`:STRING,`hs_date_entered_142982663`:STRING,`hs_date_entered_142982665`:STRING,`hs_date_entered_142982666`:STRING,`hs_date_entered_142982669`:STRING,`hs_date_entered_142982670`:STRING,`hs_date_entered_177683085`:STRING,`hs_date_exited_142982663`:STRING,`hs_date_exited_142982665`:STRING,`hs_date_exited_142982669`:STRING,`hs_date_exited_142982670`:STRING,`hs_date_exited_177683085`:STRING,`hs_is_in_first_deal_stage`:STRING,`hs_time_in_142982663`:STRING,`hs_time_in_142982665`:STRING,`hs_time_in_142982666`:STRING,`hs_time_in_142982669`:STRING,`hs_time_in_142982670`:STRING,`hs_time_in_177683085`:STRING,`hs_v2_date_entered_142982666`:STRING,`non_powered_units`:STRING,`service_locations`:STRING,`slip_locations`:STRING,`billing_support_validated`:STRING,`club_locations`:STRING,`contract__file_`:STRING,`deal_notes___contract_modifications_and_non_standard_billing_summary`:STRING,`deal_value_total___1st_year__arr_and_implementation_fee_`:STRING,`estimated_price_per_slip`:STRING,`ims_license_revenue__`:STRING,`mms_commission__molo_slips_`:STRING,`mms_commission_rep_1`:STRING,`molo_implementation_fees__`:STRING,`operators_last_year_rentals_revenue__stellar_`:STRING,`rentals_license_revenue__rentals___ims_`:STRING,`revenue_type__license__convenience__annual_or_monthly_`:STRING,`service_license_revenue__molo___sms_`:STRING,`slips_license_revenue__molo_`:STRING,`stellar_implementation_fees__`:STRING,`hs_exchange_rate`:STRING,`of_campgrounds`:STRING,`hs_date_entered_142982667`:STRING,`hs_time_in_142982667`:STRING,`hs_v2_cumulative_time_in_142982663`:STRING,`hs_v2_date_entered_142982663`:STRING,`hs_v2_date_entered_142982667`:STRING,`hs_v2_date_exited_142982663`:STRING,`hs_v2_latest_time_in_142982663`:STRING,`active_rollout`:STRING,`integration_fees__erp__fees_arr`:STRING,`ims_commission_sales_rep_1`:STRING,`ims_sales_rep_1__stellar_rentals_`:STRING,`of_club_boats`:STRING,`zoho_id__zoho_crm_`:STRING,`hs_date_entered_177683084`:STRING,`hs_time_in_177683084`:STRING,`hs_v2_date_entered_177683084`:STRING,`hs_v2_cumulative_time_in_142982670`:STRING,`hs_v2_date_entered_142982670`:STRING,`hs_v2_date_exited_142982670`:STRING,`hs_v2_latest_time_in_142982670`:STRING,`mms_commission_rep_2`:STRING,`hs_v2_date_entered_142982669`:STRING,`hs_priority`:STRING,`of_rv_sites`:STRING,`hs_acv`:STRING,`hs_arr`:STRING,`hs_mrr`:STRING,`hs_tcv`:STRING,`hs_v2_cumulative_time_in_142982665`:STRING,`hs_v2_date_entered_142982665`:STRING,`hs_v2_date_exited_142982665`:STRING,`hs_v2_latest_time_in_142982665`:STRING,`of_atvs`:STRING,`ims_sales_rep_2__stellar_rentals___cloned_`:STRING,`of_snowmobiles`:STRING,`integration_complete_`:STRING,`referral_type`:STRING,`contract_signed_date`:STRING,`description`:STRING,`assets__cloned_`:STRING,`powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units`:STRING,`rv___campsites`:STRING,`sms_commission_rep_1`:STRING,`sms_commission_rep_2`:STRING,`hs_v2_cumulative_time_in_142982669`:STRING,`hs_v2_date_exited_142982669`:STRING,`hs_v2_latest_time_in_142982669`:STRING,`sms_commission__service___molo_`:STRING,`hs_v2_cumulative_time_in_142982667`:STRING,`hs_v2_date_exited_142982667`:STRING,`hs_v2_latest_time_in_142982667`:STRING,`buoy_rep__partner_`:STRING,`hs_date_entered_142982492`:STRING,`hs_date_entered_142997278`:STRING,`hs_date_exited_142997278`:STRING,`hs_time_in_142982492`:STRING,`hs_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_136764464`:STRING,`hs_v2_date_entered_136764464`:STRING,`hs_v2_date_entered_142982492`:STRING,`hs_v2_date_exited_136764464`:STRING,`hs_v2_latest_time_in_136764464`:STRING,`partner_referral`:STRING,`partner_rep`:STRING,`hs_date_entered_136764464`:STRING,`hs_date_entered_136764466`:STRING,`hs_date_entered_136764468`:STRING,`hs_date_entered_136764469`:STRING,`hs_date_exited_136764464`:STRING,`hs_date_exited_136764466`:STRING,`hs_date_exited_136764468`:STRING,`hs_date_exited_142982492`:STRING,`hs_time_in_136764464`:STRING,`hs_time_in_136764466`:STRING,`hs_time_in_136764468`:STRING,`hs_time_in_136764469`:STRING,`hs_v2_cumulative_time_in_142982492`:STRING,`hs_v2_date_entered_136764469`:STRING,`hs_v2_date_exited_142982492`:STRING,`hs_v2_latest_time_in_142982492`:STRING,`vquip_rep__partner_`:STRING,`hs_v2_date_entered_136764468`:STRING,`hs_v2_cumulative_time_in_136764469`:STRING,`hs_v2_date_entered_136764466`:STRING,`hs_v2_date_exited_136764469`:STRING,`hs_v2_latest_time_in_136764469`:STRING,`hs_date_entered_147509879`:STRING,`hs_date_exited_147509879`:STRING,`hs_time_in_147509879`:STRING,`hs_v2_cumulative_time_in_147509879`:STRING,`hs_v2_date_entered_147509879`:STRING,`hs_v2_date_exited_147509879`:STRING,`hs_v2_latest_time_in_147509879`:STRING,`hs_date_entered_136764470`:STRING,`hs_time_in_136764470`:STRING,`hs_v2_cumulative_time_in_136764468`:STRING,`hs_v2_date_entered_136764470`:STRING,`hs_v2_date_exited_136764468`:STRING,`hs_v2_latest_time_in_136764468`:STRING,`hs_v2_cumulative_time_in_136764466`:STRING,`hs_v2_cumulative_time_in_142997278`:STRING,`hs_v2_date_entered_142997278`:STRING,`hs_v2_date_exited_136764466`:STRING,`hs_v2_date_exited_142997278`:STRING,`hs_v2_latest_time_in_136764466`:STRING,`hs_v2_latest_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_142982666`:STRING,`hs_v2_date_exited_142982666`:STRING,`hs_v2_latest_time_in_142982666`:STRING,`hs_object_source_detail_1`:STRING,`deal_status_timestamp`:STRING,`license_billing_type`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`hs_next_step`:STRING,`postal_code`:STRING,`state`:STRING,`boatfix_rep__partner_`:STRING,`noreaster_rep__partner_`:STRING,`hs_v2_cumulative_time_in_177683084`:STRING,`hs_v2_date_exited_177683084`:STRING,`hs_v2_latest_time_in_177683084`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`snag_a_slip__partner_`: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-stage/raw/hubspot_molo_deals/2024-12-09/1733750355'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals"
}
Server:
  • hostname: schemamanager-5c55c886bf-h2ts4
  • name: schema_manager
  • process_start: 2025-10-21 13:03:27
  • sf_env: stage
  • version: 2112174301
Raw: 
{
    "name": {
        "created": "2022-11-30 13:39:25",
        "disabled": false,
        "format": "raw",
        "id": 1506,
        "is_partitioned": false,
        "is_schema_datatyped": false,
        "name": {
            "database": "sfdl_stage_drivethru",
            "table": "hubspot_molo_deals"
        },
        "type": "drivethrujson"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "archived": "string",
            "createdAt": "string",
            "id": "string",
            "properties.accounting_integration_desired": "string",
            "properties.accounting_method": "string",
            "properties.active_rollout": "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.assets": "string",
            "properties.assets__cloned_": "string",
            "properties.billing_support_validated": "string",
            "properties.boatfix_rep__partner_": "string",
            "properties.buoy_rep__partner_": "string",
            "properties.caller_owner": "string",
            "properties.city": "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.club_locations": "string",
            "properties.company": "string",
            "properties.contact": "string",
            "properties.contract__file_": "string",
            "properties.contract_signed_date": "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_notes___contract_modifications_and_non_standard_billing_summary": "string",
            "properties.deal_status": "string",
            "properties.deal_status_timestamp": "string",
            "properties.deal_temperature": "string",
            "properties.deal_value": "string",
            "properties.deal_value__usd_": "string",
            "properties.deal_value_total___1st_year__arr_and_implementation_fee_": "string",
            "properties.dealname": "string",
            "properties.dealstage": "string",
            "properties.dealtype": "string",
            "properties.demo_performed": "string",
            "properties.demo_scheduled": "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.estimated_price_per_slip": "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_attributed_team_ids": "string",
            "properties.hs_campaign": "string",
            "properties.hs_closed_amount": "string",
            "properties.hs_closed_amount_in_home_currency": "string",
            "properties.hs_closed_deal_close_date": "string",
            "properties.hs_closed_deal_create_date": "string",
            "properties.hs_closed_won_count": "string",
            "properties.hs_closed_won_date": "string",
            "properties.hs_created_by_user_id": "string",
            "properties.hs_createdate": "string",
            "properties.hs_date_entered_136764464": "string",
            "properties.hs_date_entered_136764466": "string",
            "properties.hs_date_entered_136764468": "string",
            "properties.hs_date_entered_136764469": "string",
            "properties.hs_date_entered_136764470": "string",
            "properties.hs_date_entered_142982492": "string",
            "properties.hs_date_entered_142982663": "string",
            "properties.hs_date_entered_142982665": "string",
            "properties.hs_date_entered_142982666": "string",
            "properties.hs_date_entered_142982667": "string",
            "properties.hs_date_entered_142982669": "string",
            "properties.hs_date_entered_142982670": "string",
            "properties.hs_date_entered_142997278": "string",
            "properties.hs_date_entered_147509879": "string",
            "properties.hs_date_entered_177683084": "string",
            "properties.hs_date_entered_177683085": "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_136764464": "string",
            "properties.hs_date_exited_136764466": "string",
            "properties.hs_date_exited_136764468": "string",
            "properties.hs_date_exited_142982492": "string",
            "properties.hs_date_exited_142982663": "string",
            "properties.hs_date_exited_142982665": "string",
            "properties.hs_date_exited_142982669": "string",
            "properties.hs_date_exited_142982670": "string",
            "properties.hs_date_exited_142997278": "string",
            "properties.hs_date_exited_147509879": "string",
            "properties.hs_date_exited_177683085": "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_days_to_close_raw": "string",
            "properties.hs_deal_amount_calculation_preference": "string",
            "properties.hs_deal_score": "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_active_shared_deal": "string",
            "properties.hs_is_closed": "string",
            "properties.hs_is_closed_count": "string",
            "properties.hs_is_closed_lost": "string",
            "properties.hs_is_closed_won": "string",
            "properties.hs_is_deal_split": "string",
            "properties.hs_is_in_first_deal_stage": "string",
            "properties.hs_is_open_count": "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_notes_last_activity": "string",
            "properties.hs_notes_next_activity": "string",
            "properties.hs_notes_next_activity_type": "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_of_associated_line_items": "string",
            "properties.hs_num_target_accounts": "string",
            "properties.hs_object_id": "string",
            "properties.hs_object_source": "string",
            "properties.hs_object_source_detail_1": "string",
            "properties.hs_object_source_detail_2": "string",
            "properties.hs_object_source_detail_3": "string",
            "properties.hs_object_source_id": "string",
            "properties.hs_object_source_label": "string",
            "properties.hs_object_source_user_id": "string",
            "properties.hs_open_deal_create_date": "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_136764464": "string",
            "properties.hs_time_in_136764466": "string",
            "properties.hs_time_in_136764468": "string",
            "properties.hs_time_in_136764469": "string",
            "properties.hs_time_in_136764470": "string",
            "properties.hs_time_in_142982492": "string",
            "properties.hs_time_in_142982663": "string",
            "properties.hs_time_in_142982665": "string",
            "properties.hs_time_in_142982666": "string",
            "properties.hs_time_in_142982667": "string",
            "properties.hs_time_in_142982669": "string",
            "properties.hs_time_in_142982670": "string",
            "properties.hs_time_in_142997278": "string",
            "properties.hs_time_in_147509879": "string",
            "properties.hs_time_in_177683084": "string",
            "properties.hs_time_in_177683085": "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.hs_v2_cumulative_time_in_136764464": "string",
            "properties.hs_v2_cumulative_time_in_136764466": "string",
            "properties.hs_v2_cumulative_time_in_136764468": "string",
            "properties.hs_v2_cumulative_time_in_136764469": "string",
            "properties.hs_v2_cumulative_time_in_142982492": "string",
            "properties.hs_v2_cumulative_time_in_142982663": "string",
            "properties.hs_v2_cumulative_time_in_142982665": "string",
            "properties.hs_v2_cumulative_time_in_142982666": "string",
            "properties.hs_v2_cumulative_time_in_142982667": "string",
            "properties.hs_v2_cumulative_time_in_142982669": "string",
            "properties.hs_v2_cumulative_time_in_142982670": "string",
            "properties.hs_v2_cumulative_time_in_142997278": "string",
            "properties.hs_v2_cumulative_time_in_147509879": "string",
            "properties.hs_v2_cumulative_time_in_177683084": "string",
            "properties.hs_v2_cumulative_time_in_23229963": "string",
            "properties.hs_v2_cumulative_time_in_23229964": "string",
            "properties.hs_v2_cumulative_time_in_23229965": "string",
            "properties.hs_v2_cumulative_time_in_23229966": "string",
            "properties.hs_v2_cumulative_time_in_23229967": "string",
            "properties.hs_v2_cumulative_time_in_23229968": "string",
            "properties.hs_v2_cumulative_time_in_closedlost": "string",
            "properties.hs_v2_cumulative_time_in_closedwon": "string",
            "properties.hs_v2_date_entered_136764464": "string",
            "properties.hs_v2_date_entered_136764466": "string",
            "properties.hs_v2_date_entered_136764468": "string",
            "properties.hs_v2_date_entered_136764469": "string",
            "properties.hs_v2_date_entered_136764470": "string",
            "properties.hs_v2_date_entered_142982492": "string",
            "properties.hs_v2_date_entered_142982663": "string",
            "properties.hs_v2_date_entered_142982665": "string",
            "properties.hs_v2_date_entered_142982666": "string",
            "properties.hs_v2_date_entered_142982667": "string",
            "properties.hs_v2_date_entered_142982669": "string",
            "properties.hs_v2_date_entered_142982670": "string",
            "properties.hs_v2_date_entered_142997278": "string",
            "properties.hs_v2_date_entered_147509879": "string",
            "properties.hs_v2_date_entered_177683084": "string",
            "properties.hs_v2_date_entered_177683085": "string",
            "properties.hs_v2_date_entered_23229963": "string",
            "properties.hs_v2_date_entered_23229964": "string",
            "properties.hs_v2_date_entered_23229965": "string",
            "properties.hs_v2_date_entered_23229966": "string",
            "properties.hs_v2_date_entered_23229967": "string",
            "properties.hs_v2_date_entered_23229968": "string",
            "properties.hs_v2_date_entered_closedlost": "string",
            "properties.hs_v2_date_entered_closedwon": "string",
            "properties.hs_v2_date_exited_136764464": "string",
            "properties.hs_v2_date_exited_136764466": "string",
            "properties.hs_v2_date_exited_136764468": "string",
            "properties.hs_v2_date_exited_136764469": "string",
            "properties.hs_v2_date_exited_142982492": "string",
            "properties.hs_v2_date_exited_142982663": "string",
            "properties.hs_v2_date_exited_142982665": "string",
            "properties.hs_v2_date_exited_142982666": "string",
            "properties.hs_v2_date_exited_142982667": "string",
            "properties.hs_v2_date_exited_142982669": "string",
            "properties.hs_v2_date_exited_142982670": "string",
            "properties.hs_v2_date_exited_142997278": "string",
            "properties.hs_v2_date_exited_147509879": "string",
            "properties.hs_v2_date_exited_177683084": "string",
            "properties.hs_v2_date_exited_23229963": "string",
            "properties.hs_v2_date_exited_23229964": "string",
            "properties.hs_v2_date_exited_23229965": "string",
            "properties.hs_v2_date_exited_23229966": "string",
            "properties.hs_v2_date_exited_23229967": "string",
            "properties.hs_v2_date_exited_23229968": "string",
            "properties.hs_v2_date_exited_closedlost": "string",
            "properties.hs_v2_date_exited_closedwon": "string",
            "properties.hs_v2_latest_time_in_136764464": "string",
            "properties.hs_v2_latest_time_in_136764466": "string",
            "properties.hs_v2_latest_time_in_136764468": "string",
            "properties.hs_v2_latest_time_in_136764469": "string",
            "properties.hs_v2_latest_time_in_142982492": "string",
            "properties.hs_v2_latest_time_in_142982663": "string",
            "properties.hs_v2_latest_time_in_142982665": "string",
            "properties.hs_v2_latest_time_in_142982666": "string",
            "properties.hs_v2_latest_time_in_142982667": "string",
            "properties.hs_v2_latest_time_in_142982669": "string",
            "properties.hs_v2_latest_time_in_142982670": "string",
            "properties.hs_v2_latest_time_in_142997278": "string",
            "properties.hs_v2_latest_time_in_147509879": "string",
            "properties.hs_v2_latest_time_in_177683084": "string",
            "properties.hs_v2_latest_time_in_23229963": "string",
            "properties.hs_v2_latest_time_in_23229964": "string",
            "properties.hs_v2_latest_time_in_23229965": "string",
            "properties.hs_v2_latest_time_in_23229966": "string",
            "properties.hs_v2_latest_time_in_23229967": "string",
            "properties.hs_v2_latest_time_in_23229968": "string",
            "properties.hs_v2_latest_time_in_closedlost": "string",
            "properties.hs_v2_latest_time_in_closedwon": "string",
            "properties.hs_was_imported": "string",
            "properties.hubspot_owner_assigneddate": "string",
            "properties.hubspot_owner_id": "string",
            "properties.hubspot_team_id": "string",
            "properties.ims_commission_sales_rep_1": "string",
            "properties.ims_license_revenue__": "string",
            "properties.ims_sales_rep_1__stellar_rentals_": "string",
            "properties.ims_sales_rep_2__stellar_rentals___cloned_": "string",
            "properties.integration_complete_": "string",
            "properties.integration_fees__erp__fees_arr": "string",
            "properties.license_billing_type": "string",
            "properties.likelihood": "string",
            "properties.micro": "string",
            "properties.mms_commission__molo_slips_": "string",
            "properties.mms_commission_rep_1": "string",
            "properties.mms_commission_rep_2": "string",
            "properties.modules": "string",
            "properties.molo_implementation_fees__": "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.non_powered_units": "string",
            "properties.noreaster_rep__partner_": "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_atvs": "string",
            "properties.of_boats": "string",
            "properties.of_campgrounds": "string",
            "properties.of_club_boats": "string",
            "properties.of_resources": "string",
            "properties.of_rv_sites": "string",
            "properties.of_service_techs": "string",
            "properties.of_slips": "string",
            "properties.of_snowmobiles": "string",
            "properties.operators_last_year_rentals_revenue__stellar_": "string",
            "properties.other_vendor_lost_to": "string",
            "properties.panda_url": "string",
            "properties.partner_referral": "string",
            "properties.partner_rep": "string",
            "properties.perform_date": "string",
            "properties.pipeline": "string",
            "properties.point_of_contact": "string",
            "properties.point_of_contact_email": "string",
            "properties.postal_code": "string",
            "properties.powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units": "string",
            "properties.referral_type": "string",
            "properties.rental_locations": "string",
            "properties.rentals_license_revenue__rentals___ims_": "string",
            "properties.revenue_type__license__convenience__annual_or_monthly_": "string",
            "properties.rv___campsites": "string",
            "properties.second_deal_owner": "string",
            "properties.service_license_revenue__molo___sms_": "string",
            "properties.service_locations": "string",
            "properties.services_offered": "string",
            "properties.size": "string",
            "properties.slip_locations": "string",
            "properties.slips_license_revenue__molo_": "string",
            "properties.sms_commission__service___molo_": "string",
            "properties.sms_commission_rep_1": "string",
            "properties.sms_commission_rep_2": "string",
            "properties.snag_a_slip__partner_": "string",
            "properties.source": "string",
            "properties.state": "string",
            "properties.state_region": "string",
            "properties.stellar_bundle_": "string",
            "properties.stellar_implementation_fees__": "string",
            "properties.stellar_rep": "string",
            "properties.street_address": "string",
            "properties.tags": "string",
            "properties.temperature": "string",
            "properties.title__role___responsibilities": "string",
            "properties.vendor_lost_to": "string",
            "properties.vquip_rep__partner_": "string",
            "properties.website": "string",
            "properties.zoho_id__zoho_crm_": "string",
            "updatedAt": "string"
        },
        "created": "2024-12-09 07:19:59",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_drivethru.hubspot_molo_deals`\n(\n`id`STRING,`properties`struct<`closed_lost_reason`:STRING,`closed_lost_reason12`:STRING,`closedate`:STRING,`company`:STRING,`contact`:STRING,`createdate`:STRING,`current_vendor_new`: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_closed_deal_close_date`:STRING,`hs_closed_deal_create_date`:STRING,`hs_closed_won_count`:STRING,`hs_createdate`:STRING,`hs_date_entered_closedlost`:STRING,`hs_days_to_close_raw`:STRING,`hs_deal_stage_probability`:STRING,`hs_deal_stage_probability_shadow`:STRING,`hs_forecast_probability`:STRING,`hs_is_active_shared_deal`:STRING,`hs_is_closed`:STRING,`hs_is_closed_count`:STRING,`hs_is_closed_lost`:STRING,`hs_is_closed_won`:STRING,`hs_is_deal_split`:STRING,`hs_is_open_count`:STRING,`hs_lastmodifieddate`:STRING,`hs_manual_forecast_category`:STRING,`hs_num_of_associated_line_items`:STRING,`hs_num_target_accounts`:STRING,`hs_object_id`:STRING,`hs_open_deal_create_date`:STRING,`hs_time_in_closedlost`:STRING,`hs_updated_by_user_id`:STRING,`hs_v2_date_entered_closedlost`:STRING,`hs_was_imported`:STRING,`num_associated_contacts`:STRING,`pipeline`:STRING,`size`:STRING,`state_region`:STRING,`hs_notes_last_activity`:STRING,`notes_last_updated`:STRING,`notes_next_activity_date`:STRING,`num_contacted_notes`:STRING,`num_notes`:STRING,`hs_v2_cumulative_time_in_closedlost`:STRING,`hs_v2_date_exited_closedlost`:STRING,`hs_v2_latest_time_in_closedlost`: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_analytics_latest_source_timestamp`:STRING,`hs_analytics_latest_source_timestamp_company`:STRING,`hs_user_ids_of_all_owners`:STRING,`hubspot_owner_assigneddate`:STRING,`hubspot_owner_id`:STRING,`hubspot_team_id`:STRING,`current_vendor`:STRING,`hs_attributed_team_ids`:STRING,`closed_won_reason`:STRING,`closed_won_reason1`:STRING,`hs_closed_won_date`: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_v2_date_entered_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_contact`:STRING,`notes_last_contacted`:STRING,`amount`:STRING,`amount_in_home_currency`:STRING,`deal_currency_code`: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,`hs_deal_score`:STRING,`hs_v2_date_entered_23229967`:STRING,`dealtype`:STRING,`tags`:STRING,`temperature`:STRING,`hs_v2_cumulative_time_in_closedwon`:STRING,`hs_v2_date_exited_closedwon`:STRING,`hs_v2_latest_time_in_closedwon`: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,`hs_notes_next_activity`:STRING,`hs_notes_next_activity_type`:STRING,`hs_created_by_user_id`:STRING,`hs_object_source`:STRING,`hs_object_source_label`:STRING,`hs_object_source_id`:STRING,`hs_object_source_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,`hs_v2_date_entered_23229964`:STRING,`hs_v2_cumulative_time_in_23229967`:STRING,`hs_v2_date_exited_23229967`:STRING,`hs_v2_latest_time_in_23229967`:STRING,`other_vendor_lost_to`:STRING,`panda_url`:STRING,`deal_status`:STRING,`discount_offered`:STRING,`discount_reception_perception`:STRING,`hs_v2_cumulative_time_in_23229968`:STRING,`hs_v2_date_entered_23229968`:STRING,`hs_v2_date_exited_23229968`:STRING,`hs_v2_latest_time_in_23229968`: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,`hs_v2_cumulative_time_in_23229965`:STRING,`hs_v2_date_entered_23229965`:STRING,`hs_v2_date_exited_23229965`:STRING,`hs_v2_latest_time_in_23229965`: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,`assets`:STRING,`hs_num_associated_deal_splits`:STRING,`hs_v2_date_entered_23229966`:STRING,`caller_owner`:STRING,`hs_num_associated_active_deal_registrations`:STRING,`hs_num_associated_deal_registrations`:STRING,`hs_v2_cumulative_time_in_23229966`:STRING,`hs_v2_date_exited_23229966`:STRING,`hs_v2_latest_time_in_23229966`:STRING,`hs_v2_cumulative_time_in_23229964`:STRING,`hs_v2_date_exited_23229964`:STRING,`hs_v2_latest_time_in_23229964`:STRING,`point_of_contact_email`:STRING,`second_deal_owner`:STRING,`hs_v2_cumulative_time_in_23229963`:STRING,`hs_v2_date_entered_23229963`:STRING,`hs_v2_date_exited_23229963`:STRING,`hs_v2_latest_time_in_23229963`:STRING,`demo_performed`:STRING,`demo_scheduled`:STRING,`hs_date_entered_23229963`:STRING,`hs_time_in_23229963`:STRING,`stellar_bundle_`:STRING,`stellar_rep`:STRING,`city`:STRING,`of_boats`:STRING,`of_service_techs`:STRING,`rental_locations`:STRING,`street_address`:STRING,`accounting_method`:STRING,`hs_date_entered_142982663`:STRING,`hs_date_entered_142982665`:STRING,`hs_date_entered_142982666`:STRING,`hs_date_entered_142982669`:STRING,`hs_date_entered_142982670`:STRING,`hs_date_entered_177683085`:STRING,`hs_date_exited_142982663`:STRING,`hs_date_exited_142982665`:STRING,`hs_date_exited_142982669`:STRING,`hs_date_exited_142982670`:STRING,`hs_date_exited_177683085`:STRING,`hs_is_in_first_deal_stage`:STRING,`hs_time_in_142982663`:STRING,`hs_time_in_142982665`:STRING,`hs_time_in_142982666`:STRING,`hs_time_in_142982669`:STRING,`hs_time_in_142982670`:STRING,`hs_time_in_177683085`:STRING,`hs_v2_date_entered_142982666`:STRING,`non_powered_units`:STRING,`service_locations`:STRING,`slip_locations`:STRING,`billing_support_validated`:STRING,`club_locations`:STRING,`contract__file_`:STRING,`deal_notes___contract_modifications_and_non_standard_billing_summary`:STRING,`deal_value_total___1st_year__arr_and_implementation_fee_`:STRING,`estimated_price_per_slip`:STRING,`ims_license_revenue__`:STRING,`mms_commission__molo_slips_`:STRING,`mms_commission_rep_1`:STRING,`molo_implementation_fees__`:STRING,`operators_last_year_rentals_revenue__stellar_`:STRING,`rentals_license_revenue__rentals___ims_`:STRING,`revenue_type__license__convenience__annual_or_monthly_`:STRING,`service_license_revenue__molo___sms_`:STRING,`slips_license_revenue__molo_`:STRING,`stellar_implementation_fees__`:STRING,`hs_exchange_rate`:STRING,`of_campgrounds`:STRING,`hs_date_entered_142982667`:STRING,`hs_time_in_142982667`:STRING,`hs_v2_cumulative_time_in_142982663`:STRING,`hs_v2_date_entered_142982663`:STRING,`hs_v2_date_entered_142982667`:STRING,`hs_v2_date_exited_142982663`:STRING,`hs_v2_latest_time_in_142982663`:STRING,`active_rollout`:STRING,`integration_fees__erp__fees_arr`:STRING,`ims_commission_sales_rep_1`:STRING,`ims_sales_rep_1__stellar_rentals_`:STRING,`of_club_boats`:STRING,`zoho_id__zoho_crm_`:STRING,`hs_date_entered_177683084`:STRING,`hs_time_in_177683084`:STRING,`hs_v2_date_entered_177683084`:STRING,`hs_v2_cumulative_time_in_142982670`:STRING,`hs_v2_date_entered_142982670`:STRING,`hs_v2_date_exited_142982670`:STRING,`hs_v2_latest_time_in_142982670`:STRING,`mms_commission_rep_2`:STRING,`hs_v2_date_entered_142982669`:STRING,`hs_priority`:STRING,`of_rv_sites`:STRING,`hs_acv`:STRING,`hs_arr`:STRING,`hs_mrr`:STRING,`hs_tcv`:STRING,`hs_v2_cumulative_time_in_142982665`:STRING,`hs_v2_date_entered_142982665`:STRING,`hs_v2_date_exited_142982665`:STRING,`hs_v2_latest_time_in_142982665`:STRING,`of_atvs`:STRING,`ims_sales_rep_2__stellar_rentals___cloned_`:STRING,`of_snowmobiles`:STRING,`integration_complete_`:STRING,`referral_type`:STRING,`contract_signed_date`:STRING,`description`:STRING,`assets__cloned_`:STRING,`powersports_units__atvs__snowmobiles__etc___non_waterports_powered_units`:STRING,`rv___campsites`:STRING,`sms_commission_rep_1`:STRING,`sms_commission_rep_2`:STRING,`hs_v2_cumulative_time_in_142982669`:STRING,`hs_v2_date_exited_142982669`:STRING,`hs_v2_latest_time_in_142982669`:STRING,`sms_commission__service___molo_`:STRING,`hs_v2_cumulative_time_in_142982667`:STRING,`hs_v2_date_exited_142982667`:STRING,`hs_v2_latest_time_in_142982667`:STRING,`buoy_rep__partner_`:STRING,`hs_date_entered_142982492`:STRING,`hs_date_entered_142997278`:STRING,`hs_date_exited_142997278`:STRING,`hs_time_in_142982492`:STRING,`hs_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_136764464`:STRING,`hs_v2_date_entered_136764464`:STRING,`hs_v2_date_entered_142982492`:STRING,`hs_v2_date_exited_136764464`:STRING,`hs_v2_latest_time_in_136764464`:STRING,`partner_referral`:STRING,`partner_rep`:STRING,`hs_date_entered_136764464`:STRING,`hs_date_entered_136764466`:STRING,`hs_date_entered_136764468`:STRING,`hs_date_entered_136764469`:STRING,`hs_date_exited_136764464`:STRING,`hs_date_exited_136764466`:STRING,`hs_date_exited_136764468`:STRING,`hs_date_exited_142982492`:STRING,`hs_time_in_136764464`:STRING,`hs_time_in_136764466`:STRING,`hs_time_in_136764468`:STRING,`hs_time_in_136764469`:STRING,`hs_v2_cumulative_time_in_142982492`:STRING,`hs_v2_date_entered_136764469`:STRING,`hs_v2_date_exited_142982492`:STRING,`hs_v2_latest_time_in_142982492`:STRING,`vquip_rep__partner_`:STRING,`hs_v2_date_entered_136764468`:STRING,`hs_v2_cumulative_time_in_136764469`:STRING,`hs_v2_date_entered_136764466`:STRING,`hs_v2_date_exited_136764469`:STRING,`hs_v2_latest_time_in_136764469`:STRING,`hs_date_entered_147509879`:STRING,`hs_date_exited_147509879`:STRING,`hs_time_in_147509879`:STRING,`hs_v2_cumulative_time_in_147509879`:STRING,`hs_v2_date_entered_147509879`:STRING,`hs_v2_date_exited_147509879`:STRING,`hs_v2_latest_time_in_147509879`:STRING,`hs_date_entered_136764470`:STRING,`hs_time_in_136764470`:STRING,`hs_v2_cumulative_time_in_136764468`:STRING,`hs_v2_date_entered_136764470`:STRING,`hs_v2_date_exited_136764468`:STRING,`hs_v2_latest_time_in_136764468`:STRING,`hs_v2_cumulative_time_in_136764466`:STRING,`hs_v2_cumulative_time_in_142997278`:STRING,`hs_v2_date_entered_142997278`:STRING,`hs_v2_date_exited_136764466`:STRING,`hs_v2_date_exited_142997278`:STRING,`hs_v2_latest_time_in_136764466`:STRING,`hs_v2_latest_time_in_142997278`:STRING,`hs_v2_cumulative_time_in_142982666`:STRING,`hs_v2_date_exited_142982666`:STRING,`hs_v2_latest_time_in_142982666`:STRING,`hs_object_source_detail_1`:STRING,`deal_status_timestamp`:STRING,`license_billing_type`:STRING,`hs_all_assigned_business_unit_ids`:STRING,`hs_next_step`:STRING,`postal_code`:STRING,`state`:STRING,`boatfix_rep__partner_`:STRING,`noreaster_rep__partner_`:STRING,`hs_v2_cumulative_time_in_177683084`:STRING,`hs_v2_date_exited_177683084`:STRING,`hs_v2_latest_time_in_177683084`:STRING,`hs_object_source_detail_2`:STRING,`hs_object_source_detail_3`:STRING,`snag_a_slip__partner_`: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-stage/raw/hubspot_molo_deals/2024-12-09/1733750355'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_drivethru.hubspot_molo_deals`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_drivethru.hubspot_molo_deals"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform