Schema

This documentation describes the standard tables in your Bonsai data warehouse, enabling reliable access to core marketing and business data with consistent naming, data types, and performance.

Overview

These tables provide standardized geographic reference data used across the Bonsai platform. They map postal codes, regions, cities, and DMAs while supplying demographic indices to enable consistent geographic segmentation, modeling, and reporting.

---

Geo Mapping

dma_table schema Description: A reference table of DMA data for the Bonsai platform.

field_name	is_nullable	data_type	definition
dma_id	YES	INT64	Bonsai's DMA ID.
dma_name	YES	STRING	DMA name.

dma_demographics_indicies_data_table schema Description: A reference table of DMA demographic and household indices for the Bonsai platform.

field_name	is_nullable	data_type	definition
dma_id	YES	INT64	Bonsai's DMA ID.
dma_name	YES	STRING	DMA name.
pop_index	YES	FLOAT64	US population index.
tv_index	YES	FLOAT64	US TV household index.
household_index	YES	FLOAT64	US household index.
male_index	YES	FLOAT64	US male population index.
female_index	YES	FLOAT64	US female population index.
male_1824_index	YES	FLOAT64	Male 18–24 population index.
female_1824_index	YES	FLOAT64	Female 18–24 population index.
male_2534_index	YES	FLOAT64	Male 25–34 population index.
female_2534_index	YES	FLOAT64	Female 25–34 population index.
male_3544_index	YES	FLOAT64	Male 35–44 population index.
female_3544_index	YES	FLOAT64	Female 35–44 population index.
male_4554_index	YES	FLOAT64	Male 45–54 population index.
female_4554_index	YES	FLOAT64	Female 45–54 population index.
male_5564_index	YES	FLOAT64	Male 55–64 population index.
female_5564_index	YES	FLOAT64	Female 55–64 population index.
male_65_index	YES	FLOAT64	Male 65+ population index.
female_65_index	YES	FLOAT64	Female 65+ population index.

zip_to_dma schema Description: A reference table mapping US Postal Codes to Bonsai DMA IDs.

field_name	is_nullable	data_type	definition
zip_code	YES	STRING	US postal code.
dma_id	YES	INT64	Bonsai's DMA ID.

zip_to_region schema Description: A reference table mapping US Postal Codes to US State/Region.

field_name	is_nullable	data_type	definition
zip_code	YES	STRING	US postal code.
region_code	YES	STRING	Bonsai's region ID.
region_abbr	YES	STRING	Region abbreviation, typically the US state abbreviation.
region_name	YES	STRING	Region name, typically referring to US state.

city schema Description: A reference table of cities in the Bonsai platform.

field_name	is_nullable	data_type	definition
city_id	YES	INT64	Bonsai's city ID.
city_name	YES	STRING	City name.