Hubs

Data related to the Hubs service

Source Directory

active_subscription_ids

Active Subscription Ids

hubs.active_subscription_ids

Please provide a description for the query

Schema

Column	Description	Type	Nullable
active_date		Date	Yes
subscription_id		String	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	hubs_derived	active_subscription_ids_live
moz-fx-data-shared-prod	hubs_derived	active_subscription_ids_v1

Source Directory | View Definition | Metadata File

---

active_subscriptions

Active Subscriptions

hubs.active_subscriptions

Please provide a description for the query

Schema

Column	Description	Type	Nullable
active_date		Date	Yes
plan_id		String	Yes
country		String	Yes
country_name		String	Yes
provider		String	Yes
plan_amount		Integer	Yes
billing_scheme		String	Yes
plan_currency		String	Yes
plan_interval		String	Yes
plan_interval_count		Integer	Yes
product_id		String	Yes
product_name		String	Yes
pricing_plan		String	Yes
promotion_codes		String	No
promotion_discounts_amount		Integer	Yes
count		Integer	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	hubs_derived	active_subscriptions_live
moz-fx-data-shared-prod	hubs_derived	active_subscriptions_v1

Source Directory | View Definition | Metadata File

---

subscription_events

Subscription Events

hubs.subscription_events

Please provide a description for the query

Schema

Column	Description	Type	Nullable
event_date		Date	Yes
event_type		String	Yes
granular_event_type		String	Yes
plan_id		String	Yes
country		String	Yes
country_name		String	Yes
provider		String	Yes
plan_amount		Integer	Yes
billing_scheme		String	Yes
plan_currency		String	Yes
plan_interval		String	Yes
plan_interval_count		Integer	Yes
product_id		String	Yes
product_name		String	Yes
pricing_plan		String	Yes
promotion_codes		String	No
count		Integer	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	hubs_derived	subscription_events_live
moz-fx-data-shared-prod	hubs_derived	subscription_events_v1

Source Directory | View Definition | Metadata File

---

subscriptions

Subscriptions

hubs.subscriptions

Please provide a description for the query

Schema

Column	Description	Type	Nullable
customer_id		String	Yes
subscription_id		String	Yes
original_subscription_id		String	Yes
plan_id		String	Yes
status		String	Yes
event_timestamp		Timestamp	Yes
subscription_start_date		Timestamp	Yes
original_subscription_start_date		Timestamp	Yes
subscription_start_reason		String	Yes
created		Timestamp	Yes
trial_start		Timestamp	Yes
trial_end		Timestamp	Yes
canceled_at		Timestamp	Yes
canceled_for_customer_at		String	Yes
cancel_at		Timestamp	Yes
cancel_at_period_end		Boolean	Yes
ended_at		Timestamp	Yes
ended_reason		String	Yes
fxa_uid		String	Yes
country		String	Yes
country_name		String	Yes
provider		String	Yes
plan_amount		Integer	Yes
billing_scheme		String	Yes
plan_currency		String	Yes
plan_interval		String	Yes
plan_interval_count		Integer	Yes
plan_interval_timezone		String	Yes
product_id		String	Yes
product_name		String	Yes
pricing_plan		String	Yes
billing_grace_period		Interval	Yes
promotion_codes		String	No
promotion_discounts_amount		Integer	Yes
customer_start_date		Timestamp	Yes
end_date		Timestamp	Yes
months_retained		Integer	Yes
original_subscription_months_retained		Integer	Yes
current_months_since_subscription_start		Integer	Yes
current_months_since_original_subscription_start		Integer	Yes

Referenced Tables

Project	Dataset	Table
moz-fx-data-shared-prod	hubs_derived	subscriptions_v1

Source Directory | View Definition | Metadata File

---