Snowflake, Snowflake,

Home » Snowflake » Guide to Geography Dimension on the Snowflake Marketplace

Guide to Geography Dimension on the Snowflake Marketplace

by Kristijan Berta

Published on February 3, 2021
Updated on October 23, 2024

We have published a universal Geography Dimension on the marketplace of the Snowflake Data Cloud. You can easily join the data with your in house data to look up location data. You can also use it for drilling down / rolling up in any type of location analytics.

CORE TABLES

The core tables in the data model are listed below.

COUNTRY

This table holds the country level information.

COLUMNS

Column	Description
GEO_ID	The integer id of the record
COUNTRY_CD	The unique country code
ISO	The ISO code for the country
ISO3	The ISO3 code for the country
ISO_NUMERIC	The numeric ISO for the country
FIPS	Country FIPS code
COUNTRY	Country name
CAPITAL	Country Capital
AREA_IN_SQ_KM	The total area of country in sq.km
POPULATION	Total population of the country
CONTINENT	The continent where the country belongs
TLD	Top-level domain of the country
CURRENCYCD	Currency code
CURRENCYNAME	Currency name
PHONE	Phone dialing code
POSTAL_CD_FORMAT	Postal code format of country
POSTAL_CD_REGEX	The regular expression for the postal code of the country
LANGUAGES	Languages spoken in a country ordered by the number of speakers. The language code is a ‘locale’, where any two-letter primary-tag is an ISO-639 language abbreviation and any two-letter initial subtag is an ISO-3166 country code. Example : es-AR is the Spanish variant spoken in Argentina.
NEIGHBOURS	The neighbouring countries
EQUIVALENTFIPSCD	Equivalent Fips code if any

ADMIN_1

All first-order/primary administrative divisions within each country, such as a state in the United States.

COLUMNS

Column	Description
GEO_ID	The integer id of the record
ADMIN1_CD	The first order administrative division code
COUNTRY_CD	Country code where the administrative division belongs
FEATURE_CD	Indicates the feature (eg: ADM1, ADM2 etc)
NAME	Name of the geographical point
ASCIINAME	Name of the geographical point in plain ascii characters
LATITUDE	Latitude in decimal degrees
LONGITUDE	Longitude in decimal degrees
POPULATION	Population
DEM	Digital elevation model, srtm3 or gtopo30, average elevation of 3”x3” (ca 90mx90m) or 30”x30” (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.
TIMEZONE	Timezone
MODIFICATION_DT	Date of last modification

SAMPLE QUERIES

As an example, here is the query to find all the first-order administrative divisions of France.

SELECT
    ADMIN1_CD,
    NAME,
    LATITUDE,
    LONGITUDE,
    POPULATION,
    DEM
FROM
    ADMIN_1
WHERE
    COUNTRY_CD = 'FR' ;

SELECT

ADMIN1_CD,

NAME,

LATITUDE,

LONGITUDE,

POPULATION,

DEM

FROM

ADMIN_1

WHERE

COUNTRY_CD = 'FR' ;

Book a demo with us.

Book a Demo

The result shows the details of 13 first-order administrative divisions(ADM1) in France.
The number of the first-order administrative divisions within a country can be obtained from the following query.

SELECT
	COUNT(*)
FROM
	ADMIN_1 AD1
JOIN COUNTRY C ON
	AD1.COUNTRY_CD = C.COUNTRY_CD
WHERE
	C.COUNTRY = 'Italy';

SELECT

COUNT(*)

FROM

ADMIN_1 AD1

JOIN COUNTRY C ON

AD1.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Italy';

ADMIN_2

All second-order administrative divisions within each country which is a subdivision of a first-order administrative division, such as a county in the US.

COLUMNS

Column	Description
GEO_ID	The integer id of the record
ADMIN2_CD	The second order administrative division code
PARENT_ADMIN_CD	The code of the parent administrative division(code of corresponding ADM1 division in this case)
COUNTRY_CD	Country code where the administrative division belongs
FEATURE_CD	Indicates the feature (eg: ADM1, ADM2 etc)
NAME	Name of the geographical point
ASCIINAME	Name of the geographical point in plain ascii characters
LATITUDE	Latitude in decimal degrees
LONGITUDE	Longitude in decimal degrees
POPULATION	Population
DEM	digital elevation model, srtm3 or gtopo30, average elevation of 3”x3” (ca 90mx90m) or 30”x30” (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.
TIMEZONE	Timezone
MODIFICATION_DT	Date of last modification

SAMPLE QUERIES

The following query shows second order administrative divisions(ADM2) in France.

SELECT
	AD2.ADMIN2_CD,
	AD2.PARENT_ADMIN_CD,
	AD2.NAME,
	AD2.LATITUDE,
	AD2.LONGITUDE,
	AD2.POPULATION,
	AD2.DEM
FROM
	ADMIN_2 AD2
INNER JOIN COUNTRY C ON
	AD2.COUNTRY_CD = C.COUNTRY_CD
WHERE
	C.COUNTRY = 'France';

SELECT

AD2.ADMIN2_CD,

AD2.PARENT_ADMIN_CD,

AD2.NAME,

AD2.LATITUDE,

AD2.LONGITUDE,

AD2.POPULATION,

AD2.DEM

FROM

ADMIN_2 AD2

INNER JOIN COUNTRY C ON

AD2.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'France';

The result has the data of 96 second-order administrative levels in France.

ADMIN_3

All third-order administrative divisions within each country which is a subdivision of a second-order administrative division.

SAMPLE QUERIES

The query given below can be used to fetch the latitude,longitude and population of the third-order administrative divisions of Spain.

SELECT
	AD3.ADMIN3_CD,
	AD3.NAME,
	AD3.LATITUDE,
	AD3.LONGITUDE,
	AD3.POPULATION
FROM
	ADMIN_3 AD3
INNER JOIN COUNTRY C
    	ON AD3.COUNTRY_CD = C.COUNTRY_CD
WHERE
	C.COUNTRY = 'Spain';

SELECT

AD3.ADMIN3_CD,

AD3.NAME,

AD3.LATITUDE,

AD3.LONGITUDE,

AD3.POPULATION

FROM

ADMIN_3 AD3

INNER JOIN COUNTRY C

ON AD3.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Spain';

ADMIN_4

All fourth-order administrative divisions within each country which is a subdivision of a third-order administrative division.

SAMPLE QUERIES

The query given below can be used to fetch the number of fourth-order divisions under each of the first-order administrative divisions of France.

SELECT
    ADM1.ADMIN1_CD,
    ADM1.NAME,
    COUNT(*)
FROM
    ADMIN_4 ADM4
INNER JOIN ADMIN_3 ADM3 ON
    ADM4.PARENT_ADMIN_CD = ADM3.ADMIN3_CD
INNER JOIN ADMIN_2 ADM2 ON
    ADM3.PARENT_ADMIN_CD = ADM2.ADMIN2_CD
INNER JOIN ADMIN_1 ADM1 ON
    ADM2.PARENT_ADMIN_CD = ADM1.ADMIN1_CD
INNER JOIN COUNTRY C ON
    ADM4.COUNTRY_CD = C.COUNTRY_CD
WHERE
    C.COUNTRY = 'France'
GROUP BY
    ADM1.ADMIN1_CD,
    ADM1.NAME;

SELECT

ADM1.ADMIN1_CD,

ADM1.NAME,

COUNT(*)

FROM

ADMIN_4 ADM4

INNER JOIN ADMIN_3 ADM3 ON

ADM4.PARENT_ADMIN_CD = ADM3.ADMIN3_CD

INNER JOIN ADMIN_2 ADM2 ON

ADM3.PARENT_ADMIN_CD = ADM2.ADMIN2_CD

INNER JOIN ADMIN_1 ADM1 ON

ADM2.PARENT_ADMIN_CD = ADM1.ADMIN1_CD

INNER JOIN COUNTRY C ON

ADM4.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'France'

GROUP BY

ADM1.ADMIN1_CD,

ADM1.NAME;

ADMIN_5

All fifth-order administrative divisions within each country which is a subdivision of a fourth-order administrative division.

SAMPLE QUERY

The query given below can be used to fetch the hierarchical parent administrative divisions of a fifth order administrative division.

SELECT
    AD1.NAME ADMIN1_NAME,
    AD2.NAME ADMIN2_NAME,
    AD3.NAME ADMIN3_NAME,
    AD4.NAME ADMIN4_NAME,
    AD5.NAME ADMIN5_NAME
FROM
    ADMIN_5 AD5
INNER JOIN ADMIN_4 AD4 ON
    AD5.PARENT_ADMIN_CD = AD4.ADMIN4_CD
INNER JOIN ADMIN_3 AD3 ON
    AD4.PARENT_ADMIN_CD = AD3.ADMIN3_CD
INNER JOIN ADMIN_2 AD2 ON
    AD3.PARENT_ADMIN_CD = AD2.ADMIN2_CD
INNER JOIN ADMIN_1 AD1 ON
    AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD
INNER JOIN COUNTRY C ON
    AD5.COUNTRY_CD = C.COUNTRY_CD
WHERE
    C.COUNTRY = 'Italy'
    AND AD5.NAME = 'La Storta';

SELECT

AD1.NAME ADMIN1_NAME,

AD2.NAME ADMIN2_NAME,

AD3.NAME ADMIN3_NAME,

AD4.NAME ADMIN4_NAME,

AD5.NAME ADMIN5_NAME

FROM

ADMIN_5 AD5

INNER JOIN ADMIN_4 AD4 ON

AD5.PARENT_ADMIN_CD = AD4.ADMIN4_CD

INNER JOIN ADMIN_3 AD3 ON

AD4.PARENT_ADMIN_CD = AD3.ADMIN3_CD

INNER JOIN ADMIN_2 AD2 ON

AD3.PARENT_ADMIN_CD = AD2.ADMIN2_CD

INNER JOIN ADMIN_1 AD1 ON

AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD

INNER JOIN COUNTRY C ON

AD5.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Italy'

AND AD5.NAME = 'La Storta';

ADMIN_3_REL1, ADMIN4_REL1, ADMIN4_REL2, ADMIN5_REL1, ADMIN5_REL2, ADMIN5_REL3

Administrative Divisions may contain skip level hierarchies, i.e. that certain levels in the hierarchy are skipped for some or all children and directly reference grandchildren or great grandchildren.
For these scenarios we created additional tables that are suffixed with _REL<parent admin level>.
For example ADMIN_3_REL1 table has third-order administrative divisions which come directly under a first-order administrative division and ADMIN_4_REL2 has fourth-order administrative divisions which come directly under a second-order administrative division.
As an example, the third-order administrative division Oktyabr’skiy Rayon in Russia comes directly under the first order administrative division Belgorod Oblast.

SAMPLE QUERIES

The query given below fetches the third-order administrative divisions in Russia that come directly under first-order administrative divisions.

SELECT
    AD1.ADMIN1_CD,
    AD1.NAME,
    AD31.ADMIN3_CD,
    AD31.PARENT_ADMIN_CD,
    AD31.NAME
FROM
    ADMIN_3_REL1 AD31
INNER JOIN ADMIN_1 AD1 ON
    AD31.PARENT_ADMIN_CD = AD1.ADMIN1_CD
INNER JOIN COUNTRY C ON
    AD31.COUNTRY_CD = C.COUNTRY_CD
WHERE
    C.COUNTRY = 'Russia';

SELECT

AD1.ADMIN1_CD,

AD1.NAME,

AD31.ADMIN3_CD,

AD31.PARENT_ADMIN_CD,

AD31.NAME

FROM

ADMIN_3_REL1 AD31

INNER JOIN ADMIN_1 AD1 ON

AD31.PARENT_ADMIN_CD = AD1.ADMIN1_CD

INNER JOIN COUNTRY C ON

AD31.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Russia';

Country level skip hierarchies

Update April 2024

Some administrative divisions at lower admin levels are directly attached to the country level.

We have created some additional tables for these skip level hierarchies:

ADMIN_2_RELCOUNTRY (reserved for future use)

ADMIN_3_RELCOUNTRY

ADMIN_4_RELCOUNTRY

ADMIN_5_RELCOUNTRY

Example

The records in ADMIN_3_RELCOUNTRY are directly linked to the country code as parent

The sample query to retrieve these records is as follows

SELECT * FROM 
LOCATION.GEONM_202404.ADMIN_3_RELCOUNTRY a
JOIN LOCATION.GEONM_202404.COUNTRY b on a.parent_admin_cd = b.country_cd;

SELECT * FROM

LOCATION.GEONM_202404.ADMIN_3_RELCOUNTRY a

JOIN LOCATION.GEONM_202404.COUNTRY b on a.parent_admin_cd = b.country_cd;

CITY_500

The table has all cities with a population > 500 or seats of adm div down to PPLA4(seat of a fourth-order administrative division).

COLUMNS

Column	Description
GEO_ID	The integer id of the record
COUNTRY_CD	Country code where the city belongs
ADMIN_CD	The administrative division code of the city
PARENT_ADMIN_ORDER	The maximum administrative division order under which the city comes
FEATURE_CD	Indicates the feature (eg: PPLA, PPLA2 etc)
NAME	Name of the city
ASCIINAME	Name of the city in plain ascii characters
LATITUDE	Latitude in decimal degrees
LONGITUDE	Longitude in decimal degrees
POPULATION	Population of the city
DEM	Digital elevation model, srtm3 or gtopo30, average elevation of 3”x3” (ca 90mx90m) or 30”x30” (ca 900mx900m) area in meters, integer. srtm processed by cgiar/ciat.
TIMEZONE	Timezone
MODIFICATION_DT	Date of last modification

SAMPLE QUERIES

The query given below can be used to find the highest populated city in all of the nineteen first-order administrative divisions of Spain.

SELECT
    ADMIN1_NAME,
    CITY_NAME,
    POPULATION,
    RANK() OVER(PARTITION BY ADMIN1_NAME
ORDER BY
    POPULATION DESC) AS POPULATION_RANK
FROM
    (
    SELECT
   	 AD1.NAME ADMIN1_NAME,
   	 C500.NAME CITY_NAME,
   	 C500.POPULATION
    FROM
   	 CITY_500 C500
    INNER JOIN ADMIN_4 AD4 ON
   	 C500.ADMIN_CD = AD4.ADMIN4_CD
    INNER JOIN ADMIN_3 AD3 ON
   	 AD4.PARENT_ADMIN_CD = AD3.ADMIN3_CD
    INNER JOIN ADMIN_2 AD2 ON
   	 AD3.PARENT_ADMIN_CD = AD2.ADMIN2_CD
    INNER JOIN ADMIN_1 AD1 ON
   	 AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD
    INNER JOIN COUNTRY C ON
   	 C500.COUNTRY_CD = C.COUNTRY_CD
    WHERE
   	 C.COUNTRY = 'Spain'
   	 AND PARENT_ADMIN_ORDER = 'ADM4'
UNION
    SELECT
   	 AD1.NAME ADMIN1_NAME,
   	 C500.NAME CITY_NAME,
   	 C500.POPULATION
    FROM
   	 CITY_500 C500
    INNER JOIN ADMIN_3 AD3 ON
   	 C500.ADMIN_CD = AD3.ADMIN3_CD
    INNER JOIN ADMIN_2 AD2 ON
   	 AD3.PARENT_ADMIN_CD = AD2.ADMIN2_CD
    INNER JOIN ADMIN_1 AD1 ON
   	 AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD
    INNER JOIN COUNTRY C ON
   	 C500.COUNTRY_CD = C.COUNTRY_CD
    WHERE
   	 C.COUNTRY = 'Spain'
   	 AND PARENT_ADMIN_ORDER = 'ADM3'
UNION
    SELECT
   	 AD1.NAME ADMIN1_NAME,
   	 C500.NAME CITY_NAME,
   	 C500.POPULATION
    FROM
   	 CITY_500 C500
    INNER JOIN ADMIN_2 AD2 ON
   	 C500.ADMIN_CD = AD2.ADMIN2_CD
    INNER JOIN ADMIN_1 AD1 ON
   	 AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD
    INNER JOIN COUNTRY C ON
   	 C500.COUNTRY_CD = C.COUNTRY_CD
    WHERE
   	 C.COUNTRY = 'Spain'
   	 AND PARENT_ADMIN_ORDER = 'ADM2' ) QUALIFY POPULATION_RANK = 1;

SELECT

ADMIN1_NAME,

CITY_NAME,

POPULATION,

RANK() OVER(PARTITION BY ADMIN1_NAME

ORDER BY

POPULATION DESC) AS POPULATION_RANK

FROM

(

SELECT

AD1.NAME ADMIN1_NAME,

C500.NAME CITY_NAME,

C500.POPULATION

FROM

CITY_500 C500

INNER JOIN ADMIN_4 AD4 ON

C500.ADMIN_CD = AD4.ADMIN4_CD

INNER JOIN ADMIN_3 AD3 ON

AD4.PARENT_ADMIN_CD = AD3.ADMIN3_CD

INNER JOIN ADMIN_2 AD2 ON

AD3.PARENT_ADMIN_CD = AD2.ADMIN2_CD

INNER JOIN ADMIN_1 AD1 ON

AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD

INNER JOIN COUNTRY C ON

C500.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Spain'

AND PARENT_ADMIN_ORDER = 'ADM4'

UNION

SELECT

AD1.NAME ADMIN1_NAME,

C500.NAME CITY_NAME,

C500.POPULATION

FROM

CITY_500 C500

INNER JOIN ADMIN_3 AD3 ON

C500.ADMIN_CD = AD3.ADMIN3_CD

INNER JOIN ADMIN_2 AD2 ON

AD3.PARENT_ADMIN_CD = AD2.ADMIN2_CD

INNER JOIN ADMIN_1 AD1 ON

AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD

INNER JOIN COUNTRY C ON

C500.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Spain'

AND PARENT_ADMIN_ORDER = 'ADM3'

UNION

SELECT

AD1.NAME ADMIN1_NAME,

C500.NAME CITY_NAME,

C500.POPULATION

FROM

CITY_500 C500

INNER JOIN ADMIN_2 AD2 ON

C500.ADMIN_CD = AD2.ADMIN2_CD

INNER JOIN ADMIN_1 AD1 ON

AD2.PARENT_ADMIN_CD = AD1.ADMIN1_CD

INNER JOIN COUNTRY C ON

C500.COUNTRY_CD = C.COUNTRY_CD

WHERE

C.COUNTRY = 'Spain'

AND PARENT_ADMIN_ORDER = 'ADM2' ) QUALIFY POPULATION_RANK = 1;

ALT_NM

This table has the alternate name details if any, for the geographical points. If a point has more than one alternate name more than one row will be there in the table for that particular point.

COLUMNS

Column	Description
ALTERNATENAME_ID	The unique id for the alternate name
GEO_ID	The geo_id refers to the geo_id in admin level tables and country.
ISOLANGUAGE	ISO 639 language code 2- or 3-characters; 4-characters ‘post’ for postal codes and ‘iata’,’icao’ and faac for airport codes, fr_1793 for French Revolution names, abbr for abbreviation, link to a website (mostly to wikipedia), wkdt for the wikidataid
ALTERNATE_NAME	Alternate name or name variant
ISPREFERREDNAME	‘1’, if this alternate name is an official/preferred name
ISSHORTNAME	‘1’, if this is a short name like ‘California’ for ‘State of California’
ISCOLLOQUIAL	‘1’, if this alternate name is a colloquial or slang term
ISHISTORIC	‘1’, if this alternate name is historic and was used in the past

SAMPLE QUERIES

The query given below can be used to fetch the alternate names of Lazio which is one among the 20 first-order administrative divisions of Italy.

SELECT
    AN.*
FROM
    ALT_NM AN
INNER JOIN ADMIN_1 AD1 ON
    AN.GEO_ID = AD1.GEO_ID
WHERE
    AD1.NAME = 'Lazio'
    AND AD1.COUNTRY_CD = 'IT';

SELECT

AN.*

FROM

ALT_NM AN

INNER JOIN ADMIN_1 AD1 ON

AN.GEO_ID = AD1.GEO_ID

WHERE

AD1.NAME = 'Lazio'

AND AD1.COUNTRY_CD = 'IT';

FEATURE

The table contains the name and description for the feature codes.

COLUMNS

Column	Description
FEATURE_CD	The feature code
FEATURE_CLASS	The general class of the feature code
NAME	The name of the feature code
DESCRIPTION	The description of the feature

We are offering various GEO datasets. You can find our offering here:

Back to Blog

Cookie	Duration	Description
__cfruid	session	Cloudflare sets this cookie to identify trusted web traffic.
cookielawinfo-checkbox-marketing	1 month	This cookie is set by the GDPR Cookie Consent plugin to store the user consent for the cookies in the category "Marketing".
cookielawinfo-checkbox-necessary	1 month	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-preferences	1 month	This cookie is set by the GDPR Cookie Consent plugin to check if the user has given consent to use cookies under the "Preferences" category.
cookielawinfo-checkbox-statistics	1 month	This cookie is set by the GDPR Cookie Consent plugin to store the user consent for the cookies in the category "Statistics".
cookielawinfo-checkbox-unclassified	1 month	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Unclassified".
CookieLawInfoConsent	1 month	Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie.
csrftoken	1 year	This cookie is associated with Django web development platform for python. Used to help protect the website against Cross-Site Request Forgery attacks

Cookie	Duration	Description
AnalyticsSyncHistory	1 month	Linkedin set this cookie to store information about the time a sync took place with the lms_analytics cookie.
bcookie	2 years	LinkedIn sets this cookie from LinkedIn share buttons and ad tags to recognize browser ID.
bscookie	2 years	LinkedIn sets this cookie to store performed actions on the website.
lang	session	LinkedIn sets this cookie to remember a user's language setting.
li_gc	2 years	Linkedin set this cookie for storing visitor's consent regarding using cookies for non-essential purposes.
lidc	1 day	LinkedIn sets the lidc cookie to facilitate data center selection.
mgref	1 year	This cookie is set by Eventbrite to deliver content tailored to the end user's interests and improve content creation. It is also used for event-booking purposes.
mgrefby	1 year	This cookie is set by Eventbrite to deliver content tailored to the end user's interests and improve content creation. It is also used for event-booking purposes.
UserMatchHistory	1 month	LinkedIn sets this cookie for LinkedIn Ads ID syncing.

Cookie	Duration	Description
G	1 year	Cookie used to facilitate the translation into the preferred language of the visitor.
SERVERID	session	This cookie is set by Slideshare's HAProxy load balancer to assign the visitor to a specific server.

Cookie	Duration	Description
_ga	2 years	The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors.
_ga_7H38LVR4Z5	2 years	This cookie is installed by Google Analytics.
_gat_gtag_UA_44804396_1	1 minute	Set by Google to distinguish users.
_gat_UA-44804396-1	1 minute	A variation of the _gat cookie set by Google Analytics and Google Tag Manager to allow website owners to track visitor behaviour and measure site performance. The pattern element in the name contains the unique identity number of the account or website it relates to.
_gcl_au	3 months	Provided by Google Tag Manager to experiment advertisement efficiency of websites using their services.
_gid	1 day	Installed by Google Analytics, _gid cookie stores information on how visitors use a website, while also creating an analytics report of the website's performance. Some of the data that are collected include the number of visitors, their source, and the pages they visit anonymously.
CONSENT	2 years	YouTube sets this cookie via embedded youtube-videos and registers anonymous statistical data.
SIDCC	6 Months	The "SIDCC" cookie is used as security measure to protect users data from unauthorised access
test_cookie	15 minutes	The test_cookie is set by doubleclick.net and is used to determine if the user's browser supports cookies.
VISITOR_INFO1_LIVE	5 months 27 days	A cookie set by YouTube to measure bandwidth that determines whether the user gets the new or old player interface.
YSC	session	YSC cookie is set by Youtube and is used to track the views of embedded videos on Youtube pages.
yt-remote-connected-devices	never	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt-remote-device-id	never	YouTube sets this cookie to store the video preferences of the user using embedded YouTube video.
yt.innertube::nextId	never	This cookie, set by YouTube, registers a unique ID to store data on what videos from YouTube the user has seen.
yt.innertube::requests	never	This cookie, set by YouTube, registers a unique ID to store data on what videos from YouTube the user has seen.

Cookie	Duration	Description
AN	1 month
AS	session
ebEventToTrack	1 month
eblang	1 year
SNID	2 years	This cookie is set by the Google. This cookie is used by the map which helps visitors to identify and reach the facility.
SP	session
SS	session

SQL Visualisation Guide - Query Diagrams, Lineage & ERD

SQL Visualisation Guide - Query Diagrams, Lineage & ERD

SQL Visualisation Guide - Query Diagrams, Lineage & ERD

SQL Visualisation Guide - Query Diagrams, Lineage & ERD

Guide to Geography Dimension on the Snowflake Marketplace

CORE TABLES

COUNTRY

COLUMNS

ADMIN_1

COLUMNS

SAMPLE QUERIES

ADMIN_2

COLUMNS

SAMPLE QUERIES

ADMIN_3

SAMPLE QUERIES

ADMIN_4

SAMPLE QUERIES

ADMIN_5

SAMPLE QUERY

ADMIN_3_REL1, ADMIN4_REL1, ADMIN4_REL2, ADMIN5_REL1, ADMIN5_REL2, ADMIN5_REL3

SAMPLE QUERIES

Country level skip hierarchies

CITY_500

COLUMNS

SAMPLE QUERIES

ALT_NM

COLUMNS

SAMPLE QUERIES

FEATURE

COLUMNS

Guide to Geography Dimension on the Snowflake Marketplace

CORE TABLES

COUNTRY

COLUMNS

ADMIN_1

COLUMNS

SAMPLE QUERIES

ADMIN_2

COLUMNS

SAMPLE QUERIES

ADMIN_3

SAMPLE QUERIES

ADMIN_4

SAMPLE QUERIES

ADMIN_5

SAMPLE QUERY

ADMIN_3_REL1, ADMIN4_REL1, ADMIN4_REL2, ADMIN5_REL1, ADMIN5_REL2, ADMIN5_REL3

SAMPLE QUERIES

Country level skip hierarchies

CITY_500

COLUMNS

SAMPLE QUERIES

ALT_NM

COLUMNS

SAMPLE QUERIES

FEATURE

COLUMNS

Related Articles

Iceberg Ahead! All you need to know about Snowflake’s Polaris Catalog

How to Parse & Flatten XML in Snowflake with Examples

Data Orchestration Deep Dive Snowflake Tasks. An Airflow replacement?

Cookies consent