Hubspot

Query and insert/update/delete data from Hubspot.

Usage

-- Query all contacts
SELECT * FROM hubspot_contacts

-- Join contacts with companies
SELECT * FROM hubspot_contacts c
JOIN hubspot_companies co ON c.primary_associated_company_id = co.record_id

-- Insert a new contact
INSERT INTO hubspot_contacts (email, first_name, last_name) VALUES 
('john.doe@acme.com', 'John', 'Doe')

-- Update a contact
UPDATE hubspot_contacts SET first_name = 'Jane' WHERE email = 'john.doe@acme.com'

-- Delete a contact
DELETE FROM hubspot_contacts WHERE email = 'john.doe@acme.com';

Setup

First, install the Hubspot plugin:

anyquery install hubspot

You'll need to authenticate with Hubspot to use this plugin. To do so, create a new private app:

Open the settings for your Hubspot account (top navigation bar > gear icon)
In the left sidebar, click on "Integrations" > "Private apps"
Click on "Create private app"
Fill in the name
Go to the "Scopes" tab, click on "add scopes" and select as much scopes as you need under the "CRM" section. To access tickets, you need to select the "Tickets" scope under the "Other" section. You're free to unselect any scope you don't need. However, some tables may not be available if you don't select the right scopes.
Click on "Create app"
Click on "Continue" when you see the security warning
Copy the token by clicking on "Show" and then "Copy".
Paste it when asked by Anyquery

During the plugin installation, anyquery will ask you for the cache_ttl parameter. This is the number of seconds the plugin will cache the data for. For instance, if you set it to 3600, the plugin will cache the data for 1 hour. This is useful to avoid hitting the Hubspot API rate limits.

Schema

hubspot_contacts

Column index	Column name	type
0	street_address	TEXT
1	annual_revenue	TEXT
2	primary_associated_company_id	REAL
3	associated_company_last_updated	REAL
4	city	TEXT
5	close_date	TEXT
6	company_name	TEXT
7	company_size	TEXT
8	countryregion	TEXT
9	create_date	TEXT
10	currently_in_workflow	TEXT
11	date_of_birth	TEXT
12	days_to_close	REAL
13	degree	TEXT
14	email	TEXT
15	date_of_last_meeting_booked_in_meetings_tool	TEXT
16	campaign_of_last_booking_in_meetings_tool	TEXT
17	medium_of_last_booking_in_meetings_tool	TEXT
18	source_of_last_booking_in_meetings_tool	TEXT
19	fax_number	TEXT
20	field_of_study	TEXT
21	first_conversion_date	TEXT
22	first_conversion	TEXT
23	first_deal_created_date	TEXT
24	first_name	TEXT
25	follower_count	REAL
26	gender	TEXT
27	graduation_date	TEXT
28	additional_email_addresses	TEXT
29	all_teams	TEXT
30	business_units	TEXT
31	all_vids_for_a_contact	TEXT
32	all_owner_ids	TEXT
33	all_team_ids	TEXT
34	average_pageviews	REAL
35	first_referring_site	TEXT
36	time_first_seen	TEXT
37	first_touch_converting_campaign	TEXT
38	first_page_seen	TEXT
39	time_of_first_session	TEXT
40	last_referring_site	TEXT
41	time_last_seen	TEXT
42	last_touch_converting_campaign	TEXT
43	last_page_seen	TEXT
44	time_of_last_session	TEXT
45	number_of_event_completions	REAL
46	number_of_pageviews	REAL
47	number_of_sessions	REAL
48	event_revenue	REAL
49	original_source	TEXT
50	original_source_drill_down_1	TEXT
51	original_source_drill_down_2	TEXT
52	associated_target_accounts	REAL
53	avatar_filemanager_key	TEXT
54	buying_role	TEXT
55	all_form_submissions_for_a_contact	TEXT
56	merged_vids_with_timestamps_of_a_contact	TEXT
57	calculated_mobile_number_in_international_format	TEXT
58	calculated_phone_number_in_international_format	TEXT
59	calculated_phone_number_area_code	TEXT
60	calculated_phone_number_country_code	TEXT
61	calculated_phone_number_region	TEXT
62	clicked_on_a_linkedin_ad	TEXT
63	enrichment_opt_out	INTEGER
64	enrichment_opt_out_timestamp	TEXT
65	member_email	TEXT
66	email_confirmed	INTEGER
67	time_enrolled_in_registration_follow_up_emails	TEXT
68	membership_notes	TEXT
69	registered_at	TEXT
70	domain_to_which_registration_email_was_sent	TEXT
71	time_registration_email_was_sent	TEXT
72	status	TEXT
73	conversations_visitor_email	TEXT
74	count_of_unengaged_contacts	REAL
75	count_of_engaged_contacts	REAL
76	countryregion_code	TEXT
77	created_by_conversations	INTEGER
78	created_by_user_id	REAL
79	object_create_datetime	TEXT
80	currently_enrolled_in_prospecting_agent	INTEGER
81	ads_consent_from_forms	INTEGER
82	date_entered_customer_lifecycle_stage_pipeline	TEXT
83	date_entered_evangelist_lifecycle_stage_pipeline	TEXT
84	date_entered_lead_lifecycle_stage_pipeline	TEXT
85	date_entered_marketing_qualified_lead_lifecycle_stage_pipeline	TEXT
86	date_entered_opportunity_lifecycle_stage_pipeline	TEXT
87	date_entered_other_lifecycle_stage_pipeline	TEXT
88	date_entered_sales_qualified_lead_lifecycle_stage_pipeline	TEXT
89	date_entered_subscriber_lifecycle_stage_pipeline	TEXT
90	date_exited_customer_lifecycle_stage_pipeline	TEXT
91	date_exited_evangelist_lifecycle_stage_pipeline	TEXT
92	date_exited_lead_lifecycle_stage_pipeline	TEXT
93	date_exited_marketing_qualified_lead_lifecycle_stage_pipeline	TEXT
94	date_exited_opportunity_lifecycle_stage_pipeline	TEXT
95	date_exited_other_lifecycle_stage_pipeline	TEXT
96	date_exited_sales_qualified_lead_lifecycle_stage_pipeline	TEXT
97	date_exited_subscriber_lifecycle_stage_pipeline	TEXT
98	recent_document_revisit_date	TEXT
99	invalid_email_address	INTEGER
100	marketing_emails_bounced	REAL
101	marketing_emails_clicked	REAL
102	email_address_quarantine_reason	TEXT
103	marketing_emails_delivered	REAL
104	email_domain	TEXT
105	first_marketing_email_click_date	TEXT
106	first_marketing_email_open_date	TEXT
107	first_marketing_email_reply_date	TEXT
108	first_marketing_email_send_date	TEXT
109	email_hard_bounce_reason	TEXT
110	is_globally_ineligible	INTEGER
111	last_marketing_email_click_date	TEXT
112	last_marketing_email_name	TEXT
113	last_marketing_email_open_date	TEXT
114	last_marketing_email_reply_date	TEXT
115	last_marketing_email_send_date	TEXT
116	marketing_emails_opened	REAL
117	unsubscribed_from_all_email	INTEGER
118	opted_out_of_email_customer_service_communication	TEXT
119	opted_out_of_email_marketing_information	TEXT
120	opted_out_of_email_one_to_one	TEXT
121	email_address_quarantined	INTEGER
122	email_address_automated_quarantine_reason	TEXT
123	email_address_recipient_fatigue_next_available_sending_time	TEXT
124	marketing_emails_replied	REAL
125	sends_since_last_engagement	REAL
126	marketing_email_confirmation_status	TEXT
127	clicked_facebook_ad	INTEGER
128	facebook_click_id	TEXT
129	facebook_id	TEXT
130	last_nps_survey_comment	TEXT
131	last_nps_survey_rating	TEXT
132	last_nps_survey_date	TEXT
133	should_be_shown_an_nps_web_survey	INTEGER
134	id_of_first_engagement	REAL
135	first_order_closed_date	TEXT
136	first_outreach_date	TEXT
137	first_subscription_create_date	TEXT
138	google_ad_click_id	TEXT
139	googleplus_id	TEXT
140	contact_has_an_active_subscription	REAL
141	ip_timezone	TEXT
142	is_a_contact	INTEGER
143	has_been_enriched	INTEGER
144	contact_unworked	INTEGER
145	journey_stage	TEXT
146	preferred_language	TEXT
147	last_sales_activity_date_old	TEXT
148	last_engagement_date	TEXT
149	last_engagement_type	TEXT
150	object_last_modified_datetime	TEXT
151	latest_disqualified_lead_date	TEXT
152	latest_meeting_activity	TEXT
153	latest_open_lead_date	TEXT
154	latest_qualified_lead_date	TEXT
155	last_sequence_ended_date	TEXT
156	last_sequence_enrolled	REAL
157	last_sequence_enrolled_date	TEXT
158	last_sequence_finished_date	TEXT
159	last_sequence_unenrolled_date	TEXT
160	latest_source	TEXT
161	latest_source_drill_down_1	TEXT
162	latest_source_drill_down_2	TEXT
163	latest_source_date	TEXT
164	latest_subscription_create_date	TEXT
165	lead_status	TEXT
166	legal_basis_for_processing_contacts_data	TEXT
167	became_a_customer_date	TEXT
168	became_an_evangelist_date	TEXT
169	became_a_lead_date	TEXT
170	became_a_marketing_qualified_lead_date	TEXT
171	became_an_opportunity_date	TEXT
172	became_an_other_lifecycle_date	TEXT
173	became_a_sales_qualified_lead_date	TEXT
174	became_a_subscriber_date	TEXT
175	clicked_linkedin_ad	TEXT
176	linkedin_url	TEXT
177	linkedin_id	TEXT
178	marketing_contact_status_source_name	TEXT
179	marketing_contact_status_source_type	TEXT
180	marketing_contact_status	TEXT
181	marketing_contact_until_next_update	TEXT
182	member_has_accessed_private_content	REAL
183	membership_last_private_content_access_date	TEXT
184	merged_contact_ids	TEXT
185	mobile_sdk_push_tokens	TEXT
186	next_activity_type	TEXT
187	record_id	REAL
188	record_creation_source	TEXT
189	record_source_detail_1	TEXT
190	record_source_detail_2	TEXT
191	record_source_detail_3	TEXT
192	record_creation_source_id	TEXT
193	record_source	TEXT
194	record_creation_source_user_id	REAL
195	persona	TEXT
196	pinned_engagement_id	REAL
197	pipeline	TEXT
198	predictive_lead_score	REAL
199	likelihood_to_close_tmp	REAL
200	likelihood_to_close	REAL
201	lead_rating	TEXT
202	contact_priority	TEXT
203	contact_priority_tmp	TEXT
204	prospecting_agent_actively_enrolled_count	REAL
205	quarantined_emails	TEXT
206	read_only_object	INTEGER
207	recent_closed_order_date	TEXT
208	registered_member	REAL
209	registration_method	TEXT
210	employment_role	TEXT
211	date_of_first_engagement	TEXT
212	description_of_first_engagement	TEXT
213	type_of_first_engagement	TEXT
214	recent_sales_email_clicked_date	TEXT
215	recent_sales_email_opened_date	TEXT
216	recent_sales_email_replied_date	TEXT
217	employment_seniority	TEXT
218	number_of_sequences_actively_enrolled	REAL
219	number_of_sequences_enrolled	REAL
220	currently_in_sequence	INTEGER
221	shared_teams	TEXT
222	shared_users	TEXT
223	facebook_clicks	REAL
224	google_plus_clicks	REAL
225	most_recent_social_click	TEXT
226	linkedin_clicks	REAL
227	broadcast_clicks	REAL
228	twitter_clicks	REAL
229	source_object_id	REAL
230	source_portal_id	REAL
231	stateregion_code	TEXT
232	employment_sub_role	TEXT
233	testpurge	TEXT
234	testrollback	TEXT
235	time_between_contact_creation_and_deal_close	REAL
236	time_between_contact_creation_and_deal_creation	REAL
237	time_in_customer_lifecycle_stage_pipeline	REAL
238	time_in_evangelist_lifecycle_stage_pipeline	REAL
239	time_in_lead_lifecycle_stage_pipeline	REAL
240	time_in_marketing_qualified_lead_lifecycle_stage_pipeline	REAL
241	time_in_opportunity_lifecycle_stage_pipeline	REAL
242	time_in_other_lifecycle_stage_pipeline	REAL
243	time_in_sales_qualified_lead_lifecycle_stage_pipeline	REAL
244	time_in_subscriber_lifecycle_stage_pipeline	REAL
245	lead_response_time	REAL
246	time_to_move_from_lead_to_customer	REAL
247	time_to_move_from_marketing_qualified_lead_to_customer	REAL
248	time_to_move_from_opportunity_to_customer	REAL
249	time_to_move_from_sales_qualified_lead_to_customer	REAL
250	time_to_move_from_subscriber_to_customer	REAL
251	time_zone	TEXT
252	twitter_id	TEXT
253	unique_creation_key	TEXT
254	updated_by_user_id	REAL
255	user_ids_of_all_notification_followers	TEXT
256	user_ids_of_all_notification_unfollowers	TEXT
257	user_ids_of_all_owners	TEXT
258	cumulative_time_in_customer_lifecycle_stage_pipeline	REAL
259	cumulative_time_in_evangelist_lifecycle_stage_pipeline	REAL
260	cumulative_time_in_lead_lifecycle_stage_pipeline	REAL
261	cumulative_time_in_marketing_qualified_lead_lifecycle_stage_pipeline	REAL
262	cumulative_time_in_opportunity_lifecycle_stage_pipeline	REAL
263	cumulative_time_in_other_lifecycle_stage_pipeline	REAL
264	cumulative_time_in_sales_qualified_lead_lifecycle_stage_pipeline	REAL
265	cumulative_time_in_subscriber_lifecycle_stage_pipeline	REAL
266	latest_time_in_customer_lifecycle_stage_pipeline	REAL
267	latest_time_in_evangelist_lifecycle_stage_pipeline	REAL
268	latest_time_in_lead_lifecycle_stage_pipeline	REAL
269	latest_time_in_marketing_qualified_lead_lifecycle_stage_pipeline	REAL
270	latest_time_in_opportunity_lifecycle_stage_pipeline	REAL
271	latest_time_in_other_lifecycle_stage_pipeline	REAL
272	latest_time_in_sales_qualified_lead_lifecycle_stage_pipeline	REAL
273	latest_time_in_subscriber_lifecycle_stage_pipeline	REAL
274	performed_in_an_import	INTEGER
275	whatsapp_phone_number	TEXT
276	owner_assigned_date	TEXT
277	contact_owner	TEXT
278	hubspot_team	TEXT
279	hubspot_score	REAL
280	industry	TEXT
281	ip_city	TEXT
282	ip_country	TEXT
283	ip_country_code	TEXT
284	ip_latitude__longitude	TEXT
285	ip_stateregion	TEXT
286	ip_state_coderegion_code	TEXT
287	ip_zipcode	TEXT
288	job_function	TEXT
289	job_title	TEXT
290	klout_score	REAL
291	last_modified_date	TEXT
292	last_name	TEXT
293	lifecycle_stage	TEXT
294	linkedin_bio	TEXT
295	linkedin_connections	REAL
296	marital_status	TEXT
297	message	TEXT
298	military_status	TEXT
299	mobile_phone_number	TEXT
300	last_contacted	TEXT
301	last_activity_date	TEXT
302	next_activity_date	TEXT
303	number_of_associated_deals	REAL
304	number_of_times_contacted	REAL
305	number_of_form_submissions	REAL
306	number_of_sales_activities	REAL
307	number_of_unique_forms_submitted	REAL
308	number_of_employees	TEXT
309	hubspot_owner_email_legacy	TEXT
310	hubspot_owner_name_legacy	TEXT
311	phone_number	TEXT
312	photo	TEXT
313	recent_conversion_date	TEXT
314	recent_conversion	TEXT
315	recent_deal_amount	REAL
316	recent_deal_close_date	TEXT
317	relationship_status	TEXT
318	salutation	TEXT
319	school	TEXT
320	seniority	TEXT
321	start_date	TEXT
322	stateregion	TEXT
323	surveymonkey_event_last_updated	REAL
324	total_revenue	REAL
325	twitter_bio	TEXT
326	twitter_username	TEXT
327	twitter_profile_photo	TEXT
328	webinar_event_last_updated	REAL
329	website_url	TEXT
330	work_email	TEXT
331	postal_code	TEXT
332	record_created_at	TEXT
333	record_updated_at	TEXT

hubspot_deals

Column index	Column name	type
0	amount	REAL
1	amount_in_company_currency	REAL
2	closed_lost_reason	TEXT
3	closed_won_reason	TEXT
4	close_date	TEXT
5	create_date	TEXT
6	days_to_close	REAL
7	currency	TEXT
8	deal_name	TEXT
9	deal_stage	TEXT
10	deal_type	TEXT
11	deal_description	TEXT
12	date_of_last_meeting_booked_in_meetings_tool	TEXT
13	campaign_of_last_booking_in_meetings_tool	TEXT
14	medium_of_last_booking_in_meetings_tool	TEXT
15	source_of_last_booking_in_meetings_tool	TEXT
16	annual_contract_value	REAL
17	all_teams	TEXT
18	business_units	TEXT
19	deal_collaborator	TEXT
20	deal_split_users	TEXT
21	all_owner_ids	TEXT
22	all_team_ids	TEXT
23	latest_source	TEXT
24	latest_source_company	TEXT
25	latest_source_contact	TEXT
26	latest_source_data_1	TEXT
27	latest_source_data_1_company	TEXT
28	latest_source_data_1_contact	TEXT
29	latest_source_data_2	TEXT
30	latest_source_data_2_company	TEXT
31	latest_source_data_2_contact	TEXT
32	latest_source_timestamp	TEXT
33	latest_source_timestamp_company	TEXT
34	latest_source_timestamp_contact	TEXT
35	original_source	TEXT
36	original_source_drill_down_1	TEXT
37	original_source_drill_down_2	TEXT
38	annual_recurring_revenue	REAL
39	associated_shared_deal_type	TEXT
40	associated_shared_deal_product_interests	TEXT
41	hubspot_campaign	TEXT
42	closed_deal_amount	REAL
43	closed_deal_amount_in_home_currency	REAL
44	closed_deal_close_date	REAL
45	closed_deal_create_date	REAL
46	is_closed_won_numeric	REAL
47	closed_won_date_internal	TEXT
48	created_by_user_id	REAL
49	hubspot_create_date	TEXT
50	date_entered_appointment_scheduled_sales_pipeline	TEXT
51	date_entered_closed_lost_sales_pipeline	TEXT
52	date_entered_closed_won_sales_pipeline	TEXT
53	date_entered_contract_sent_sales_pipeline	TEXT
54	date_entered_decision_maker_bought_in_sales_pipeline	TEXT
55	date_entered_presentation_scheduled_sales_pipeline	TEXT
56	date_entered_qualified_to_buy_sales_pipeline	TEXT
57	date_exited_appointment_scheduled_sales_pipeline	TEXT
58	date_exited_closed_lost_sales_pipeline	TEXT
59	date_exited_closed_won_sales_pipeline	TEXT
60	date_exited_contract_sent_sales_pipeline	TEXT
61	date_exited_decision_maker_bought_in_sales_pipeline	TEXT
62	date_exited_presentation_scheduled_sales_pipeline	TEXT
63	date_exited_qualified_to_buy_sales_pipeline	TEXT
64	days_to_close_without_rounding	REAL
65	deal_amount_calculation_preference	TEXT
66	hubspot_shared_deal_mrr	REAL
67	hubspot_shared_deal_mrr_currency_code	TEXT
68	deal_score	REAL
69	deal_probability	REAL
70	deal_stage_probability_shadow	REAL
71	exchange_rate	REAL
72	forecast_amount	REAL
73	forecast_probability	REAL
74	has_empty_conditional_stage_properties	INTEGER
75	is_active_shared_deal	INTEGER
76	is_deal_closed	INTEGER
77	is_closed_numeric	REAL
78	is_closed_lost	INTEGER
79	is_closed_won	INTEGER
80	deal_split_added	INTEGER
81	is_in_first_deal_stage	INTEGER
82	is_open_numeric	REAL
83	last_modified_date	TEXT
84	latest_approval_status	TEXT
85	latest_approval_status_approval_id	REAL
86	latest_meeting_activity	TEXT
87	likelihood_to_close_by_the_close_date	REAL
88	global_term_line_item_discount_percentage	TEXT
89	global_term_line_item_discount_percentage_enabled	INTEGER
90	global_term_line_item_recurring_billing_period	TEXT
91	global_term_line_item_recurring_billing_period_enabled	INTEGER
92	global_term_line_item_recurring_billing_start_date	TEXT
93	global_term_line_item_recurring_billing_start_date_enabled	INTEGER
94	global_term_line_item_recurring_billing_frequency	TEXT
95	global_term_line_item_recurring_billing_frequency_enabled	INTEGER
96	forecast_category	TEXT
97	merged_deal_ids	TEXT
98	monthly_recurring_revenue	REAL
99	next_step	TEXT
100	next_step_updated_at	TEXT
101	next_activity_type	TEXT
102	number_of_active_deal_registrations	REAL
103	number_of_deal_registrations	REAL
104	number_of_deal_splits	REAL
105	number_of_associated_line_items	REAL
106	number_of_target_accounts	REAL
107	record_id	REAL
108	record_creation_source	TEXT
109	record_source_detail_1	TEXT
110	record_source_detail_2	TEXT
111	record_source_detail_3	TEXT
112	record_creation_source_id	TEXT
113	record_source	TEXT
114	record_creation_source_user_id	REAL
115	open_deal_create_date	REAL
116	pinned_engagement_id	REAL
117	the_predicted_deal_amount	REAL
118	the_predicted_deal_amount_in_your_companys_currency	REAL
119	priority	TEXT
120	weighted_amount	REAL
121	weighted_amount_in_company_currency	REAL
122	read_only_object	INTEGER
123	recent_sales_email_replied_date	TEXT
124	shared_teams	TEXT
125	shared_users	TEXT
126	source_object_id	REAL
127	hubspot_sales_lead	TEXT
128	deal_tags	TEXT
129	total_contract_value	REAL
130	time_in_appointment_scheduled_sales_pipeline	REAL
131	time_in_closed_lost_sales_pipeline	REAL
132	time_in_closed_won_sales_pipeline	REAL
133	time_in_contract_sent_sales_pipeline	REAL
134	time_in_decision_maker_bought_in_sales_pipeline	REAL
135	time_in_presentation_scheduled_sales_pipeline	REAL
136	time_in_qualified_to_buy_sales_pipeline	REAL
137	unique_creation_key	TEXT
138	updated_by_user_id	REAL
139	user_ids_of_all_notification_followers	TEXT
140	user_ids_of_all_notification_unfollowers	TEXT
141	user_ids_of_all_owners	TEXT
142	cumulative_time_in_appointment_scheduled_sales_pipeline	REAL
143	cumulative_time_in_closed_lost_sales_pipeline	REAL
144	cumulative_time_in_closed_won_sales_pipeline	REAL
145	cumulative_time_in_contract_sent_sales_pipeline	REAL
146	cumulative_time_in_decision_maker_bought_in_sales_pipeline	REAL
147	cumulative_time_in_presentation_scheduled_sales_pipeline	REAL
148	cumulative_time_in_qualified_to_buy_sales_pipeline	REAL
149	latest_time_in_appointment_scheduled_sales_pipeline	REAL
150	latest_time_in_closed_lost_sales_pipeline	REAL
151	latest_time_in_closed_won_sales_pipeline	REAL
152	latest_time_in_contract_sent_sales_pipeline	REAL
153	latest_time_in_decision_maker_bought_in_sales_pipeline	REAL
154	latest_time_in_presentation_scheduled_sales_pipeline	REAL
155	latest_time_in_qualified_to_buy_sales_pipeline	REAL
156	performed_in_an_import	INTEGER
157	owner_assigned_date	TEXT
158	deal_owner	TEXT
159	hubspot_team	TEXT
160	last_contacted	TEXT
161	last_activity_date	TEXT
162	next_activity_date	TEXT
163	number_of_associated_contacts	REAL
164	number_of_times_contacted	REAL
165	number_of_sales_activities	REAL
166	pipeline	TEXT
167	record_created_at	TEXT
168	record_updated_at	TEXT

hubspot_feedback_submissions

Column index	Column name	type
0	agent_email	TEXT
1	agent_responsible_for_the_conversation	REAL
2	agent_name	TEXT
3	all_teams	TEXT
4	business_units	TEXT
5	all_owner_ids	TEXT
6	all_team_ids	TEXT
7	chatflow_id	REAL
8	chatflow_name	TEXT
9	chatflow_object_id	REAL
10	email	TEXT
11	contact_first_name	TEXT
12	contact_id	REAL
13	contact_last_name	TEXT
14	response	TEXT
15	conversation_thread_id	REAL
16	created_by_user_id	REAL
17	object_create_datetime	TEXT
18	engagement_id	REAL
19	form_guid	TEXT
20	industry_standard_question_type	TEXT
21	ingestion_id	TEXT
22	knowledge_article_id	REAL
23	object_last_modified_datetime	TEXT
24	merged_record_ids	TEXT
25	negative_follow_up	TEXT
26	neutral_follow_up	TEXT
27	record_id	REAL
28	record_creation_source	TEXT
29	record_source_detail_1	TEXT
30	record_source_detail_2	TEXT
31	record_source_detail_3	TEXT
32	record_creation_source_id	TEXT
33	record_source	TEXT
34	record_creation_source_user_id	REAL
35	positive_follow_up	TEXT
36	read_only_object	INTEGER
37	feedback_sentiment	TEXT
38	sentiment	TEXT
39	shared_teams	TEXT
40	shared_users	TEXT
41	submission_name	TEXT
42	date	TEXT
43	submission_url	TEXT
44	source	TEXT
45	survey_crm_id	TEXT
46	survey_id	REAL
47	survey_name	TEXT
48	survey_type	TEXT
49	tags	TEXT
50	tag_names	TEXT
51	ticket_id	REAL
52	ticket_owner_avatar_uri	TEXT
53	ticket_owner	REAL
54	ticket_name	TEXT
55	unique_creation_key	TEXT
56	updated_by_user_id	REAL
57	user_ids_of_all_notification_followers	TEXT
58	user_ids_of_all_notification_unfollowers	TEXT
59	user_ids_of_all_owners	TEXT
60	rating	REAL
61	visitor_id	REAL
62	performed_in_an_import	INTEGER
63	owner_assigned_date	TEXT
64	owner	TEXT
65	owners_main_team	TEXT
66	record_created_at	TEXT
67	record_updated_at	TEXT

hubspot_goal_targets

Column index	Column name	type
0	migration_soft_delete_deprecated	TEXT
1	ad_account_asset_ids	TEXT
2	ad_campaign_asset_ids	TEXT
3	all_teams	TEXT
4	business_units	TEXT
5	all_owner_ids	TEXT
6	all_team_ids	TEXT
7	assignee_team_id	REAL
8	assignee_type	TEXT
9	assignee_user_id	REAL
10	campaign_asset_ids	TEXT
11	contact_lifecycle_stage	TEXT
12	created_by_user_id	REAL
13	object_create_datetime	TEXT
14	currency	TEXT
15	currency_exchange_rate	REAL
16	deal_pipelines	TEXT
17	edit_updates_notification_frequency	TEXT
18	end_date	TEXT
19	end_datetime	TEXT
20	extra_team_member_user_ids	TEXT
21	fiscal_year_offset	REAL
22	forecast_type_id	REAL
23	goal_definition_key	TEXT
24	goal_definition_key_with_team	TEXT
25	goal_definition_key_with_user	TEXT
26	goal_name	TEXT
27	goal_target_currency_code	TEXT
28	goal_target_group_id	REAL
29	goal_type	TEXT
30	group_correlation_uuid	TEXT
31	is_forecastable	TEXT
32	is_legacy	TEXT
33	kpi_attribution_model	TEXT
34	kpi_display_unit	TEXT
35	kpi_filter_groups	TEXT
36	kpi_filter_groups_for_key_grouping	TEXT
37	kpi_filter_groups_for_key_team_grouping	TEXT
38	kpi_is_team_rollup	INTEGER
39	kpi_metric_type	TEXT
40	kpi_object_type	TEXT
41	kpi_object_type_id	TEXT
42	kpi_progress_percent	REAL
43	kpi_property_name	TEXT
44	kpi_single_object_custom_goal_type_name	TEXT
45	kpi_time_period_property	TEXT
46	kpi_tracking_method	TEXT
47	kpi_unit_type	TEXT
48	kpi_value	REAL
49	kpi_value_calculated_at	REAL
50	kpi_value_last_calculated_at	TEXT
51	object_last_modified_datetime	TEXT
52	legacy_active	TEXT
53	legacy_created_at	REAL
54	legacy_created_by	REAL
55	legacy_quarterly_target_composite_id	TEXT
56	legacy_sql_id	REAL
57	legacy_unique_sql_id	REAL
58	legacy_updated_at	REAL
59	legacy_updated_by	REAL
60	marketing_campaign_object_ids	REAL
61	merged_record_ids	TEXT
62	migration_soft_delete	TEXT
63	milestone	TEXT
64	record_id	REAL
65	record_creation_source	TEXT
66	record_source_detail_1	TEXT
67	record_source_detail_2	TEXT
68	record_source_detail_3	TEXT
69	record_creation_source_id	TEXT
70	record_source	TEXT
71	record_creation_source_user_id	REAL
72	outcome	TEXT
73	owner_ids_of_all_owners	TEXT
74	pipeline_ids	TEXT
75	pipelines	TEXT
76	progress_updates_notification_frequency	TEXT
77	read_only_object	INTEGER
78	shared_teams	TEXT
79	shared_users	TEXT
80	notify_on_goal_achieved	TEXT
81	notify_with_goal_edit_updates	TEXT
82	notify_on_goal_exceeded	TEXT
83	notify_on_goal_kickoff	TEXT
84	notify_on_goal_missed	TEXT
85	notify_with_progress_updates	TEXT
86	should_recalculate	TEXT
87	start_date	TEXT
88	start_datetime	TEXT
89	static_kpi_filter_groups	TEXT
90	status	TEXT
91	status_display_order	REAL
92	target_amount	REAL
93	target_amount_in_company_currency	REAL
94	team_id	REAL
95	template_id	REAL
96	ticket_pipelines	TEXT
97	unique_creation_key	TEXT
98	updated_by_user_id	REAL
99	user_id	REAL
100	user_ids_of_all_notification_followers	TEXT
101	user_ids_of_all_notification_unfollowers	TEXT
102	user_ids_of_all_owners	TEXT
103	performed_in_an_import	INTEGER
104	owner_assigned_date	TEXT
105	owner	TEXT
106	hubspot_team	TEXT
107	record_created_at	TEXT
108	record_updated_at	TEXT

hubspot_leads

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	associated_company_domain	TEXT
5	associated_company_name	TEXT
6	associated_contact_email	TEXT
7	associated_contact_first_name	TEXT
8	associated_contact_last_name	TEXT
9	attempted_calls_count	REAL
10	calls_connected_count	REAL
11	primary_company_analytics_source	TEXT
12	primary_company_analytics_source_first_drilldown	TEXT
13	primary_company_analytics_source_second_drilldown	TEXT
14	company_avatar_filemanager_key	TEXT
15	is_target_account	TEXT
16	company_last_activity_date	TEXT
17	company_last_engagement_date	TEXT
18	company_last_engagement_type	TEXT
19	company_time_of_last_session	TEXT
20	company_next_activity_date	TEXT
21	company_next_activity_type	TEXT
22	company_number_of_pageviews	REAL
23	associated_company_timezone	TEXT
24	primary_contact_analytics_source	TEXT
25	primary_contact_analytics_source_first_drilldown	TEXT
26	primary_contact_analytics_source_second_drilldown	TEXT
27	contact_avatar_filemanager_key	TEXT
28	contact_buying_role	TEXT
29	associated_contact_job_title	TEXT
30	contact_last_activity_date	TEXT
31	contact_last_engagement_date	TEXT
32	contact_last_engagement_type	TEXT
33	contact_time_of_last_session	TEXT
34	contact_next_activity_date	TEXT
35	contact_next_activity_type	TEXT
36	contact_number_of_pageviews	REAL
37	associated_contact_timezone	TEXT
38	created_by_user_id	REAL
39	object_create_datetime	TEXT
40	emails_connected_count	REAL
41	connected_emails_count_v2	REAL
42	initial_assign_notification_state	TEXT
43	last_activity_date	TEXT
44	last_engagement_date	TEXT
45	last_engagement_type	TEXT
46	lead_time_of_last_session	TEXT
47	object_last_modified_datetime	TEXT
48	associated_deal_pipeline_stage	TEXT
49	associated_deals	REAL
50	call_count	REAL
51	closed_won_deal_amount	REAL
52	message_thread_count	REAL
53	currency	TEXT
54	lead_disqualification_note	TEXT
55	disqualification_reason	TEXT
56	email_count	REAL
57	first_outreach_date	TEXT
58	lead_flow_id	REAL
59	import_unique_key	TEXT
60	lead_inferred_pseudostage	TEXT
61	is_disqualified	REAL
62	in_progress_leads	REAL
63	is_new	REAL
64	open_leads	REAL
65	is_qualified	REAL
66	lead_label	TEXT
67	meeting_count	REAL
68	lead_name	TEXT
69	lead_name_calculated	TEXT
70	outreach_activity_count	REAL
71	open_deal_amount	REAL
72	primary_company_owner	TEXT
73	primary_contact_owner	TEXT
74	lead_source	TEXT
75	initial_company_lifecycle_stage	TEXT
76	initial_contact_lifecycle_stage	TEXT
77	lead_source_drill_down_1	TEXT
78	lead_source_drill_down_2	TEXT
79	initial_source_lifecycle_stage	TEXT
80	time_to_first_touch	REAL
81	lead_title_deprecated_use_hs_lead_name_	TEXT
82	lead_type	TEXT
83	meetings_connected_count	REAL
84	merged_record_ids	TEXT
85	next_activity_date	TEXT
86	next_activity_type	TEXT
87	lead_number_of_pageviews	REAL
88	record_id	REAL
89	record_creation_source	TEXT
90	record_source_detail_1	TEXT
91	record_source_detail_2	TEXT
92	record_source_detail_3	TEXT
93	record_creation_source_id	TEXT
94	record_source	TEXT
95	record_creation_source_user_id	REAL
96	lead_owner_calculated	TEXT
97	lead_pipeline	TEXT
98	lead_pipeline_stage	TEXT
99	pipeline_stage_category_id	TEXT
100	pipeline_stage_category_last_updated_at	TEXT
101	pipeline_stage_category	TEXT
102	primary_associated_object_name	TEXT
103	primary_associated_company_object_id	REAL
104	primary_contact_enrolled_in_sequence	INTEGER
105	primary_associated_contact_object_id	REAL
106	read_only_object	INTEGER
107	shared_teams	TEXT
108	shared_users	TEXT
109	lead_tags	TEXT
110	unique_creation_key	TEXT
111	updated_by_user_id	REAL
112	user_ids_of_all_notification_followers	TEXT
113	user_ids_of_all_notification_unfollowers	TEXT
114	user_ids_of_all_owners	TEXT
115	cumulative_time_in_attempting_lead_pipeline	REAL
116	cumulative_time_in_connected_lead_pipeline	REAL
117	cumulative_time_in_new_lead_pipeline	REAL
118	cumulative_time_in_qualified_lead_pipeline	REAL
119	cumulative_time_in_disqualified_lead_pipeline	REAL
120	date_entered_attempting_lead_pipeline	TEXT
121	date_entered_connected_lead_pipeline	TEXT
122	date_entered_new_lead_pipeline	TEXT
123	date_entered_qualified_lead_pipeline	TEXT
124	date_entered_disqualified_lead_pipeline	TEXT
125	date_exited_attempting_lead_pipeline	TEXT
126	date_exited_connected_lead_pipeline	TEXT
127	date_exited_new_lead_pipeline	TEXT
128	date_exited_qualified_lead_pipeline	TEXT
129	date_exited_disqualified_lead_pipeline	TEXT
130	latest_time_in_attempting_lead_pipeline	REAL
131	latest_time_in_connected_lead_pipeline	REAL
132	latest_time_in_new_lead_pipeline	REAL
133	latest_time_in_qualified_lead_pipeline	REAL
134	latest_time_in_disqualified_lead_pipeline	REAL
135	performed_in_an_import	INTEGER
136	workflow_updated_lifecycle_stage_of_company	INTEGER
137	workflow_updated_lifecycle_stage_of_contact	INTEGER
138	owner_assigned_date	TEXT
139	lead_owner	TEXT
140	hubspot_team	TEXT
141	record_created_at	TEXT
142	record_updated_at	TEXT

hubspot_tickets

Column index	Column name	type
0	close_date	TEXT
1	ticket_description	TEXT
2	created_by	REAL
3	create_date	TEXT
4	first_agent_email_response_date	TEXT
5	all_teams	TEXT
6	business_units	TEXT
7	all_associated_contact_companies	TEXT
8	all_associated_contact_emails	TEXT
9	all_associated_contact_first_names	TEXT
10	all_associated_contact_last_names	TEXT
11	all_associated_contact_mobile_phones	TEXT
12	all_associated_contact_phones	TEXT
13	all_conversation_mentions	TEXT
14	all_owner_ids	TEXT
15	all_team_ids	TEXT
16	applied_sla_rule_config_date	TEXT
17	applied_sla_rule_config_id	REAL
18	assigned_teams	TEXT
19	assignment_method	TEXT
20	auto_generated_from_thread_id	REAL
21	originating_conversations_message_id	TEXT
22	conversations_originating_thread_id	REAL
23	created_by_user_id	REAL
24	hubspot_create_date	TEXT
25	custom_inbox_id	REAL
26	date_entered_new_support_pipeline	TEXT
27	date_entered_waiting_on_contact_support_pipeline	TEXT
28	date_entered_waiting_on_us_support_pipeline	TEXT
29	date_entered_closed_support_pipeline	TEXT
30	date_exited_new_support_pipeline	TEXT
31	date_exited_waiting_on_contact_support_pipeline	TEXT
32	date_exited_waiting_on_us_support_pipeline	TEXT
33	date_exited_closed_support_pipeline	TEXT
34	email_subject	TEXT
35	external_object_ids	TEXT
36	last_ces_survey_comment	TEXT
37	last_ces_survey_rating	TEXT
38	last_ces_survey_date	TEXT
39	file_upload	TEXT
40	first_agent_response_date	TEXT
41	help_desk_onboarding_ticket	TEXT
42	helpdesk_sort_timestamp	TEXT
43	in_help_desk	INTEGER
44	inbox_id	REAL
45	is_latest_message_failed	INTEGER
46	is_latest_message_hidden_from_all	INTEGER
47	is_visible_in_help_desk	INTEGER
48	last_closed_date	TEXT
49	last_email_activity	TEXT
50	last_email_date	TEXT
51	last_message_from_visitor	INTEGER
52	last_message_received_date	TEXT
53	last_response_date	TEXT
54	last_activity_date	TEXT
55	last_contacted_date	TEXT
56	last_modified_date	TEXT
57	latest_message_attachment_types	TEXT
58	latest_message_is_forwarded_email	INTEGER
59	latest_message_is_thread_comment	INTEGER
60	latest_message_seen_by_agent_ids	TEXT
61	latest_message_visible_to_visitor	TEXT
62	latest_message_visible_to_visitor_sent_at	TEXT
63	merged_ticket_ids	TEXT
64	most_relevant_sla_status	TEXT
65	most_relevant_sla_type	TEXT
66	microsoft_teams_message_id_for_this_ticket	TEXT
67	next_activity_date	TEXT
68	next_activity_type	TEXT
69	number_of_associated_companies	REAL
70	number_of_associated_conversations	REAL
71	number_of_times_contacted	REAL
72	record_id	REAL
73	record_creation_source	TEXT
74	record_source_detail_1	TEXT
75	record_source_detail_2	TEXT
76	record_source_detail_3	TEXT
77	record_creation_source_id	TEXT
78	record_source	TEXT
79	record_creation_source_user_id	REAL
80	originating_channel_account	TEXT
81	originating_email_engagement_id	REAL
82	originating_channel_type	TEXT
83	pinned_engagement_id	REAL
84	pipeline	TEXT
85	ticket_status	TEXT
86	primary_company	TEXT
87	primary_company_id	REAL
88	primary_company_name	TEXT
89	read_only_object	INTEGER
90	resolution	TEXT
91	recent_sales_email_replied_date	TEXT
92	users_interaction	TEXT
93	shared_teams	TEXT
94	shared_users	TEXT
95	sla_operating_hours	TEXT
96	source_object_id	REAL
97	ticket_tags	TEXT
98	thread_ids_to_restore	TEXT
99	category	TEXT
100	ticket_id	REAL
101	language	TEXT
102	priority	TEXT
103	time_in_new_support_pipeline	REAL
104	time_in_waiting_on_contact_support_pipeline	REAL
105	time_in_waiting_on_us_support_pipeline	REAL
106	time_in_closed_support_pipeline	REAL
107	time_to_close_within_sla_goals	REAL
108	time_to_close_sla_due_date	TEXT
109	time_to_close_sla_ticket_status	TEXT
110	time_to_first_response_within_sla_goals	REAL
111	time_to_first_response_sla_due_date	TEXT
112	time_to_first_response_sla_status	TEXT
113	time_to_next_response_sla_due_date	TEXT
114	time_to_next_response_sla_status	TEXT
115	unique_creation_key	TEXT
116	updated_by_user_id	REAL
117	user_ids_of_all_notification_followers	TEXT
118	user_ids_of_all_notification_unfollowers	TEXT
119	user_ids_of_all_owners	TEXT
120	performed_in_an_import	INTEGER
121	owner_assigned_date	TEXT
122	ticket_owner	TEXT
123	hubspot_team	TEXT
124	date_of_last_engagement	TEXT
125	last_customer_reply_date	TEXT
126	last_contacted_ticket_note	TEXT
127	last_activity_date_ticket_note	TEXT
128	next_activity_date_ticket_note	TEXT
129	nps_follow_up	TEXT
130	nps_follow_up_question	REAL
131	conversation_nps_score	TEXT
132	number_of_times_contacted_ticket_note	REAL
133	number_of_sales_activities	REAL
134	reference_to_source_specific_object	TEXT
135	reference_to_email_thread	TEXT
136	source	TEXT
137	ticket_name	TEXT
138	tags	TEXT
139	time_to_close	REAL
140	time_to_first_agent_email_reply	REAL
141	record_created_at	TEXT
142	record_updated_at	TEXT

hubspot_carts

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	billing_city	TEXT
5	billing_country	TEXT
6	billing_phone_number	TEXT
7	billing_zippostal_code	TEXT
8	billing_state	TEXT
9	billing_street	TEXT
10	buyer_accepts_marketing	INTEGER
11	cart_discount	REAL
12	name	TEXT
13	cart_url	TEXT
14	created_by_user_id	REAL
15	object_create_datetime	TEXT
16	currency_code	TEXT
17	discount_codes	TEXT
18	exchange_rate	REAL
19	cart_id	TEXT
20	created_date	TEXT
21	modified_date	TEXT
22	status	TEXT
23	token	TEXT
24	amount_in_company_currency	REAL
25	landing_site	TEXT
26	object_last_modified_datetime	TEXT
27	merged_record_ids	TEXT
28	record_id	REAL
29	record_creation_source	TEXT
30	record_source_detail_1	TEXT
31	record_source_detail_2	TEXT
32	record_source_detail_3	TEXT
33	record_creation_source_id	TEXT
34	record_source	TEXT
35	record_creation_source_user_id	REAL
36	pinned_engagement_id	REAL
37	read_only_object	INTEGER
38	referring_site	TEXT
39	shared_teams	TEXT
40	shared_users	TEXT
41	shipping_city	TEXT
42	shipping_country	TEXT
43	shipping_phone_number	TEXT
44	shipping_zippostal_code	TEXT
45	shipping_state	TEXT
46	shipping_street	TEXT
47	shipping_cost	REAL
48	source_id	REAL
49	source_store	TEXT
50	subtotal_price	REAL
51	tags	TEXT
52	tax_price	REAL
53	total_price	REAL
54	total_weight	TEXT
55	unique_creation_key	TEXT
56	updated_by_user_id	REAL
57	user_ids_of_all_notification_followers	TEXT
58	user_ids_of_all_notification_unfollowers	TEXT
59	user_ids_of_all_owners	TEXT
60	performed_in_an_import	INTEGER
61	owner_assigned_date	TEXT
62	owner	TEXT
63	owners_main_team	TEXT
64	record_created_at	TEXT
65	record_updated_at	TEXT

hubspot_discounts

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	created_by_user_id	REAL
5	object_create_datetime	TEXT
6	frequency	TEXT
7	name	TEXT
8	object_last_modified_datetime	TEXT
9	merged_record_ids	TEXT
10	record_id	REAL
11	record_creation_source	TEXT
12	record_source_detail_1	TEXT
13	record_source_detail_2	TEXT
14	record_source_detail_3	TEXT
15	record_creation_source_id	TEXT
16	record_source	TEXT
17	record_creation_source_user_id	REAL
18	read_only_object	INTEGER
19	shared_teams	TEXT
20	shared_users	TEXT
21	display_order	REAL
22	type	TEXT
23	unique_creation_key	TEXT
24	updated_by_user_id	REAL
25	user_ids_of_all_notification_followers	TEXT
26	user_ids_of_all_notification_unfollowers	TEXT
27	user_ids_of_all_owners	TEXT
28	value	REAL
29	performed_in_an_import	INTEGER
30	owner_assigned_date	TEXT
31	owner	TEXT
32	owners_main_team	TEXT
33	record_created_at	TEXT
34	record_updated_at	TEXT

hubspot_fees

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	created_by_user_id	REAL
5	object_create_datetime	TEXT
6	name	TEXT
7	object_last_modified_datetime	TEXT
8	merged_record_ids	TEXT
9	record_id	REAL
10	record_creation_source	TEXT
11	record_source_detail_1	TEXT
12	record_source_detail_2	TEXT
13	record_source_detail_3	TEXT
14	record_creation_source_id	TEXT
15	record_source	TEXT
16	record_creation_source_user_id	REAL
17	read_only_object	INTEGER
18	shared_teams	TEXT
19	shared_users	TEXT
20	display_order	REAL
21	type	TEXT
22	unique_creation_key	TEXT
23	updated_by_user_id	REAL
24	user_ids_of_all_notification_followers	TEXT
25	user_ids_of_all_notification_unfollowers	TEXT
26	user_ids_of_all_owners	TEXT
27	value	REAL
28	performed_in_an_import	INTEGER
29	owner_assigned_date	TEXT
30	owner	TEXT
31	owners_main_team	TEXT
32	record_created_at	TEXT
33	record_updated_at	TEXT

hubspot_invoices

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	allow_partial_payments	INTEGER
5	allowed_payment_methods	TEXT
6	amount_billed	REAL
7	amount_billed_in_company_currency	REAL
8	amount_billed_pre_tax	REAL
9	amount_paid	REAL
10	amount_paid_in_company_currency	REAL
11	amount_processing	REAL
12	balance_due	REAL
13	balance_due_in_company_currency	REAL
14	billing_frequency_type	TEXT
15	address_types_to_collect	TEXT
16	comments	TEXT
17	created_by_user_id	REAL
18	create_date	TEXT
19	currency	TEXT
20	custom_invoice_fields	TEXT
21	days_paid_late	TEXT
22	discounts_total	REAL
23	domain	TEXT
24	due_date	TEXT
25	automated_taxes_on	INTEGER
26	exchange_rate	REAL
27	external_account_id	TEXT
28	invoice_external_create_datetime	TEXT
29	external__id	TEXT
30	external_recipient	TEXT
31	fees_total	REAL
32	age_category	TEXT
33	invoice_date	TEXT
34	latest_company_name	TEXT
35	latest_contact_email	TEXT
36	latest_contact_first_name	TEXT
37	latest_contact_last_name	TEXT
38	invoice_link	TEXT
39	invoice_payment_collection_method	TEXT
40	invoice_source	TEXT
41	invoice_status	TEXT
42	invoice_status_details	TEXT
43	invoice_tool_source	TEXT
44	invoice_tool_source_id	TEXT
45	language	TEXT
46	last_edit_date	TEXT
47	last_reminder_sent_date	TEXT
48	last_sent_date	TEXT
49	object_last_modified_datetime	TEXT
50	locale	TEXT
51	merged_record_ids	TEXT
52	number	TEXT
53	number_of_subscriptions	REAL
54	record_id	REAL
55	record_creation_source	TEXT
56	record_source_detail_1	TEXT
57	record_source_detail_2	TEXT
58	record_source_detail_3	TEXT
59	record_creation_source_id	TEXT
60	record_source	TEXT
61	record_creation_source_user_id	REAL
62	order_level_discounts_total	REAL
63	payment_date	TEXT
64	payment_status	TEXT
65	pdf_download_link	TEXT
66	po_number	TEXT
67	read_only_object	INTEGER
68	received_by_recipient_date_quickbooks_online	TEXT
69	recipient_company_street_address	TEXT
70	recipient_company_street_address_2	TEXT
71	recipient_company_city	TEXT
72	recipient_company_country	TEXT
73	recipient_company_country_code	TEXT
74	recipient_company_stateregion	TEXT
75	recipient_company_postal_code	TEXT
76	recipient_shipping_street_address	TEXT
77	recipient_shipping_street_address_2	TEXT
78	recipient_shipping_city	TEXT
79	recipient_shipping_country	TEXT
80	recipient_shipping_country_code	TEXT
81	recipient_shipping_name	TEXT
82	recipient_shipping_stateregion	TEXT
83	recipient_shipping_postal_code	TEXT
84	sender_company_address	TEXT
85	sender_company_address_line_2	TEXT
86	sender_company_city	TEXT
87	sender_company_country	TEXT
88	sender_company_domain	TEXT
89	sender_company_logo_url	TEXT
90	sender_company_name	TEXT
91	sender_company_state	TEXT
92	sender_company_zip	TEXT
93	shared_teams	TEXT
94	shared_users	TEXT
95	slug	TEXT
96	external_invoice_status	TEXT
97	store_payment_method_at_checkout	INTEGER
98	subtotal	REAL
99	tax_calculation_id	TEXT
100	tax_id	TEXT
101	taxes_total	REAL
102	test_mode	TEXT
103	time_zone	TEXT
104	title	TEXT
105	unique_creation_key	TEXT
106	unique_id	TEXT
107	upcoming_reminder_dates	TEXT
108	updated_by_user_id	REAL
109	user_ids_of_all_notification_followers	TEXT
110	user_ids_of_all_notification_unfollowers	TEXT
111	user_ids_of_all_owners	TEXT
112	performed_in_an_import	INTEGER
113	owner_assigned_date	TEXT
114	owner	TEXT
115	owners_main_team	TEXT
116	record_created_at	TEXT
117	record_updated_at	TEXT

hubspot_line_items

The relation between a deal and a product is stored in the hubspot_line_items table.

Column index	Column name	type
0	net_price	REAL
1	create_date	TEXT
2	description	TEXT
3	unit_discount	REAL
4	annual_contract_value	REAL
5	all_teams	TEXT
6	business_units	TEXT
7	all_owner_ids	TEXT
8	all_team_ids	TEXT
9	allow_buyer_selected_quantity	TEXT
10	annual_recurring_revenue	REAL
11	automatic_tax_amount	REAL
12	billing_period_end_date	TEXT
13	billing_period_start_date	TEXT
14	delayed_billing_start_by_days	REAL
15	delayed_billing_start_by_months	REAL
16	start_billing_terms	TEXT
17	buyer_selected_quantity_maximum	REAL
18	buyer_selected_quantity_minimum	REAL
19	unit_cost	REAL
20	created_by_user_id	REAL
21	object_create_datetime	TEXT
22	discount_percentage	REAL
23	external_lineitem_id	REAL
24	image_url	TEXT
25	is_editable_price	INTEGER
26	is_optional	INTEGER
27	last_modified_date	TEXT
28	currency	TEXT
29	margin	REAL
30	annual_contract_value_margin	REAL
31	annual_recurring_revenue_margin	REAL
32	monthly_recurring_revenue_margin	REAL
33	total_contract_value_margin	REAL
34	merged_record_ids	TEXT
35	monthly_recurring_revenue	REAL
36	record_id	REAL
37	record_creation_source	TEXT
38	record_source_detail_1	TEXT
39	record_source_detail_2	TEXT
40	record_source_detail_3	TEXT
41	record_creation_source_id	TEXT
42	record_source	TEXT
43	record_creation_source_user_id	REAL
44	position_on_quote	REAL
45	net_price_after_tax	REAL
46	pre_discount_amount	REAL
47	product_id	REAL
48	product_type	TEXT
49	read_only_object	INTEGER
50	billing_end_date	TEXT
51	number_of_payments	REAL
52	term	TEXT
53	billing_start_date	TEXT
54	billing_terms	TEXT
55	shared_teams	TEXT
56	shared_users	TEXT
57	sku	TEXT
58	sync_amount	REAL
59	tax_amount	REAL
60	tax_category	TEXT
61	tax_label	TEXT
62	resolved_tax_rate	REAL
63	tax_rate	TEXT
64	total_contract_value	REAL
65	term_in_months	REAL
66	calculated_total_discount	REAL
67	unique_creation_key	TEXT
68	updated_by_user_id	REAL
69	url	TEXT
70	user_ids_of_all_notification_followers	TEXT
71	user_ids_of_all_notification_unfollowers	TEXT
72	user_ids_of_all_owners	TEXT
73	variant_id_of_the_product	REAL
74	performed_in_an_import	INTEGER
75	owner_assigned_date	TEXT
76	owner	TEXT
77	owners_main_team	TEXT
78	name	TEXT
79	unit_price	REAL
80	quantity	REAL
81	billing_frequency	TEXT
82	tax	REAL
83	record_created_at	TEXT
84	record_updated_at	TEXT

hubspot_orders

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	billing_city	TEXT
5	billing_country	TEXT
6	billing_email	TEXT
7	billing_first_name	TEXT
8	billing_last_name	TEXT
9	billing_address_customer_name	TEXT
10	billing_phone_number	TEXT
11	billing_zippostal_code	TEXT
12	billing_state	TEXT
13	billing_street	TEXT
14	buyer_accepts_marketing	INTEGER
15	cancellation_reason	TEXT
16	closed_date	TEXT
17	created_by_user_id	REAL
18	object_create_datetime	TEXT
19	currency_code	TEXT
20	discount_codes	TEXT
21	exchange_rate	REAL
22	canceled_date	TEXT
23	cart_id	TEXT
24	checkout_id	TEXT
25	created_date	TEXT
26	modified_date	TEXT
27	order_id	TEXT
28	status	TEXT
29	order_url	TEXT
30	fulfillment_status	TEXT
31	amount_in_company_currency	REAL
32	landing_site	TEXT
33	object_last_modified_datetime	TEXT
34	merged_record_ids	TEXT
35	record_id	REAL
36	record_creation_source	TEXT
37	record_source_detail_1	TEXT
38	record_source_detail_2	TEXT
39	record_source_detail_3	TEXT
40	record_creation_source_id	TEXT
41	record_source	TEXT
42	record_creation_source_user_id	REAL
43	order_buisiness_type	TEXT
44	discount	REAL
45	name	TEXT
46	notes	TEXT
47	payment_processing_method	TEXT
48	payment_status	TEXT
49	pinned_engagement_id	REAL
50	pipeline	TEXT
51	stage	TEXT
52	processed_date	TEXT
53	read_only_object	INTEGER
54	referring_site	TEXT
55	refund_amount	REAL
56	shared_teams	TEXT
57	shared_users	TEXT
58	shipping_city	TEXT
59	shipping_country	TEXT
60	shipping_address_customer_name	TEXT
61	shipping_phone_number	TEXT
62	shipping_zippostal_code	TEXT
63	shipping_state	TEXT
64	shipping_street	TEXT
65	shipping_cost	REAL
66	shipping_status_url	TEXT
67	shipping_tracking_number	TEXT
68	source_id	REAL
69	source_store	TEXT
70	subtotal_price	REAL
71	tags	TEXT
72	tax_price	REAL
73	total_price	REAL
74	total_weight	TEXT
75	unique_creation_key	TEXT
76	updated_by_user_id	REAL
77	user_ids_of_all_notification_followers	TEXT
78	user_ids_of_all_notification_unfollowers	TEXT
79	user_ids_of_all_owners	TEXT
80	performed_in_an_import	INTEGER
81	owner_assigned_date	TEXT
82	owner	TEXT
83	owners_main_team	TEXT
84	record_created_at	TEXT
85	record_updated_at	TEXT

hubspot_commerce_payments

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	billing_address_city	TEXT
5	billing_address_country	TEXT
6	billing_address_line_1	TEXT
7	billing_address_line_2	TEXT
8	billing_address_state	TEXT
9	billing_address_zip	TEXT
10	billing_bill_to_name	TEXT
11	created_by_user_id	REAL
12	object_create_datetime	TEXT
13	currency_code	TEXT
14	customer	TEXT
15	digital_wallet_type	TEXT
16	processing_fees	REAL
17	processing_fees_amount_in_company_currency	REAL
18	processing_fees_amount_in_settlement_currency	REAL
19	billing_address	TEXT
20	shipping_address	TEXT
21	has_an_associated_invoice	INTEGER
22	gross_amount	REAL
23	gross_amount_in_company_currency	REAL
24	payment_date	TEXT
25	internal_comment	TEXT
26	refundable	INTEGER
27	object_last_modified_datetime	TEXT
28	status	TEXT
29	status_updated_on	TEXT
30	line_item_discount_amount	REAL
31	line_item_discount_amount_in_company_currency	REAL
32	max_refundable_amount	REAL
33	max_refundable_amount_in_company_currency	REAL
34	merged_record_ids	TEXT
35	net_amount	REAL
36	net_amount_after_refunds	REAL
37	net_amount_in_company_currency	REAL
38	net_amount_in_settlement_currency	REAL
39	number_of_associated_invoices	REAL
40	record_id	REAL
41	record_creation_source	TEXT
42	record_source_detail_1	TEXT
43	record_source_detail_2	TEXT
44	record_source_detail_3	TEXT
45	record_creation_source_id	TEXT
46	record_source	TEXT
47	record_creation_source_user_id	REAL
48	order_discount_amount	REAL
49	order_discount_amount_in_company_currency	REAL
50	order_discount_code	TEXT
51	order_discount_percentage	REAL
52	order_discount_template_id	REAL
53	payment_id	TEXT
54	external_payment_method	TEXT
55	bank_or_issuer	TEXT
56	last_four_digits	TEXT
57	payment_method	TEXT
58	source	TEXT
59	source_id	TEXT
60	payment_source_name	TEXT
61	source_url	TEXT
62	payment_type	TEXT
63	payout_date	TEXT
64	platform_fee	REAL
65	platform_fee_in_company_currency	REAL
66	platform_fee_in_settlement_currency	REAL
67	platform_invoice_id	REAL
68	platform_invoice_id_and_failed_at	TEXT
69	presentment_to_portal_currency_dated_exchange_rate	REAL
70	exchange_rate	REAL
71	processor	TEXT
72	read_only_object	INTEGER
73	reference_number	TEXT
74	refund_deadline_date	TEXT
75	refund_disabled_reason	TEXT
76	refunded	REAL
77	refunded_amount_in_company_currency	REAL
78	settlement_currency_code	TEXT
79	shared_teams	TEXT
80	shared_users	TEXT
81	shipping_address_city	TEXT
82	shipping_address_country	TEXT
83	shipping_address_line_1	TEXT
84	shipping_address_line_2	TEXT
85	shipping_address_state	TEXT
86	shipping_address_zip	TEXT
87	shipping_ship_to_name	TEXT
88	amount_paid	REAL
89	amount_paid_in_company_currency	REAL
90	total_fees	REAL
91	total_fees_in_company_currency	REAL
92	total_taxes	REAL
93	total_taxes_in_company_currency	REAL
94	total_discount_amount	REAL
95	total_discount_amount_in_company_currency	REAL
96	unique_creation_key	TEXT
97	updated_by_user_id	REAL
98	user_ids_of_all_notification_followers	TEXT
99	user_ids_of_all_notification_unfollowers	TEXT
100	user_ids_of_all_owners	TEXT
101	was_created_with_associated_deal	TEXT
102	performed_in_an_import	INTEGER
103	owner_assigned_date	TEXT
104	owner	TEXT
105	hubspot_team	TEXT
106	record_created_at	TEXT
107	record_updated_at	TEXT

hubspot_products

I could not find the schema for the hubspot_products.

hubspot_quotes

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	allowed_payment_methods	TEXT
5	quote_approver	TEXT
6	is_archived	INTEGER
7	associated_deal_owner_id	TEXT
8	collect_billing_address	INTEGER
9	collect_shipping_address	INTEGER
10	comments_to_buyer	TEXT
11	created_by_user_id	REAL
12	create_date	TEXT
13	currency	TEXT
14	is_dealless_quote	INTEGER
15	display_tcv_on_quote	INTEGER
16	quote_domain	TEXT
17	esign_date	TEXT
18	esign_enabled	INTEGER
19	esign_completed_signatures	REAL
20	esign_number_of_signers_required	REAL
21	expiration_date	TEXT
22	expiration_template_path	TEXT
23	quote_approval_feedback	TEXT
24	language	TEXT
25	last_modified_date	TEXT
26	legacy_stripe_migrated	INTEGER
27	global_term_line_item_discount_percentage	TEXT
28	global_term_line_item_discount_percentage_enabled	INTEGER
29	global_term_line_item_recurring_billing_period	TEXT
30	global_term_line_item_recurring_billing_period_enabled	INTEGER
31	global_term_line_item_recurring_billing_start_date	TEXT
32	global_term_line_item_recurring_billing_start_date_enabled	INTEGER
33	global_term_line_item_recurring_billing_frequency	TEXT
34	global_term_line_item_recurring_billing_frequency_enabled	INTEGER
35	locale	TEXT
36	locked	INTEGER
37	logo_url	TEXT
38	is_manually_signed	INTEGER
39	merged_record_ids	TEXT
40	associated_deals	REAL
41	record_id	REAL
42	record_creation_source	TEXT
43	record_source_detail_1	TEXT
44	record_source_detail_2	TEXT
45	record_source_detail_3	TEXT
46	record_creation_source_id	TEXT
47	record_source	TEXT
48	record_creation_source_user_id	REAL
49	payment_date	TEXT
50	payment_enabled	INTEGER
51	payment_status	TEXT
52	payment_type	TEXT
53	quote_pdf_download_link	TEXT
54	status_of_quote_pdf_generation	TEXT
55	branding_color	TEXT
56	proposal_domain	TEXT
57	proposal_slug	TEXT
58	proposal_template	TEXT
59	public_url_key	TEXT
60	quote_amount	REAL
61	link_to_hosted_quote	TEXT
62	quote_number	TEXT
63	quote_owner_id	TEXT
64	quote_total_preference	TEXT
65	read_only_object	INTEGER
66	status_of_quote_rendering	TEXT
67	recent_sales_email_replied_date	TEXT
68	sender_company_street_address	TEXT
69	sender_company_street_address_2	TEXT
70	sender_company_city	TEXT
71	sender_company_country	TEXT
72	sender_company_domain	TEXT
73	sender_company_image_url	TEXT
74	sender_company_name	TEXT
75	sender_company_stateregion	TEXT
76	sender_company_postal_code	TEXT
77	sender_email	TEXT
78	sender_first_name	TEXT
79	sender_image_url	TEXT
80	sender_job_title	TEXT
81	sender_last_name	TEXT
82	sender_phone_number	TEXT
83	shared_teams	TEXT
84	shared_users	TEXT
85	space_for_written_countersignature	INTEGER
86	space_for_written_signature	INTEGER
87	signing_status_of_quote	TEXT
88	quote_slug	TEXT
89	quote_approval_status	TEXT
90	store_payment_method_at_checkout	INTEGER
91	total_contract_value	REAL
92	legacy_quote_template	TEXT
93	template_type	TEXT
94	terms	TEXT
95	test_mode	INTEGER
96	time_zone	TEXT
97	quote_title	TEXT
98	unique_creation_key	TEXT
99	updated_by_user_id	REAL
100	user_ids_of_all_notification_followers	TEXT
101	user_ids_of_all_notification_unfollowers	TEXT
102	user_ids_of_all_owners	TEXT
103	performed_in_an_import	INTEGER
104	owner_assigned_date	TEXT
105	quote_owner	TEXT
106	hubspot_team	TEXT
107	last_contacted	TEXT
108	last_activity_date	TEXT
109	next_activity_date	TEXT
110	number_of_times_contacted	REAL
111	number_of_sales_activities	REAL
112	record_created_at	TEXT
113	record_updated_at	TEXT

hubspot_subscriptions

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	allowed_payment_methods	TEXT
5	annual_recurring_revenue	REAL
6	annual_recurring_revenue_in_company_currency	REAL
7	automatically_email_invoices	INTEGER
8	churn_date	TEXT
9	address_types_to_collect	TEXT
10	collection_process	TEXT
11	contact_email	TEXT
12	created_by_user_id	REAL
13	object_create_datetime	TEXT
14	currency_code	TEXT
15	subscription_id	REAL
16	invoice_comments	TEXT
17	invoice_creation	TEXT
18	status_is_active	REAL
19	language	TEXT
20	last_modification_reason	TEXT
21	subscription_modified_on	TEXT
22	last_modified_by	TEXT
23	last_payment_amount	REAL
24	last_payment_date	TEXT
25	status_of_last_payment	TEXT
26	object_last_modified_datetime	TEXT
27	locale	TEXT
28	merged_record_ids	TEXT
29	monthly_recurring_revenue	REAL
30	monthly_recurring_revenue_in_company_currency	REAL
31	name	TEXT
32	net_payment_terms	REAL
33	next_payment_amount	REAL
34	next_billing_date	TEXT
35	number_of_completed_payments	REAL
36	number_of_expected_payments	REAL
37	record_id	REAL
38	record_creation_source	TEXT
39	record_source_detail_1	TEXT
40	record_source_detail_2	TEXT
41	record_source_detail_3	TEXT
42	record_creation_source_id	TEXT
43	record_source	TEXT
44	record_creation_source_user_id	REAL
45	original_buyer_email_address	TEXT
46	payment_enabled	INTEGER
47	payment_method	TEXT
48	payment_source	TEXT
49	payment_source_id	TEXT
50	processor	TEXT
51	read_only_object	INTEGER
52	recipient_billing_address_source	TEXT
53	recipient_company_street_address	TEXT
54	recipient_company_street_address_2	TEXT
55	recipient_company_city	TEXT
56	recipient_company_country	TEXT
57	recipient_company_stateregion	TEXT
58	recipient_company_postal_code	TEXT
59	end_date	TEXT
60	recurring_billing_frequency	TEXT
61	start_date	TEXT
62	shared_teams	TEXT
63	shared_users	TEXT
64	status	TEXT
65	store_payment_method_at_checkout	INTEGER
66	tax_id	TEXT
67	total_collected_amount	REAL
68	total_remaining_amount	REAL
69	unique_creation_key	TEXT
70	update_payment_method_link	TEXT
71	updated_by_user_id	REAL
72	user_ids_of_all_notification_followers	TEXT
73	user_ids_of_all_notification_unfollowers	TEXT
74	user_ids_of_all_owners	TEXT
75	performed_in_an_import	INTEGER
76	owner_assigned_date	TEXT
77	subscription_owner	TEXT
78	owners_main_team	TEXT
79	record_created_at	TEXT
80	record_updated_at	TEXT

hubspot_taxes

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	created_by_user_id	REAL
5	object_create_datetime	TEXT
6	name	TEXT
7	object_last_modified_datetime	TEXT
8	merged_record_ids	TEXT
9	record_id	REAL
10	record_creation_source	TEXT
11	record_source_detail_1	TEXT
12	record_source_detail_2	TEXT
13	record_source_detail_3	TEXT
14	record_creation_source_id	TEXT
15	record_source	TEXT
16	record_creation_source_user_id	REAL
17	read_only_object	INTEGER
18	shared_teams	TEXT
19	shared_users	TEXT
20	display_order	REAL
21	type	TEXT
22	unique_creation_key	TEXT
23	updated_by_user_id	REAL
24	user_ids_of_all_notification_followers	TEXT
25	user_ids_of_all_notification_unfollowers	TEXT
26	user_ids_of_all_owners	TEXT
27	value	REAL
28	performed_in_an_import	INTEGER
29	owner_assigned_date	TEXT
30	owner	TEXT
31	owners_main_team	TEXT
32	record_created_at	TEXT
33	record_updated_at	TEXT

hubspot_calls

Column index	Column name	type
0	call_and_meeting_type	TEXT
1	all_teams	TEXT
2	business_units	TEXT
3	all_owner_ids	TEXT
4	all_team_ids	TEXT
5	at_mentioned_owner_ids	TEXT
6	attached_file_ids	TEXT
7	call_notes_preview	TEXT
8	html_body_preview	TEXT
9	body_preview_truncated	INTEGER
10	integrating_app_id	REAL
11	authenticated_recording_files_url_provider	TEXT
12	call_notes	TEXT
13	callee_object_id	REAL
14	callee_object_type	TEXT
15	deal_stage_during_call	TEXT
16	call_direction	TEXT
17	call_outcome	TEXT
18	call_duration	REAL
19	external_account_id	TEXT
20	external_id	TEXT
21	from_number	TEXT
22	from_number_name	TEXT
23	transcript_available	INTEGER
24	voicemail_available	TEXT
25	call_location	TEXT
26	meeting_id	TEXT
27	msteams_payload	TEXT
28	call_phone_number_source	TEXT
29	recording_duration	REAL
30	recording_url	TEXT
31	call_routing_strategy_type	TEXT
32	call_source	TEXT
33	call_status	TEXT
34	call_suggested_next_actions	TEXT
35	call_summary	TEXT
36	call_summary_execution_id	TEXT
37	call_title	TEXT
38	to_number	TEXT
39	to_number_name	TEXT
40	call_transcript_audio_channel_count	REAL
41	tracked_terms	TEXT
42	call_transcription_id	REAL
43	call_unified_phone_number_id	REAL
44	call_video_meeting_type	TEXT
45	video_url	TEXT
46	unique_zoom_meeting_id	TEXT
47	calls_service_call_id	REAL
48	connected_count	REAL
49	activity_created_by	REAL
50	created_by_user_id	REAL
51	create_date	TEXT
52	engagement_source	TEXT
53	engagement_source_id	TEXT
54	follow_up_action	TEXT
55	gdpr_deleted	INTEGER
56	last_modified_date	TEXT
57	merged_record_ids	TEXT
58	updated_by	REAL
59	record_id	REAL
60	record_creation_source	TEXT
61	record_source_detail_1	TEXT
62	record_source_detail_2	TEXT
63	record_source_detail_3	TEXT
64	record_creation_source_id	TEXT
65	record_source	TEXT
66	record_creation_source_user_id	REAL
67	product_name	TEXT
68	queue_memberships	TEXT
69	read_only_object	INTEGER
70	shared_teams	TEXT
71	shared_users	TEXT
72	activity_date	TEXT
73	unique_creation_key	TEXT
74	unique_id	TEXT
75	unknown_visitor_conversation	INTEGER
76	updated_by_user_id	REAL
77	user_ids_of_all_notification_followers	TEXT
78	user_ids_of_all_notification_unfollowers	TEXT
79	user_ids_of_all_owners	TEXT
80	voicemail_count	REAL
81	performed_in_an_import	INTEGER
82	owner_assigned_date	TEXT
83	activity_assigned_to	TEXT
84	hubspot_team	TEXT
85	record_created_at	TEXT
86	record_updated_at	TEXT

hubspot_communications

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	at_mentioned_owner_ids	TEXT
5	attached_file_ids	TEXT
6	body_preview	TEXT
7	html_body_preview	TEXT
8	body_preview_truncated	INTEGER
9	communication_body	TEXT
10	channel_type	TEXT
11	conversation_associations_sync_timestamp	TEXT
12	conversation_object_id	REAL
13	conversations_channel_ids	TEXT
14	conversations_channel_account_ids	TEXT
15	conversations_first_message_timestamp	TEXT
16	conversations_thread_id	REAL
17	logged_from	TEXT
18	activity_created_by	REAL
19	created_by_user_id	REAL
20	object_create_datetime	TEXT
21	engagement_source	TEXT
22	engagement_source_id	TEXT
23	gdpr_deleted	INTEGER
24	object_last_modified_datetime	TEXT
25	merged_record_ids	TEXT
26	updated_by	REAL
27	record_id	REAL
28	record_creation_source	TEXT
29	record_source_detail_1	TEXT
30	record_source_detail_2	TEXT
31	record_source_detail_3	TEXT
32	record_creation_source_id	TEXT
33	record_source	TEXT
34	record_creation_source_user_id	REAL
35	read_only_object	INTEGER
36	shared_teams	TEXT
37	shared_users	TEXT
38	activity_date	TEXT
39	unique_creation_key	TEXT
40	unique_id	TEXT
41	updated_by_user_id	REAL
42	user_ids_of_all_notification_followers	TEXT
43	user_ids_of_all_notification_unfollowers	TEXT
44	user_ids_of_all_owners	TEXT
45	performed_in_an_import	INTEGER
46	owner_assigned_date	TEXT
47	activity_assigned_to	TEXT
48	hubspot_team	TEXT
49	record_created_at	TEXT
50	record_updated_at	TEXT

hubspot_emails

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	at_mentioned_owner_ids	TEXT
5	attached_file_ids	TEXT
6	body_preview	TEXT
7	html_body_preview	TEXT
8	body_preview_truncated	INTEGER
9	activity_created_by	TEXT
10	created_by_user_id	REAL
11	create_date	TEXT
12	email_direction_and_unique_id	TEXT
13	email_associated_contact_id	REAL
14	attached_video	TEXT
15	attached_video_name	TEXT
16	attached_video_opened	INTEGER
17	attached_video_watched	INTEGER
18	email_bcc_address	TEXT
19	email_bcc_first_name	TEXT
20	email_bcc_last_name	TEXT
21	email_bcc	TEXT
22	email_bounce_error_detail_message	TEXT
23	email_bounce_error_detail_status_code	REAL
24	email_cc_address	TEXT
25	email_cc_first_name	TEXT
26	email_cc_last_name	TEXT
27	email_cc	TEXT
28	number_of_email_clicks	REAL
29	email_click_rate	REAL
30	email_direction	TEXT
31	encoded_email_associations_request	TEXT
32	error_message	TEXT
33	email_send_id	TEXT
34	email_from_address	TEXT
35	email_from_first_name	TEXT
36	email_from_last_name	TEXT
37	email_from	TEXT
38	email_has_inline_images_stripped	INTEGER
39	email_body	TEXT
40	logged_from	TEXT
41	media_processing_status	TEXT
42	email_is_member_of_forwarded_subthread	INTEGER
43	message_id	TEXT
44	email_migrated_via_portal_data_migration	TEXT
45	msteams_payload	TEXT
46	number_of_email_opens	REAL
47	email_open_rate	REAL
48	email_pending_inline_image_file_ids	TEXT
49	post_send_status	TEXT
50	number_of_email_replies	REAL
51	email_reply_rate	REAL
52	email_send_event_id	TEXT
53	email_send_event_id_created	TEXT
54	email_sender_address	TEXT
55	email_sender_first_name	TEXT
56	email_sender_last_name	TEXT
57	email_sender	TEXT
58	number_of_emails_sent	REAL
59	sent_via	TEXT
60	email_send_status	TEXT
61	email_stripped_attachment_count	REAL
62	email_subject	TEXT
63	text	TEXT
64	thread_id	TEXT
65	email_thread_summary	TEXT
66	email_to_address	TEXT
67	email_to_first_name	TEXT
68	email_to_last_name	TEXT
69	email_to	TEXT
70	tracker_key	TEXT
71	validation_skipped	TEXT
72	engagement_source	TEXT
73	engagement_source_id	TEXT
74	follow_up_action	TEXT
75	gdpr_deleted	INTEGER
76	incoming_email_out_of_office	INTEGER
77	last_modified_date	TEXT
78	merged_record_ids	TEXT
79	updated_by	TEXT
80	record_id	REAL
81	record_creation_source	TEXT
82	record_source_detail_1	TEXT
83	record_source_detail_2	TEXT
84	record_source_detail_3	TEXT
85	record_creation_source_id	TEXT
86	record_source	TEXT
87	record_creation_source_user_id	REAL
88	owner_ids_bcc	TEXT
89	owner_ids_cc	TEXT
90	owner_ids_from	TEXT
91	owner_ids_to	TEXT
92	product_name	TEXT
93	queue_memberships	TEXT
94	read_only_object	INTEGER
95	sales_client_association_status	TEXT
96	sales_clients_audit_id	TEXT
97	shared_teams	TEXT
98	shared_users	TEXT
99	activity_date	TEXT
100	unique_creation_key	TEXT
101	unique_id	TEXT
102	updated_by_user_id	REAL
103	user_ids_of_all_notification_followers	TEXT
104	user_ids_of_all_notification_unfollowers	TEXT
105	user_ids_of_all_owners	TEXT
106	performed_in_an_import	INTEGER
107	owner_assigned_date	TEXT
108	activity_assigned_to	TEXT
109	hubspot_team	TEXT
110	record_created_at	TEXT
111	record_updated_at	TEXT

hubspot_meetings

Column index	Column name	type
0	call_and_meeting_type	TEXT
1	all_teams	TEXT
2	business_units	TEXT
3	all_owner_ids	TEXT
4	all_team_ids	TEXT
5	at_mentioned_owner_ids	TEXT
6	attached_file_ids	TEXT
7	hubspot_attendee_owner_ids	TEXT
8	body_preview	TEXT
9	html_body_preview	TEXT
10	body_preview_truncated	INTEGER
11	booking_instance_id	REAL
12	contact_first_outreach_date	TEXT
13	activity_created_by	REAL
14	created_by_user_id	REAL
15	create_date	TEXT
16	engagement_source	TEXT
17	engagement_source_id	TEXT
18	external_calendar_id	TEXT
19	follow_up_action	TEXT
20	follow_up_tasks_remaining	REAL
21	gdpr_deleted	INTEGER
22	guest_emails	TEXT
23	icaluid	TEXT
24	should_include_description_in_reminder	INTEGER
25	internal_meeting_notes	TEXT
26	last_modified_date	TEXT
27	meeting_description	TEXT
28	meeting_calendar_event_hash	TEXT
29	meeting_change_id	TEXT
30	created_from_link_id	TEXT
31	meeting_end_time	TEXT
32	external_url	TEXT
33	meeting_location	TEXT
34	location_type	TEXT
35	msteams_payload	TEXT
36	meeting_outcome	TEXT
37	payments_session_id	TEXT
38	pre_meeting_prospect_reminders	TEXT
39	meeting_source	TEXT
40	source_id	TEXT
41	meeting_start_time	TEXT
42	meeting_name	TEXT
43	web_conference_meeting_id	TEXT
44	merged_record_ids	TEXT
45	updated_by	REAL
46	record_id	REAL
47	record_creation_source	TEXT
48	record_source_detail_1	TEXT
49	record_source_detail_2	TEXT
50	record_source_detail_3	TEXT
51	record_creation_source_id	TEXT
52	record_source	TEXT
53	record_creation_source_user_id	REAL
54	outcome_canceled_count	REAL
55	outcome_completed_count	REAL
56	outcome_no_show_count	REAL
57	outcome_rescheduled_count	REAL
58	outcome_scheduled_count	REAL
59	product_name	TEXT
60	queue_memberships	TEXT
61	read_only_object	INTEGER
62	shared_teams	TEXT
63	shared_users	TEXT
64	time_to_book_meeting_from_first_contact	REAL
65	activity_date	TEXT
66	timezone	TEXT
67	unique_creation_key	TEXT
68	unique_id	TEXT
69	updated_by_user_id	REAL
70	user_ids_of_all_notification_followers	TEXT
71	user_ids_of_all_notification_unfollowers	TEXT
72	user_ids_of_all_owners	TEXT
73	video_conference_url	TEXT
74	performed_in_an_import	INTEGER
75	owner_assigned_date	TEXT
76	activity_assigned_to	TEXT
77	hubspot_team	TEXT
78	record_created_at	TEXT
79	record_updated_at	TEXT

hubspot_notes

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	at_mentioned_owner_ids	TEXT
5	attached_file_ids	TEXT
6	body_preview	TEXT
7	html_body_preview	TEXT
8	body_preview_truncated	INTEGER
9	activity_created_by	REAL
10	created_by_user_id	REAL
11	create_date	TEXT
12	engagement_source	TEXT
13	engagement_source_id	TEXT
14	follow_up_action	TEXT
15	gdpr_deleted	INTEGER
16	last_modified_date	TEXT
17	merged_record_ids	TEXT
18	updated_by	REAL
19	note_body	TEXT
20	msteams_payload	TEXT
21	record_id	REAL
22	record_creation_source	TEXT
23	record_source_detail_1	TEXT
24	record_source_detail_2	TEXT
25	record_source_detail_3	TEXT
26	record_creation_source_id	TEXT
27	record_source	TEXT
28	record_creation_source_user_id	REAL
29	product_name	TEXT
30	queue_memberships	TEXT
31	read_only_object	INTEGER
32	shared_teams	TEXT
33	shared_users	TEXT
34	activity_date	TEXT
35	unique_creation_key	TEXT
36	unique_id	TEXT
37	updated_by_user_id	REAL
38	user_ids_of_all_notification_followers	TEXT
39	user_ids_of_all_notification_unfollowers	TEXT
40	user_ids_of_all_owners	TEXT
41	performed_in_an_import	INTEGER
42	owner_assigned_date	TEXT
43	activity_assigned_to	TEXT
44	hubspot_team	TEXT
45	record_created_at	TEXT
46	record_updated_at	TEXT

hubspot_postal_mail

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	at_mentioned_owner_ids	TEXT
5	attached_file_ids	TEXT
6	body_preview	TEXT
7	html_body_preview	TEXT
8	body_preview_truncated	INTEGER
9	activity_created_by	REAL
10	created_by_user_id	REAL
11	object_create_datetime	TEXT
12	engagement_source	TEXT
13	engagement_source_id	TEXT
14	gdpr_deleted	INTEGER
15	object_last_modified_datetime	TEXT
16	merged_record_ids	TEXT
17	updated_by	REAL
18	record_id	REAL
19	record_creation_source	TEXT
20	record_source_detail_1	TEXT
21	record_source_detail_2	TEXT
22	record_source_detail_3	TEXT
23	record_creation_source_id	TEXT
24	record_source	TEXT
25	record_creation_source_user_id	REAL
26	postal_mail_body	TEXT
27	postal_mail_type	TEXT
28	queue_memberships	TEXT
29	read_only_object	INTEGER
30	shared_teams	TEXT
31	shared_users	TEXT
32	activity_date	TEXT
33	unique_creation_key	TEXT
34	unique_id	TEXT
35	updated_by_user_id	REAL
36	user_ids_of_all_notification_followers	TEXT
37	user_ids_of_all_notification_unfollowers	TEXT
38	user_ids_of_all_owners	TEXT
39	performed_in_an_import	INTEGER
40	owner_assigned_date	TEXT
41	owner	TEXT
42	owners_main_team	TEXT
43	record_created_at	TEXT
44	record_updated_at	TEXT

hubspot_tasks

Column index	Column name	type
0	all_teams	TEXT
1	business_units	TEXT
2	all_owner_ids	TEXT
3	all_team_ids	TEXT
4	at_mentioned_owner_ids	TEXT
5	attached_file_ids	TEXT
6	notes_preview	TEXT
7	html_body_preview	TEXT
8	body_preview_truncated	INTEGER
9	calendar_event_id	TEXT
10	created_by	REAL
11	created_by_user_id	REAL
12	created_at	TEXT
13	date_entered_in_progress_task_pipeline	TEXT
14	date_entered_completed_task_pipeline	TEXT
15	date_entered_not_started_task_pipeline	TEXT
16	date_entered_waiting_task_pipeline	TEXT
17	date_entered_deferred_task_pipeline	TEXT
18	date_exited_in_progress_task_pipeline	TEXT
19	date_exited_completed_task_pipeline	TEXT
20	date_exited_not_started_task_pipeline	TEXT
21	date_exited_waiting_task_pipeline	TEXT
22	date_exited_deferred_task_pipeline	TEXT
23	source	TEXT
24	source_id	TEXT
25	follow_up_action	TEXT
26	gdpr_deleted	INTEGER
27	last_modified_at	TEXT
28	category	TEXT
29	category_id	REAL
30	merged_record_ids	TEXT
31	last_modified_by	REAL
32	ms_teams_message_id	TEXT
33	record_id	REAL
34	record_creation_source	TEXT
35	record_source_detail_1	TEXT
36	record_source_detail_2	TEXT
37	record_source_detail_3	TEXT
38	record_creation_source_id	TEXT
39	record_source	TEXT
40	record_creation_source_user_id	REAL
41	pipeline	TEXT
42	pipeline_stage	TEXT
43	product_name	TEXT
44	queue	TEXT
45	read_only_object	INTEGER
46	task_repeat_status	TEXT
47	shared_teams	TEXT
48	shared_users	TEXT
49	notes	TEXT
50	campaign_guid	TEXT
51	task_completion_count	REAL
52	completed_at	TEXT
53	contact_time_zone	TEXT
54	task_family	TEXT
55	for_object_type	TEXT
56	task_is_all_day	INTEGER
57	tasks_completed	REAL
58	call_tasks_completed	REAL
59	email_tasks_completed	REAL
60	linkedin_tasks_completed	REAL
61	sequence_tasks_completed	REAL
62	is_overdue	INTEGER
63	is_past_due_date	INTEGER
64	last_contacted	TEXT
65	last_engagement	TEXT
66	task_missed_due_date	INTEGER
67	overdue_tasks	REAL
68	ms_teams_payload	TEXT
69	priority	TEXT
70	task_probability_to_complete	REAL
71	relative_task_reminders	TEXT
72	reminder	TEXT
73	interval	TEXT
74	send_default_reminder	INTEGER
75	sequence_enrollment_is_active	INTEGER
76	sequence_step_enrollment_id	TEXT
77	sequence_step_number	REAL
78	task_status	TEXT
79	task_title	TEXT
80	task_template_id	REAL
81	task_type	TEXT
82	time_in_in_progress_task_pipeline	REAL
83	time_in_completed_task_pipeline	REAL
84	time_in_not_started_task_pipeline	REAL
85	time_in_waiting_task_pipeline	REAL
86	time_in_deferred_task_pipeline	REAL
87	due_date	TEXT
88	unique_creation_key	TEXT
89	unique_id	TEXT
90	updated_by_user_id	REAL
91	user_ids_of_all_notification_followers	TEXT
92	user_ids_of_all_notification_unfollowers	TEXT
93	user_ids_of_all_owners	TEXT
94	performed_in_an_import	INTEGER
95	owner_assigned_date	TEXT
96	assigned_to	TEXT
97	hubspot_team	TEXT
98	record_created_at	TEXT
99	record_updated_at	TEXT

Additional information

The plugin uses bulk operations to insert/update/delete records in HubSpot. At most, 100 records can be processed in a single bulk operation. This means that when a statement is run, it might not be immediately reflected in the HubSpot dashboard. Run a select statement to flush the buffer and see the changes in the dashboard.
The plugin uses the HubSpot API to fetch data. The API has a rate limit of 10 requests per second. If the rate limit is exceeded, the plugin will wait for the next second before making the next request. It means that on average, the plugin will fetch 1000 records per second.
The lower the cache_ttl, the more you might hit the rate limit. Configure it appropriately based on the number of records you are fetching. A good default value is 3600 seconds.