This is the Airbyte source connector for DataCops — a fraud detection platform for web applications.
| Stream | Sync Mode | Cursor Field | Description |
|---|---|---|---|
identified_users |
Full / Incremental | identified_at |
Email-identified users with full risk signals (email risk score, disposable check, AI fake score, IP/VPN flags) |
sessions |
Full / Incremental | start_time |
All user sessions with bot detection, country, device, and traffic source data |
bot_detections |
Full / Incremental | detected_at |
Sessions flagged as bot traffic |
vpn_proxy_detections |
Full / Incremental | detected_at |
Sessions using VPN, proxy, or Tor |
| Field | Type | Required | Description |
|---|---|---|---|
api_key |
string | ✅ | Private API Key (dcp_...) from DataCops dashboard → Settings → API Keys → Private Keys |
base_url |
string | ✅ | API base URL (https://api.joindatacops.com) |
start_date |
string | ❌ | ISO 8601 start date for initial sync (e.g. 2024年01月01日T00:00:00Z) |
- Log into your DataCops dashboard
- Go to Settings → API Keys
- Click the Private Keys tab
- Click Create new key
- Copy the
dcp_...key — it's only shown once
Once synced into your warehouse (Snowflake, BigQuery, Redshift, etc.):
-- Find which fraud-flagged users completed a purchase SELECT u.email, u.email_risk_score, u.ai_verdict, u.ip_is_vpn, o.order_total FROM datacops.identified_users u JOIN your_schema.orders o ON o.user_email = u.normalized_email WHERE u.email_risk_score > 70 OR u.ai_verdict = 'CHALLENGE'; -- Bot traffic by country last 30 days SELECT country, COUNT(*) as bot_count FROM datacops.bot_detections WHERE detected_at >= CURRENT_DATE - INTERVAL '30 days' GROUP BY 1 ORDER BY 2 DESC; -- VPN/Proxy users who signed up SELECT v.ip_address, v.is_vpn, v.is_tor, u.email FROM datacops.vpn_proxy_detections v JOIN datacops.identified_users u ON u.session_id = v.session_id;
# Install Airbyte CDK pip install airbyte-cdk # Test the connector locally python -m airbyte_cdk.entrypoint check --config config.json python -m airbyte_cdk.entrypoint discover --config config.json python -m airbyte_cdk.entrypoint read --config config.json --catalog catalog.json
Example config.json:
{
"api_key": "dcp_your_key_here",
"base_url": "https://api.joindatacops.com",
"start_date": "2024年01月01日T00:00:00Z"
}