Table: hubspot_owner - Query HubSpot Owners using SQL

HubSpot Owners are the users who have been assigned ownership of specific contacts, companies, deals, or tickets in a HubSpot account. Owners can be assigned to these resources either manually or through automation, and they are responsible for managing and interacting with these resources. Each owner has a unique ID, email, and other personal details stored in the HubSpot system.

Table Usage Guide

The hubspot_owner table provides insights into the owners within a HubSpot account. As a sales or marketing professional, you can use this table to explore detailed information about each owner, such as their unique ID, email, first and last name, and more. This table can be particularly useful for understanding the distribution of resources among owners in your HubSpot account.

Examples

Basic info

Explore the essential details of the HubSpot owners, such as their identification, title, and creation date. This is beneficial to understand the owners' archival status and personal information, which can be useful for auditing and account management purposes.

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner;

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner;

List all archived owners

Discover the segments that include all archived owners. This is useful for understanding which owners are no longer active, helping to maintain an up-to-date and accurate database.

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner
where
  archived;

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner
where
  archived = 1;

List owners created in the last 30 days

Discover recent additions to your team by identifying new owners added within the past month. This is useful for keeping track of team growth and ensuring all new members are properly onboarded.

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner
where
  created_at > now() - interval '30 days';

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner
where
  created_at > datetime('now', '-30 days');

List owners who are not associated with any team

Uncover the details of owners who are not part of any team. This can be useful for identifying potential resource allocation or communication gaps within your organization.

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner
where
  teams is null;

select
  id,
  title,
  created_at,
  archived,
  email,
  first_name,
  last_name,
  user_id
from
  hubspot_owner
where
  teams is null;

Schema for hubspot_owner

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
archived	boolean	=	Indicates whether the owner is archived or not.
created_at	timestamp with time zone		The timestamp when the owner was created.
email	text		The email address associated with the owner.
first_name	text		The first name of the person.
id	text	=	The unique ID of the owner.
last_name	text		The last name of the person.
portal_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier for the HubSpot portal or account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
teams	jsonb		The teams associated with the owner.
title	text		Title of the resource.
updated_at	timestamp with time zone		The timestamp when the owner was last updated.
user_id	bigint		The user ID associated with the owner.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- hubspot

You can pass the configuration to the command with the --config argument:

steampipe_export_hubspot --config '<your_config>' hubspot_owner