source_data_definition.sql

-- Source Market Data Definition (for reference)
-- This represents the raw 2026 market data structure

CREATE TABLE IF NOT EXISTS raw_market_indicators (
    market_segment VARCHAR(100),
    customer_id VARCHAR(50),
    first_name VARCHAR(100),
    last_name VARCHAR(100),
    email VARCHAR(200),
    phone VARCHAR(50),
    city VARCHAR(100),
    age INTEGER,
    registration_date TIMESTAMP,
    -- 2026 Market indicators
    market_size_2026 DECIMAL(15,2),
    cagr DECIMAL(5,2),
    conversion_rate_impact DECIMAL(5,2),
    personalized_marketing_growth DECIMAL(5,2),
    data_preparation_market_size DECIMAL(15,2),
    ai_crm_market_size DECIMAL(15,2),
    marketing_analytics_market_size DECIMAL(15,2)
);

-- Sample data reflecting 2026 market conditions
INSERT INTO raw_market_indicators VALUES
('Data Preparation/ETL', 'C001', 'Alice', 'Johnson', 'alice@example.com', '555-0101', 'San Francisco', 35, '2024-01-15', 15140, 22.71, 40, 45, 15140, 85000, 8020),
('AI-Powered CRM', 'C002', 'Bob', 'Smith', 'bob@company.org', '555-0102', 'New York', 42, '2023-06-20', 85000, 9.48, 35, 40, 85000, 85000, 8020),
('Marketing Analytics', 'C003', 'Carol', 'Williams', 'carol@marketing.net', '555-0103', 'Chicago', 28, '2025-03-10', 8020, 12.65, 40, 45, 15140, 85000, 8020),
('Data Preparation/ETL', 'C004', 'David', 'Brown', 'david@etl.io', NULL, 'Austin', 31, '2024-08-05', 15140, 22.71, 40, 45, 15140, 85000, 8020),
('Marketing Analytics', 'C005', 'Eve', 'Davis', 'eve@analytics.com', '555-0105', NULL, 29, '2025-01-22', 8020, 12.65, 40, 45, 15140, 85000, 8020);