AI_REDACT

AI_REDACT(text)

SELECT AI_REDACT(
    'Contact John Doe at john.doe@email.com or call 555-123-4567'
) AS

SELECT 
    ticket_id,
    AI_REDACT(customer_message) AS redacted_message,
    ticket_category
FROM support_tickets
WHERE created_date >= CURRENT_DATE - 30

CREATE TABLE customer_feedback_anonymized AS
SELECT 
    feedback_id,
    AI_REDACT(feedback_text) AS anonymized_feedback,
    product_id,
    rating,
    feedback_date
FROM

WITH redacted_data AS (
    SELECT 
        order_id,
        AI_REDACT(customer_notes) AS safe_notes,
        order_total,
        order_date
    FROM orders
)
SELECT *
FROM redacted_data
WHERE order_date >= '2024-01-01'

SELECT 
    user_id,
    CASE 
        WHEN user_consent = false THEN AI_REDACT(user_comments)
        ELSE user_comments
    END AS comments
FROM

-- Check that sensitive data was redacted
SELECT 
    original_text,
    AI_REDACT(original_text) AS redacted,
    CASE 
        WHEN AI_REDACT(original_text) LIKE '%@%.%' THEN 'Email not redacted'
        WHEN AI_REDACT(original_text) REGEXP '[0-9]{3}-[0-9]{2}-[0-9]{4}' THEN 'SSN not redacted'
        ELSE 'OK'
    END AS validation
FROM sensitive_data
WHERE validation != 'OK'

-- Create view with automatic redaction for non-privileged users
CREATE VIEW customer_data_safe AS
SELECT 
    customer_id,
    AI_REDACT(contact_info) AS contact_info,
    purchase_history
FROM customers;

GRANT SELECT ON customer_data_safe TO

-- Redact but keep metadata for analysis
SELECT 
    ticket_id,
    AI_REDACT(description) AS safe_description,
    LENGTH(description) AS original_length,
    REGEXP_COUNT(description, '@') AS email_mentions,
    created_date
FROM

-- Tag redacted data
CREATE TABLE redacted_logs AS
SELECT 
    log_id,
    AI_REDACT(log_message) AS redacted_message,
    'PII_REDACTED' AS data_classification,
    CURRENT_TIMESTAMP() AS redacted_at,
    CURRENT_USER() AS redacted_by
FROM

-- Anonymize customer data for analytics
CREATE TABLE customer_analytics_gdpr AS
SELECT 
    customer_segment,
    product_category,
    AI_REDACT(feedback_text) AS anonymous_feedback,
    sentiment_score
FROM

-- Create safe test data from production
CREATE TABLE orders_test_data AS
SELECT 
    order_id,
    AI_REDACT(shipping_address) AS test_address,
    AI_REDACT(customer_notes) AS test_notes,
    order_total
FROM orders_production
LIMIT 1000

-- Sanitize application logs before analysis
SELECT 
    timestamp,
    log_level,
    AI_REDACT(message) AS safe_message,
    application_name
FROM application_logs
WHERE log_level = 'ERROR'
  AND timestamp >= CURRENT_DATE - 7

-- Prepare data for external partners
CREATE TABLE partner_share AS
SELECT 
    transaction_id,
    transaction_date,
    AI_REDACT(customer_details) AS anonymized_customer,
    product_sku,
    quantity
FROM transactions
WHERE share_approved = true

-- Redact only specific fields
SELECT 
    customer_id,
    customer_name,  -- Keep name
    AI_REDACT(email) AS email,  -- Redact email
    AI_REDACT(phone) AS phone,  -- Redact phone
    city,  -- Keep city
    AI_REDACT(street_address) AS street_address  -- Redact address
FROM

CREATE TABLE data_access_log AS
SELECT 
    CURRENT_USER() AS accessed_by,
    CURRENT_TIMESTAMP() AS accessed_at,
    'customer_pii' AS table_name,
    customer_id,
    AI_REDACT(sensitive_field) AS redacted_value
FROM customer_pii
WHERE CURRENT_USER() NOT IN (SELECT user FROM privileged_users)