Dedicated REST API endpoint to monitor the real-time status and health of On-premises Data Gateway

[CharlieFab]

Requested Features:

(Gateway connection status)

1. Gateway Connection Health API
- Endpoint: GET /gateways/{gatewayId}/{connection}/health
- Returns: Overall gateway connection health status (online/offline/degraded)
- Includes: Last heartbeat timestamp, connectivity status

2. Datasource Connection Test API
- Endpoint: POST /gateways/{gatewayId}/datasources/{datasourceId}/test
- Returns: Connection test result without triggering actual data operations
- Includes: Response time, connection success/failure, error details

3. Gateway Metrics API
- Endpoint: GET /gateways/{gatewayId}/metrics
- Returns: Performance metrics (CPU, memory, active connections, query queue)
- Supports: Time-range queries for historical data

Use Case:

Organizations need to proactively monitor gateway infrastructure for:

- Alerting when gateway connection go offline
- Detecting SQL Server connection failures before users report issues
- Integrating with external monitoring tools (Datadog, Azure Monitor, etc.)
- Meeting SLA requirements for data availability

Current Limitations:

- Existing APIs only show gateway registration status, not real-time connectivity
- No way to test datasource connections without triggering data refreshes
- No programmatic access to gateway performance metrics

Expected Benefit:

This would enable enterprise customers to build robust monitoring solutions and ensure high availability of their data infrastructure.

---
Please vote if you'd find this valuable for your organization!