Usage dashboard

The Usage dashboard shows validation activity recorded by the app.

Use it to monitor:

• Total validations
• Success rate
• Valid, invalid and error counts
• Confidence distribution
• Recent validation requests

Time frames

The dashboard can show usage from:

• 1 hour
• 24 hours
• 7 days
• 30 days

Select a time frame and click Refresh to reload the dashboard.

Usage tables

The dashboard reads from app-owned usage tables:

Each single-record call creates a usage row with interface_type set to record. Each completed or partially completed bulk job creates a usage row with interface_type set to bulk.

Query usage from SQL

SELECT
  execution_time,
  interface_type,
  source_table,
  output_table,
  total_records,
  valid_records,
  invalid_records,
  error_count,
  processing_time_seconds
FROM EDQ.CONFIG.email_usage_stats
ORDER BY execution_time DESC
LIMIT 20;

Aggregate usage by validation type:

SELECT 'address' AS validation_type, SUM(total_records) AS total_records
FROM EDQ.CONFIG.address_usage_stats
UNION ALL
SELECT 'email', SUM(total_records)
FROM EDQ.CONFIG.email_usage_stats
UNION ALL
SELECT 'phone', SUM(total_records)
FROM EDQ.CONFIG.phone_usage_stats;