HubSpot V2

Total number of contacts

SQL query for HubSpot V2

Get the total number of contacts in the database.

SELECT COUNT(*) FROM contacts

HubSpot V2 data model

HubSpot V2
Table Calls

HubSpot V2
Table Campaigns

HubSpot V2
Table Campaign Emails

HubSpot V2
Table Conversation Threads

HubSpot V2
Table Companies

HubSpot V2
Table Company Contacts Association

HubSpot V2
Table Company Company Association

HubSpot V2
Table Company Deals Association

HubSpot V2
Table Company Line Items Association

HubSpot V2
Table Company Payments Association

HubSpot V2
Table Company Subscriptions Association

HubSpot V2
Table Contacts

HubSpot V2
Table Contacts Company Associations

HubSpot V2
Table Contacts Contacts Associations

HubSpot V2
Table Contacts Deals Associations

HubSpot V2
Table Contacts Subscriptions Associations

HubSpot V2
Table Contacts Payments Associations

HubSpot V2
Table Commerce Payments

HubSpot V2
Table Payments Deals Associations

HubSpot V2
Table Deals

HubSpot V2
Table Deals Company Associations

HubSpot V2
Table Deals Contacts Associations

HubSpot V2
Table Deals Deals Associations

HubSpot V2
Table Deals Line Items Associations

HubSpot V2
Table Deals Subscription Associations

HubSpot V2
Table Deals Payments Associations

HubSpot V2
Table Deals Pipeline

HubSpot V2
Table Engagements

HubSpot V2
Table Engagements Company Associations

HubSpot V2
Table Engagements Contacts Associations

HubSpot V2
Table Engagements Deals Associations

HubSpot V2
Table Engagements Subscriptions Associations

HubSpot V2
Table Engagements Payments Associations

HubSpot V2
Table Engagement Emails

HubSpot V2
Table Feedback Submissions

HubSpot V2
Table Forms

HubSpot V2
Table Form Submissions

HubSpot V2
Table Goals

HubSpot V2
Table Leads

HubSpot V2
Table Line Items

HubSpot V2
Table Meetings

HubSpot V2
Table Meetings Company Associations

HubSpot V2
Table Meetings Contacts Associations

HubSpot V2
Table Meetings Deals Associations

HubSpot V2
Table Meetings Leads Associations

HubSpot V2
Table Notes

HubSpot V2
Table Notes Deals Associations

HubSpot V2
Table Owners

HubSpot V2
Table Products

HubSpot V2
Table Quotes

HubSpot V2
Table Quotes Company Associations

HubSpot V2
Table Quotes Contacts Associations

HubSpot V2
Table Quotes Deals Associations

HubSpot V2
Table Quotes Line Items Associations

HubSpot V2
Table Subscriptions

HubSpot V2
Table Subscriptions Deals Associations

HubSpot V2
Table Teams

HubSpot V2
Table Tickets

HubSpot V2
Table Tickets Company Associations

HubSpot V2
Table Tickets Contacts Associations

HubSpot V2
Table Tickets Deals Associations

HubSpot V2
Table Tickets Engagements Associations

HubSpot V2
Table Tickets Tickets Associations

HubSpot V2
Table Tickets Subscriptions Associations

HubSpot V2
Table Tickets Payments Associations

HubSpot V2
Table Tickets Pipeline

HubSpot V2
Table Users

HubSpot V2
Table Workflows

HubSpot V2
Table Website Pages

HubSpot V2
Table Company Leads Associations

HubSpot V2
Table Contacts Leads Associations

HubSpot V2
Table Deals Leads Associations

HubSpot V2
Table Deleted

SQL - Combine data

Magical SQL for HubSpot V2 with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Let AI do the work for you

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Overview

Ready to get instant access to
all your company data ?