Skip to main content

Data Dictionary

Canadian Statistics AttributesView Source Documentation

PUBLIC_DATA.CANADA_STATCAN_ATTRIBUTES: Demographic, economic, and social variables on Canada, including income, prices, GDP, labor, census profiles, foreign exchange, credit, and retail trade, provided by Canada's national statistical agency.

Canadian Statistics Attributes Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.CANADA_STATCAN_ATTRIBUTES_PIT: Tracks history of the canada_statcan_attributes table with start and end timestamps to indicate row validity periods.

Canadian Statistics TimeseriesView Source Documentation

PUBLIC_DATA.CANADA_STATCAN_TIMESERIES: Canadian economic, demographic, and social data, including income, household finances, prices, GDP, labor market, census, and more, by geographic entity over time.

Canadian Statistics Timeseries Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.CANADA_STATCAN_TIMESERIES_PIT: Tracks history of the canada_statcan_timeseries table with start and end timestamps to indicate row validity periods.

PUBLIC_DATA.GEOGRAPHY_INDEX: Snowflake Public Data unified geographic entity index, joinable to all tables, providing unique geographic identifiers with associated names, levels, and ISO codes for various US geographies.

Geographic Entity Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.GEOGRAPHY_INDEX_PIT: Tracks history of the geography_index table with start and end timestamps to indicate row validity periods.

Geographic Entity OverlapsView Source Documentation

PUBLIC_DATA.GEOGRAPHY_OVERLAPS: Geographic relationships between overlapping regions, such as counties and zip codes, identified by unique GEO_IDs.

Geographic Entity Overlaps Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.GEOGRAPHY_OVERLAPS_PIT: Tracks history of the geography_overlaps table with start and end timestamps to indicate row validity periods.

Geographic Entity RelationshipsView Source Documentation

PUBLIC_DATA.GEOGRAPHY_RELATIONSHIPS: Relationships between geographic entities of differing levels, including overlaps and contains relationships, using Snowflake Public Data GEO_IDs.

Geographic Entity Relationships Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.GEOGRAPHY_RELATIONSHIPS_PIT: Tracks history of the geography_relationships table with start and end timestamps to indicate row validity periods.