btcross26

import pandas as pd
from evidently.report import Report
from evidently.metric_preset import DataDriftPreset, ConceptDriftPreset
from evidently.test_suite import TestSuite
from evidently.tests import DataDriftTest, ConceptDriftTest

# Load your data
reference_data = pd.read_csv('reference_data.csv')  # Your initial training data
current_data = pd.read_csv('current_data.csv')  # Your new production data

btcross26

WITH base_applications AS (
    SELECT 
        a1.application_id,
        a1.email,
        a1.timestamp as event_timestamp,
        a2.timestamp as historical_timestamp,
        a2.application_id as historical_application_id
    FROM applications a1
    LEFT JOIN applications a2 
        ON a1.email = a2.email