After installation, select your imported database and a warehouse in Snowflake. These read-only queries use the RELEASES schema within that database, regardless of the database name you chose. Your warehouse runs the queries using your account’s compute.
Check the Accepted Release and Source
What this returns
Identify the accepted version, coverage, source licence and source update frequency before using the data.
Provider check on 19 September 2026: 1 row. See the accepted-snapshot verification note above.
Scroll SQL sideways if needed. Keyboard: focus the code and use the left and right arrow keys.
-- Check the Accepted Release and Source
-- Identify the accepted version, coverage, source licence and source update frequency before using the data.
SELECT
c.TITLE, c.PUBLISHER, c.SOURCE_URL, c.TERMS_URL,
c.ATTRIBUTION, s.ACCEPTED_VERSION, s.GENERATION,
s.PUBLICATION_STATUS, s.ROW_COUNT, s.COVERAGE_START,
s.COVERAGE_END, s.SOURCE_RELEASE_TIME, s.PUBLISHED_AT,
s.PUBLISHER_CADENCE AS SOURCE_UPDATE_FREQUENCY
FROM RELEASES.C01_FREE_DATASET_CATALOG AS c
JOIN RELEASES.C01_FREE_DATASET_STATUS AS s
ON c.DATASET_ID = s.DATASET_ID
AND c.RELEASE_ID = s.ACCEPTED_VERSION;
Explore Canada's Recent All-Items CPI
What this returns
Read the most recent 24 available months of Canada's all-items index on the 2002=100 base. Values are index levels, not percentage changes.
Provider check on 19 September 2026: 24 rows. See the accepted-snapshot verification note above.
Scroll SQL sideways if needed. Keyboard: focus the code and use the left and right arrow keys.
-- Explore Canada's Recent All-Items CPI
-- Read the most recent 24 available months of Canada's all-items index on the 2002=100 base. Values are index levels, not percentage changes.
WITH latest AS (
SELECT MAX(REFERENCE_MONTH) AS MONTH
FROM RELEASES.C01_FREE_OBSERVATIONS
WHERE GEO_EN = 'Canada' AND PRODUCT_EN = 'All-items'
AND UOM_ID = '17'
)
SELECT o.REFERENCE_MONTH, o.GEO_EN, o.GEO_FR, o.PRODUCT_EN,
o.PRODUCT_FR, o.UOM_EN, o.VECTOR, o.VALUE, o.STATUS,
o.SYMBOL, o.TERMINATED, o.RELEASE_ID
FROM RELEASES.C01_FREE_OBSERVATIONS AS o
CROSS JOIN latest
WHERE o.GEO_EN = 'Canada' AND o.PRODUCT_EN = 'All-items'
AND o.UOM_ID = '17'
AND o.REFERENCE_MONTH BETWEEN DATEADD(month, -23, latest.MONTH) AND latest.MONTH
ORDER BY o.REFERENCE_MONTH;
Compare Provincial CPI Series
What this returns
Find all-items CPI indices at the latest published reference month for Canada's ten provinces. Equal index bases do not measure absolute cost-of-living differences.
Provider check on 19 September 2026: 10 rows. See the accepted-snapshot verification note above.
Scroll SQL sideways if needed. Keyboard: focus the code and use the left and right arrow keys.
-- Compare Provincial CPI Series
-- Find all-items CPI indices at the latest published reference month for Canada's ten provinces. Equal index bases do not measure absolute cost-of-living differences.
WITH latest AS (
SELECT MAX(REFERENCE_MONTH) AS MONTH
FROM RELEASES.C01_FREE_OBSERVATIONS
)
SELECT o.GEO_EN, o.GEO_FR, o.REFERENCE_MONTH, o.VALUE,
o.UOM_EN, o.UOM_ID, o.VECTOR, o.STATUS, o.SYMBOL, o.RELEASE_ID
FROM RELEASES.C01_FREE_OBSERVATIONS AS o
JOIN latest ON o.REFERENCE_MONTH = latest.MONTH
WHERE o.PRODUCT_EN = 'All-items' AND o.UOM_ID = '17'
AND o.GEO_EN IN (
'Newfoundland and Labrador', 'Prince Edward Island', 'Nova Scotia',
'New Brunswick', 'Quebec', 'Ontario', 'Manitoba', 'Saskatchewan',
'Alberta', 'British Columbia'
)
ORDER BY o.GEO_EN;
Discover Geographic Coverage and Available History
What this returns
Inspect the geographies actually present, their observation coverage and number of CPI series. Series histories differ; the table does not contain every geography/product/month combination.
Provider check on 19 September 2026: 30 rows. See the accepted-snapshot verification note above.
Scroll SQL sideways if needed. Keyboard: focus the code and use the left and right arrow keys.
-- Discover Geographic Coverage and Available History
-- Inspect the geographies actually present, their observation coverage and number of CPI series. Series histories differ; the table does not contain every geography/product/month combination.
SELECT GEO_EN, GEO_FR, COUNT(DISTINCT VECTOR) AS SERIES_COUNT,
COUNT(*) AS OBSERVATION_COUNT,
MIN(REFERENCE_MONTH) AS FIRST_REFERENCE_MONTH,
MAX(REFERENCE_MONTH) AS LAST_REFERENCE_MONTH
FROM RELEASES.C01_FREE_OBSERVATIONS
GROUP BY GEO_EN, GEO_FR
ORDER BY GEO_EN;