Table: dim_business

Type: Dimension Columns: 12

Description

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

Columns

Column Name Description
business

The name of the business

business_data_type

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

business_timezone

The timezone of the business

business_timezone_offset

The difference in hours between the business timezone and UTC

business_country

The country where the business is located

business_state

The state where the business is located

business_city

The city where the business is located

business_postal_code

The postal code of the business's address

business_id

Unique identifier for the business

is_business_archived

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

business_last_updated

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

business_today

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