Retrieving BPD Coverage by Field

This article explains how to calculate the percentage of national dataset coverage for a specific BPD field using Snowflake. It includes both a Cortex code prompt example and a sample SQL query.

Cortex Code Input:

Give me national coverage percentages for the following field [Field Name]
​

SQL:

SELECT
COUNT(CASE WHEN [Field Name] IS NOT NULL THEN 1 END) * 100.0 / COUNT(*) AS [Field Name]_coverage_pct
FROM
​****