CCPA Do Not Sell Flag Presence

completenesscritical

Validates that all consumer records include a non-null do_not_sell flag (true or false). Under CCPA/CPRA, businesses must provide a mechanism for consumers to opt out of the sale of their personal information. The do_not_sell flag must be explicitly set on every consumer record to ensure the business can honor opt-out preferences and demonstrate compliance.

v1.0.0by dqhub508 downloads4.9 (35)

ccpado-not-sellprivacycompliancecpraopt-outconsumer-rights

Try This Rule

Parameters

column_namestringrequired

The column containing email addresses

thresholdfloatdefault: 0.99

Minimum fraction of valid emails (0.0 to 1.0)

Compliance Mapping

CCPACal. Civ. Code 1798.120 — Right to Opt-Out of Sale

VCDPAVa. Code 59.1-577(A)(5) — Opt-Out Right

CPRACal. Civ. Code 1798.135 — Do Not Sell or Share Link

CPAC.R.S. 6-1-1306(1)(a)(I) — Opt-Out Right

Install

soda

checks for {{table_name}}:
  - invalid_percent({{column_name}}) < {{(1 - threshold) * 100}}:
      valid regex: '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$'

dbt

{% test valid_email(model, column_name) %}
select {{ column_name }}
from {{ model }}
where {{ column_name }} not regexp '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$'
{% endtest %}

sql

SELECT COUNT(*) as total,
  SUM(CASE WHEN {{column_name}} REGEXP
    '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$'
    THEN 1 ELSE 0 END) as valid
FROM {{table_name}}

Great Expectations

{
  "expectation_type": "expect_column_values_to_match_regex",
  "kwargs": {
    "column": "{{column_name}}",
    "regex": "^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$",
    "mostly": {{threshold}}
  }
}

spark

from pyspark.sql.functions import col
pattern = r'^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$'
invalid = df.filter(~col("{{column_name}}").rlike(pattern)).count()

Test Data

Passing Examples

id	value
1	alice@example.com
2	bob.smith@company.co.uk
3	charlie+tag@domain.org

Failing Examples

id	value
1	not-an-email
2	@missing-local.com
3	spaces in@email.com

CLI

Terminal

npx dqhub install ccpa-do-not-sell-flag-present --format soda --table YOUR_TABLE
npx dqhub install ccpa-do-not-sell-flag-present --format dbt --model YOUR_MODEL
npx dqhub install ccpa-do-not-sell-flag-present --format sql --dialect snowflake