Table: dim_business

Type: Dimension Columns: 14

Description

Business information. The data grain is the business level information.

Columns

Column Name Type Description
business string

The name of the business

business_data_type string

The type of business data; enumerated: 'Internal Test', 'Sandbox', 'Prod', or 'Churned'

business_timezone string

The timezone of the business

business_timezone_offset double

The difference in hours between the business timezone and UTC

business_country string

The country where the business is located

business_state string

The state where the business is located

business_city string

The city where the business is located

business_postal_code string

The postal code of the business's address

business_id string

Unique identifier for the business

is_business_archived string

Indicates whether the business is currently archived; enumerated: 'Yes' or 'No'

business_last_updated timestamp[ns]

The datetime when the data was last updated per business in their own timezone

business_today date32[day]

The date when the data was last updated per business in their own timezone

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.